DBA Data[Home] [Help]

APPS.IGC_CC_PO_INTERFACE_PKG dependencies on FND_MSG_PUB

Line 43: fnd_msg_pub.add;

39: EXCEPTION
40: WHEN NO_DATA_FOUND THEN
41: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');
42: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);
43: fnd_msg_pub.add;
44: RAISE E_EMPLOYEE_NOT_FOUND;
45: END;
46:
47: -- bug 2973033 - ssmales 30-May-2003 added IF statement below for preparers without linked employee

Line 51: fnd_msg_pub.add;

47: -- bug 2973033 - ssmales 30-May-2003 added IF statement below for preparers without linked employee
48: IF l_employee_id IS NULL THEN
49: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');
50: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);
51: fnd_msg_pub.add;
52: RAISE E_EMPLOYEE_NOT_FOUND;
53: END IF;
54:
55: l_po_headers_rec.agent_id := l_employee_id;

Line 272: fnd_msg_pub.add;

268: EXCEPTION
269: WHEN NO_DATA_FOUND THEN
270: fnd_message.set_name('IGC','IGC_CC_PO_LINE_TYPE');
271: fnd_message.set_token('PO_LINE_TYPE','IGC CONTRACT COMMITMENT',TRUE);
272: fnd_msg_pub.add;
273: RAISE E_CC_PO_LINE_TYPE;
274: END;
275:
276: l_po_lines_rec.line_type_id := l_line_type_id;

Line 646: fnd_msg_pub.add;

642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN
644: fnd_message.set_name('IGC','IGC_CC_GL_PERIOD_NOT_FOUND');
645: fnd_message.set_token('PF_LINE_NUM',p_cc_pmt_fcst_rec.cc_det_pf_line_num,TRUE);
646: fnd_msg_pub.add;
647: RAISE E_CC_GL_PERIOD;
648: END;
649: ELSE
650: l_po_dist_rec.encumbered_flag := 'N';

Line 843: FND_MSG_PUB.initialize;

839: SAVEPOINT Update_PO_Approved_Flag;
840:
841: IF FND_API.to_Boolean(p_init_msg_list)
842: THEN
843: FND_MSG_PUB.initialize;
844: END IF;
845:
846: IF NOT FND_API.Compatible_API_Call(l_api_version,
847: p_api_version,

Line 873: fnd_msg_pub.add;

869: WHEN no_data_found
870: THEN
871: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
872: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
873: fnd_msg_pub.add;
874: RAISE E_CC_NOT_FOUND;
875: END;
876:
877: IF ( (l_cc_headers_rec.cc_type IS NOT NULL) AND

Line 882: fnd_msg_pub.add;

878: (l_cc_headers_rec.cc_type = 'C') )
879: THEN
880: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');
881: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
882: fnd_msg_pub.add;
883: RAISE e_cc_type;
884: END IF;
885:
886: IF ((l_cc_headers_rec.cc_state IS NOT NULL) AND

Line 891: fnd_msg_pub.add;

887: ((l_cc_headers_rec.cc_state = 'CL') OR (l_cc_headers_rec.cc_state = 'PR')))
888: THEN
889: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');
890: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
891: fnd_msg_pub.add;
892: RAISE e_cc_state;
893: END IF;
894:
895: /* Begin fix for bug 1715221 */

Line 925: fnd_msg_pub.add;

921: IF (l_curr_year_pf_lines = 0)
922: THEN
923: fnd_message.set_name('IGC','IGC_CC_UNABLE_TO_OPEN_PO');
924: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
925: fnd_msg_pub.add;
926: RAISE e_unable_to_open_po;
927: ELSIF (l_curr_year_pf_lines > 0)
928: THEN
929: /* Check whether Contract Commitment is already populated in PO Tables */

Line 944: fnd_msg_pub.add;

940: WHEN no_data_found
941: THEN
942: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');
943: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
944: fnd_msg_pub.add;
945: RAISE e_po_not_found;
946: END;
947: END IF;
948: /* End fix for bug 1715221 */

Line 1126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1122: THEN
1123: ROLLBACK TO Update_PO_Approved_Flag;
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125:
1126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1127: p_data => x_msg_data );
1128:
1129: WHEN E_CC_NOT_FOUND OR E_CC_STATE OR E_CC_TYPE OR E_PO_NOT_FOUND OR E_LINE_LOCATIONS OR E_UNABLE_TO_OPEN_PO
1130: THEN

Line 1134: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1130: THEN
1131: ROLLBACK TO Update_PO_Approved_Flag;
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1133:
1134: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1135: p_data => x_msg_data );
1136:
1137: WHEN OTHERS
1138: THEN

Line 1142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1138: THEN
1139: ROLLBACK TO Update_PO_Approved_Flag;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141:
1142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1145: l_api_name);
1146: END IF;

Line 1144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141:
1142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1145: l_api_name);
1146: END IF;
1147:
1148: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1148: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1145: l_api_name);
1146: END IF;
1147:
1148: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1149: p_data => x_msg_data );
1150: END Update_PO_Approved_Flag;
1151:
1152: /*=======================================================================+

Line 1253: FND_MSG_PUB.initialize;

1249: SAVEPOINT Convert_CC_To_PO;
1250:
1251: IF FND_API.to_Boolean(p_init_msg_list)
1252: THEN
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:
1256: IF NOT FND_API.Compatible_API_Call(l_api_version,
1257: p_api_version,

Line 1283: fnd_msg_pub.add;

1279: WHEN no_data_found
1280: THEN
1281: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
1282: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
1283: fnd_msg_pub.add;
1284: RAISE E_CC_NOT_FOUND;
1285: END;
1286:
1287: IF ( (l_cc_headers_rec.cc_type IS NOT NULL) AND

Line 1292: fnd_msg_pub.add;

1288: (l_cc_headers_rec.cc_type = 'C') )
1289: THEN
1290: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');
1291: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1292: fnd_msg_pub.add;
1293: RAISE e_cc_type;
1294: END IF;
1295:
1296: IF ((l_cc_headers_rec.cc_state IS NOT NULL) AND

Line 1301: fnd_msg_pub.add;

1297: ((l_cc_headers_rec.cc_state = 'CL') OR (l_cc_headers_rec.cc_state = 'PR')))
1298: THEN
1299: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');
1300: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1301: fnd_msg_pub.add;
1302: RAISE e_cc_state;
1303: END IF;
1304:
1305: /* Check whether encumbrance is turned on */

Line 1343: fnd_msg_pub.add;

1339: IF (l_cc_headers_rec.cc_encmbrnc_status <> 'C')
1340: THEN
1341: fnd_message.set_name('IGC','IGC_CC_CC_NOT_ENCUMBERED');
1342: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1343: fnd_msg_pub.add;
1344: RAISE e_cc_not_encumbered;
1345: END IF;
1346: END IF;
1347: END IF;

Line 1352: fnd_msg_pub.add;

1348: ELSE
1349: /* Contract Commitment is not approved */
1350: fnd_message.set_name('IGC','IGC_CC_CC_NOT_APPROVED');
1351: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1352: fnd_msg_pub.add;
1353: RAISE e_cc_not_approved;
1354: END IF;
1355: END IF;
1356:

Line 1897: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1893: THEN
1894: ROLLBACK TO Convert_CC_To_PO;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1898: p_data => x_msg_data );
1899:
1900: WHEN E_CC_NOT_FOUND OR E_CC_STATE OR E_CC_TYPE OR E_CC_NOT_ENCUMBERED OR E_LINE_LOCATIONS
1901: OR E_CC_NOT_APPROVED

Line 1905: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1901: OR E_CC_NOT_APPROVED
1902: THEN
1903: ROLLBACK TO Convert_CC_To_PO;
1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1906: p_data => x_msg_data );
1907:
1908: WHEN OTHERS
1909: THEN

Line 1913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1909: THEN
1910: ROLLBACK TO Convert_CC_To_PO;
1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912:
1913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1914: THEN
1915: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1916: l_api_name);
1917: END IF;

Line 1915: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912:
1913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1914: THEN
1915: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1916: l_api_name);
1917: END IF;
1918:
1919: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1919: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1915: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1916: l_api_name);
1917: END IF;
1918:
1919: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1920: p_data => x_msg_data );
1921:
1922:
1923: END Convert_CC_To_PO;

Line 1978: FND_MSG_PUB.initialize ;

1974:
1975:
1976: IF FND_API.to_Boolean ( p_init_msg_list )
1977: THEN
1978: FND_MSG_PUB.initialize ;
1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1982:

Line 1998: fnd_msg_pub.add;

1994: WHEN no_data_found
1995: THEN
1996: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
1997: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
1998: fnd_msg_pub.add;
1999: RAISE E_CC_NOT_FOUND;
2000: END;
2001:
2002:

Line 2011: fnd_msg_pub.add;

2007: THEN
2008: CLOSE C;
2009: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');
2010: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
2011: fnd_msg_pub.add;
2012: RAISE e_po_not_found;
2013:
2014: END IF;
2015:

Line 2025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2021: ROLLBACK TO Lock_Row_Pvt ;
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023: x_row_locked := FND_API.G_FALSE;
2024:
2025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2026: p_data => x_msg_data );
2027:
2028:
2029: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION

Line 2035: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2031:
2032: ROLLBACK TO Lock_Row_Pvt ;
2033: x_row_locked := FND_API.G_FALSE;
2034: x_return_status := FND_API.G_RET_STS_ERROR;
2035: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2036: p_data => x_msg_data );
2037:
2038: WHEN FND_API.G_EXC_ERROR
2039: THEN

Line 2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2040:
2041: ROLLBACK TO Lock_Row_Pvt ;
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: x_row_locked := FND_API.G_FALSE;
2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2045: p_data => x_msg_data );
2046:
2047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2048: THEN

Line 2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2048: THEN
2049: ROLLBACK TO Lock_Row_Pvt ;
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: x_row_locked := FND_API.G_FALSE;
2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:
2055: WHEN OTHERS
2056: THEN

Line 2062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2058: ROLLBACK TO Lock_Row_Pvt ;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: x_row_locked := FND_API.G_FALSE;
2061:
2062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2063: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2064: l_api_name);
2065: END IF;
2066:

Line 2063: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: x_row_locked := FND_API.G_FALSE;
2061:
2062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2063: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2064: l_api_name);
2065: END IF;
2066:
2067: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2067: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2063: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2064: l_api_name);
2065: END IF;
2066:
2067: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2068: p_data => x_msg_data );
2069:
2070: END Lock_PO_Row;
2071: BEGIN