DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_GRP dependencies on STANDARD

Line 28: -- Standard call to check for call compatibility.

24: l_api_version CONSTANT NUMBER := 1.0;
25:
26: BEGIN
27:
28: -- Standard call to check for call compatibility.
29: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32:

Line 63: -- Standard call to get message count and if count is 1, get message info.

59: ELSE
60: RAISE FND_API.G_EXC_ERROR;
61: END IF;
62:
63: -- Standard call to get message count and if count is 1, get message info.
64: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
65:
66: EXCEPTION
67: WHEN FND_API.G_EXC_ERROR THEN

Line 130: -- Standard call to check for call compatibility.

126: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
127:
128: BEGIN
129:
130: -- Standard call to check for call compatibility.
131: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:

Line 188: -- Standard call to get message count and if count is 1, get message info.

184: ELSE
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: -- Standard call to get message count and if count is 1, get message info.
189: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN

Line 245: -- Standard call to check for call compatibility.

241: l_api_version CONSTANT NUMBER := 1.0;
242:
243: BEGIN
244:
245: -- Standard call to check for call compatibility.
246: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:

Line 279: -- Standard call to get message count and if count is 1, get message info.

275: ELSE
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;
278:
279: -- Standard call to get message count and if count is 1, get message info.
280: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
281:
282: EXCEPTION
283: WHEN FND_API.G_EXC_ERROR THEN

Line 345: -- Standard call to check for call compatibility.

341: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
342: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
343:
344: BEGIN
345: -- Standard call to check for call compatibility.
346: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:

Line 398: -- Standard call to get message count and if count is 1, get message info.

394: ELSE
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: -- Standard call to get message count and if count is 1, get message info.
399: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
400:
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN

Line 459: -- Standard call to check for call compatibility.

455: l_api_version CONSTANT NUMBER := 1.0;
456:
457: BEGIN
458:
459: -- Standard call to check for call compatibility.
460: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;
463:

Line 486: -- Standard call to get message count and if count is 1, get message info.

482: X_MSG_DATA => X_MSG_DATA
483: );
484:
485:
486: -- Standard call to get message count and if count is 1, get message info.
487: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
488:
489: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
490: IF FND_API.To_Boolean( p_commit ) THEN

Line 497: -- Standard call to get message count and if count is 1, get message info.

493: ELSE
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN

Line 560: -- Standard call to check for call compatibility.

556: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
557: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
558:
559: BEGIN
560: -- Standard call to check for call compatibility.
561: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:

Line 604: -- Standard call to get message count and if count is 1, get message info.

600: ELSE
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
606:
607: EXCEPTION
608: WHEN FND_API.G_EXC_ERROR THEN

Line 666: -- Standard call to check for call compatibility.

662: l_api_version CONSTANT NUMBER := 1.0;
663:
664: BEGIN
665:
666: -- Standard call to check for call compatibility.
667: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:

Line 698: -- Standard call to get message count and if count is 1, get message info.

694: ELSE
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN

Line 754: -- Standard call to check for call compatibility.

750: l_api_version CONSTANT NUMBER := 1.0;
751:
752: BEGIN
753:
754: -- Standard call to check for call compatibility.
755: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:

Line 786: -- Standard call to get message count and if count is 1, get message info.

782: ELSE
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:
786: -- Standard call to get message count and if count is 1, get message info.
787: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
788:
789: EXCEPTION
790: WHEN FND_API.G_EXC_ERROR THEN

Line 841: -- Standard Start of API savepoint

837: l_api_version CONSTANT NUMBER := 1.0;
838:
839:
840: BEGIN
841: -- Standard Start of API savepoint
842: SAVEPOINT GET_DEFN_STATUS_GRP;
843:
844: -- Standard call to check for call compatibility.
845: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

Line 844: -- Standard call to check for call compatibility.

840: BEGIN
841: -- Standard Start of API savepoint
842: SAVEPOINT GET_DEFN_STATUS_GRP;
843:
844: -- Standard call to check for call compatibility.
845: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848:

Line 864: -- Standard call to get message count and if count is 1, get message info.

860: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
861:
862:
863:
864: -- Standard call to get message count and if count is 1, get message info.
865: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
866:
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN

Line 926: -- Standard Start of API savepoint

922: --This variable would hold the XML details in XMLType format.
923: L_INSTR_XML XMLTYPE;
924:
925: BEGIN
926: -- Standard Start of API savepoint
927: SAVEPOINT GET_INSTR_XML_GRP;
928:
929: -- Standard call to check for call compatibility.
930: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

Line 929: -- Standard call to check for call compatibility.

925: BEGIN
926: -- Standard Start of API savepoint
927: SAVEPOINT GET_INSTR_XML_GRP;
928:
929: -- Standard call to check for call compatibility.
930: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933:

Line 949: -- Standard call to get message count and if count is 1, get message info.

945: P_INSTRUCTION_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
946: X_OUTPUT_XML => X_OUTPUT_XML
947: );
948:
949: -- Standard call to get message count and if count is 1, get message info.
950: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
951:
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN

Line 1011: -- Standard Start of API savepoint

1007: --This variable would hold the XML details in XMLType format.
1008: L_INSTR_XML XMLTYPE;
1009:
1010: BEGIN
1011: -- Standard Start of API savepoint
1012: SAVEPOINT GET_INSTR_XML_GRP;
1013:
1014: -- Standard call to check for call compatibility.
1015: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1014: -- Standard call to check for call compatibility.

1010: BEGIN
1011: -- Standard Start of API savepoint
1012: SAVEPOINT GET_INSTR_XML_GRP;
1013:
1014: -- Standard call to check for call compatibility.
1015: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END IF;
1018:

Line 1034: -- Standard call to get message count and if count is 1, get message info.

1030: P_INSTRUCTION_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
1031: X_OUTPUT_XML => X_OUTPUT_XML
1032: );
1033:
1034: -- Standard call to get message count and if count is 1, get message info.
1035: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_ERROR THEN

Line 1094: -- Standard Start of API savepoint

1090: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_FROM_DEFN';
1091: l_api_version CONSTANT NUMBER := 1.0;
1092:
1093: BEGIN
1094: -- Standard Start of API savepoint
1095: SAVEPOINT CREATE_INSTANCE_FROM_DEFN_GRP;
1096:
1097: -- Standard call to check for call compatibility.
1098: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1097: -- Standard call to check for call compatibility.

1093: BEGIN
1094: -- Standard Start of API savepoint
1095: SAVEPOINT CREATE_INSTANCE_FROM_DEFN_GRP;
1096:
1097: -- Standard call to check for call compatibility.
1098: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101:

Line 1127: -- Standard call to get message count and if count is 1, get message info.

1123: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1124: RAISE FND_API.G_EXC_ERROR;
1125: END IF;
1126:
1127: -- Standard call to get message count and if count is 1, get message info.
1128: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1129:
1130: IF FND_API.To_Boolean( p_commit ) THEN
1131: COMMIT ;

Line 1192: -- Standard call to check for call compatibility.

1188: l_api_version CONSTANT NUMBER := 1.0;
1189:
1190: BEGIN
1191: SAVEPOINT CREATE_INST_FRM_INST_SV;
1192: -- Standard call to check for call compatibility.
1193: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: END IF;
1196:

Line 1225: -- Standard call to get message count and if count is 1, get message info.

1221: COMMIT ;
1222: END IF;
1223: END IF;
1224:
1225: -- Standard call to get message count and if count is 1, get message info.
1226: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1227:
1228: EXCEPTION
1229: WHEN FND_API.G_EXC_ERROR THEN

Line 1286: -- Standard call to check for call compatibility.

1282: l_api_version CONSTANT NUMBER := 1.0;
1283:
1284: BEGIN
1285:
1286: -- Standard call to check for call compatibility.
1287: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1289: END IF;
1290:

Line 1320: -- Standard call to get message count and if count is 1, get message info.

1316: ELSE
1317: COMMIT;
1318: END IF;
1319:
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN

Line 1379: -- Standard call to check for call compatibility.

1375: l_api_version CONSTANT NUMBER := 1.0;
1376:
1377: BEGIN
1378:
1379: -- Standard call to check for call compatibility.
1380: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382: END IF;
1383:

Line 1409: -- Standard call to get message count and if count is 1, get message info.

1405: ELSE
1406: COMMIT;
1407: END IF;
1408:
1409: -- Standard call to get message count and if count is 1, get message info.
1410: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1411:
1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN

Line 1467: -- Standard Start of API savepoint

1463: l_api_version CONSTANT NUMBER := 1.0;
1464: L_TASK_PARAM_VALUE VARCHAR2(1000);
1465:
1466: BEGIN
1467: -- Standard Start of API savepoint
1468: SAVEPOINT GET_TASK_PARAMETER_GRP;
1469:
1470: -- Standard call to check for call compatibility.
1471: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1470: -- Standard call to check for call compatibility.

1466: BEGIN
1467: -- Standard Start of API savepoint
1468: SAVEPOINT GET_TASK_PARAMETER_GRP;
1469:
1470: -- Standard call to check for call compatibility.
1471: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: END IF;
1474:

Line 1490: -- Standard call to get message count and if count is 1, get message info.

1486: );
1487: X_ATTRIBUTE_VALUE := L_TASK_PARAM_VALUE;
1488: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1489:
1490: -- Standard call to get message count and if count is 1, get message info.
1491: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1492:
1493: EXCEPTION
1494: WHEN FND_API.G_EXC_ERROR THEN

Line 1567: -- Standard Start of API savepoint

1563: l_api_name CONSTANT VARCHAR2(30) := 'IS_TASK_ATTRIBUTE_USED';
1564: l_api_version CONSTANT NUMBER := 1.0;
1565:
1566: BEGIN
1567: -- Standard Start of API savepoint
1568: SAVEPOINT IS_TASK_ATTRIBUTE_USED_GRP;
1569:
1570: -- Standard call to check for call compatibility.
1571: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1570: -- Standard call to check for call compatibility.

1566: BEGIN
1567: -- Standard Start of API savepoint
1568: SAVEPOINT IS_TASK_ATTRIBUTE_USED_GRP;
1569:
1570: -- Standard call to check for call compatibility.
1571: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
1572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1573: END IF;
1574:

Line 1594: -- Standard call to get message count and if count is 1, get message info.

1590: X_MSG_COUNT => X_MSG_COUNT,
1591: X_MSG_DATA => X_MSG_DATA
1592: );
1593:
1594: -- Standard call to get message count and if count is 1, get message info.
1595: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN