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.OKC_REP_CONTRACT_PROCESS_PVT dependencies on STANDARD

Line 72: -- Standard Start of API savepoint

68: 'Contract Id is: ' || p_contract_id);
69: END IF;
70: l_api_name := 'submit_contract_for_approval';
71: l_api_version := 1.0;
72: -- Standard Start of API savepoint
73: SAVEPOINT submit_contract_PVT;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

70: l_api_name := 'submit_contract_for_approval';
71: l_api_version := 1.0;
72: -- Standard Start of API savepoint
73: SAVEPOINT submit_contract_PVT;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.

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

324:
325: END IF;
326:
327:
328: -- Standard call to get message count and if count is 1, get message info.
329: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 438: -- Standard Start of API savepoint

434: 'Contract Id is: ' || to_char(p_contract_id));
435: END IF;
436: l_api_name := 'delete_contacts';
437: l_api_version := 1.0;
438: -- Standard Start of API savepoint
439: SAVEPOINT delete_contacts_PVT;
440: -- Standard call to check for call compatibility.
441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

436: l_api_name := 'delete_contacts';
437: l_api_version := 1.0;
438: -- Standard Start of API savepoint
439: SAVEPOINT delete_contacts_PVT;
440: -- Standard call to check for call compatibility.
441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 456: -- Standard check of p_commit

452: -- Delete the records. The records are locked in the delete_contract API.
453: DELETE FROM OKC_REP_PARTY_CONTACTS
454: WHERE CONTRACT_ID = p_CONTRACT_ID;
455:
456: -- Standard check of p_commit
457: IF FND_API.To_Boolean( p_commit ) THEN
458: COMMIT WORK;
459: END IF;
460:

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

457: IF FND_API.To_Boolean( p_commit ) THEN
458: COMMIT WORK;
459: END IF;
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
463:
464: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 557: -- Standard Start of API savepoint

553: 'Contract Id is: ' || p_contract_id);
554: END IF;
555: l_api_name := 'delete_parties';
556: l_api_version := 1.0;
557: -- Standard Start of API savepoint
558: SAVEPOINT delete_parties_PVT;
559: -- Standard call to check for call compatibility.
560: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

555: l_api_name := 'delete_parties';
556: l_api_version := 1.0;
557: -- Standard Start of API savepoint
558: SAVEPOINT delete_parties_PVT;
559: -- Standard call to check for call compatibility.
560: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 575: -- Standard check of p_commit

571: -- Delete the records. The records are locked in the delete_contract API.
572: DELETE FROM OKC_REP_CONTRACT_PARTIES
573: WHERE CONTRACT_ID = p_CONTRACT_ID;
574:
575: -- Standard check of p_commit
576: IF FND_API.To_Boolean( p_commit ) THEN
577: COMMIT WORK;
578: END IF;
579:

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

576: IF FND_API.To_Boolean( p_commit ) THEN
577: COMMIT WORK;
578: END IF;
579:
580: -- Standard call to get message count and if count is 1, get message info.
581: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
582:
583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
584: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 684: -- Standard Start of API savepoint

680: 'Contract Id is: ' || p_contract_id);
681: END IF;
682: l_api_name := 'delete_risks';
683: l_api_version := 1.0;
684: -- Standard Start of API savepoint
685: SAVEPOINT delete_risks_PVT;
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

682: l_api_name := 'delete_risks';
683: l_api_version := 1.0;
684: -- Standard Start of API savepoint
685: SAVEPOINT delete_risks_PVT;
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 720: -- Standard check of p_commit

716: AND BUSINESS_DOCUMENT_ID = p_CONTRACT_ID
717: AND BUSINESS_DOCUMENT_VERSION = contract_rec.contract_version_num;
718: -- Close cursor
719: CLOSE contract_csr;
720: -- Standard check of p_commit
721: IF FND_API.To_Boolean( p_commit ) THEN
722: COMMIT WORK;
723: END IF;
724:

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

721: IF FND_API.To_Boolean( p_commit ) THEN
722: COMMIT WORK;
723: END IF;
724:
725: -- Standard call to get message count and if count is 1, get message info.
726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
727:
728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 842: -- Standard Start of API savepoint

838: 'Contract Id is: ' || p_contract_id);
839: END IF;
840: l_api_name := 'delete_related_contracts';
841: l_api_version := 1.0;
842: -- Standard Start of API savepoint
843: SAVEPOINT delete_related_contracts_PVT;
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;

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

840: l_api_name := 'delete_related_contracts';
841: l_api_version := 1.0;
842: -- Standard Start of API savepoint
843: SAVEPOINT delete_related_contracts_PVT;
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: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 879: -- Standard check of p_commit

875: WHERE contract_TYPE = contract_rec.contract_type
876: AND contract_ID = p_CONTRACT_ID
877: AND contract_VERSION = contract_rec.contract_version_num;
878:
879: -- Standard check of p_commit
880: IF FND_API.To_Boolean( p_commit ) THEN
881: COMMIT WORK;
882: END IF;
883:

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

880: IF FND_API.To_Boolean( p_commit ) THEN
881: COMMIT WORK;
882: END IF;
883:
884: -- Standard call to get message count and if count is 1, get message info.
885: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
886:
887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 998: -- Standard Start of API savepoint

994: 'Contract Id is: ' || p_contract_id);
995: END IF;
996: l_api_name := 'delete_ACL';
997: l_api_version := 1.0;
998: -- Standard Start of API savepoint
999: SAVEPOINT delete_ACL_PVT;
1000: -- Standard call to check for call compatibility.
1001: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

996: l_api_name := 'delete_ACL';
997: l_api_version := 1.0;
998: -- Standard Start of API savepoint
999: SAVEPOINT delete_ACL_PVT;
1000: -- Standard call to check for call compatibility.
1001: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1050: -- Standard check of p_commit

1046: RAISE OKC_API.G_EXCEPTION_ERROR;
1047: END IF;
1048: --------------------------------------------------------
1049: END LOOP;
1050: -- Standard check of p_commit
1051: IF FND_API.To_Boolean( p_commit ) THEN
1052: COMMIT WORK;
1053: END IF;
1054:

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

1051: IF FND_API.To_Boolean( p_commit ) THEN
1052: COMMIT WORK;
1053: END IF;
1054:
1055: -- Standard call to get message count and if count is 1, get message info.
1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1057:
1058: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1167: -- Standard Start of API savepoint

1163: 'Contract Version is: ' || to_char(p_contract_version));
1164: END IF;
1165: l_api_name := 'delete_status_history';
1166: l_api_version := 1.0;
1167: -- Standard Start of API savepoint
1168: SAVEPOINT delete_status_history_PVT;
1169: -- Standard call to check for call compatibility.
1170: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1165: l_api_name := 'delete_status_history';
1166: l_api_version := 1.0;
1167: -- Standard Start of API savepoint
1168: SAVEPOINT delete_status_history_PVT;
1169: -- Standard call to check for call compatibility.
1170: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: END IF;
1173: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1186: -- Standard check of p_commit

1182: DELETE FROM OKC_REP_CON_STATUS_HIST
1183: WHERE CONTRACT_ID = p_CONTRACT_ID
1184: AND CONTRACT_VERSION_NUM = p_contract_version;
1185:
1186: -- Standard check of p_commit
1187: IF FND_API.To_Boolean( p_commit ) THEN
1188: COMMIT WORK;
1189: END IF;
1190:

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

1187: IF FND_API.To_Boolean( p_commit ) THEN
1188: COMMIT WORK;
1189: END IF;
1190:
1191: -- Standard call to get message count and if count is 1, get message info.
1192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1193:
1194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1296: -- Standard Start of API savepoint

1292: 'Contract Version is: ' || to_char(p_contract_version));
1293: END IF;
1294: l_api_name := 'delete_approval_history';
1295: l_api_version := 1.0;
1296: -- Standard Start of API savepoint
1297: SAVEPOINT delete_approval_history_PVT;
1298: -- Standard call to check for call compatibility.
1299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1294: l_api_name := 'delete_approval_history';
1295: l_api_version := 1.0;
1296: -- Standard Start of API savepoint
1297: SAVEPOINT delete_approval_history_PVT;
1298: -- Standard call to check for call compatibility.
1299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;
1302: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1315: -- Standard check of p_commit

1311: DELETE FROM OKC_REP_CON_APPROVALS
1312: WHERE CONTRACT_ID = p_CONTRACT_ID
1313: AND CONTRACT_VERSION_NUM = p_contract_version;
1314:
1315: -- Standard check of p_commit
1316: IF FND_API.To_Boolean( p_commit ) THEN
1317: COMMIT WORK;
1318: END IF;
1319:

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

1316: IF FND_API.To_Boolean( p_commit ) THEN
1317: COMMIT WORK;
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: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1419: -- Standard Start of API savepoint

1415: 'Contract Id is: ' || p_contract_id);
1416: END IF;
1417: l_api_name := 'delete_bookmarks';
1418: l_api_version := 1.0;
1419: -- Standard Start of API savepoint
1420: SAVEPOINT delete_bookmarks_PVT;
1421: -- Standard call to check for call compatibility.
1422: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1417: l_api_name := 'delete_bookmarks';
1418: l_api_version := 1.0;
1419: -- Standard Start of API savepoint
1420: SAVEPOINT delete_bookmarks_PVT;
1421: -- Standard call to check for call compatibility.
1422: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END IF;
1425: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1441: -- Standard check of p_commit

1437: WHERE OBJECT_TYPE = p_contract_type
1438: AND OBJECT_ID = p_CONTRACT_ID
1439: AND BOOKMARK_TYPE_CODE = G_CONTRACT_BOOKMARK_TYPE;
1440:
1441: -- Standard check of p_commit
1442: IF FND_API.To_Boolean( p_commit ) THEN
1443: COMMIT WORK;
1444: END IF;
1445:

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

1442: IF FND_API.To_Boolean( p_commit ) THEN
1443: COMMIT WORK;
1444: END IF;
1445:
1446: -- Standard call to get message count and if count is 1, get message info.
1447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1448:
1449: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1766: -- Standard Start of API savepoint

1762: 'Contract Id is: ' || p_contract_id);
1763: END IF;
1764: l_api_name := 'delete_contract';
1765: l_api_version := 1.0;
1766: -- Standard Start of API savepoint
1767: SAVEPOINT delete_contract_PVT;
1768: -- Standard call to check for call compatibility.
1769: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1764: l_api_name := 'delete_contract';
1765: l_api_version := 1.0;
1766: -- Standard Start of API savepoint
1767: SAVEPOINT delete_contract_PVT;
1768: -- Standard call to check for call compatibility.
1769: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1771: END IF;
1772: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2400: -- Standard check of p_commit

2396: WHERE contract_id = p_contract_id
2397: AND contract_version_num = l_prev_version;
2398: END IF; -- (contract_rec.contract_version_num > 1)
2399:
2400: -- Standard check of p_commit
2401: IF FND_API.To_Boolean( p_commit ) THEN
2402: COMMIT WORK;
2403: END IF;
2404:

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

2402: COMMIT WORK;
2403: END IF;
2404:
2405: CLOSE contract_csr;
2406: -- Standard call to get message count and if count is 1, get message info.
2407: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2408:
2409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2410: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2530: -- Standard Start of API savepoint

2526: 'Target Contract Id is: ' || to_char(p_target_contract_id));
2527: END IF;
2528: l_api_name := 'copy_contacts';
2529: l_api_version := 1.0;
2530: -- Standard Start of API savepoint
2531: SAVEPOINT copy_contacts_PVT;
2532: -- Standard call to check for call compatibility.
2533: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2528: l_api_name := 'copy_contacts';
2529: l_api_version := 1.0;
2530: -- Standard Start of API savepoint
2531: SAVEPOINT copy_contacts_PVT;
2532: -- Standard call to check for call compatibility.
2533: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2592: -- Standard check of p_commit

2588: l_last_update_login,
2589: contact_rec.SIGNATURE_SEQUENCE,
2590: contact_rec.ESIGNATURE_TYPE);
2591: END LOOP;
2592: -- Standard check of p_commit
2593: IF FND_API.To_Boolean( p_commit ) THEN
2594: COMMIT WORK;
2595: END IF;
2596:

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

2593: IF FND_API.To_Boolean( p_commit ) THEN
2594: COMMIT WORK;
2595: END IF;
2596:
2597: -- Standard call to get message count and if count is 1, get message info.
2598: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2599:
2600: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2709: -- Standard Start of API savepoint

2705: 'Target Contract Id is: ' || to_char(p_target_contract_id));
2706: END IF;
2707: l_api_name := 'copy_parties';
2708: l_api_version := 1.0;
2709: -- Standard Start of API savepoint
2710: SAVEPOINT copy_parties_PVT;
2711: -- Standard call to check for call compatibility.
2712: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2707: l_api_name := 'copy_parties';
2708: l_api_version := 1.0;
2709: -- Standard Start of API savepoint
2710: SAVEPOINT copy_parties_PVT;
2711: -- Standard call to check for call compatibility.
2712: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2714: END IF;
2715: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2762: -- Standard check of p_commit

2758: l_last_updated_by,
2759: l_last_update_date,
2760: l_last_update_login);
2761: END LOOP;
2762: -- Standard check of p_commit
2763: IF FND_API.To_Boolean( p_commit ) THEN
2764: COMMIT WORK;
2765: END IF;
2766:

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

2763: IF FND_API.To_Boolean( p_commit ) THEN
2764: COMMIT WORK;
2765: END IF;
2766:
2767: -- Standard call to get message count and if count is 1, get message info.
2768: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2769:
2770: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2890: -- Standard Start of API savepoint

2886: 'Target Contract Id is: ' || to_char(p_target_contract_id));
2887: END IF;
2888: l_api_name := 'copy_risks';
2889: l_api_version := 1.0;
2890: -- Standard Start of API savepoint
2891: SAVEPOINT copy_risks_PVT;
2892: -- Standard call to check for call compatibility.
2893: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2888: l_api_name := 'copy_risks';
2889: l_api_version := 1.0;
2890: -- Standard Start of API savepoint
2891: SAVEPOINT copy_risks_PVT;
2892: -- Standard call to check for call compatibility.
2893: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: END IF;
2896: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2989: -- Standard check of p_commit

2985: l_last_updated_by,
2986: l_last_update_date,
2987: l_last_update_login);
2988: END LOOP;
2989: -- Standard check of p_commit
2990: IF FND_API.To_Boolean( p_commit ) THEN
2991: COMMIT WORK;
2992: END IF;
2993:

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

2990: IF FND_API.To_Boolean( p_commit ) THEN
2991: COMMIT WORK;
2992: END IF;
2993:
2994: -- Standard call to get message count and if count is 1, get message info.
2995: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2996:
2997: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2998: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3130: -- Standard Start of API savepoint

3126: 'Target Contract Id is: ' || p_target_contract_id);
3127: END IF;
3128: l_api_name := 'copy_ACL';
3129: l_api_version := 1.0;
3130: -- Standard Start of API savepoint
3131: SAVEPOINT copy_ACL_PVT;
3132: -- Standard call to check for call compatibility.
3133: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3128: l_api_name := 'copy_ACL';
3129: l_api_version := 1.0;
3130: -- Standard Start of API savepoint
3131: SAVEPOINT copy_ACL_PVT;
3132: -- Standard call to check for call compatibility.
3133: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: END IF;
3136: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3189: -- Standard check of p_commit

3185: RAISE OKC_API.G_EXCEPTION_ERROR;
3186: END IF;
3187: --------------------------------------------------------
3188: END LOOP;
3189: -- Standard check of p_commit
3190: IF FND_API.To_Boolean( p_commit ) THEN
3191: COMMIT WORK;
3192: END IF;
3193:

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

3190: IF FND_API.To_Boolean( p_commit ) THEN
3191: COMMIT WORK;
3192: END IF;
3193:
3194: -- Standard call to get message count and if count is 1, get message info.
3195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3196:
3197: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3198: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3328: -- Standard Start of API savepoint

3324: 'Target Contract Number is: ' || p_target_contract_number);
3325: END IF;
3326: l_api_name := 'copy_contract_details';
3327: l_api_version := 1.0;
3328: -- Standard Start of API savepoint
3329: SAVEPOINT copy_contract_details_PVT;
3330: -- Standard call to check for call compatibility.
3331: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3326: l_api_name := 'copy_contract_details';
3327: l_api_version := 1.0;
3328: -- Standard Start of API savepoint
3329: SAVEPOINT copy_contract_details_PVT;
3330: -- Standard call to check for call compatibility.
3331: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3333: END IF;
3334: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3606: -- Standard check of p_commit

3602: -- close open cursors
3603: CLOSE source_contract_csr;
3604: CLOSE party_csr;
3605:
3606: -- Standard check of p_commit
3607: IF FND_API.To_Boolean( p_commit ) THEN
3608: COMMIT WORK;
3609: END IF;
3610:

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

3607: IF FND_API.To_Boolean( p_commit ) THEN
3608: COMMIT WORK;
3609: END IF;
3610:
3611: -- Standard call to get message count and if count is 1, get message info.
3612: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3613:
3614: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3752: -- Standard Start of API savepoint

3748: ' Contract Id is: ' || to_char(p_contract_id));
3749: END IF;
3750: l_api_name := 'version_contract_usages';
3751: l_api_version := 1.0;
3752: -- Standard Start of API savepoint
3753: SAVEPOINT version_contract_usages_PVT;
3754: -- Standard call to check for call compatibility.
3755: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3750: l_api_name := 'version_contract_usages';
3751: l_api_version := 1.0;
3752: -- Standard Start of API savepoint
3753: SAVEPOINT version_contract_usages_PVT;
3754: -- Standard call to check for call compatibility.
3755: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: END IF;
3758: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3859: -- Standard check of p_commit

3855: l_last_update_date
3856: );
3857:
3858: END LOOP;
3859: -- Standard check of p_commit
3860: IF FND_API.To_Boolean( p_commit ) THEN
3861: COMMIT WORK;
3862: END IF;
3863:

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

3860: IF FND_API.To_Boolean( p_commit ) THEN
3861: COMMIT WORK;
3862: END IF;
3863:
3864: -- Standard call to get message count and if count is 1, get message info.
3865: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3866:
3867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3868: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3991: -- Standard Start of API savepoint

3987: 'Contract Id is: ' || p_contract_id);
3988: END IF;
3989: l_api_name := 'version_contract_details';
3990: l_api_version := 1.0;
3991: -- Standard Start of API savepoint
3992: SAVEPOINT version_contract_details_PVT;
3993: -- Standard call to check for call compatibility.
3994: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3989: l_api_name := 'version_contract_details';
3990: l_api_version := 1.0;
3991: -- Standard Start of API savepoint
3992: SAVEPOINT version_contract_details_PVT;
3993: -- Standard call to check for call compatibility.
3994: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3996: END IF;
3997: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4410: -- Standard check of p_commit

4406: DELETE FROM OKC_REP_CONTRACTS_ALL
4407: WHERE contract_id=p_contract_id;
4408: END IF;
4409:
4410: -- Standard check of p_commit
4411: IF FND_API.To_Boolean( p_commit ) THEN
4412: COMMIT WORK;
4413: END IF;
4414:

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

4411: IF FND_API.To_Boolean( p_commit ) THEN
4412: COMMIT WORK;
4413: END IF;
4414:
4415: -- Standard call to get message count and if count is 1, get message info.
4416: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4417:
4418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 4550: -- Standard Start of API savepoint

4546: 'Contract Id is: ' || p_contract_id);
4547: END IF;
4548: l_api_name := 'sign_contacts';
4549: l_api_version := 1.0;
4550: -- Standard Start of API savepoint
4551: SAVEPOINT sign_contract_PVT;
4552: -- Standard call to check for call compatibility.
4553: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4548: l_api_name := 'sign_contacts';
4549: l_api_version := 1.0;
4550: -- Standard Start of API savepoint
4551: SAVEPOINT sign_contract_PVT;
4552: -- Standard call to check for call compatibility.
4553: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: END IF;
4556: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4827: -- Standard check of p_commit

4823: UPDATE okc_rep_contracts_all
4824: SET latest_signed_ver_number = contract_rec.contract_version_num
4825: WHERE contract_id = p_contract_id;
4826: CLOSE contract_csr;
4827: -- Standard check of p_commit
4828: IF FND_API.To_Boolean( p_commit ) THEN
4829: COMMIT WORK;
4830: END IF;
4831:

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

4828: IF FND_API.To_Boolean( p_commit ) THEN
4829: COMMIT WORK;
4830: END IF;
4831:
4832: -- Standard call to get message count and if count is 1, get message info.
4833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4834:
4835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 4985: -- Standard Start of API savepoint

4981: 'Contract Id is: ' || p_contract_id);
4982: END IF;
4983: l_api_name := 'Esign_contract';
4984: l_api_version := 1.0;
4985: -- Standard Start of API savepoint
4986: SAVEPOINT Esign_contract;
4987: -- Standard call to check for call compatibility.
4988: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4983: l_api_name := 'Esign_contract';
4984: l_api_version := 1.0;
4985: -- Standard Start of API savepoint
4986: SAVEPOINT Esign_contract;
4987: -- Standard call to check for call compatibility.
4988: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: END IF;
4991: -- Initialize message list if p_init_msg_list is set to TRUE.

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

5231: COMMIT WORK;
5232:
5233: END IF;
5234:
5235: -- Standard call to get message count and if count is 1, get message info.
5236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5237:
5238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 5363: -- Standard Start of API savepoint

5359: 'Termination date is: ' || to_char(p_termination_date));
5360: END IF;
5361: l_api_name := 'terminate_contacts';
5362: l_api_version := 1.0;
5363: -- Standard Start of API savepoint
5364: SAVEPOINT terminate_contract_PVT;
5365: -- Standard call to check for call compatibility.
5366: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5361: l_api_name := 'terminate_contacts';
5362: l_api_version := 1.0;
5363: -- Standard Start of API savepoint
5364: SAVEPOINT terminate_contract_PVT;
5365: -- Standard call to check for call compatibility.
5366: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5368: END IF;
5369: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5525: -- Standard check of p_commit

5521: END IF; -- contract_rec.termination_date = null
5522:
5523: CLOSE contract_csr;
5524:
5525: -- Standard check of p_commit
5526: IF FND_API.To_Boolean( p_commit ) THEN
5527: COMMIT WORK;
5528: END IF;
5529:

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

5526: IF FND_API.To_Boolean( p_commit ) THEN
5527: COMMIT WORK;
5528: END IF;
5529:
5530: -- Standard call to get message count and if count is 1, get message info.
5531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5532:
5533: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 5723: -- Standard Start of API savepoint

5719:
5720: l_message_token_con_number := 'CONTRACT_NUMBER';
5721: l_message_token_con_version := 'CONTRACT_VERSION';
5722:
5723: -- Standard Start of API savepoint
5724: SAVEPOINT repository_notifier_pvt;
5725:
5726: -- Standard call to check for call compatibility.
5727: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

5722:
5723: -- Standard Start of API savepoint
5724: SAVEPOINT repository_notifier_pvt;
5725:
5726: -- Standard call to check for call compatibility.
5727: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5729: END IF;
5730:

Line 5878: --set standard parameter

5874: itemtype => l_item_type,
5875: itemkey => l_item_key,
5876: process => l_process_name);
5877:
5878: --set standard parameter
5879: wf_engine.SetItemUserKey (
5880: itemtype => l_item_type,
5881: itemkey => l_item_key,
5882: userkey => l_item_key);

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

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

Line 6147: -- Standard Start of API savepoint

6143: END IF;
6144: l_api_name := 'cancel_approval';
6145: l_api_version := 1.0;
6146:
6147: -- Standard Start of API savepoint
6148: SAVEPOINT submit_contract_PVT;
6149:
6150: -- Standard call to check for call compatibility.
6151: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

6146:
6147: -- Standard Start of API savepoint
6148: SAVEPOINT submit_contract_PVT;
6149:
6150: -- Standard call to check for call compatibility.
6151: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6153: END IF;
6154:

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

6296: --------------------------------------------------------
6297:
6298: COMMIT WORK;
6299:
6300: -- Standard call to get message count and if count is 1, get message info.
6301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6302:
6303: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6304: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 6457: -- Standard Start of API savepoint

6453: END IF;
6454: l_api_name := 'get_next_contract_number';
6455: l_api_version := 1.0;
6456:
6457: -- Standard Start of API savepoint
6458: SAVEPOINT submit_contract_PVT;
6459:
6460: -- Standard call to check for call compatibility.
6461: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

6456:
6457: -- Standard Start of API savepoint
6458: SAVEPOINT submit_contract_PVT;
6459:
6460: -- Standard call to check for call compatibility.
6461: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6463: END IF;
6464:

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

6564: x_contract_number := p_contract_number;
6565: END IF;
6566:
6567:
6568: -- Standard call to get message count and if count is 1, get message info.
6569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6570:
6571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6572: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 6694: -- Standard Start of API savepoint

6690: 'Contract Id is: ' || to_char(p_contract_id));
6691: END IF;
6692: l_api_name := 'delete_uda_attribute_values';
6693: l_api_version := 1.0;
6694: -- Standard Start of API savepoint
6695: SAVEPOINT delete_uda_attr_values_PVT;
6696: -- Standard call to check for call compatibility.
6697: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6692: l_api_name := 'delete_uda_attribute_values';
6693: l_api_version := 1.0;
6694: -- Standard Start of API savepoint
6695: SAVEPOINT delete_uda_attr_values_PVT;
6696: -- Standard call to check for call compatibility.
6697: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6699: END IF;
6700: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 7060: -- Standard check of p_commit

7056: DELETE FROM OKC_REP_CONTRACT_VERS_EXT_TL
7057: WHERE CONTRACT_ID = p_contract_id
7058: AND contract_version_num = l_con_version - 1 ;
7059: */
7060: -- Standard check of p_commit
7061: IF FND_API.To_Boolean( p_commit ) THEN
7062: COMMIT WORK;
7063: END IF;
7064:

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

7061: IF FND_API.To_Boolean( p_commit ) THEN
7062: COMMIT WORK;
7063: END IF;
7064:
7065: -- Standard call to get message count and if count is 1, get message info.
7066: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7067:
7068: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 7187: -- Standard Start of API savepoint

7183: 'Target Contract Id is: ' || p_target_contract_id);
7184: END IF;
7185: l_api_name := 'copy_uda_attribute_values';
7186: l_api_version := 1.0;
7187: -- Standard Start of API savepoint
7188: SAVEPOINT copy_uda_attribute_values_PVT;
7189: -- Standard call to check for call compatibility.
7190: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7185: l_api_name := 'copy_uda_attribute_values';
7186: l_api_version := 1.0;
7187: -- Standard Start of API savepoint
7188: SAVEPOINT copy_uda_attribute_values_PVT;
7189: -- Standard call to check for call compatibility.
7190: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7192: END IF;
7193: -- Initialize message list if p_init_msg_list is set to TRUE.

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

7309: IF FND_API.To_Boolean( p_commit ) THEN
7310: COMMIT WORK;
7311: END IF;
7312:
7313: -- Standard call to get message count and if count is 1, get message info.
7314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7315:
7316: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 7422: -- Standard Start of API savepoint

7418: 'Contract Id is: ' || to_char(p_contract_id));
7419: END IF;
7420: l_api_name := 'version_uda_attribute_values';
7421: l_api_version := 1.0;
7422: -- Standard Start of API savepoint
7423: SAVEPOINT version_uda_attr_values_PVT;
7424: -- Standard call to check for call compatibility.
7425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7420: l_api_name := 'version_uda_attribute_values';
7421: l_api_version := 1.0;
7422: -- Standard Start of API savepoint
7423: SAVEPOINT version_uda_attr_values_PVT;
7424: -- Standard call to check for call compatibility.
7425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7427: END IF;
7428: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 7775: -- Standard check of p_commit

7771: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7772:
7773: END LOOP;
7774:
7775: -- Standard check of p_commit
7776: IF FND_API.To_Boolean( p_commit ) THEN
7777: COMMIT WORK;
7778: END IF;
7779:

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

7776: IF FND_API.To_Boolean( p_commit ) THEN
7777: COMMIT WORK;
7778: END IF;
7779:
7780: -- Standard call to get message count and if count is 1, get message info.
7781: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7782:
7783: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7784: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,