eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_MATERIAL_TRANSACTIONS_PVT dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

49:
50: -- Initialize message list if p_init_msg_list is set to TRUE.
51: IF FND_API.to_Boolean( p_init_msg_list )
52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56:
57: -- Debug Message

Line 58: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

54: END IF;
55:
56:
57: -- Debug Message
58: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
59:
60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

86: -- Validate Environment
87: -- ******************************************************************
88: IF FND_GLOBAL.User_Id IS NULL
89: THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;

Line 94: FND_MSG_PUB.ADD;

90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;
95: END IF;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:

Line 116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_material_transactions');

112:
113: /* IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
114: THEN
115: -- Debug message
116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_material_transactions');
117:
118: -- Invoke validation procedures
119: Validate_material_transactions(
120: p_init_msg_list => FND_API.G_FALSE,

Line 136: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

132: */
133: -- Hint: Add corresponding Master-Detail business logic here if necessary.
134:
135: -- Debug Message
136: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137:
138: -- assign p_CSP_rec.transaction_temp_id to x_transaction_temp_id
139: x_TRANSACTION_TEMP_ID := p_CSP_rec.TRANSACTION_TEMP_ID;
140:

Line 353: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

349: END IF;
350:
351:
352: -- Debug Message
353: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
354:
355:
356: -- Standard call to get message count and if count is 1, get message info.
357: FND_MSG_PUB.Count_And_Get

Line 357: FND_MSG_PUB.Count_And_Get

353: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
354:
355:
356: -- Standard call to get message count and if count is 1, get message info.
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );
361:

Line 384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

380: WHEN FND_API.G_EXC_ERROR THEN
381: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
385: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
386: ,X_MSG_COUNT => X_MSG_COUNT
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 394: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
395: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
396: ,X_MSG_COUNT => X_MSG_COUNT
397: ,X_MSG_DATA => X_MSG_DATA
398: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 642: FND_MSG_PUB.initialize;

638:
639: -- Initialize message list if p_init_msg_list is set to TRUE.
640: IF FND_API.to_Boolean( p_init_msg_list )
641: THEN
642: FND_MSG_PUB.initialize;
643: END IF;
644:
645:
646: -- Debug Message

Line 647: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

643: END IF;
644:
645:
646: -- Debug Message
647: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
648:
649:
650: -- Initialize API return status to SUCCESS
651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 688: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686: */
687: -- Debug Message
688: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
689:
690: /*
691: Open C_Get_material_transactions( l_tar_CSP_rec.TRANSACTION_HEADER_ID);
692:

Line 883: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

879: l_ref_CSP_rec.RESERVATION_ID,
880: l_ref_CSP_rec.TRANSACTION_STATUS;
881:
882: If ( C_Get_material_transactions%NOTFOUND) Then
883: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
884: THEN
885: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
886: FND_MESSAGE.Set_Token ('INFO', 'material_transactions', FALSE);
887: FND_MSG_PUB.Add;

Line 887: FND_MSG_PUB.Add;

883: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
884: THEN
885: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
886: FND_MESSAGE.Set_Token ('INFO', 'material_transactions', FALSE);
887: FND_MSG_PUB.Add;
888: END IF;
889: raise FND_API.G_EXC_ERROR;
890: END IF;
891: -- Debug Message

Line 892: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

888: END IF;
889: raise FND_API.G_EXC_ERROR;
890: END IF;
891: -- Debug Message
892: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
893: Close C_Get_material_transactions;
894: */
895:
896:

Line 899: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

895:
896:
897: /* If (l_tar_CSP_rec.last_update_date is NULL or
898: l_tar_CSP_rec.last_update_date = FND_API.G_MISS_Date ) Then
899: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
900: THEN
901: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
902: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
903: FND_MSG_PUB.ADD;

Line 903: FND_MSG_PUB.ADD;

899: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
900: THEN
901: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
902: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
903: FND_MSG_PUB.ADD;
904: END IF;
905: raise FND_API.G_EXC_ERROR;
906: End if;
907: -- Check Whether record has been changed by someone else

Line 909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

905: raise FND_API.G_EXC_ERROR;
906: End if;
907: -- Check Whether record has been changed by someone else
908: If (l_tar_CSP_rec.last_update_date <> l_ref_CSP_rec.last_update_date) Then
909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
910: THEN
911: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
912: FND_MESSAGE.Set_Token('INFO', 'material_transactions', FALSE);
913: FND_MSG_PUB.ADD;

Line 913: FND_MSG_PUB.ADD;

909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
910: THEN
911: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
912: FND_MESSAGE.Set_Token('INFO', 'material_transactions', FALSE);
913: FND_MSG_PUB.ADD;
914: END IF;
915: raise FND_API.G_EXC_ERROR;
916: End if;
917: */

Line 922: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_material_transactions');

918:
919: /* IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
920: THEN
921: -- Debug message
922: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_material_transactions');
923:
924: -- Invoke validation procedures
925: Validate_material_transactions(
926: p_init_msg_list => FND_API.G_FALSE,

Line 942: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

938: */
939: -- Hint: Add corresponding Master-Detail business logic here if necessary.
940:
941: -- Debug Message
942: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
943:
944: -- Invoke table handler(MTL_MATERIAL_TRANSACTIONS_TEMP_PKG.Update_Row)
945: CSP_MTL_TRANSACTIONS_PKG.Update_Row(
946: p_TRANSACTION_HEADER_ID => p_CSP_rec.TRANSACTION_HEADER_ID,

Line 1149: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1145: END IF;
1146:
1147:
1148: -- Debug Message
1149: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1150:
1151:
1152: -- Standard call to get message count and if count is 1, get message info.
1153: FND_MSG_PUB.Count_And_Get

Line 1153: FND_MSG_PUB.Count_And_Get

1149: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1150:
1151:
1152: -- Standard call to get message count and if count is 1, get message info.
1153: FND_MSG_PUB.Count_And_Get
1154: ( p_count => x_msg_count,
1155: p_data => x_msg_data
1156: );
1157:

Line 1181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1177: WHEN FND_API.G_EXC_ERROR THEN
1178: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1179: P_API_NAME => L_API_NAME
1180: ,P_PKG_NAME => G_PKG_NAME
1181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1182: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1183: ,X_MSG_COUNT => X_MSG_COUNT
1184: ,X_MSG_DATA => X_MSG_DATA
1185: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1189: P_API_NAME => L_API_NAME
1190: ,P_PKG_NAME => G_PKG_NAME
1191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1192: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1193: ,X_MSG_COUNT => X_MSG_COUNT
1194: ,X_MSG_DATA => X_MSG_DATA
1195: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1246: FND_MSG_PUB.initialize;

1242:
1243: -- Initialize message list if p_init_msg_list is set to TRUE.
1244: IF FND_API.to_Boolean( p_init_msg_list )
1245: THEN
1246: FND_MSG_PUB.initialize;
1247: END IF;
1248:
1249: --dbms_output.put_line('in CSP MATERIAL');
1250:

Line 1252: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1248:
1249: --dbms_output.put_line('in CSP MATERIAL');
1250:
1251: -- Debug Message
1252: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1253:
1254:
1255: -- Initialize API return status to SUCCESS
1256: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1293: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291: */
1292: -- Debug Message
1293: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
1294:
1295: -- Invoke table handler(MTL_MATERIAL_TRANSACTIONS_TEMP_PKG.Delete_Row)
1296:
1297: CSP_MTL_TRANSACTIONS_PKG.Delete_Row(

Line 1308: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1304: END IF;
1305:
1306:
1307: -- Debug Message
1308: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1309:
1310:
1311: -- Standard call to get message count and if count is 1, get message info.
1312: FND_MSG_PUB.Count_And_Get

Line 1312: FND_MSG_PUB.Count_And_Get

1308: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1309:
1310:
1311: -- Standard call to get message count and if count is 1, get message info.
1312: FND_MSG_PUB.Count_And_Get
1313: ( p_count => x_msg_count,
1314: p_data => x_msg_data
1315: );
1316:

Line 1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1336: WHEN FND_API.G_EXC_ERROR THEN
1337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1342: ,X_MSG_COUNT => X_MSG_COUNT
1343: ,X_MSG_DATA => X_MSG_DATA
1344: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1348: P_API_NAME => L_API_NAME
1349: ,P_PKG_NAME => G_PKG_NAME
1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1352: ,X_MSG_COUNT => X_MSG_COUNT
1353: ,X_MSG_DATA => X_MSG_DATA
1354: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1376: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');

1372: )
1373: IS
1374: BEGIN
1375: -- Debug Message
1376: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
1377:
1378: -- define all columns for CSP_MATERIAL_TRANSACTIONS_V view
1379: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.TRANSACTION_HEADER_ID);
1380: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.TRANSACTION_TEMP_ID);

Line 1559: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');

1555: dbms_sql.define_column(p_cur_get_CSP, 177, P_CSP_Rec.RESERVATION_ID);
1556: dbms_sql.define_column(p_cur_get_CSP, 178, P_CSP_Rec.TRANSACTION_STATUS);
1557:
1558: -- Debug Message
1559: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
1560: END Define_Columns;
1561:
1562: -- This procudure gets column values by the Dynamic SQL.
1563: PROCEDURE Get_Column_Values(

Line 1570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');

1566: )
1567: IS
1568: BEGIN
1569: -- Debug Message
1570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
1571:
1572: -- get all column values for CSP_MATERIAL_TRANSACTIONS_V table
1573: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.TRANSACTION_HEADER_ID);
1574: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.TRANSACTION_TEMP_ID);

Line 1753: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');

1749: dbms_sql.column_value(p_cur_get_CSP, 177, X_CSP_Rec.RESERVATION_ID);
1750: dbms_sql.column_value(p_cur_get_CSP, 178, X_CSP_Rec.TRANSACTION_STATUS);
1751:
1752: -- Debug Message
1753: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
1754: END Get_Column_Values;
1755:
1756: PROCEDURE Gen_CSP_order_cl(
1757: p_order_by_rec IN CSP_MATERIAL_TRANSACTIONS_PUB.CSP_sort_rec_type,

Line 1768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');

1764: l_order_by_cl VARCHAR2(1000) := NULL;
1765: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
1766: BEGIN
1767: -- Debug Message
1768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
1769:
1770: -- Hint: Developer should add more statements according to CSP_sort_rec_type
1771: -- Ex:
1772: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

Line 1776: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke JTF_PLSQL_API.Translate_OrderBy');

1772: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1773: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
1774:
1775: -- Debug Message
1776: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke JTF_PLSQL_API.Translate_OrderBy');
1777:
1778: JTF_PLSQL_API.Translate_OrderBy(
1779: p_api_version_number => 1.0
1780: ,p_init_msg_list => FND_API.G_FALSE

Line 1795: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');

1791: x_order_by_cl := NULL;
1792: END IF;
1793:
1794: -- Debug Message
1795: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');
1796: END Gen_CSP_order_cl;
1797:
1798: -- This procedure bind the variables for the Dynamic SQL
1799: PROCEDURE Bind(

Line 1809: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');

1805: BEGIN
1806: -- Bind variables
1807: -- Only those that are not NULL
1808: -- Debug Message
1809: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
1810:
1811: -- The following example applies to all columns,
1812: -- developers can copy and paste them.
1813: IF( (P_CSP_Rec.TRANSACTION_HEADER_ID IS NOT NULL) AND (P_CSP_Rec.TRANSACTION_HEADER_ID <> FND_API.G_MISS_NUM) )

Line 1819: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');

1815: DBMS_SQL.BIND_VARIABLE(p_cur_get_CSP, ':p_TRANSACTION_HEADER_ID', P_CSP_Rec.TRANSACTION_HEADER_ID);
1816: END IF;
1817:
1818: -- Debug Message
1819: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
1820: END Bind;
1821:
1822: PROCEDURE Gen_Select(
1823: x_select_cl OUT NOCOPY VARCHAR2

Line 1828: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');

1824: )
1825: IS
1826: BEGIN
1827: -- Debug Message
1828: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
1829:
1830: x_select_cl := 'Select ' ||
1831: 'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_HEADER_ID,' ||
1832: 'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_TEMP_ID,' ||

Line 2019: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');

2015: 'CSP_MATERIAL_TRANSACTIONS_V.RESERVATION_ID,' ||
2016: 'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_STATUS,' ||
2017: 'from CSP_MATERIAL_TRANSACTIONS_V';
2018: -- Debug Message
2019: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
2020:
2021: END Gen_Select;
2022:
2023: PROCEDURE Gen_CSP_Where(

Line 2043: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');

2039: str_csr2 NUMBER;
2040: l_operator VARCHAR2(10);
2041: BEGIN
2042: -- Debug Message
2043: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
2044:
2045: -- There are three examples for each kind of datatype:
2046: -- NUMBER, DATE, VARCHAR2.
2047: -- Developer can copy and paste the following codes for your own record.

Line 2129: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');

2125:
2126: -- Add more IF statements for each column below
2127:
2128: -- Debug Message
2129: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
2130:
2131: END Gen_CSP_Where;
2132:
2133: -- Item-level validation procedures

Line 2149: FND_MSG_PUB.initialize;

2145:
2146: -- Initialize message list if p_init_msg_list is set to TRUE.
2147: IF FND_API.to_Boolean( p_init_msg_list )
2148: THEN
2149: FND_MSG_PUB.initialize;
2150: END IF;
2151:
2152:
2153: -- Initialize API return status to SUCCESS

Line 2173: FND_MSG_PUB.Count_And_Get

2169: NULL;
2170: END IF;
2171:
2172: -- Standard call to get message count and if count is 1, get message info.
2173: FND_MSG_PUB.Count_And_Get
2174: ( p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );
2177:

Line 2196: FND_MSG_PUB.initialize;

2192:
2193: -- Initialize message list if p_init_msg_list is set to TRUE.
2194: IF FND_API.to_Boolean( p_init_msg_list )
2195: THEN
2196: FND_MSG_PUB.initialize;
2197: END IF;
2198:
2199:
2200: -- Initialize API return status to SUCCESS

Line 2220: FND_MSG_PUB.Count_And_Get

2216: NULL;
2217: END IF;
2218:
2219: -- Standard call to get message count and if count is 1, get message info.
2220: FND_MSG_PUB.Count_And_Get
2221: ( p_count => x_msg_count,
2222: p_data => x_msg_data
2223: );
2224:

Line 2243: FND_MSG_PUB.initialize;

2239:
2240: -- Initialize message list if p_init_msg_list is set to TRUE.
2241: IF FND_API.to_Boolean( p_init_msg_list )
2242: THEN
2243: FND_MSG_PUB.initialize;
2244: END IF;
2245:
2246:
2247: -- Initialize API return status to SUCCESS

Line 2267: FND_MSG_PUB.Count_And_Get

2263: NULL;
2264: END IF;
2265:
2266: -- Standard call to get message count and if count is 1, get message info.
2267: FND_MSG_PUB.Count_And_Get
2268: ( p_count => x_msg_count,
2269: p_data => x_msg_data
2270: );
2271:

Line 2290: FND_MSG_PUB.initialize;

2286:
2287: -- Initialize message list if p_init_msg_list is set to TRUE.
2288: IF FND_API.to_Boolean( p_init_msg_list )
2289: THEN
2290: FND_MSG_PUB.initialize;
2291: END IF;
2292:
2293:
2294: -- Initialize API return status to SUCCESS

Line 2314: FND_MSG_PUB.Count_And_Get

2310: NULL;
2311: END IF;
2312:
2313: -- Standard call to get message count and if count is 1, get message info.
2314: FND_MSG_PUB.Count_And_Get
2315: ( p_count => x_msg_count,
2316: p_data => x_msg_data
2317: );
2318:

Line 2337: FND_MSG_PUB.initialize;

2333:
2334: -- Initialize message list if p_init_msg_list is set to TRUE.
2335: IF FND_API.to_Boolean( p_init_msg_list )
2336: THEN
2337: FND_MSG_PUB.initialize;
2338: END IF;
2339:
2340:
2341: -- Initialize API return status to SUCCESS

Line 2361: FND_MSG_PUB.Count_And_Get

2357: NULL;
2358: END IF;
2359:
2360: -- Standard call to get message count and if count is 1, get message info.
2361: FND_MSG_PUB.Count_And_Get
2362: ( p_count => x_msg_count,
2363: p_data => x_msg_data
2364: );
2365:

Line 2384: FND_MSG_PUB.initialize;

2380:
2381: -- Initialize message list if p_init_msg_list is set to TRUE.
2382: IF FND_API.to_Boolean( p_init_msg_list )
2383: THEN
2384: FND_MSG_PUB.initialize;
2385: END IF;
2386:
2387:
2388: -- Initialize API return status to SUCCESS

Line 2408: FND_MSG_PUB.Count_And_Get

2404: NULL;
2405: END IF;
2406:
2407: -- Standard call to get message count and if count is 1, get message info.
2408: FND_MSG_PUB.Count_And_Get
2409: ( p_count => x_msg_count,
2410: p_data => x_msg_data
2411: );
2412:

Line 2431: FND_MSG_PUB.initialize;

2427:
2428: -- Initialize message list if p_init_msg_list is set to TRUE.
2429: IF FND_API.to_Boolean( p_init_msg_list )
2430: THEN
2431: FND_MSG_PUB.initialize;
2432: END IF;
2433:
2434:
2435: -- Initialize API return status to SUCCESS

Line 2455: FND_MSG_PUB.Count_And_Get

2451: NULL;
2452: END IF;
2453:
2454: -- Standard call to get message count and if count is 1, get message info.
2455: FND_MSG_PUB.Count_And_Get
2456: ( p_count => x_msg_count,
2457: p_data => x_msg_data
2458: );
2459:

Line 2478: FND_MSG_PUB.initialize;

2474:
2475: -- Initialize message list if p_init_msg_list is set to TRUE.
2476: IF FND_API.to_Boolean( p_init_msg_list )
2477: THEN
2478: FND_MSG_PUB.initialize;
2479: END IF;
2480:
2481:
2482: -- Initialize API return status to SUCCESS

Line 2509: FND_MSG_PUB.Count_And_Get

2505: NULL;
2506: END IF;
2507:
2508: -- Standard call to get message count and if count is 1, get message info.
2509: FND_MSG_PUB.Count_And_Get
2510: ( p_count => x_msg_count,
2511: p_data => x_msg_data
2512: );
2513:

Line 2532: FND_MSG_PUB.initialize;

2528:
2529: -- Initialize message list if p_init_msg_list is set to TRUE.
2530: IF FND_API.to_Boolean( p_init_msg_list )
2531: THEN
2532: FND_MSG_PUB.initialize;
2533: END IF;
2534:
2535:
2536: -- Initialize API return status to SUCCESS

Line 2556: FND_MSG_PUB.Count_And_Get

2552: NULL;
2553: END IF;
2554:
2555: -- Standard call to get message count and if count is 1, get message info.
2556: FND_MSG_PUB.Count_And_Get
2557: ( p_count => x_msg_count,
2558: p_data => x_msg_data
2559: );
2560:

Line 2579: FND_MSG_PUB.initialize;

2575:
2576: -- Initialize message list if p_init_msg_list is set to TRUE.
2577: IF FND_API.to_Boolean( p_init_msg_list )
2578: THEN
2579: FND_MSG_PUB.initialize;
2580: END IF;
2581:
2582:
2583: -- Initialize API return status to SUCCESS

Line 2610: FND_MSG_PUB.Count_And_Get

2606: NULL;
2607: END IF;
2608:
2609: -- Standard call to get message count and if count is 1, get message info.
2610: FND_MSG_PUB.Count_And_Get
2611: ( p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );
2614:

Line 2633: FND_MSG_PUB.initialize;

2629:
2630: -- Initialize message list if p_init_msg_list is set to TRUE.
2631: IF FND_API.to_Boolean( p_init_msg_list )
2632: THEN
2633: FND_MSG_PUB.initialize;
2634: END IF;
2635:
2636:
2637: -- Initialize API return status to SUCCESS

Line 2657: FND_MSG_PUB.Count_And_Get

2653: NULL;
2654: END IF;
2655:
2656: -- Standard call to get message count and if count is 1, get message info.
2657: FND_MSG_PUB.Count_And_Get
2658: ( p_count => x_msg_count,
2659: p_data => x_msg_data
2660: );
2661:

Line 2680: FND_MSG_PUB.initialize;

2676:
2677: -- Initialize message list if p_init_msg_list is set to TRUE.
2678: IF FND_API.to_Boolean( p_init_msg_list )
2679: THEN
2680: FND_MSG_PUB.initialize;
2681: END IF;
2682:
2683:
2684: -- Initialize API return status to SUCCESS

Line 2704: FND_MSG_PUB.Count_And_Get

2700: NULL;
2701: END IF;
2702:
2703: -- Standard call to get message count and if count is 1, get message info.
2704: FND_MSG_PUB.Count_And_Get
2705: ( p_count => x_msg_count,
2706: p_data => x_msg_data
2707: );
2708:

Line 2727: FND_MSG_PUB.initialize;

2723:
2724: -- Initialize message list if p_init_msg_list is set to TRUE.
2725: IF FND_API.to_Boolean( p_init_msg_list )
2726: THEN
2727: FND_MSG_PUB.initialize;
2728: END IF;
2729:
2730:
2731: -- Initialize API return status to SUCCESS

Line 2758: FND_MSG_PUB.Count_And_Get

2754: NULL;
2755: END IF;
2756:
2757: -- Standard call to get message count and if count is 1, get message info.
2758: FND_MSG_PUB.Count_And_Get
2759: ( p_count => x_msg_count,
2760: p_data => x_msg_data
2761: );
2762:

Line 2781: FND_MSG_PUB.initialize;

2777:
2778: -- Initialize message list if p_init_msg_list is set to TRUE.
2779: IF FND_API.to_Boolean( p_init_msg_list )
2780: THEN
2781: FND_MSG_PUB.initialize;
2782: END IF;
2783:
2784:
2785: -- Initialize API return status to SUCCESS

Line 2812: FND_MSG_PUB.Count_And_Get

2808: NULL;
2809: END IF;
2810:
2811: -- Standard call to get message count and if count is 1, get message info.
2812: FND_MSG_PUB.Count_And_Get
2813: ( p_count => x_msg_count,
2814: p_data => x_msg_data
2815: );
2816:

Line 2835: FND_MSG_PUB.initialize;

2831:
2832: -- Initialize message list if p_init_msg_list is set to TRUE.
2833: IF FND_API.to_Boolean( p_init_msg_list )
2834: THEN
2835: FND_MSG_PUB.initialize;
2836: END IF;
2837:
2838:
2839: -- Initialize API return status to SUCCESS

Line 2866: FND_MSG_PUB.Count_And_Get

2862: NULL;
2863: END IF;
2864:
2865: -- Standard call to get message count and if count is 1, get message info.
2866: FND_MSG_PUB.Count_And_Get
2867: ( p_count => x_msg_count,
2868: p_data => x_msg_data
2869: );
2870:

Line 2889: FND_MSG_PUB.initialize;

2885:
2886: -- Initialize message list if p_init_msg_list is set to TRUE.
2887: IF FND_API.to_Boolean( p_init_msg_list )
2888: THEN
2889: FND_MSG_PUB.initialize;
2890: END IF;
2891:
2892:
2893: -- Initialize API return status to SUCCESS

Line 2913: FND_MSG_PUB.Count_And_Get

2909: NULL;
2910: END IF;
2911:
2912: -- Standard call to get message count and if count is 1, get message info.
2913: FND_MSG_PUB.Count_And_Get
2914: ( p_count => x_msg_count,
2915: p_data => x_msg_data
2916: );
2917:

Line 2936: FND_MSG_PUB.initialize;

2932:
2933: -- Initialize message list if p_init_msg_list is set to TRUE.
2934: IF FND_API.to_Boolean( p_init_msg_list )
2935: THEN
2936: FND_MSG_PUB.initialize;
2937: END IF;
2938:
2939:
2940: -- Initialize API return status to SUCCESS

Line 2967: FND_MSG_PUB.Count_And_Get

2963: NULL;
2964: END IF;
2965:
2966: -- Standard call to get message count and if count is 1, get message info.
2967: FND_MSG_PUB.Count_And_Get
2968: ( p_count => x_msg_count,
2969: p_data => x_msg_data
2970: );
2971:

Line 2990: FND_MSG_PUB.initialize;

2986:
2987: -- Initialize message list if p_init_msg_list is set to TRUE.
2988: IF FND_API.to_Boolean( p_init_msg_list )
2989: THEN
2990: FND_MSG_PUB.initialize;
2991: END IF;
2992:
2993:
2994: -- Initialize API return status to SUCCESS

Line 3021: FND_MSG_PUB.Count_And_Get

3017: NULL;
3018: END IF;
3019:
3020: -- Standard call to get message count and if count is 1, get message info.
3021: FND_MSG_PUB.Count_And_Get
3022: ( p_count => x_msg_count,
3023: p_data => x_msg_data
3024: );
3025:

Line 3044: FND_MSG_PUB.initialize;

3040:
3041: -- Initialize message list if p_init_msg_list is set to TRUE.
3042: IF FND_API.to_Boolean( p_init_msg_list )
3043: THEN
3044: FND_MSG_PUB.initialize;
3045: END IF;
3046:
3047:
3048: -- Initialize API return status to SUCCESS

Line 3075: FND_MSG_PUB.Count_And_Get

3071: NULL;
3072: END IF;
3073:
3074: -- Standard call to get message count and if count is 1, get message info.
3075: FND_MSG_PUB.Count_And_Get
3076: ( p_count => x_msg_count,
3077: p_data => x_msg_data
3078: );
3079:

Line 3098: FND_MSG_PUB.initialize;

3094:
3095: -- Initialize message list if p_init_msg_list is set to TRUE.
3096: IF FND_API.to_Boolean( p_init_msg_list )
3097: THEN
3098: FND_MSG_PUB.initialize;
3099: END IF;
3100:
3101:
3102: -- Initialize API return status to SUCCESS

Line 3122: FND_MSG_PUB.Count_And_Get

3118: NULL;
3119: END IF;
3120:
3121: -- Standard call to get message count and if count is 1, get message info.
3122: FND_MSG_PUB.Count_And_Get
3123: ( p_count => x_msg_count,
3124: p_data => x_msg_data
3125: );
3126:

Line 3145: FND_MSG_PUB.initialize;

3141:
3142: -- Initialize message list if p_init_msg_list is set to TRUE.
3143: IF FND_API.to_Boolean( p_init_msg_list )
3144: THEN
3145: FND_MSG_PUB.initialize;
3146: END IF;
3147:
3148:
3149: -- Initialize API return status to SUCCESS

Line 3169: FND_MSG_PUB.Count_And_Get

3165: NULL;
3166: END IF;
3167:
3168: -- Standard call to get message count and if count is 1, get message info.
3169: FND_MSG_PUB.Count_And_Get
3170: ( p_count => x_msg_count,
3171: p_data => x_msg_data
3172: );
3173:

Line 3192: FND_MSG_PUB.initialize;

3188:
3189: -- Initialize message list if p_init_msg_list is set to TRUE.
3190: IF FND_API.to_Boolean( p_init_msg_list )
3191: THEN
3192: FND_MSG_PUB.initialize;
3193: END IF;
3194:
3195:
3196: -- Initialize API return status to SUCCESS

Line 3223: FND_MSG_PUB.Count_And_Get

3219: NULL;
3220: END IF;
3221:
3222: -- Standard call to get message count and if count is 1, get message info.
3223: FND_MSG_PUB.Count_And_Get
3224: ( p_count => x_msg_count,
3225: p_data => x_msg_data
3226: );
3227:

Line 3246: FND_MSG_PUB.initialize;

3242:
3243: -- Initialize message list if p_init_msg_list is set to TRUE.
3244: IF FND_API.to_Boolean( p_init_msg_list )
3245: THEN
3246: FND_MSG_PUB.initialize;
3247: END IF;
3248:
3249:
3250: -- Initialize API return status to SUCCESS

Line 3277: FND_MSG_PUB.Count_And_Get

3273: NULL;
3274: END IF;
3275:
3276: -- Standard call to get message count and if count is 1, get message info.
3277: FND_MSG_PUB.Count_And_Get
3278: ( p_count => x_msg_count,
3279: p_data => x_msg_data
3280: );
3281:

Line 3300: FND_MSG_PUB.initialize;

3296:
3297: -- Initialize message list if p_init_msg_list is set to TRUE.
3298: IF FND_API.to_Boolean( p_init_msg_list )
3299: THEN
3300: FND_MSG_PUB.initialize;
3301: END IF;
3302:
3303:
3304: -- Initialize API return status to SUCCESS

Line 3324: FND_MSG_PUB.Count_And_Get

3320: NULL;
3321: END IF;
3322:
3323: -- Standard call to get message count and if count is 1, get message info.
3324: FND_MSG_PUB.Count_And_Get
3325: ( p_count => x_msg_count,
3326: p_data => x_msg_data
3327: );
3328:

Line 3347: FND_MSG_PUB.initialize;

3343:
3344: -- Initialize message list if p_init_msg_list is set to TRUE.
3345: IF FND_API.to_Boolean( p_init_msg_list )
3346: THEN
3347: FND_MSG_PUB.initialize;
3348: END IF;
3349:
3350:
3351: -- Initialize API return status to SUCCESS

Line 3371: FND_MSG_PUB.Count_And_Get

3367: NULL;
3368: END IF;
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: FND_MSG_PUB.Count_And_Get
3372: ( p_count => x_msg_count,
3373: p_data => x_msg_data
3374: );
3375:

Line 3394: FND_MSG_PUB.initialize;

3390:
3391: -- Initialize message list if p_init_msg_list is set to TRUE.
3392: IF FND_API.to_Boolean( p_init_msg_list )
3393: THEN
3394: FND_MSG_PUB.initialize;
3395: END IF;
3396:
3397:
3398: -- Initialize API return status to SUCCESS

Line 3418: FND_MSG_PUB.Count_And_Get

3414: NULL;
3415: END IF;
3416:
3417: -- Standard call to get message count and if count is 1, get message info.
3418: FND_MSG_PUB.Count_And_Get
3419: ( p_count => x_msg_count,
3420: p_data => x_msg_data
3421: );
3422:

Line 3441: FND_MSG_PUB.initialize;

3437:
3438: -- Initialize message list if p_init_msg_list is set to TRUE.
3439: IF FND_API.to_Boolean( p_init_msg_list )
3440: THEN
3441: FND_MSG_PUB.initialize;
3442: END IF;
3443:
3444:
3445: -- Initialize API return status to SUCCESS

Line 3465: FND_MSG_PUB.Count_And_Get

3461: NULL;
3462: END IF;
3463:
3464: -- Standard call to get message count and if count is 1, get message info.
3465: FND_MSG_PUB.Count_And_Get
3466: ( p_count => x_msg_count,
3467: p_data => x_msg_data
3468: );
3469:

Line 3488: FND_MSG_PUB.initialize;

3484:
3485: -- Initialize message list if p_init_msg_list is set to TRUE.
3486: IF FND_API.to_Boolean( p_init_msg_list )
3487: THEN
3488: FND_MSG_PUB.initialize;
3489: END IF;
3490:
3491:
3492: -- Initialize API return status to SUCCESS

Line 3512: FND_MSG_PUB.Count_And_Get

3508: NULL;
3509: END IF;
3510:
3511: -- Standard call to get message count and if count is 1, get message info.
3512: FND_MSG_PUB.Count_And_Get
3513: ( p_count => x_msg_count,
3514: p_data => x_msg_data
3515: );
3516:

Line 3535: FND_MSG_PUB.initialize;

3531:
3532: -- Initialize message list if p_init_msg_list is set to TRUE.
3533: IF FND_API.to_Boolean( p_init_msg_list )
3534: THEN
3535: FND_MSG_PUB.initialize;
3536: END IF;
3537:
3538:
3539: -- Initialize API return status to SUCCESS

Line 3559: FND_MSG_PUB.Count_And_Get

3555: NULL;
3556: END IF;
3557:
3558: -- Standard call to get message count and if count is 1, get message info.
3559: FND_MSG_PUB.Count_And_Get
3560: ( p_count => x_msg_count,
3561: p_data => x_msg_data
3562: );
3563:

Line 3582: FND_MSG_PUB.initialize;

3578:
3579: -- Initialize message list if p_init_msg_list is set to TRUE.
3580: IF FND_API.to_Boolean( p_init_msg_list )
3581: THEN
3582: FND_MSG_PUB.initialize;
3583: END IF;
3584:
3585:
3586: -- Initialize API return status to SUCCESS

Line 3606: FND_MSG_PUB.Count_And_Get

3602: NULL;
3603: END IF;
3604:
3605: -- Standard call to get message count and if count is 1, get message info.
3606: FND_MSG_PUB.Count_And_Get
3607: ( p_count => x_msg_count,
3608: p_data => x_msg_data
3609: );
3610:

Line 3629: FND_MSG_PUB.initialize;

3625:
3626: -- Initialize message list if p_init_msg_list is set to TRUE.
3627: IF FND_API.to_Boolean( p_init_msg_list )
3628: THEN
3629: FND_MSG_PUB.initialize;
3630: END IF;
3631:
3632:
3633: -- Initialize API return status to SUCCESS

Line 3653: FND_MSG_PUB.Count_And_Get

3649: NULL;
3650: END IF;
3651:
3652: -- Standard call to get message count and if count is 1, get message info.
3653: FND_MSG_PUB.Count_And_Get
3654: ( p_count => x_msg_count,
3655: p_data => x_msg_data
3656: );
3657:

Line 3676: FND_MSG_PUB.initialize;

3672:
3673: -- Initialize message list if p_init_msg_list is set to TRUE.
3674: IF FND_API.to_Boolean( p_init_msg_list )
3675: THEN
3676: FND_MSG_PUB.initialize;
3677: END IF;
3678:
3679:
3680: -- Initialize API return status to SUCCESS

Line 3700: FND_MSG_PUB.Count_And_Get

3696: NULL;
3697: END IF;
3698:
3699: -- Standard call to get message count and if count is 1, get message info.
3700: FND_MSG_PUB.Count_And_Get
3701: ( p_count => x_msg_count,
3702: p_data => x_msg_data
3703: );
3704:

Line 3723: FND_MSG_PUB.initialize;

3719:
3720: -- Initialize message list if p_init_msg_list is set to TRUE.
3721: IF FND_API.to_Boolean( p_init_msg_list )
3722: THEN
3723: FND_MSG_PUB.initialize;
3724: END IF;
3725:
3726:
3727: -- Initialize API return status to SUCCESS

Line 3747: FND_MSG_PUB.Count_And_Get

3743: NULL;
3744: END IF;
3745:
3746: -- Standard call to get message count and if count is 1, get message info.
3747: FND_MSG_PUB.Count_And_Get
3748: ( p_count => x_msg_count,
3749: p_data => x_msg_data
3750: );
3751:

Line 3770: FND_MSG_PUB.initialize;

3766:
3767: -- Initialize message list if p_init_msg_list is set to TRUE.
3768: IF FND_API.to_Boolean( p_init_msg_list )
3769: THEN
3770: FND_MSG_PUB.initialize;
3771: END IF;
3772:
3773:
3774: -- Initialize API return status to SUCCESS

Line 3794: FND_MSG_PUB.Count_And_Get

3790: NULL;
3791: END IF;
3792:
3793: -- Standard call to get message count and if count is 1, get message info.
3794: FND_MSG_PUB.Count_And_Get
3795: ( p_count => x_msg_count,
3796: p_data => x_msg_data
3797: );
3798:

Line 3817: FND_MSG_PUB.initialize;

3813:
3814: -- Initialize message list if p_init_msg_list is set to TRUE.
3815: IF FND_API.to_Boolean( p_init_msg_list )
3816: THEN
3817: FND_MSG_PUB.initialize;
3818: END IF;
3819:
3820:
3821: -- Initialize API return status to SUCCESS

Line 3841: FND_MSG_PUB.Count_And_Get

3837: NULL;
3838: END IF;
3839:
3840: -- Standard call to get message count and if count is 1, get message info.
3841: FND_MSG_PUB.Count_And_Get
3842: ( p_count => x_msg_count,
3843: p_data => x_msg_data
3844: );
3845:

Line 3864: FND_MSG_PUB.initialize;

3860:
3861: -- Initialize message list if p_init_msg_list is set to TRUE.
3862: IF FND_API.to_Boolean( p_init_msg_list )
3863: THEN
3864: FND_MSG_PUB.initialize;
3865: END IF;
3866:
3867:
3868: -- Initialize API return status to SUCCESS

Line 3888: FND_MSG_PUB.Count_And_Get

3884: NULL;
3885: END IF;
3886:
3887: -- Standard call to get message count and if count is 1, get message info.
3888: FND_MSG_PUB.Count_And_Get
3889: ( p_count => x_msg_count,
3890: p_data => x_msg_data
3891: );
3892:

Line 3911: FND_MSG_PUB.initialize;

3907:
3908: -- Initialize message list if p_init_msg_list is set to TRUE.
3909: IF FND_API.to_Boolean( p_init_msg_list )
3910: THEN
3911: FND_MSG_PUB.initialize;
3912: END IF;
3913:
3914:
3915: -- Initialize API return status to SUCCESS

Line 3935: FND_MSG_PUB.Count_And_Get

3931: NULL;
3932: END IF;
3933:
3934: -- Standard call to get message count and if count is 1, get message info.
3935: FND_MSG_PUB.Count_And_Get
3936: ( p_count => x_msg_count,
3937: p_data => x_msg_data
3938: );
3939:

Line 3958: FND_MSG_PUB.initialize;

3954:
3955: -- Initialize message list if p_init_msg_list is set to TRUE.
3956: IF FND_API.to_Boolean( p_init_msg_list )
3957: THEN
3958: FND_MSG_PUB.initialize;
3959: END IF;
3960:
3961:
3962: -- Initialize API return status to SUCCESS

Line 3982: FND_MSG_PUB.Count_And_Get

3978: NULL;
3979: END IF;
3980:
3981: -- Standard call to get message count and if count is 1, get message info.
3982: FND_MSG_PUB.Count_And_Get
3983: ( p_count => x_msg_count,
3984: p_data => x_msg_data
3985: );
3986:

Line 4005: FND_MSG_PUB.initialize;

4001:
4002: -- Initialize message list if p_init_msg_list is set to TRUE.
4003: IF FND_API.to_Boolean( p_init_msg_list )
4004: THEN
4005: FND_MSG_PUB.initialize;
4006: END IF;
4007:
4008:
4009: -- Initialize API return status to SUCCESS

Line 4029: FND_MSG_PUB.Count_And_Get

4025: NULL;
4026: END IF;
4027:
4028: -- Standard call to get message count and if count is 1, get message info.
4029: FND_MSG_PUB.Count_And_Get
4030: ( p_count => x_msg_count,
4031: p_data => x_msg_data
4032: );
4033:

Line 4052: FND_MSG_PUB.initialize;

4048:
4049: -- Initialize message list if p_init_msg_list is set to TRUE.
4050: IF FND_API.to_Boolean( p_init_msg_list )
4051: THEN
4052: FND_MSG_PUB.initialize;
4053: END IF;
4054:
4055:
4056: -- Initialize API return status to SUCCESS

Line 4076: FND_MSG_PUB.Count_And_Get

4072: NULL;
4073: END IF;
4074:
4075: -- Standard call to get message count and if count is 1, get message info.
4076: FND_MSG_PUB.Count_And_Get
4077: ( p_count => x_msg_count,
4078: p_data => x_msg_data
4079: );
4080:

Line 4099: FND_MSG_PUB.initialize;

4095:
4096: -- Initialize message list if p_init_msg_list is set to TRUE.
4097: IF FND_API.to_Boolean( p_init_msg_list )
4098: THEN
4099: FND_MSG_PUB.initialize;
4100: END IF;
4101:
4102:
4103: -- Initialize API return status to SUCCESS

Line 4123: FND_MSG_PUB.Count_And_Get

4119: NULL;
4120: END IF;
4121:
4122: -- Standard call to get message count and if count is 1, get message info.
4123: FND_MSG_PUB.Count_And_Get
4124: ( p_count => x_msg_count,
4125: p_data => x_msg_data
4126: );
4127:

Line 4146: FND_MSG_PUB.initialize;

4142:
4143: -- Initialize message list if p_init_msg_list is set to TRUE.
4144: IF FND_API.to_Boolean( p_init_msg_list )
4145: THEN
4146: FND_MSG_PUB.initialize;
4147: END IF;
4148:
4149:
4150: -- Initialize API return status to SUCCESS

Line 4170: FND_MSG_PUB.Count_And_Get

4166: NULL;
4167: END IF;
4168:
4169: -- Standard call to get message count and if count is 1, get message info.
4170: FND_MSG_PUB.Count_And_Get
4171: ( p_count => x_msg_count,
4172: p_data => x_msg_data
4173: );
4174:

Line 4193: FND_MSG_PUB.initialize;

4189:
4190: -- Initialize message list if p_init_msg_list is set to TRUE.
4191: IF FND_API.to_Boolean( p_init_msg_list )
4192: THEN
4193: FND_MSG_PUB.initialize;
4194: END IF;
4195:
4196:
4197: -- Initialize API return status to SUCCESS

Line 4217: FND_MSG_PUB.Count_And_Get

4213: NULL;
4214: END IF;
4215:
4216: -- Standard call to get message count and if count is 1, get message info.
4217: FND_MSG_PUB.Count_And_Get
4218: ( p_count => x_msg_count,
4219: p_data => x_msg_data
4220: );
4221:

Line 4240: FND_MSG_PUB.initialize;

4236:
4237: -- Initialize message list if p_init_msg_list is set to TRUE.
4238: IF FND_API.to_Boolean( p_init_msg_list )
4239: THEN
4240: FND_MSG_PUB.initialize;
4241: END IF;
4242:
4243:
4244: -- Initialize API return status to SUCCESS

Line 4264: FND_MSG_PUB.Count_And_Get

4260: NULL;
4261: END IF;
4262:
4263: -- Standard call to get message count and if count is 1, get message info.
4264: FND_MSG_PUB.Count_And_Get
4265: ( p_count => x_msg_count,
4266: p_data => x_msg_data
4267: );
4268:

Line 4287: FND_MSG_PUB.initialize;

4283:
4284: -- Initialize message list if p_init_msg_list is set to TRUE.
4285: IF FND_API.to_Boolean( p_init_msg_list )
4286: THEN
4287: FND_MSG_PUB.initialize;
4288: END IF;
4289:
4290:
4291: -- Initialize API return status to SUCCESS

Line 4311: FND_MSG_PUB.Count_And_Get

4307: NULL;
4308: END IF;
4309:
4310: -- Standard call to get message count and if count is 1, get message info.
4311: FND_MSG_PUB.Count_And_Get
4312: ( p_count => x_msg_count,
4313: p_data => x_msg_data
4314: );
4315:

Line 4334: FND_MSG_PUB.initialize;

4330:
4331: -- Initialize message list if p_init_msg_list is set to TRUE.
4332: IF FND_API.to_Boolean( p_init_msg_list )
4333: THEN
4334: FND_MSG_PUB.initialize;
4335: END IF;
4336:
4337:
4338: -- Initialize API return status to SUCCESS

Line 4358: FND_MSG_PUB.Count_And_Get

4354: NULL;
4355: END IF;
4356:
4357: -- Standard call to get message count and if count is 1, get message info.
4358: FND_MSG_PUB.Count_And_Get
4359: ( p_count => x_msg_count,
4360: p_data => x_msg_data
4361: );
4362:

Line 4381: FND_MSG_PUB.initialize;

4377:
4378: -- Initialize message list if p_init_msg_list is set to TRUE.
4379: IF FND_API.to_Boolean( p_init_msg_list )
4380: THEN
4381: FND_MSG_PUB.initialize;
4382: END IF;
4383:
4384:
4385: -- Initialize API return status to SUCCESS

Line 4405: FND_MSG_PUB.Count_And_Get

4401: NULL;
4402: END IF;
4403:
4404: -- Standard call to get message count and if count is 1, get message info.
4405: FND_MSG_PUB.Count_And_Get
4406: ( p_count => x_msg_count,
4407: p_data => x_msg_data
4408: );
4409:

Line 4428: FND_MSG_PUB.initialize;

4424:
4425: -- Initialize message list if p_init_msg_list is set to TRUE.
4426: IF FND_API.to_Boolean( p_init_msg_list )
4427: THEN
4428: FND_MSG_PUB.initialize;
4429: END IF;
4430:
4431:
4432: -- Initialize API return status to SUCCESS

Line 4452: FND_MSG_PUB.Count_And_Get

4448: NULL;
4449: END IF;
4450:
4451: -- Standard call to get message count and if count is 1, get message info.
4452: FND_MSG_PUB.Count_And_Get
4453: ( p_count => x_msg_count,
4454: p_data => x_msg_data
4455: );
4456:

Line 4475: FND_MSG_PUB.initialize;

4471:
4472: -- Initialize message list if p_init_msg_list is set to TRUE.
4473: IF FND_API.to_Boolean( p_init_msg_list )
4474: THEN
4475: FND_MSG_PUB.initialize;
4476: END IF;
4477:
4478:
4479: -- Initialize API return status to SUCCESS

Line 4499: FND_MSG_PUB.Count_And_Get

4495: NULL;
4496: END IF;
4497:
4498: -- Standard call to get message count and if count is 1, get message info.
4499: FND_MSG_PUB.Count_And_Get
4500: ( p_count => x_msg_count,
4501: p_data => x_msg_data
4502: );
4503:

Line 4522: FND_MSG_PUB.initialize;

4518:
4519: -- Initialize message list if p_init_msg_list is set to TRUE.
4520: IF FND_API.to_Boolean( p_init_msg_list )
4521: THEN
4522: FND_MSG_PUB.initialize;
4523: END IF;
4524:
4525:
4526: -- Initialize API return status to SUCCESS

Line 4546: FND_MSG_PUB.Count_And_Get

4542: NULL;
4543: END IF;
4544:
4545: -- Standard call to get message count and if count is 1, get message info.
4546: FND_MSG_PUB.Count_And_Get
4547: ( p_count => x_msg_count,
4548: p_data => x_msg_data
4549: );
4550:

Line 4569: FND_MSG_PUB.initialize;

4565:
4566: -- Initialize message list if p_init_msg_list is set to TRUE.
4567: IF FND_API.to_Boolean( p_init_msg_list )
4568: THEN
4569: FND_MSG_PUB.initialize;
4570: END IF;
4571:
4572:
4573: -- Initialize API return status to SUCCESS

Line 4593: FND_MSG_PUB.Count_And_Get

4589: NULL;
4590: END IF;
4591:
4592: -- Standard call to get message count and if count is 1, get message info.
4593: FND_MSG_PUB.Count_And_Get
4594: ( p_count => x_msg_count,
4595: p_data => x_msg_data
4596: );
4597:

Line 4616: FND_MSG_PUB.initialize;

4612:
4613: -- Initialize message list if p_init_msg_list is set to TRUE.
4614: IF FND_API.to_Boolean( p_init_msg_list )
4615: THEN
4616: FND_MSG_PUB.initialize;
4617: END IF;
4618:
4619:
4620: -- Initialize API return status to SUCCESS

Line 4640: FND_MSG_PUB.Count_And_Get

4636: NULL;
4637: END IF;
4638:
4639: -- Standard call to get message count and if count is 1, get message info.
4640: FND_MSG_PUB.Count_And_Get
4641: ( p_count => x_msg_count,
4642: p_data => x_msg_data
4643: );
4644:

Line 4663: FND_MSG_PUB.initialize;

4659:
4660: -- Initialize message list if p_init_msg_list is set to TRUE.
4661: IF FND_API.to_Boolean( p_init_msg_list )
4662: THEN
4663: FND_MSG_PUB.initialize;
4664: END IF;
4665:
4666:
4667: -- Initialize API return status to SUCCESS

Line 4687: FND_MSG_PUB.Count_And_Get

4683: NULL;
4684: END IF;
4685:
4686: -- Standard call to get message count and if count is 1, get message info.
4687: FND_MSG_PUB.Count_And_Get
4688: ( p_count => x_msg_count,
4689: p_data => x_msg_data
4690: );
4691:

Line 4710: FND_MSG_PUB.initialize;

4706:
4707: -- Initialize message list if p_init_msg_list is set to TRUE.
4708: IF FND_API.to_Boolean( p_init_msg_list )
4709: THEN
4710: FND_MSG_PUB.initialize;
4711: END IF;
4712:
4713:
4714: -- Initialize API return status to SUCCESS

Line 4734: FND_MSG_PUB.Count_And_Get

4730: NULL;
4731: END IF;
4732:
4733: -- Standard call to get message count and if count is 1, get message info.
4734: FND_MSG_PUB.Count_And_Get
4735: ( p_count => x_msg_count,
4736: p_data => x_msg_data
4737: );
4738:

Line 4757: FND_MSG_PUB.initialize;

4753:
4754: -- Initialize message list if p_init_msg_list is set to TRUE.
4755: IF FND_API.to_Boolean( p_init_msg_list )
4756: THEN
4757: FND_MSG_PUB.initialize;
4758: END IF;
4759:
4760:
4761: -- Initialize API return status to SUCCESS

Line 4781: FND_MSG_PUB.Count_And_Get

4777: NULL;
4778: END IF;
4779:
4780: -- Standard call to get message count and if count is 1, get message info.
4781: FND_MSG_PUB.Count_And_Get
4782: ( p_count => x_msg_count,
4783: p_data => x_msg_data
4784: );
4785:

Line 4804: FND_MSG_PUB.initialize;

4800:
4801: -- Initialize message list if p_init_msg_list is set to TRUE.
4802: IF FND_API.to_Boolean( p_init_msg_list )
4803: THEN
4804: FND_MSG_PUB.initialize;
4805: END IF;
4806:
4807:
4808: -- Initialize API return status to SUCCESS

Line 4828: FND_MSG_PUB.Count_And_Get

4824: NULL;
4825: END IF;
4826:
4827: -- Standard call to get message count and if count is 1, get message info.
4828: FND_MSG_PUB.Count_And_Get
4829: ( p_count => x_msg_count,
4830: p_data => x_msg_data
4831: );
4832:

Line 4851: FND_MSG_PUB.initialize;

4847:
4848: -- Initialize message list if p_init_msg_list is set to TRUE.
4849: IF FND_API.to_Boolean( p_init_msg_list )
4850: THEN
4851: FND_MSG_PUB.initialize;
4852: END IF;
4853:
4854:
4855: -- Initialize API return status to SUCCESS

Line 4875: FND_MSG_PUB.Count_And_Get

4871: NULL;
4872: END IF;
4873:
4874: -- Standard call to get message count and if count is 1, get message info.
4875: FND_MSG_PUB.Count_And_Get
4876: ( p_count => x_msg_count,
4877: p_data => x_msg_data
4878: );
4879:

Line 4898: FND_MSG_PUB.initialize;

4894:
4895: -- Initialize message list if p_init_msg_list is set to TRUE.
4896: IF FND_API.to_Boolean( p_init_msg_list )
4897: THEN
4898: FND_MSG_PUB.initialize;
4899: END IF;
4900:
4901:
4902: -- Initialize API return status to SUCCESS

Line 4922: FND_MSG_PUB.Count_And_Get

4918: NULL;
4919: END IF;
4920:
4921: -- Standard call to get message count and if count is 1, get message info.
4922: FND_MSG_PUB.Count_And_Get
4923: ( p_count => x_msg_count,
4924: p_data => x_msg_data
4925: );
4926:

Line 4945: FND_MSG_PUB.initialize;

4941:
4942: -- Initialize message list if p_init_msg_list is set to TRUE.
4943: IF FND_API.to_Boolean( p_init_msg_list )
4944: THEN
4945: FND_MSG_PUB.initialize;
4946: END IF;
4947:
4948:
4949: -- Initialize API return status to SUCCESS

Line 4969: FND_MSG_PUB.Count_And_Get

4965: NULL;
4966: END IF;
4967:
4968: -- Standard call to get message count and if count is 1, get message info.
4969: FND_MSG_PUB.Count_And_Get
4970: ( p_count => x_msg_count,
4971: p_data => x_msg_data
4972: );
4973:

Line 4992: FND_MSG_PUB.initialize;

4988:
4989: -- Initialize message list if p_init_msg_list is set to TRUE.
4990: IF FND_API.to_Boolean( p_init_msg_list )
4991: THEN
4992: FND_MSG_PUB.initialize;
4993: END IF;
4994:
4995:
4996: -- Initialize API return status to SUCCESS

Line 5016: FND_MSG_PUB.Count_And_Get

5012: NULL;
5013: END IF;
5014:
5015: -- Standard call to get message count and if count is 1, get message info.
5016: FND_MSG_PUB.Count_And_Get
5017: ( p_count => x_msg_count,
5018: p_data => x_msg_data
5019: );
5020:

Line 5039: FND_MSG_PUB.initialize;

5035:
5036: -- Initialize message list if p_init_msg_list is set to TRUE.
5037: IF FND_API.to_Boolean( p_init_msg_list )
5038: THEN
5039: FND_MSG_PUB.initialize;
5040: END IF;
5041:
5042:
5043: -- Initialize API return status to SUCCESS

Line 5063: FND_MSG_PUB.Count_And_Get

5059: NULL;
5060: END IF;
5061:
5062: -- Standard call to get message count and if count is 1, get message info.
5063: FND_MSG_PUB.Count_And_Get
5064: ( p_count => x_msg_count,
5065: p_data => x_msg_data
5066: );
5067:

Line 5086: FND_MSG_PUB.initialize;

5082:
5083: -- Initialize message list if p_init_msg_list is set to TRUE.
5084: IF FND_API.to_Boolean( p_init_msg_list )
5085: THEN
5086: FND_MSG_PUB.initialize;
5087: END IF;
5088:
5089:
5090: -- Initialize API return status to SUCCESS

Line 5110: FND_MSG_PUB.Count_And_Get

5106: NULL;
5107: END IF;
5108:
5109: -- Standard call to get message count and if count is 1, get message info.
5110: FND_MSG_PUB.Count_And_Get
5111: ( p_count => x_msg_count,
5112: p_data => x_msg_data
5113: );
5114:

Line 5133: FND_MSG_PUB.initialize;

5129:
5130: -- Initialize message list if p_init_msg_list is set to TRUE.
5131: IF FND_API.to_Boolean( p_init_msg_list )
5132: THEN
5133: FND_MSG_PUB.initialize;
5134: END IF;
5135:
5136:
5137: -- Initialize API return status to SUCCESS

Line 5157: FND_MSG_PUB.Count_And_Get

5153: NULL;
5154: END IF;
5155:
5156: -- Standard call to get message count and if count is 1, get message info.
5157: FND_MSG_PUB.Count_And_Get
5158: ( p_count => x_msg_count,
5159: p_data => x_msg_data
5160: );
5161:

Line 5180: FND_MSG_PUB.initialize;

5176:
5177: -- Initialize message list if p_init_msg_list is set to TRUE.
5178: IF FND_API.to_Boolean( p_init_msg_list )
5179: THEN
5180: FND_MSG_PUB.initialize;
5181: END IF;
5182:
5183:
5184: -- Initialize API return status to SUCCESS

Line 5204: FND_MSG_PUB.Count_And_Get

5200: NULL;
5201: END IF;
5202:
5203: -- Standard call to get message count and if count is 1, get message info.
5204: FND_MSG_PUB.Count_And_Get
5205: ( p_count => x_msg_count,
5206: p_data => x_msg_data
5207: );
5208:

Line 5227: FND_MSG_PUB.initialize;

5223:
5224: -- Initialize message list if p_init_msg_list is set to TRUE.
5225: IF FND_API.to_Boolean( p_init_msg_list )
5226: THEN
5227: FND_MSG_PUB.initialize;
5228: END IF;
5229:
5230:
5231: -- Initialize API return status to SUCCESS

Line 5251: FND_MSG_PUB.Count_And_Get

5247: NULL;
5248: END IF;
5249:
5250: -- Standard call to get message count and if count is 1, get message info.
5251: FND_MSG_PUB.Count_And_Get
5252: ( p_count => x_msg_count,
5253: p_data => x_msg_data
5254: );
5255:

Line 5274: FND_MSG_PUB.initialize;

5270:
5271: -- Initialize message list if p_init_msg_list is set to TRUE.
5272: IF FND_API.to_Boolean( p_init_msg_list )
5273: THEN
5274: FND_MSG_PUB.initialize;
5275: END IF;
5276:
5277:
5278: -- Initialize API return status to SUCCESS

Line 5298: FND_MSG_PUB.Count_And_Get

5294: NULL;
5295: END IF;
5296:
5297: -- Standard call to get message count and if count is 1, get message info.
5298: FND_MSG_PUB.Count_And_Get
5299: ( p_count => x_msg_count,
5300: p_data => x_msg_data
5301: );
5302:

Line 5321: FND_MSG_PUB.initialize;

5317:
5318: -- Initialize message list if p_init_msg_list is set to TRUE.
5319: IF FND_API.to_Boolean( p_init_msg_list )
5320: THEN
5321: FND_MSG_PUB.initialize;
5322: END IF;
5323:
5324:
5325: -- Initialize API return status to SUCCESS

Line 5345: FND_MSG_PUB.Count_And_Get

5341: NULL;
5342: END IF;
5343:
5344: -- Standard call to get message count and if count is 1, get message info.
5345: FND_MSG_PUB.Count_And_Get
5346: ( p_count => x_msg_count,
5347: p_data => x_msg_data
5348: );
5349:

Line 5368: FND_MSG_PUB.initialize;

5364:
5365: -- Initialize message list if p_init_msg_list is set to TRUE.
5366: IF FND_API.to_Boolean( p_init_msg_list )
5367: THEN
5368: FND_MSG_PUB.initialize;
5369: END IF;
5370:
5371:
5372: -- Initialize API return status to SUCCESS

Line 5392: FND_MSG_PUB.Count_And_Get

5388: NULL;
5389: END IF;
5390:
5391: -- Standard call to get message count and if count is 1, get message info.
5392: FND_MSG_PUB.Count_And_Get
5393: ( p_count => x_msg_count,
5394: p_data => x_msg_data
5395: );
5396:

Line 5415: FND_MSG_PUB.initialize;

5411:
5412: -- Initialize message list if p_init_msg_list is set to TRUE.
5413: IF FND_API.to_Boolean( p_init_msg_list )
5414: THEN
5415: FND_MSG_PUB.initialize;
5416: END IF;
5417:
5418:
5419: -- Initialize API return status to SUCCESS

Line 5439: FND_MSG_PUB.Count_And_Get

5435: NULL;
5436: END IF;
5437:
5438: -- Standard call to get message count and if count is 1, get message info.
5439: FND_MSG_PUB.Count_And_Get
5440: ( p_count => x_msg_count,
5441: p_data => x_msg_data
5442: );
5443:

Line 5462: FND_MSG_PUB.initialize;

5458:
5459: -- Initialize message list if p_init_msg_list is set to TRUE.
5460: IF FND_API.to_Boolean( p_init_msg_list )
5461: THEN
5462: FND_MSG_PUB.initialize;
5463: END IF;
5464:
5465:
5466: -- Initialize API return status to SUCCESS

Line 5486: FND_MSG_PUB.Count_And_Get

5482: NULL;
5483: END IF;
5484:
5485: -- Standard call to get message count and if count is 1, get message info.
5486: FND_MSG_PUB.Count_And_Get
5487: ( p_count => x_msg_count,
5488: p_data => x_msg_data
5489: );
5490:

Line 5509: FND_MSG_PUB.initialize;

5505:
5506: -- Initialize message list if p_init_msg_list is set to TRUE.
5507: IF FND_API.to_Boolean( p_init_msg_list )
5508: THEN
5509: FND_MSG_PUB.initialize;
5510: END IF;
5511:
5512:
5513: -- Initialize API return status to SUCCESS

Line 5533: FND_MSG_PUB.Count_And_Get

5529: NULL;
5530: END IF;
5531:
5532: -- Standard call to get message count and if count is 1, get message info.
5533: FND_MSG_PUB.Count_And_Get
5534: ( p_count => x_msg_count,
5535: p_data => x_msg_data
5536: );
5537:

Line 5556: FND_MSG_PUB.initialize;

5552:
5553: -- Initialize message list if p_init_msg_list is set to TRUE.
5554: IF FND_API.to_Boolean( p_init_msg_list )
5555: THEN
5556: FND_MSG_PUB.initialize;
5557: END IF;
5558:
5559:
5560: -- Initialize API return status to SUCCESS

Line 5580: FND_MSG_PUB.Count_And_Get

5576: NULL;
5577: END IF;
5578:
5579: -- Standard call to get message count and if count is 1, get message info.
5580: FND_MSG_PUB.Count_And_Get
5581: ( p_count => x_msg_count,
5582: p_data => x_msg_data
5583: );
5584:

Line 5603: FND_MSG_PUB.initialize;

5599:
5600: -- Initialize message list if p_init_msg_list is set to TRUE.
5601: IF FND_API.to_Boolean( p_init_msg_list )
5602: THEN
5603: FND_MSG_PUB.initialize;
5604: END IF;
5605:
5606:
5607: -- Initialize API return status to SUCCESS

Line 5627: FND_MSG_PUB.Count_And_Get

5623: NULL;
5624: END IF;
5625:
5626: -- Standard call to get message count and if count is 1, get message info.
5627: FND_MSG_PUB.Count_And_Get
5628: ( p_count => x_msg_count,
5629: p_data => x_msg_data
5630: );
5631:

Line 5650: FND_MSG_PUB.initialize;

5646:
5647: -- Initialize message list if p_init_msg_list is set to TRUE.
5648: IF FND_API.to_Boolean( p_init_msg_list )
5649: THEN
5650: FND_MSG_PUB.initialize;
5651: END IF;
5652:
5653:
5654: -- Initialize API return status to SUCCESS

Line 5674: FND_MSG_PUB.Count_And_Get

5670: NULL;
5671: END IF;
5672:
5673: -- Standard call to get message count and if count is 1, get message info.
5674: FND_MSG_PUB.Count_And_Get
5675: ( p_count => x_msg_count,
5676: p_data => x_msg_data
5677: );
5678:

Line 5697: FND_MSG_PUB.initialize;

5693:
5694: -- Initialize message list if p_init_msg_list is set to TRUE.
5695: IF FND_API.to_Boolean( p_init_msg_list )
5696: THEN
5697: FND_MSG_PUB.initialize;
5698: END IF;
5699:
5700:
5701: -- Initialize API return status to SUCCESS

Line 5721: FND_MSG_PUB.Count_And_Get

5717: NULL;
5718: END IF;
5719:
5720: -- Standard call to get message count and if count is 1, get message info.
5721: FND_MSG_PUB.Count_And_Get
5722: ( p_count => x_msg_count,
5723: p_data => x_msg_data
5724: );
5725:

Line 5744: FND_MSG_PUB.initialize;

5740:
5741: -- Initialize message list if p_init_msg_list is set to TRUE.
5742: IF FND_API.to_Boolean( p_init_msg_list )
5743: THEN
5744: FND_MSG_PUB.initialize;
5745: END IF;
5746:
5747:
5748: -- Initialize API return status to SUCCESS

Line 5768: FND_MSG_PUB.Count_And_Get

5764: NULL;
5765: END IF;
5766:
5767: -- Standard call to get message count and if count is 1, get message info.
5768: FND_MSG_PUB.Count_And_Get
5769: ( p_count => x_msg_count,
5770: p_data => x_msg_data
5771: );
5772:

Line 5791: FND_MSG_PUB.initialize;

5787:
5788: -- Initialize message list if p_init_msg_list is set to TRUE.
5789: IF FND_API.to_Boolean( p_init_msg_list )
5790: THEN
5791: FND_MSG_PUB.initialize;
5792: END IF;
5793:
5794:
5795: -- Initialize API return status to SUCCESS

Line 5815: FND_MSG_PUB.Count_And_Get

5811: NULL;
5812: END IF;
5813:
5814: -- Standard call to get message count and if count is 1, get message info.
5815: FND_MSG_PUB.Count_And_Get
5816: ( p_count => x_msg_count,
5817: p_data => x_msg_data
5818: );
5819:

Line 5838: FND_MSG_PUB.initialize;

5834:
5835: -- Initialize message list if p_init_msg_list is set to TRUE.
5836: IF FND_API.to_Boolean( p_init_msg_list )
5837: THEN
5838: FND_MSG_PUB.initialize;
5839: END IF;
5840:
5841:
5842: -- Initialize API return status to SUCCESS

Line 5862: FND_MSG_PUB.Count_And_Get

5858: NULL;
5859: END IF;
5860:
5861: -- Standard call to get message count and if count is 1, get message info.
5862: FND_MSG_PUB.Count_And_Get
5863: ( p_count => x_msg_count,
5864: p_data => x_msg_data
5865: );
5866:

Line 5885: FND_MSG_PUB.initialize;

5881:
5882: -- Initialize message list if p_init_msg_list is set to TRUE.
5883: IF FND_API.to_Boolean( p_init_msg_list )
5884: THEN
5885: FND_MSG_PUB.initialize;
5886: END IF;
5887:
5888:
5889: -- Initialize API return status to SUCCESS

Line 5909: FND_MSG_PUB.Count_And_Get

5905: NULL;
5906: END IF;
5907:
5908: -- Standard call to get message count and if count is 1, get message info.
5909: FND_MSG_PUB.Count_And_Get
5910: ( p_count => x_msg_count,
5911: p_data => x_msg_data
5912: );
5913:

Line 5932: FND_MSG_PUB.initialize;

5928:
5929: -- Initialize message list if p_init_msg_list is set to TRUE.
5930: IF FND_API.to_Boolean( p_init_msg_list )
5931: THEN
5932: FND_MSG_PUB.initialize;
5933: END IF;
5934:
5935:
5936: -- Initialize API return status to SUCCESS

Line 5956: FND_MSG_PUB.Count_And_Get

5952: NULL;
5953: END IF;
5954:
5955: -- Standard call to get message count and if count is 1, get message info.
5956: FND_MSG_PUB.Count_And_Get
5957: ( p_count => x_msg_count,
5958: p_data => x_msg_data
5959: );
5960:

Line 5979: FND_MSG_PUB.initialize;

5975:
5976: -- Initialize message list if p_init_msg_list is set to TRUE.
5977: IF FND_API.to_Boolean( p_init_msg_list )
5978: THEN
5979: FND_MSG_PUB.initialize;
5980: END IF;
5981:
5982:
5983: -- Initialize API return status to SUCCESS

Line 6003: FND_MSG_PUB.Count_And_Get

5999: NULL;
6000: END IF;
6001:
6002: -- Standard call to get message count and if count is 1, get message info.
6003: FND_MSG_PUB.Count_And_Get
6004: ( p_count => x_msg_count,
6005: p_data => x_msg_data
6006: );
6007:

Line 6026: FND_MSG_PUB.initialize;

6022:
6023: -- Initialize message list if p_init_msg_list is set to TRUE.
6024: IF FND_API.to_Boolean( p_init_msg_list )
6025: THEN
6026: FND_MSG_PUB.initialize;
6027: END IF;
6028:
6029:
6030: -- Initialize API return status to SUCCESS

Line 6050: FND_MSG_PUB.Count_And_Get

6046: NULL;
6047: END IF;
6048:
6049: -- Standard call to get message count and if count is 1, get message info.
6050: FND_MSG_PUB.Count_And_Get
6051: ( p_count => x_msg_count,
6052: p_data => x_msg_data
6053: );
6054:

Line 6073: FND_MSG_PUB.initialize;

6069:
6070: -- Initialize message list if p_init_msg_list is set to TRUE.
6071: IF FND_API.to_Boolean( p_init_msg_list )
6072: THEN
6073: FND_MSG_PUB.initialize;
6074: END IF;
6075:
6076:
6077: -- Initialize API return status to SUCCESS

Line 6097: FND_MSG_PUB.Count_And_Get

6093: NULL;
6094: END IF;
6095:
6096: -- Standard call to get message count and if count is 1, get message info.
6097: FND_MSG_PUB.Count_And_Get
6098: ( p_count => x_msg_count,
6099: p_data => x_msg_data
6100: );
6101:

Line 6120: FND_MSG_PUB.initialize;

6116:
6117: -- Initialize message list if p_init_msg_list is set to TRUE.
6118: IF FND_API.to_Boolean( p_init_msg_list )
6119: THEN
6120: FND_MSG_PUB.initialize;
6121: END IF;
6122:
6123:
6124: -- Initialize API return status to SUCCESS

Line 6144: FND_MSG_PUB.Count_And_Get

6140: NULL;
6141: END IF;
6142:
6143: -- Standard call to get message count and if count is 1, get message info.
6144: FND_MSG_PUB.Count_And_Get
6145: ( p_count => x_msg_count,
6146: p_data => x_msg_data
6147: );
6148:

Line 6167: FND_MSG_PUB.initialize;

6163:
6164: -- Initialize message list if p_init_msg_list is set to TRUE.
6165: IF FND_API.to_Boolean( p_init_msg_list )
6166: THEN
6167: FND_MSG_PUB.initialize;
6168: END IF;
6169:
6170:
6171: -- Initialize API return status to SUCCESS

Line 6191: FND_MSG_PUB.Count_And_Get

6187: NULL;
6188: END IF;
6189:
6190: -- Standard call to get message count and if count is 1, get message info.
6191: FND_MSG_PUB.Count_And_Get
6192: ( p_count => x_msg_count,
6193: p_data => x_msg_data
6194: );
6195:

Line 6214: FND_MSG_PUB.initialize;

6210:
6211: -- Initialize message list if p_init_msg_list is set to TRUE.
6212: IF FND_API.to_Boolean( p_init_msg_list )
6213: THEN
6214: FND_MSG_PUB.initialize;
6215: END IF;
6216:
6217:
6218: -- Initialize API return status to SUCCESS

Line 6238: FND_MSG_PUB.Count_And_Get

6234: NULL;
6235: END IF;
6236:
6237: -- Standard call to get message count and if count is 1, get message info.
6238: FND_MSG_PUB.Count_And_Get
6239: ( p_count => x_msg_count,
6240: p_data => x_msg_data
6241: );
6242:

Line 6261: FND_MSG_PUB.initialize;

6257:
6258: -- Initialize message list if p_init_msg_list is set to TRUE.
6259: IF FND_API.to_Boolean( p_init_msg_list )
6260: THEN
6261: FND_MSG_PUB.initialize;
6262: END IF;
6263:
6264:
6265: -- Initialize API return status to SUCCESS

Line 6285: FND_MSG_PUB.Count_And_Get

6281: NULL;
6282: END IF;
6283:
6284: -- Standard call to get message count and if count is 1, get message info.
6285: FND_MSG_PUB.Count_And_Get
6286: ( p_count => x_msg_count,
6287: p_data => x_msg_data
6288: );
6289:

Line 6308: FND_MSG_PUB.initialize;

6304:
6305: -- Initialize message list if p_init_msg_list is set to TRUE.
6306: IF FND_API.to_Boolean( p_init_msg_list )
6307: THEN
6308: FND_MSG_PUB.initialize;
6309: END IF;
6310:
6311:
6312: -- Initialize API return status to SUCCESS

Line 6332: FND_MSG_PUB.Count_And_Get

6328: NULL;
6329: END IF;
6330:
6331: -- Standard call to get message count and if count is 1, get message info.
6332: FND_MSG_PUB.Count_And_Get
6333: ( p_count => x_msg_count,
6334: p_data => x_msg_data
6335: );
6336:

Line 6355: FND_MSG_PUB.initialize;

6351:
6352: -- Initialize message list if p_init_msg_list is set to TRUE.
6353: IF FND_API.to_Boolean( p_init_msg_list )
6354: THEN
6355: FND_MSG_PUB.initialize;
6356: END IF;
6357:
6358:
6359: -- Initialize API return status to SUCCESS

Line 6379: FND_MSG_PUB.Count_And_Get

6375: NULL;
6376: END IF;
6377:
6378: -- Standard call to get message count and if count is 1, get message info.
6379: FND_MSG_PUB.Count_And_Get
6380: ( p_count => x_msg_count,
6381: p_data => x_msg_data
6382: );
6383:

Line 6402: FND_MSG_PUB.initialize;

6398:
6399: -- Initialize message list if p_init_msg_list is set to TRUE.
6400: IF FND_API.to_Boolean( p_init_msg_list )
6401: THEN
6402: FND_MSG_PUB.initialize;
6403: END IF;
6404:
6405:
6406: -- Initialize API return status to SUCCESS

Line 6426: FND_MSG_PUB.Count_And_Get

6422: NULL;
6423: END IF;
6424:
6425: -- Standard call to get message count and if count is 1, get message info.
6426: FND_MSG_PUB.Count_And_Get
6427: ( p_count => x_msg_count,
6428: p_data => x_msg_data
6429: );
6430:

Line 6449: FND_MSG_PUB.initialize;

6445:
6446: -- Initialize message list if p_init_msg_list is set to TRUE.
6447: IF FND_API.to_Boolean( p_init_msg_list )
6448: THEN
6449: FND_MSG_PUB.initialize;
6450: END IF;
6451:
6452:
6453: -- Initialize API return status to SUCCESS

Line 6473: FND_MSG_PUB.Count_And_Get

6469: NULL;
6470: END IF;
6471:
6472: -- Standard call to get message count and if count is 1, get message info.
6473: FND_MSG_PUB.Count_And_Get
6474: ( p_count => x_msg_count,
6475: p_data => x_msg_data
6476: );
6477:

Line 6496: FND_MSG_PUB.initialize;

6492:
6493: -- Initialize message list if p_init_msg_list is set to TRUE.
6494: IF FND_API.to_Boolean( p_init_msg_list )
6495: THEN
6496: FND_MSG_PUB.initialize;
6497: END IF;
6498:
6499:
6500: -- Initialize API return status to SUCCESS

Line 6520: FND_MSG_PUB.Count_And_Get

6516: NULL;
6517: END IF;
6518:
6519: -- Standard call to get message count and if count is 1, get message info.
6520: FND_MSG_PUB.Count_And_Get
6521: ( p_count => x_msg_count,
6522: p_data => x_msg_data
6523: );
6524:

Line 6543: FND_MSG_PUB.initialize;

6539:
6540: -- Initialize message list if p_init_msg_list is set to TRUE.
6541: IF FND_API.to_Boolean( p_init_msg_list )
6542: THEN
6543: FND_MSG_PUB.initialize;
6544: END IF;
6545:
6546:
6547: -- Initialize API return status to SUCCESS

Line 6567: FND_MSG_PUB.Count_And_Get

6563: NULL;
6564: END IF;
6565:
6566: -- Standard call to get message count and if count is 1, get message info.
6567: FND_MSG_PUB.Count_And_Get
6568: ( p_count => x_msg_count,
6569: p_data => x_msg_data
6570: );
6571:

Line 6590: FND_MSG_PUB.initialize;

6586:
6587: -- Initialize message list if p_init_msg_list is set to TRUE.
6588: IF FND_API.to_Boolean( p_init_msg_list )
6589: THEN
6590: FND_MSG_PUB.initialize;
6591: END IF;
6592:
6593:
6594: -- Initialize API return status to SUCCESS

Line 6614: FND_MSG_PUB.Count_And_Get

6610: NULL;
6611: END IF;
6612:
6613: -- Standard call to get message count and if count is 1, get message info.
6614: FND_MSG_PUB.Count_And_Get
6615: ( p_count => x_msg_count,
6616: p_data => x_msg_data
6617: );
6618:

Line 6637: FND_MSG_PUB.initialize;

6633:
6634: -- Initialize message list if p_init_msg_list is set to TRUE.
6635: IF FND_API.to_Boolean( p_init_msg_list )
6636: THEN
6637: FND_MSG_PUB.initialize;
6638: END IF;
6639:
6640:
6641: -- Initialize API return status to SUCCESS

Line 6661: FND_MSG_PUB.Count_And_Get

6657: NULL;
6658: END IF;
6659:
6660: -- Standard call to get message count and if count is 1, get message info.
6661: FND_MSG_PUB.Count_And_Get
6662: ( p_count => x_msg_count,
6663: p_data => x_msg_data
6664: );
6665:

Line 6684: FND_MSG_PUB.initialize;

6680:
6681: -- Initialize message list if p_init_msg_list is set to TRUE.
6682: IF FND_API.to_Boolean( p_init_msg_list )
6683: THEN
6684: FND_MSG_PUB.initialize;
6685: END IF;
6686:
6687:
6688: -- Initialize API return status to SUCCESS

Line 6708: FND_MSG_PUB.Count_And_Get

6704: NULL;
6705: END IF;
6706:
6707: -- Standard call to get message count and if count is 1, get message info.
6708: FND_MSG_PUB.Count_And_Get
6709: ( p_count => x_msg_count,
6710: p_data => x_msg_data
6711: );
6712:

Line 6731: FND_MSG_PUB.initialize;

6727:
6728: -- Initialize message list if p_init_msg_list is set to TRUE.
6729: IF FND_API.to_Boolean( p_init_msg_list )
6730: THEN
6731: FND_MSG_PUB.initialize;
6732: END IF;
6733:
6734:
6735: -- Initialize API return status to SUCCESS

Line 6755: FND_MSG_PUB.Count_And_Get

6751: NULL;
6752: END IF;
6753:
6754: -- Standard call to get message count and if count is 1, get message info.
6755: FND_MSG_PUB.Count_And_Get
6756: ( p_count => x_msg_count,
6757: p_data => x_msg_data
6758: );
6759:

Line 6778: FND_MSG_PUB.initialize;

6774:
6775: -- Initialize message list if p_init_msg_list is set to TRUE.
6776: IF FND_API.to_Boolean( p_init_msg_list )
6777: THEN
6778: FND_MSG_PUB.initialize;
6779: END IF;
6780:
6781:
6782: -- Initialize API return status to SUCCESS

Line 6802: FND_MSG_PUB.Count_And_Get

6798: NULL;
6799: END IF;
6800:
6801: -- Standard call to get message count and if count is 1, get message info.
6802: FND_MSG_PUB.Count_And_Get
6803: ( p_count => x_msg_count,
6804: p_data => x_msg_data
6805: );
6806:

Line 6825: FND_MSG_PUB.initialize;

6821:
6822: -- Initialize message list if p_init_msg_list is set to TRUE.
6823: IF FND_API.to_Boolean( p_init_msg_list )
6824: THEN
6825: FND_MSG_PUB.initialize;
6826: END IF;
6827:
6828:
6829: -- Initialize API return status to SUCCESS

Line 6849: FND_MSG_PUB.Count_And_Get

6845: NULL;
6846: END IF;
6847:
6848: -- Standard call to get message count and if count is 1, get message info.
6849: FND_MSG_PUB.Count_And_Get
6850: ( p_count => x_msg_count,
6851: p_data => x_msg_data
6852: );
6853:

Line 6872: FND_MSG_PUB.initialize;

6868:
6869: -- Initialize message list if p_init_msg_list is set to TRUE.
6870: IF FND_API.to_Boolean( p_init_msg_list )
6871: THEN
6872: FND_MSG_PUB.initialize;
6873: END IF;
6874:
6875:
6876: -- Initialize API return status to SUCCESS

Line 6896: FND_MSG_PUB.Count_And_Get

6892: NULL;
6893: END IF;
6894:
6895: -- Standard call to get message count and if count is 1, get message info.
6896: FND_MSG_PUB.Count_And_Get
6897: ( p_count => x_msg_count,
6898: p_data => x_msg_data
6899: );
6900:

Line 6919: FND_MSG_PUB.initialize;

6915:
6916: -- Initialize message list if p_init_msg_list is set to TRUE.
6917: IF FND_API.to_Boolean( p_init_msg_list )
6918: THEN
6919: FND_MSG_PUB.initialize;
6920: END IF;
6921:
6922:
6923: -- Initialize API return status to SUCCESS

Line 6943: FND_MSG_PUB.Count_And_Get

6939: NULL;
6940: END IF;
6941:
6942: -- Standard call to get message count and if count is 1, get message info.
6943: FND_MSG_PUB.Count_And_Get
6944: ( p_count => x_msg_count,
6945: p_data => x_msg_data
6946: );
6947:

Line 6966: FND_MSG_PUB.initialize;

6962:
6963: -- Initialize message list if p_init_msg_list is set to TRUE.
6964: IF FND_API.to_Boolean( p_init_msg_list )
6965: THEN
6966: FND_MSG_PUB.initialize;
6967: END IF;
6968:
6969:
6970: -- Initialize API return status to SUCCESS

Line 6990: FND_MSG_PUB.Count_And_Get

6986: NULL;
6987: END IF;
6988:
6989: -- Standard call to get message count and if count is 1, get message info.
6990: FND_MSG_PUB.Count_And_Get
6991: ( p_count => x_msg_count,
6992: p_data => x_msg_data
6993: );
6994:

Line 7013: FND_MSG_PUB.initialize;

7009:
7010: -- Initialize message list if p_init_msg_list is set to TRUE.
7011: IF FND_API.to_Boolean( p_init_msg_list )
7012: THEN
7013: FND_MSG_PUB.initialize;
7014: END IF;
7015:
7016:
7017: -- Initialize API return status to SUCCESS

Line 7037: FND_MSG_PUB.Count_And_Get

7033: NULL;
7034: END IF;
7035:
7036: -- Standard call to get message count and if count is 1, get message info.
7037: FND_MSG_PUB.Count_And_Get
7038: ( p_count => x_msg_count,
7039: p_data => x_msg_data
7040: );
7041:

Line 7060: FND_MSG_PUB.initialize;

7056:
7057: -- Initialize message list if p_init_msg_list is set to TRUE.
7058: IF FND_API.to_Boolean( p_init_msg_list )
7059: THEN
7060: FND_MSG_PUB.initialize;
7061: END IF;
7062:
7063:
7064: -- Initialize API return status to SUCCESS

Line 7084: FND_MSG_PUB.Count_And_Get

7080: NULL;
7081: END IF;
7082:
7083: -- Standard call to get message count and if count is 1, get message info.
7084: FND_MSG_PUB.Count_And_Get
7085: ( p_count => x_msg_count,
7086: p_data => x_msg_data
7087: );
7088:

Line 7107: FND_MSG_PUB.initialize;

7103:
7104: -- Initialize message list if p_init_msg_list is set to TRUE.
7105: IF FND_API.to_Boolean( p_init_msg_list )
7106: THEN
7107: FND_MSG_PUB.initialize;
7108: END IF;
7109:
7110:
7111: -- Initialize API return status to SUCCESS

Line 7131: FND_MSG_PUB.Count_And_Get

7127: NULL;
7128: END IF;
7129:
7130: -- Standard call to get message count and if count is 1, get message info.
7131: FND_MSG_PUB.Count_And_Get
7132: ( p_count => x_msg_count,
7133: p_data => x_msg_data
7134: );
7135:

Line 7154: FND_MSG_PUB.initialize;

7150:
7151: -- Initialize message list if p_init_msg_list is set to TRUE.
7152: IF FND_API.to_Boolean( p_init_msg_list )
7153: THEN
7154: FND_MSG_PUB.initialize;
7155: END IF;
7156:
7157:
7158: -- Initialize API return status to SUCCESS

Line 7178: FND_MSG_PUB.Count_And_Get

7174: NULL;
7175: END IF;
7176:
7177: -- Standard call to get message count and if count is 1, get message info.
7178: FND_MSG_PUB.Count_And_Get
7179: ( p_count => x_msg_count,
7180: p_data => x_msg_data
7181: );
7182:

Line 7201: FND_MSG_PUB.initialize;

7197:
7198: -- Initialize message list if p_init_msg_list is set to TRUE.
7199: IF FND_API.to_Boolean( p_init_msg_list )
7200: THEN
7201: FND_MSG_PUB.initialize;
7202: END IF;
7203:
7204:
7205: -- Initialize API return status to SUCCESS

Line 7225: FND_MSG_PUB.Count_And_Get

7221: NULL;
7222: END IF;
7223:
7224: -- Standard call to get message count and if count is 1, get message info.
7225: FND_MSG_PUB.Count_And_Get
7226: ( p_count => x_msg_count,
7227: p_data => x_msg_data
7228: );
7229:

Line 7248: FND_MSG_PUB.initialize;

7244:
7245: -- Initialize message list if p_init_msg_list is set to TRUE.
7246: IF FND_API.to_Boolean( p_init_msg_list )
7247: THEN
7248: FND_MSG_PUB.initialize;
7249: END IF;
7250:
7251:
7252: -- Initialize API return status to SUCCESS

Line 7272: FND_MSG_PUB.Count_And_Get

7268: NULL;
7269: END IF;
7270:
7271: -- Standard call to get message count and if count is 1, get message info.
7272: FND_MSG_PUB.Count_And_Get
7273: ( p_count => x_msg_count,
7274: p_data => x_msg_data
7275: );
7276:

Line 7295: FND_MSG_PUB.initialize;

7291:
7292: -- Initialize message list if p_init_msg_list is set to TRUE.
7293: IF FND_API.to_Boolean( p_init_msg_list )
7294: THEN
7295: FND_MSG_PUB.initialize;
7296: END IF;
7297:
7298:
7299: -- Initialize API return status to SUCCESS

Line 7319: FND_MSG_PUB.Count_And_Get

7315: NULL;
7316: END IF;
7317:
7318: -- Standard call to get message count and if count is 1, get message info.
7319: FND_MSG_PUB.Count_And_Get
7320: ( p_count => x_msg_count,
7321: p_data => x_msg_data
7322: );
7323:

Line 7342: FND_MSG_PUB.initialize;

7338:
7339: -- Initialize message list if p_init_msg_list is set to TRUE.
7340: IF FND_API.to_Boolean( p_init_msg_list )
7341: THEN
7342: FND_MSG_PUB.initialize;
7343: END IF;
7344:
7345:
7346: -- Initialize API return status to SUCCESS

Line 7366: FND_MSG_PUB.Count_And_Get

7362: NULL;
7363: END IF;
7364:
7365: -- Standard call to get message count and if count is 1, get message info.
7366: FND_MSG_PUB.Count_And_Get
7367: ( p_count => x_msg_count,
7368: p_data => x_msg_data
7369: );
7370:

Line 7389: FND_MSG_PUB.initialize;

7385:
7386: -- Initialize message list if p_init_msg_list is set to TRUE.
7387: IF FND_API.to_Boolean( p_init_msg_list )
7388: THEN
7389: FND_MSG_PUB.initialize;
7390: END IF;
7391:
7392:
7393: -- Initialize API return status to SUCCESS

Line 7413: FND_MSG_PUB.Count_And_Get

7409: NULL;
7410: END IF;
7411:
7412: -- Standard call to get message count and if count is 1, get message info.
7413: FND_MSG_PUB.Count_And_Get
7414: ( p_count => x_msg_count,
7415: p_data => x_msg_data
7416: );
7417:

Line 7436: FND_MSG_PUB.initialize;

7432:
7433: -- Initialize message list if p_init_msg_list is set to TRUE.
7434: IF FND_API.to_Boolean( p_init_msg_list )
7435: THEN
7436: FND_MSG_PUB.initialize;
7437: END IF;
7438:
7439:
7440: -- Initialize API return status to SUCCESS

Line 7460: FND_MSG_PUB.Count_And_Get

7456: NULL;
7457: END IF;
7458:
7459: -- Standard call to get message count and if count is 1, get message info.
7460: FND_MSG_PUB.Count_And_Get
7461: ( p_count => x_msg_count,
7462: p_data => x_msg_data
7463: );
7464:

Line 7483: FND_MSG_PUB.initialize;

7479:
7480: -- Initialize message list if p_init_msg_list is set to TRUE.
7481: IF FND_API.to_Boolean( p_init_msg_list )
7482: THEN
7483: FND_MSG_PUB.initialize;
7484: END IF;
7485:
7486:
7487: -- Initialize API return status to SUCCESS

Line 7507: FND_MSG_PUB.Count_And_Get

7503: NULL;
7504: END IF;
7505:
7506: -- Standard call to get message count and if count is 1, get message info.
7507: FND_MSG_PUB.Count_And_Get
7508: ( p_count => x_msg_count,
7509: p_data => x_msg_data
7510: );
7511:

Line 7530: FND_MSG_PUB.initialize;

7526:
7527: -- Initialize message list if p_init_msg_list is set to TRUE.
7528: IF FND_API.to_Boolean( p_init_msg_list )
7529: THEN
7530: FND_MSG_PUB.initialize;
7531: END IF;
7532:
7533:
7534: -- Initialize API return status to SUCCESS

Line 7554: FND_MSG_PUB.Count_And_Get

7550: NULL;
7551: END IF;
7552:
7553: -- Standard call to get message count and if count is 1, get message info.
7554: FND_MSG_PUB.Count_And_Get
7555: ( p_count => x_msg_count,
7556: p_data => x_msg_data
7557: );
7558:

Line 7577: FND_MSG_PUB.initialize;

7573:
7574: -- Initialize message list if p_init_msg_list is set to TRUE.
7575: IF FND_API.to_Boolean( p_init_msg_list )
7576: THEN
7577: FND_MSG_PUB.initialize;
7578: END IF;
7579:
7580:
7581: -- Initialize API return status to SUCCESS

Line 7601: FND_MSG_PUB.Count_And_Get

7597: NULL;
7598: END IF;
7599:
7600: -- Standard call to get message count and if count is 1, get message info.
7601: FND_MSG_PUB.Count_And_Get
7602: ( p_count => x_msg_count,
7603: p_data => x_msg_data
7604: );
7605:

Line 7624: FND_MSG_PUB.initialize;

7620:
7621: -- Initialize message list if p_init_msg_list is set to TRUE.
7622: IF FND_API.to_Boolean( p_init_msg_list )
7623: THEN
7624: FND_MSG_PUB.initialize;
7625: END IF;
7626:
7627:
7628: -- Initialize API return status to SUCCESS

Line 7648: FND_MSG_PUB.Count_And_Get

7644: NULL;
7645: END IF;
7646:
7647: -- Standard call to get message count and if count is 1, get message info.
7648: FND_MSG_PUB.Count_And_Get
7649: ( p_count => x_msg_count,
7650: p_data => x_msg_data
7651: );
7652:

Line 7671: FND_MSG_PUB.initialize;

7667:
7668: -- Initialize message list if p_init_msg_list is set to TRUE.
7669: IF FND_API.to_Boolean( p_init_msg_list )
7670: THEN
7671: FND_MSG_PUB.initialize;
7672: END IF;
7673:
7674:
7675: -- Initialize API return status to SUCCESS

Line 7695: FND_MSG_PUB.Count_And_Get

7691: NULL;
7692: END IF;
7693:
7694: -- Standard call to get message count and if count is 1, get message info.
7695: FND_MSG_PUB.Count_And_Get
7696: ( p_count => x_msg_count,
7697: p_data => x_msg_data
7698: );
7699:

Line 7718: FND_MSG_PUB.initialize;

7714:
7715: -- Initialize message list if p_init_msg_list is set to TRUE.
7716: IF FND_API.to_Boolean( p_init_msg_list )
7717: THEN
7718: FND_MSG_PUB.initialize;
7719: END IF;
7720:
7721:
7722: -- Initialize API return status to SUCCESS

Line 7742: FND_MSG_PUB.Count_And_Get

7738: NULL;
7739: END IF;
7740:
7741: -- Standard call to get message count and if count is 1, get message info.
7742: FND_MSG_PUB.Count_And_Get
7743: ( p_count => x_msg_count,
7744: p_data => x_msg_data
7745: );
7746:

Line 7765: FND_MSG_PUB.initialize;

7761:
7762: -- Initialize message list if p_init_msg_list is set to TRUE.
7763: IF FND_API.to_Boolean( p_init_msg_list )
7764: THEN
7765: FND_MSG_PUB.initialize;
7766: END IF;
7767:
7768:
7769: -- Initialize API return status to SUCCESS

Line 7789: FND_MSG_PUB.Count_And_Get

7785: NULL;
7786: END IF;
7787:
7788: -- Standard call to get message count and if count is 1, get message info.
7789: FND_MSG_PUB.Count_And_Get
7790: ( p_count => x_msg_count,
7791: p_data => x_msg_data
7792: );
7793:

Line 7812: FND_MSG_PUB.initialize;

7808:
7809: -- Initialize message list if p_init_msg_list is set to TRUE.
7810: IF FND_API.to_Boolean( p_init_msg_list )
7811: THEN
7812: FND_MSG_PUB.initialize;
7813: END IF;
7814:
7815:
7816: -- Initialize API return status to SUCCESS

Line 7836: FND_MSG_PUB.Count_And_Get

7832: NULL;
7833: END IF;
7834:
7835: -- Standard call to get message count and if count is 1, get message info.
7836: FND_MSG_PUB.Count_And_Get
7837: ( p_count => x_msg_count,
7838: p_data => x_msg_data
7839: );
7840:

Line 7859: FND_MSG_PUB.initialize;

7855:
7856: -- Initialize message list if p_init_msg_list is set to TRUE.
7857: IF FND_API.to_Boolean( p_init_msg_list )
7858: THEN
7859: FND_MSG_PUB.initialize;
7860: END IF;
7861:
7862:
7863: -- Initialize API return status to SUCCESS

Line 7883: FND_MSG_PUB.Count_And_Get

7879: NULL;
7880: END IF;
7881:
7882: -- Standard call to get message count and if count is 1, get message info.
7883: FND_MSG_PUB.Count_And_Get
7884: ( p_count => x_msg_count,
7885: p_data => x_msg_data
7886: );
7887:

Line 7906: FND_MSG_PUB.initialize;

7902:
7903: -- Initialize message list if p_init_msg_list is set to TRUE.
7904: IF FND_API.to_Boolean( p_init_msg_list )
7905: THEN
7906: FND_MSG_PUB.initialize;
7907: END IF;
7908:
7909:
7910: -- Initialize API return status to SUCCESS

Line 7930: FND_MSG_PUB.Count_And_Get

7926: NULL;
7927: END IF;
7928:
7929: -- Standard call to get message count and if count is 1, get message info.
7930: FND_MSG_PUB.Count_And_Get
7931: ( p_count => x_msg_count,
7932: p_data => x_msg_data
7933: );
7934:

Line 7953: FND_MSG_PUB.initialize;

7949:
7950: -- Initialize message list if p_init_msg_list is set to TRUE.
7951: IF FND_API.to_Boolean( p_init_msg_list )
7952: THEN
7953: FND_MSG_PUB.initialize;
7954: END IF;
7955:
7956:
7957: -- Initialize API return status to SUCCESS

Line 7977: FND_MSG_PUB.Count_And_Get

7973: NULL;
7974: END IF;
7975:
7976: -- Standard call to get message count and if count is 1, get message info.
7977: FND_MSG_PUB.Count_And_Get
7978: ( p_count => x_msg_count,
7979: p_data => x_msg_data
7980: );
7981:

Line 8000: FND_MSG_PUB.initialize;

7996:
7997: -- Initialize message list if p_init_msg_list is set to TRUE.
7998: IF FND_API.to_Boolean( p_init_msg_list )
7999: THEN
8000: FND_MSG_PUB.initialize;
8001: END IF;
8002:
8003:
8004: -- Initialize API return status to SUCCESS

Line 8024: FND_MSG_PUB.Count_And_Get

8020: NULL;
8021: END IF;
8022:
8023: -- Standard call to get message count and if count is 1, get message info.
8024: FND_MSG_PUB.Count_And_Get
8025: ( p_count => x_msg_count,
8026: p_data => x_msg_data
8027: );
8028:

Line 8047: FND_MSG_PUB.initialize;

8043:
8044: -- Initialize message list if p_init_msg_list is set to TRUE.
8045: IF FND_API.to_Boolean( p_init_msg_list )
8046: THEN
8047: FND_MSG_PUB.initialize;
8048: END IF;
8049:
8050:
8051: -- Initialize API return status to SUCCESS

Line 8071: FND_MSG_PUB.Count_And_Get

8067: NULL;
8068: END IF;
8069:
8070: -- Standard call to get message count and if count is 1, get message info.
8071: FND_MSG_PUB.Count_And_Get
8072: ( p_count => x_msg_count,
8073: p_data => x_msg_data
8074: );
8075:

Line 8094: FND_MSG_PUB.initialize;

8090:
8091: -- Initialize message list if p_init_msg_list is set to TRUE.
8092: IF FND_API.to_Boolean( p_init_msg_list )
8093: THEN
8094: FND_MSG_PUB.initialize;
8095: END IF;
8096:
8097:
8098: -- Initialize API return status to SUCCESS

Line 8118: FND_MSG_PUB.Count_And_Get

8114: NULL;
8115: END IF;
8116:
8117: -- Standard call to get message count and if count is 1, get message info.
8118: FND_MSG_PUB.Count_And_Get
8119: ( p_count => x_msg_count,
8120: p_data => x_msg_data
8121: );
8122:

Line 8141: FND_MSG_PUB.initialize;

8137:
8138: -- Initialize message list if p_init_msg_list is set to TRUE.
8139: IF FND_API.to_Boolean( p_init_msg_list )
8140: THEN
8141: FND_MSG_PUB.initialize;
8142: END IF;
8143:
8144:
8145: -- Initialize API return status to SUCCESS

Line 8165: FND_MSG_PUB.Count_And_Get

8161: NULL;
8162: END IF;
8163:
8164: -- Standard call to get message count and if count is 1, get message info.
8165: FND_MSG_PUB.Count_And_Get
8166: ( p_count => x_msg_count,
8167: p_data => x_msg_data
8168: );
8169:

Line 8188: FND_MSG_PUB.initialize;

8184:
8185: -- Initialize message list if p_init_msg_list is set to TRUE.
8186: IF FND_API.to_Boolean( p_init_msg_list )
8187: THEN
8188: FND_MSG_PUB.initialize;
8189: END IF;
8190:
8191:
8192: -- Initialize API return status to SUCCESS

Line 8212: FND_MSG_PUB.Count_And_Get

8208: NULL;
8209: END IF;
8210:
8211: -- Standard call to get message count and if count is 1, get message info.
8212: FND_MSG_PUB.Count_And_Get
8213: ( p_count => x_msg_count,
8214: p_data => x_msg_data
8215: );
8216:

Line 8235: FND_MSG_PUB.initialize;

8231:
8232: -- Initialize message list if p_init_msg_list is set to TRUE.
8233: IF FND_API.to_Boolean( p_init_msg_list )
8234: THEN
8235: FND_MSG_PUB.initialize;
8236: END IF;
8237:
8238:
8239: -- Initialize API return status to SUCCESS

Line 8259: FND_MSG_PUB.Count_And_Get

8255: NULL;
8256: END IF;
8257:
8258: -- Standard call to get message count and if count is 1, get message info.
8259: FND_MSG_PUB.Count_And_Get
8260: ( p_count => x_msg_count,
8261: p_data => x_msg_data
8262: );
8263:

Line 8282: FND_MSG_PUB.initialize;

8278:
8279: -- Initialize message list if p_init_msg_list is set to TRUE.
8280: IF FND_API.to_Boolean( p_init_msg_list )
8281: THEN
8282: FND_MSG_PUB.initialize;
8283: END IF;
8284:
8285:
8286: -- Initialize API return status to SUCCESS

Line 8306: FND_MSG_PUB.Count_And_Get

8302: NULL;
8303: END IF;
8304:
8305: -- Standard call to get message count and if count is 1, get message info.
8306: FND_MSG_PUB.Count_And_Get
8307: ( p_count => x_msg_count,
8308: p_data => x_msg_data
8309: );
8310:

Line 8329: FND_MSG_PUB.initialize;

8325:
8326: -- Initialize message list if p_init_msg_list is set to TRUE.
8327: IF FND_API.to_Boolean( p_init_msg_list )
8328: THEN
8329: FND_MSG_PUB.initialize;
8330: END IF;
8331:
8332:
8333: -- Initialize API return status to SUCCESS

Line 8353: FND_MSG_PUB.Count_And_Get

8349: NULL;
8350: END IF;
8351:
8352: -- Standard call to get message count and if count is 1, get message info.
8353: FND_MSG_PUB.Count_And_Get
8354: ( p_count => x_msg_count,
8355: p_data => x_msg_data
8356: );
8357:

Line 8376: FND_MSG_PUB.initialize;

8372:
8373: -- Initialize message list if p_init_msg_list is set to TRUE.
8374: IF FND_API.to_Boolean( p_init_msg_list )
8375: THEN
8376: FND_MSG_PUB.initialize;
8377: END IF;
8378:
8379:
8380: -- Initialize API return status to SUCCESS

Line 8400: FND_MSG_PUB.Count_And_Get

8396: NULL;
8397: END IF;
8398:
8399: -- Standard call to get message count and if count is 1, get message info.
8400: FND_MSG_PUB.Count_And_Get
8401: ( p_count => x_msg_count,
8402: p_data => x_msg_data
8403: );
8404:

Line 8423: FND_MSG_PUB.initialize;

8419:
8420: -- Initialize message list if p_init_msg_list is set to TRUE.
8421: IF FND_API.to_Boolean( p_init_msg_list )
8422: THEN
8423: FND_MSG_PUB.initialize;
8424: END IF;
8425:
8426:
8427: -- Initialize API return status to SUCCESS

Line 8447: FND_MSG_PUB.Count_And_Get

8443: NULL;
8444: END IF;
8445:
8446: -- Standard call to get message count and if count is 1, get message info.
8447: FND_MSG_PUB.Count_And_Get
8448: ( p_count => x_msg_count,
8449: p_data => x_msg_data
8450: );
8451:

Line 8470: FND_MSG_PUB.initialize;

8466:
8467: -- Initialize message list if p_init_msg_list is set to TRUE.
8468: IF FND_API.to_Boolean( p_init_msg_list )
8469: THEN
8470: FND_MSG_PUB.initialize;
8471: END IF;
8472:
8473:
8474: -- Initialize API return status to SUCCESS

Line 8494: FND_MSG_PUB.Count_And_Get

8490: NULL;
8491: END IF;
8492:
8493: -- Standard call to get message count and if count is 1, get message info.
8494: FND_MSG_PUB.Count_And_Get
8495: ( p_count => x_msg_count,
8496: p_data => x_msg_data
8497: );
8498:

Line 8517: FND_MSG_PUB.initialize;

8513:
8514: -- Initialize message list if p_init_msg_list is set to TRUE.
8515: IF FND_API.to_Boolean( p_init_msg_list )
8516: THEN
8517: FND_MSG_PUB.initialize;
8518: END IF;
8519:
8520:
8521: -- Initialize API return status to SUCCESS

Line 8541: FND_MSG_PUB.Count_And_Get

8537: NULL;
8538: END IF;
8539:
8540: -- Standard call to get message count and if count is 1, get message info.
8541: FND_MSG_PUB.Count_And_Get
8542: ( p_count => x_msg_count,
8543: p_data => x_msg_data
8544: );
8545:

Line 8564: FND_MSG_PUB.initialize;

8560:
8561: -- Initialize message list if p_init_msg_list is set to TRUE.
8562: IF FND_API.to_Boolean( p_init_msg_list )
8563: THEN
8564: FND_MSG_PUB.initialize;
8565: END IF;
8566:
8567:
8568: -- Initialize API return status to SUCCESS

Line 8588: FND_MSG_PUB.Count_And_Get

8584: NULL;
8585: END IF;
8586:
8587: -- Standard call to get message count and if count is 1, get message info.
8588: FND_MSG_PUB.Count_And_Get
8589: ( p_count => x_msg_count,
8590: p_data => x_msg_data
8591: );
8592:

Line 8611: FND_MSG_PUB.initialize;

8607:
8608: -- Initialize message list if p_init_msg_list is set to TRUE.
8609: IF FND_API.to_Boolean( p_init_msg_list )
8610: THEN
8611: FND_MSG_PUB.initialize;
8612: END IF;
8613:
8614:
8615: -- Initialize API return status to SUCCESS

Line 8635: FND_MSG_PUB.Count_And_Get

8631: NULL;
8632: END IF;
8633:
8634: -- Standard call to get message count and if count is 1, get message info.
8635: FND_MSG_PUB.Count_And_Get
8636: ( p_count => x_msg_count,
8637: p_data => x_msg_data
8638: );
8639:

Line 8658: FND_MSG_PUB.initialize;

8654:
8655: -- Initialize message list if p_init_msg_list is set to TRUE.
8656: IF FND_API.to_Boolean( p_init_msg_list )
8657: THEN
8658: FND_MSG_PUB.initialize;
8659: END IF;
8660:
8661:
8662: -- Initialize API return status to SUCCESS

Line 8682: FND_MSG_PUB.Count_And_Get

8678: NULL;
8679: END IF;
8680:
8681: -- Standard call to get message count and if count is 1, get message info.
8682: FND_MSG_PUB.Count_And_Get
8683: ( p_count => x_msg_count,
8684: p_data => x_msg_data
8685: );
8686:

Line 8705: FND_MSG_PUB.initialize;

8701:
8702: -- Initialize message list if p_init_msg_list is set to TRUE.
8703: IF FND_API.to_Boolean( p_init_msg_list )
8704: THEN
8705: FND_MSG_PUB.initialize;
8706: END IF;
8707:
8708:
8709: -- Initialize API return status to SUCCESS

Line 8729: FND_MSG_PUB.Count_And_Get

8725: NULL;
8726: END IF;
8727:
8728: -- Standard call to get message count and if count is 1, get message info.
8729: FND_MSG_PUB.Count_And_Get
8730: ( p_count => x_msg_count,
8731: p_data => x_msg_data
8732: );
8733:

Line 8752: FND_MSG_PUB.initialize;

8748:
8749: -- Initialize message list if p_init_msg_list is set to TRUE.
8750: IF FND_API.to_Boolean( p_init_msg_list )
8751: THEN
8752: FND_MSG_PUB.initialize;
8753: END IF;
8754:
8755:
8756: -- Initialize API return status to SUCCESS

Line 8776: FND_MSG_PUB.Count_And_Get

8772: NULL;
8773: END IF;
8774:
8775: -- Standard call to get message count and if count is 1, get message info.
8776: FND_MSG_PUB.Count_And_Get
8777: ( p_count => x_msg_count,
8778: p_data => x_msg_data
8779: );
8780:

Line 8799: FND_MSG_PUB.initialize;

8795:
8796: -- Initialize message list if p_init_msg_list is set to TRUE.
8797: IF FND_API.to_Boolean( p_init_msg_list )
8798: THEN
8799: FND_MSG_PUB.initialize;
8800: END IF;
8801:
8802:
8803: -- Initialize API return status to SUCCESS

Line 8823: FND_MSG_PUB.Count_And_Get

8819: NULL;
8820: END IF;
8821:
8822: -- Standard call to get message count and if count is 1, get message info.
8823: FND_MSG_PUB.Count_And_Get
8824: ( p_count => x_msg_count,
8825: p_data => x_msg_data
8826: );
8827:

Line 8846: FND_MSG_PUB.initialize;

8842:
8843: -- Initialize message list if p_init_msg_list is set to TRUE.
8844: IF FND_API.to_Boolean( p_init_msg_list )
8845: THEN
8846: FND_MSG_PUB.initialize;
8847: END IF;
8848:
8849:
8850: -- Initialize API return status to SUCCESS

Line 8870: FND_MSG_PUB.Count_And_Get

8866: NULL;
8867: END IF;
8868:
8869: -- Standard call to get message count and if count is 1, get message info.
8870: FND_MSG_PUB.Count_And_Get
8871: ( p_count => x_msg_count,
8872: p_data => x_msg_data
8873: );
8874:

Line 8893: FND_MSG_PUB.initialize;

8889:
8890: -- Initialize message list if p_init_msg_list is set to TRUE.
8891: IF FND_API.to_Boolean( p_init_msg_list )
8892: THEN
8893: FND_MSG_PUB.initialize;
8894: END IF;
8895:
8896:
8897: -- Initialize API return status to SUCCESS

Line 8917: FND_MSG_PUB.Count_And_Get

8913: NULL;
8914: END IF;
8915:
8916: -- Standard call to get message count and if count is 1, get message info.
8917: FND_MSG_PUB.Count_And_Get
8918: ( p_count => x_msg_count,
8919: p_data => x_msg_data
8920: );
8921:

Line 8940: FND_MSG_PUB.initialize;

8936:
8937: -- Initialize message list if p_init_msg_list is set to TRUE.
8938: IF FND_API.to_Boolean( p_init_msg_list )
8939: THEN
8940: FND_MSG_PUB.initialize;
8941: END IF;
8942:
8943:
8944: -- Initialize API return status to SUCCESS

Line 8964: FND_MSG_PUB.Count_And_Get

8960: NULL;
8961: END IF;
8962:
8963: -- Standard call to get message count and if count is 1, get message info.
8964: FND_MSG_PUB.Count_And_Get
8965: ( p_count => x_msg_count,
8966: p_data => x_msg_data
8967: );
8968:

Line 8987: FND_MSG_PUB.initialize;

8983:
8984: -- Initialize message list if p_init_msg_list is set to TRUE.
8985: IF FND_API.to_Boolean( p_init_msg_list )
8986: THEN
8987: FND_MSG_PUB.initialize;
8988: END IF;
8989:
8990:
8991: -- Initialize API return status to SUCCESS

Line 9011: FND_MSG_PUB.Count_And_Get

9007: NULL;
9008: END IF;
9009:
9010: -- Standard call to get message count and if count is 1, get message info.
9011: FND_MSG_PUB.Count_And_Get
9012: ( p_count => x_msg_count,
9013: p_data => x_msg_data
9014: );
9015:

Line 9034: FND_MSG_PUB.initialize;

9030:
9031: -- Initialize message list if p_init_msg_list is set to TRUE.
9032: IF FND_API.to_Boolean( p_init_msg_list )
9033: THEN
9034: FND_MSG_PUB.initialize;
9035: END IF;
9036:
9037:
9038: -- Initialize API return status to SUCCESS

Line 9058: FND_MSG_PUB.Count_And_Get

9054: NULL;
9055: END IF;
9056:
9057: -- Standard call to get message count and if count is 1, get message info.
9058: FND_MSG_PUB.Count_And_Get
9059: ( p_count => x_msg_count,
9060: p_data => x_msg_data
9061: );
9062:

Line 9081: FND_MSG_PUB.initialize;

9077:
9078: -- Initialize message list if p_init_msg_list is set to TRUE.
9079: IF FND_API.to_Boolean( p_init_msg_list )
9080: THEN
9081: FND_MSG_PUB.initialize;
9082: END IF;
9083:
9084:
9085: -- Initialize API return status to SUCCESS

Line 9105: FND_MSG_PUB.Count_And_Get

9101: NULL;
9102: END IF;
9103:
9104: -- Standard call to get message count and if count is 1, get message info.
9105: FND_MSG_PUB.Count_And_Get
9106: ( p_count => x_msg_count,
9107: p_data => x_msg_data
9108: );
9109:

Line 9128: FND_MSG_PUB.initialize;

9124:
9125: -- Initialize message list if p_init_msg_list is set to TRUE.
9126: IF FND_API.to_Boolean( p_init_msg_list )
9127: THEN
9128: FND_MSG_PUB.initialize;
9129: END IF;
9130:
9131:
9132: -- Initialize API return status to SUCCESS

Line 9152: FND_MSG_PUB.Count_And_Get

9148: NULL;
9149: END IF;
9150:
9151: -- Standard call to get message count and if count is 1, get message info.
9152: FND_MSG_PUB.Count_And_Get
9153: ( p_count => x_msg_count,
9154: p_data => x_msg_data
9155: );
9156:

Line 9175: FND_MSG_PUB.initialize;

9171:
9172: -- Initialize message list if p_init_msg_list is set to TRUE.
9173: IF FND_API.to_Boolean( p_init_msg_list )
9174: THEN
9175: FND_MSG_PUB.initialize;
9176: END IF;
9177:
9178:
9179: -- Initialize API return status to SUCCESS

Line 9199: FND_MSG_PUB.Count_And_Get

9195: NULL;
9196: END IF;
9197:
9198: -- Standard call to get message count and if count is 1, get message info.
9199: FND_MSG_PUB.Count_And_Get
9200: ( p_count => x_msg_count,
9201: p_data => x_msg_data
9202: );
9203:

Line 9222: FND_MSG_PUB.initialize;

9218:
9219: -- Initialize message list if p_init_msg_list is set to TRUE.
9220: IF FND_API.to_Boolean( p_init_msg_list )
9221: THEN
9222: FND_MSG_PUB.initialize;
9223: END IF;
9224:
9225:
9226: -- Initialize API return status to SUCCESS

Line 9246: FND_MSG_PUB.Count_And_Get

9242: NULL;
9243: END IF;
9244:
9245: -- Standard call to get message count and if count is 1, get message info.
9246: FND_MSG_PUB.Count_And_Get
9247: ( p_count => x_msg_count,
9248: p_data => x_msg_data
9249: );
9250:

Line 9269: FND_MSG_PUB.initialize;

9265:
9266: -- Initialize message list if p_init_msg_list is set to TRUE.
9267: IF FND_API.to_Boolean( p_init_msg_list )
9268: THEN
9269: FND_MSG_PUB.initialize;
9270: END IF;
9271:
9272:
9273: -- Initialize API return status to SUCCESS

Line 9293: FND_MSG_PUB.Count_And_Get

9289: NULL;
9290: END IF;
9291:
9292: -- Standard call to get message count and if count is 1, get message info.
9293: FND_MSG_PUB.Count_And_Get
9294: ( p_count => x_msg_count,
9295: p_data => x_msg_data
9296: );
9297:

Line 9316: FND_MSG_PUB.initialize;

9312:
9313: -- Initialize message list if p_init_msg_list is set to TRUE.
9314: IF FND_API.to_Boolean( p_init_msg_list )
9315: THEN
9316: FND_MSG_PUB.initialize;
9317: END IF;
9318:
9319:
9320: -- Initialize API return status to SUCCESS

Line 9340: FND_MSG_PUB.Count_And_Get

9336: NULL;
9337: END IF;
9338:
9339: -- Standard call to get message count and if count is 1, get message info.
9340: FND_MSG_PUB.Count_And_Get
9341: ( p_count => x_msg_count,
9342: p_data => x_msg_data
9343: );
9344:

Line 9363: FND_MSG_PUB.initialize;

9359:
9360: -- Initialize message list if p_init_msg_list is set to TRUE.
9361: IF FND_API.to_Boolean( p_init_msg_list )
9362: THEN
9363: FND_MSG_PUB.initialize;
9364: END IF;
9365:
9366:
9367: -- Initialize API return status to SUCCESS

Line 9387: FND_MSG_PUB.Count_And_Get

9383: NULL;
9384: END IF;
9385:
9386: -- Standard call to get message count and if count is 1, get message info.
9387: FND_MSG_PUB.Count_And_Get
9388: ( p_count => x_msg_count,
9389: p_data => x_msg_data
9390: );
9391:

Line 9410: FND_MSG_PUB.initialize;

9406:
9407: -- Initialize message list if p_init_msg_list is set to TRUE.
9408: IF FND_API.to_Boolean( p_init_msg_list )
9409: THEN
9410: FND_MSG_PUB.initialize;
9411: END IF;
9412:
9413:
9414: -- Initialize API return status to SUCCESS

Line 9434: FND_MSG_PUB.Count_And_Get

9430: NULL;
9431: END IF;
9432:
9433: -- Standard call to get message count and if count is 1, get message info.
9434: FND_MSG_PUB.Count_And_Get
9435: ( p_count => x_msg_count,
9436: p_data => x_msg_data
9437: );
9438:

Line 9457: FND_MSG_PUB.initialize;

9453:
9454: -- Initialize message list if p_init_msg_list is set to TRUE.
9455: IF FND_API.to_Boolean( p_init_msg_list )
9456: THEN
9457: FND_MSG_PUB.initialize;
9458: END IF;
9459:
9460:
9461: -- Initialize API return status to SUCCESS

Line 9481: FND_MSG_PUB.Count_And_Get

9477: NULL;
9478: END IF;
9479:
9480: -- Standard call to get message count and if count is 1, get message info.
9481: FND_MSG_PUB.Count_And_Get
9482: ( p_count => x_msg_count,
9483: p_data => x_msg_data
9484: );
9485:

Line 9504: FND_MSG_PUB.initialize;

9500:
9501: -- Initialize message list if p_init_msg_list is set to TRUE.
9502: IF FND_API.to_Boolean( p_init_msg_list )
9503: THEN
9504: FND_MSG_PUB.initialize;
9505: END IF;
9506:
9507:
9508: -- Initialize API return status to SUCCESS

Line 9528: FND_MSG_PUB.Count_And_Get

9524: NULL;
9525: END IF;
9526:
9527: -- Standard call to get message count and if count is 1, get message info.
9528: FND_MSG_PUB.Count_And_Get
9529: ( p_count => x_msg_count,
9530: p_data => x_msg_data
9531: );
9532:

Line 9551: FND_MSG_PUB.initialize;

9547:
9548: -- Initialize message list if p_init_msg_list is set to TRUE.
9549: IF FND_API.to_Boolean( p_init_msg_list )
9550: THEN
9551: FND_MSG_PUB.initialize;
9552: END IF;
9553:
9554:
9555: -- Initialize API return status to SUCCESS

Line 9575: FND_MSG_PUB.Count_And_Get

9571: NULL;
9572: END IF;
9573:
9574: -- Standard call to get message count and if count is 1, get message info.
9575: FND_MSG_PUB.Count_And_Get
9576: ( p_count => x_msg_count,
9577: p_data => x_msg_data
9578: );
9579:

Line 9598: FND_MSG_PUB.initialize;

9594:
9595: -- Initialize message list if p_init_msg_list is set to TRUE.
9596: IF FND_API.to_Boolean( p_init_msg_list )
9597: THEN
9598: FND_MSG_PUB.initialize;
9599: END IF;
9600:
9601:
9602: -- Initialize API return status to SUCCESS

Line 9622: FND_MSG_PUB.Count_And_Get

9618: NULL;
9619: END IF;
9620:
9621: -- Standard call to get message count and if count is 1, get message info.
9622: FND_MSG_PUB.Count_And_Get
9623: ( p_count => x_msg_count,
9624: p_data => x_msg_data
9625: );
9626:

Line 9645: FND_MSG_PUB.initialize;

9641:
9642: -- Initialize message list if p_init_msg_list is set to TRUE.
9643: IF FND_API.to_Boolean( p_init_msg_list )
9644: THEN
9645: FND_MSG_PUB.initialize;
9646: END IF;
9647:
9648:
9649: -- Initialize API return status to SUCCESS

Line 9669: FND_MSG_PUB.Count_And_Get

9665: NULL;
9666: END IF;
9667:
9668: -- Standard call to get message count and if count is 1, get message info.
9669: FND_MSG_PUB.Count_And_Get
9670: ( p_count => x_msg_count,
9671: p_data => x_msg_data
9672: );
9673:

Line 9692: FND_MSG_PUB.initialize;

9688:
9689: -- Initialize message list if p_init_msg_list is set to TRUE.
9690: IF FND_API.to_Boolean( p_init_msg_list )
9691: THEN
9692: FND_MSG_PUB.initialize;
9693: END IF;
9694:
9695:
9696: -- Initialize API return status to SUCCESS

Line 9716: FND_MSG_PUB.Count_And_Get

9712: NULL;
9713: END IF;
9714:
9715: -- Standard call to get message count and if count is 1, get message info.
9716: FND_MSG_PUB.Count_And_Get
9717: ( p_count => x_msg_count,
9718: p_data => x_msg_data
9719: );
9720:

Line 9739: FND_MSG_PUB.initialize;

9735:
9736: -- Initialize message list if p_init_msg_list is set to TRUE.
9737: IF FND_API.to_Boolean( p_init_msg_list )
9738: THEN
9739: FND_MSG_PUB.initialize;
9740: END IF;
9741:
9742:
9743: -- Initialize API return status to SUCCESS

Line 9763: FND_MSG_PUB.Count_And_Get

9759: NULL;
9760: END IF;
9761:
9762: -- Standard call to get message count and if count is 1, get message info.
9763: FND_MSG_PUB.Count_And_Get
9764: ( p_count => x_msg_count,
9765: p_data => x_msg_data
9766: );
9767:

Line 9786: FND_MSG_PUB.initialize;

9782:
9783: -- Initialize message list if p_init_msg_list is set to TRUE.
9784: IF FND_API.to_Boolean( p_init_msg_list )
9785: THEN
9786: FND_MSG_PUB.initialize;
9787: END IF;
9788:
9789:
9790: -- Initialize API return status to SUCCESS

Line 9810: FND_MSG_PUB.Count_And_Get

9806: NULL;
9807: END IF;
9808:
9809: -- Standard call to get message count and if count is 1, get message info.
9810: FND_MSG_PUB.Count_And_Get
9811: ( p_count => x_msg_count,
9812: p_data => x_msg_data
9813: );
9814:

Line 9836: FND_MSG_PUB.initialize;

9832:
9833: -- Initialize message list if p_init_msg_list is set to TRUE.
9834: IF FND_API.to_Boolean( p_init_msg_list )
9835: THEN
9836: FND_MSG_PUB.initialize;
9837: END IF;
9838:
9839:
9840: -- Initialize API return status to SUCCESS

Line 9849: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

9845: -- THEN
9846: -- x_return_status := FND_API.G_RET_STS_ERROR;
9847:
9848: -- Debug Message
9849: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
9850:
9851: -- Standard call to get message count and if count is 1, get message info.
9852: FND_MSG_PUB.Count_And_Get
9853: ( p_count => x_msg_count,

Line 9852: FND_MSG_PUB.Count_And_Get

9848: -- Debug Message
9849: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
9850:
9851: -- Standard call to get message count and if count is 1, get message info.
9852: FND_MSG_PUB.Count_And_Get
9853: ( p_count => x_msg_count,
9854: p_data => x_msg_data
9855: );
9856:

Line 9873: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

9869: l_api_name CONSTANT VARCHAR2(30) := 'Validate_material_transactions';
9870: BEGIN
9871:
9872: -- Debug Message
9873: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
9874:
9875:
9876: -- Initialize API return status to SUCCESS
9877: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

11852: END IF;
11853:
11854:
11855: -- Debug Message
11856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
11857:
11858: END Validate_material_transactions;
11859: */
11860: