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 FND_MSG_PUB

Line 80: FND_MSG_PUB.initialize;

76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82: -- Initialize API return status to success
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:

Line 329: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
333: 'Leaving OKC_REP_WF_PVT.submit_contract');

Line 349: FND_MSG_PUB.Count_And_Get(

345: CLOSE contract_csr ;
346: END IF;
347: ROLLBACK TO submit_contract_PVT;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MSG_PUB.Count_And_Get(
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353:

Line 366: FND_MSG_PUB.Count_And_Get(

362: CLOSE contract_csr ;
363: END IF;
364: ROLLBACK TO submit_contract_PVT;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MSG_PUB.Count_And_Get(
367: p_count => x_msg_count,
368: p_data => x_msg_data
369: );
370:

Line 389: FND_MSG_PUB.Count_And_Get(

385: p_token2 => G_SQLERRM_TOKEN,
386: p_token2_value => sqlerrm);
387: ROLLBACK TO submit_contract_PVT;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: FND_MSG_PUB.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data
392: );
393:

Line 446: FND_MSG_PUB.initialize;

442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444: -- Initialize message list if p_init_msg_list is set to TRUE.
445: IF FND_API.to_Boolean( p_init_msg_list ) THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: -- Initialize API return status to success
450: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
466: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');

Line 479: FND_MSG_PUB.Count_And_Get(

475: 'Leaving delete_contacts:FND_API.G_EXC_ERROR Exception');
476: END IF;
477: ROLLBACK TO delete_contacts_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: FND_MSG_PUB.Count_And_Get(
480: p_count => x_msg_count,
481: p_data => x_msg_data
482: );
483:

Line 492: FND_MSG_PUB.Count_And_Get(

488: 'Leaving delete_contacts:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
489: END IF;
490: ROLLBACK TO delete_contacts_PVT;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: FND_MSG_PUB.Count_And_Get(
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:

Line 511: FND_MSG_PUB.Count_And_Get(

507: p_token2 => G_SQLERRM_TOKEN,
508: p_token2_value => sqlerrm);
509: ROLLBACK TO delete_contacts_PVT;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get(
512: p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515: END delete_contacts;

Line 565: FND_MSG_PUB.initialize;

561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563: -- Initialize message list if p_init_msg_list is set to TRUE.
564: IF FND_API.to_Boolean( p_init_msg_list ) THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567:
568: -- Initialize API return status to success
569: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 581: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
585: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');

Line 598: FND_MSG_PUB.Count_And_Get(

594: 'Leaving delete_parties:FND_API.G_EXC_ERROR Exception');
595: END IF;
596: ROLLBACK TO delete_parties_PVT;
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get(
599: p_count => x_msg_count,
600: p_data => x_msg_data
601: );
602:

Line 611: FND_MSG_PUB.Count_And_Get(

607: 'Leaving delete_parties:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
608: END IF;
609: ROLLBACK TO delete_parties_PVT;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_And_Get(
612: p_count => x_msg_count,
613: p_data => x_msg_data
614: );
615:

Line 630: FND_MSG_PUB.Count_And_Get(

626: p_token2 => G_SQLERRM_TOKEN,
627: p_token2_value => sqlerrm);
628: ROLLBACK TO delete_parties_PVT;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: FND_MSG_PUB.Count_And_Get(
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634: END delete_parties;

Line 692: FND_MSG_PUB.initialize;

688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690: -- Initialize message list if p_init_msg_list is set to TRUE.
691: IF FND_API.to_Boolean( p_init_msg_list ) THEN
692: FND_MSG_PUB.initialize;
693: END IF;
694:
695: -- Initialize API return status to success
696: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
730: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');

Line 747: FND_MSG_PUB.Count_And_Get(

743: CLOSE contract_csr ;
744: END IF;
745: ROLLBACK TO delete_risks_PVT;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_And_Get(
748: p_count => x_msg_count,
749: p_data => x_msg_data
750: );
751:

Line 764: FND_MSG_PUB.Count_And_Get(

760: CLOSE contract_csr ;
761: END IF;
762: ROLLBACK TO delete_risks_PVT;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MSG_PUB.Count_And_Get(
765: p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768:

Line 787: FND_MSG_PUB.Count_And_Get(

783: p_token2 => G_SQLERRM_TOKEN,
784: p_token2_value => sqlerrm);
785: ROLLBACK TO delete_risks_PVT;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.Count_And_Get(
788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791: END delete_risks;

Line 850: FND_MSG_PUB.initialize;

846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848: -- Initialize message list if p_init_msg_list is set to TRUE.
849: IF FND_API.to_Boolean( p_init_msg_list ) THEN
850: FND_MSG_PUB.initialize;
851: END IF;
852:
853: -- Initialize API return status to success
854: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 885: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
889: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');

Line 902: FND_MSG_PUB.Count_And_Get(

898: 'Leaving delete_related_contracts:FND_API.G_EXC_ERROR Exception');
899: END IF;
900: ROLLBACK TO delete_related_contracts_PVT;
901: x_return_status := FND_API.G_RET_STS_ERROR;
902: FND_MSG_PUB.Count_And_Get(
903: p_count => x_msg_count,
904: p_data => x_msg_data
905: );
906:

Line 915: FND_MSG_PUB.Count_And_Get(

911: 'Leaving delete_related_contracts:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
912: END IF;
913: ROLLBACK TO delete_related_contracts_PVT;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: FND_MSG_PUB.Count_And_Get(
916: p_count => x_msg_count,
917: p_data => x_msg_data
918: );
919:

Line 934: FND_MSG_PUB.Count_And_Get(

930: p_token2 => G_SQLERRM_TOKEN,
931: p_token2_value => sqlerrm);
932: ROLLBACK TO delete_related_contracts_PVT;
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: FND_MSG_PUB.Count_And_Get(
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );
938: END delete_related_contracts;

Line 1006: FND_MSG_PUB.initialize;

1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004: -- Initialize message list if p_init_msg_list is set to TRUE.
1005: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009: -- Initialize API return status to success
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
1060: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');

Line 1077: FND_MSG_PUB.Count_And_Get(

1073: CLOSE acl_csr ;
1074: END IF;
1075: ROLLBACK TO delete_ACL_PVT;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: FND_MSG_PUB.Count_And_Get(
1078: p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081:

Line 1093: FND_MSG_PUB.Count_And_Get(

1089: CLOSE acl_csr ;
1090: END IF;
1091: ROLLBACK TO delete_ACL_PVT;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: FND_MSG_PUB.Count_And_Get(
1094: p_count => x_msg_count,
1095: p_data => x_msg_data
1096: );
1097:

Line 1115: FND_MSG_PUB.Count_And_Get(

1111: p_token2 => G_SQLERRM_TOKEN,
1112: p_token2_value => sqlerrm);
1113: ROLLBACK TO delete_ACL_PVT;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: FND_MSG_PUB.Count_And_Get(
1116: p_count => x_msg_count,
1117: p_data => x_msg_data
1118: );
1119: END delete_ACL;

Line 1175: FND_MSG_PUB.initialize;

1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: END IF;
1173: -- Initialize message list if p_init_msg_list is set to TRUE.
1174: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1175: FND_MSG_PUB.initialize;
1176: END IF;
1177:
1178: -- Initialize API return status to success
1179: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
1196: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');

Line 1209: FND_MSG_PUB.Count_And_Get(

1205: 'Leaving delete_status_history:FND_API.G_EXC_ERROR Exception');
1206: END IF;
1207: ROLLBACK TO delete_status_history_PVT;
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: FND_MSG_PUB.Count_And_Get(
1210: p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1213:

Line 1222: FND_MSG_PUB.Count_And_Get(

1218: 'Leaving delete_status_history:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1219: END IF;
1220: ROLLBACK TO delete_status_history_PVT;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: FND_MSG_PUB.Count_And_Get(
1223: p_count => x_msg_count,
1224: p_data => x_msg_data
1225: );
1226:

Line 1241: FND_MSG_PUB.Count_And_Get(

1237: p_token2 => G_SQLERRM_TOKEN,
1238: p_token2_value => sqlerrm);
1239: ROLLBACK TO delete_status_history_PVT;
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: FND_MSG_PUB.Count_And_Get(
1242: p_count => x_msg_count,
1243: p_data => x_msg_data
1244: );
1245: END delete_status_history;

Line 1304: FND_MSG_PUB.initialize;

1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;
1302: -- Initialize message list if p_init_msg_list is set to TRUE.
1303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1304: FND_MSG_PUB.initialize;
1305: END IF;
1306:
1307: -- Initialize API return status to success
1308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
1325: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history');

Line 1338: FND_MSG_PUB.Count_And_Get(

1334: 'Leaving delete_approval_history:FND_API.G_EXC_ERROR Exception');
1335: END IF;
1336: ROLLBACK TO delete_approval_history_PVT;
1337: x_return_status :=FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.Count_And_Get(
1339: p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1342:

Line 1351: FND_MSG_PUB.Count_And_Get(

1347: 'Leaving delete_approval_history:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1348: END IF;
1349: ROLLBACK TO delete_approval_history_PVT;
1350: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
1351: FND_MSG_PUB.Count_And_Get(
1352: p_count => x_msg_count,
1353: p_data => x_msg_data
1354: );
1355:

Line 1370: FND_MSG_PUB.Count_And_Get(

1366: p_token2 => G_SQLERRM_TOKEN,
1367: p_token2_value => sqlerrm);
1368: ROLLBACK TO delete_approval_history_PVT;
1369: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR;
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count,
1372: p_data => x_msg_data
1373: );
1374: END delete_approval_history;

Line 1427: FND_MSG_PUB.initialize;

1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END IF;
1425: -- Initialize message list if p_init_msg_list is set to TRUE.
1426: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1427: FND_MSG_PUB.initialize;
1428: END IF;
1429:
1430: -- Initialize API return status to success
1431: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
1451: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');

Line 1464: FND_MSG_PUB.Count_And_Get(

1460: 'Leaving delete_bookmarks:FND_API.G_EXC_ERROR Exception');
1461: END IF;
1462: ROLLBACK TO delete_bookmarks_PVT;
1463: x_return_status := FND_API.G_RET_STS_ERROR;
1464: FND_MSG_PUB.Count_And_Get(
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468:

Line 1477: FND_MSG_PUB.Count_And_Get(

1473: 'Leaving delete_bookmarks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1474: END IF;
1475: ROLLBACK TO delete_bookmarks_PVT;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.Count_And_Get(
1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );
1481:

Line 1496: FND_MSG_PUB.Count_And_Get(

1492: p_token2 => G_SQLERRM_TOKEN,
1493: p_token2_value => sqlerrm);
1494: ROLLBACK TO delete_bookmarks_PVT;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1496: FND_MSG_PUB.Count_And_Get(
1497: p_count => x_msg_count,
1498: p_data => x_msg_data
1499: );
1500: END delete_bookmarks;

Line 1774: FND_MSG_PUB.initialize;

1770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1771: END IF;
1772: -- Initialize message list if p_init_msg_list is set to TRUE.
1773: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1774: FND_MSG_PUB.initialize;
1775: END IF;
1776:
1777: -- Initialize API return status to success
1778: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2407: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
2411: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');

Line 2428: FND_MSG_PUB.Count_And_Get(

2424: CLOSE contract_csr ;
2425: END IF;
2426: ROLLBACK TO delete_contract_PVT;
2427: x_return_status := FND_API.G_RET_STS_ERROR;
2428: FND_MSG_PUB.Count_And_Get(
2429: p_count => x_msg_count,
2430: p_data => x_msg_data
2431: );
2432:

Line 2445: FND_MSG_PUB.Count_And_Get(

2441: CLOSE contract_csr ;
2442: END IF;
2443: ROLLBACK TO delete_contract_PVT;
2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2445: FND_MSG_PUB.Count_And_Get(
2446: p_count => x_msg_count,
2447: p_data => x_msg_data
2448: );
2449:

Line 2468: FND_MSG_PUB.Count_And_Get(

2464: IF (contract_csr%ISOPEN) THEN
2465: CLOSE contract_csr ;
2466: END IF;
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2468: FND_MSG_PUB.Count_And_Get(
2469: p_count => x_msg_count,
2470: p_data => x_msg_data
2471: );
2472: END delete_contract;

Line 2538: FND_MSG_PUB.initialize;

2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: -- Initialize message list if p_init_msg_list is set to TRUE.
2537: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: -- Initialize API return status to success
2542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2598: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
2602: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');

Line 2615: FND_MSG_PUB.Count_And_Get(

2611: 'Leaving copy_contacts:FND_API.G_EXC_ERROR Exception');
2612: END IF;
2613: ROLLBACK TO copy_contacts_PVT;
2614: x_return_status := FND_API.G_RET_STS_ERROR;
2615: FND_MSG_PUB.Count_And_Get(
2616: p_count => x_msg_count,
2617: p_data => x_msg_data
2618: );
2619:

Line 2628: FND_MSG_PUB.Count_And_Get(

2624: 'Leaving copy_contacts:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2625: END IF;
2626: ROLLBACK TO copy_contacts_PVT;
2627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2628: FND_MSG_PUB.Count_And_Get(
2629: p_count => x_msg_count,
2630: p_data => x_msg_data
2631: );
2632:

Line 2647: FND_MSG_PUB.Count_And_Get(

2643: p_token2 => G_SQLERRM_TOKEN,
2644: p_token2_value => sqlerrm);
2645: ROLLBACK TO copy_contacts_PVT;
2646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2647: FND_MSG_PUB.Count_And_Get(
2648: p_count => x_msg_count,
2649: p_data => x_msg_data
2650: );
2651: END copy_contacts;

Line 2717: FND_MSG_PUB.initialize;

2713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2714: END IF;
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2768: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
2772: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');

Line 2785: FND_MSG_PUB.Count_And_Get(

2781: 'Leaving copy_parties:FND_API.G_EXC_ERROR Exception');
2782: END IF;
2783: ROLLBACK TO copy_parties_PVT;
2784: x_return_status := FND_API.G_RET_STS_ERROR;
2785: FND_MSG_PUB.Count_And_Get(
2786: p_count => x_msg_count,
2787: p_data => x_msg_data
2788: );
2789:

Line 2798: FND_MSG_PUB.Count_And_Get(

2794: 'Leaving copy_parties:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO copy_parties_PVT;
2797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2798: FND_MSG_PUB.Count_And_Get(
2799: p_count => x_msg_count,
2800: p_data => x_msg_data
2801: );
2802:

Line 2817: FND_MSG_PUB.Count_And_Get(

2813: p_token2 => G_SQLERRM_TOKEN,
2814: p_token2_value => sqlerrm);
2815: ROLLBACK TO copy_parties_PVT;
2816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2817: FND_MSG_PUB.Count_And_Get(
2818: p_count => x_msg_count,
2819: p_data => x_msg_data
2820: );
2821: END copy_parties;

Line 2898: FND_MSG_PUB.initialize;

2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: END IF;
2896: -- Initialize message list if p_init_msg_list is set to TRUE.
2897: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2898: FND_MSG_PUB.initialize;
2899: END IF;
2900:
2901: -- Initialize API return status to success
2902: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2995: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
2999: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');

Line 3016: FND_MSG_PUB.Count_And_Get(

3012: CLOSE contract_csr ;
3013: END IF;
3014: ROLLBACK TO copy_risks_PVT;
3015: x_return_status := FND_API.G_RET_STS_ERROR;
3016: FND_MSG_PUB.Count_And_Get(
3017: p_count => x_msg_count,
3018: p_data => x_msg_data
3019: );
3020:

Line 3033: FND_MSG_PUB.Count_And_Get(

3029: CLOSE contract_csr ;
3030: END IF;
3031: ROLLBACK TO copy_risks_PVT;
3032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3033: FND_MSG_PUB.Count_And_Get(
3034: p_count => x_msg_count,
3035: p_data => x_msg_data
3036: );
3037:

Line 3056: FND_MSG_PUB.Count_And_Get(

3052: p_token2 => G_SQLERRM_TOKEN,
3053: p_token2_value => sqlerrm);
3054: ROLLBACK TO copy_risks_PVT;
3055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3056: FND_MSG_PUB.Count_And_Get(
3057: p_count => x_msg_count,
3058: p_data => x_msg_data
3059: );
3060: END copy_risks;

Line 3138: FND_MSG_PUB.initialize;

3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: END IF;
3136: -- Initialize message list if p_init_msg_list is set to TRUE.
3137: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3138: FND_MSG_PUB.initialize;
3139: END IF;
3140:
3141: -- Initialize API return status to success
3142: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
3199: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');

Line 3212: FND_MSG_PUB.Count_And_Get(

3208: 'Leaving copy_ACL:FND_API.G_EXC_ERROR Exception');
3209: END IF;
3210: ROLLBACK TO copy_ACL_PVT;
3211: x_return_status := FND_API.G_RET_STS_ERROR;
3212: FND_MSG_PUB.Count_And_Get(
3213: p_count => x_msg_count,
3214: p_data => x_msg_data
3215: );
3216:

Line 3225: FND_MSG_PUB.Count_And_Get(

3221: 'Leaving copy_ACL:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3222: END IF;
3223: ROLLBACK TO copy_ACL_PVT;
3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225: FND_MSG_PUB.Count_And_Get(
3226: p_count => x_msg_count,
3227: p_data => x_msg_data
3228: );
3229:

Line 3244: FND_MSG_PUB.Count_And_Get(

3240: p_token2 => G_SQLERRM_TOKEN,
3241: p_token2_value => sqlerrm);
3242: ROLLBACK TO copy_ACL_PVT;
3243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3244: FND_MSG_PUB.Count_And_Get(
3245: p_count => x_msg_count,
3246: p_data => x_msg_data
3247: );
3248: END copy_ACL;

Line 3336: FND_MSG_PUB.initialize;

3332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3333: END IF;
3334: -- Initialize message list if p_init_msg_list is set to TRUE.
3335: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3336: FND_MSG_PUB.initialize;
3337: END IF;
3338:
3339: -- Initialize API return status to success
3340: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3612: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
3616: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');

Line 3636: FND_MSG_PUB.Count_And_Get(

3632: CLOSE party_csr ;
3633: END IF;
3634: ROLLBACK TO copy_contract_details_PVT;
3635: x_return_status := FND_API.G_RET_STS_ERROR;
3636: FND_MSG_PUB.Count_And_Get(
3637: p_count => x_msg_count,
3638: p_data => x_msg_data
3639: );
3640:

Line 3656: FND_MSG_PUB.Count_And_Get(

3652: CLOSE party_csr ;
3653: END IF;
3654: ROLLBACK TO copy_contract_details_PVT;
3655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3656: FND_MSG_PUB.Count_And_Get(
3657: p_count => x_msg_count,
3658: p_data => x_msg_data
3659: );
3660:

Line 3682: FND_MSG_PUB.Count_And_Get(

3678: IF (party_csr%ISOPEN) THEN
3679: CLOSE party_csr ;
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3682: FND_MSG_PUB.Count_And_Get(
3683: p_count => x_msg_count,
3684: p_data => x_msg_data
3685: );
3686: END copy_contract_details;

Line 3760: FND_MSG_PUB.initialize;

3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: END IF;
3758: -- Initialize message list if p_init_msg_list is set to TRUE.
3759: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3760: FND_MSG_PUB.initialize;
3761: END IF;
3762:
3763: -- Initialize API return status to success
3764: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3865: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
3869: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.');

Line 3886: FND_MSG_PUB.Count_And_Get(

3882: CLOSE contract_csr ;
3883: END IF;
3884: ROLLBACK TO version_contract_usages_PVT;
3885: x_return_status := FND_API.G_RET_STS_ERROR;
3886: FND_MSG_PUB.Count_And_Get(
3887: p_count => x_msg_count,
3888: p_data => x_msg_data
3889: );
3890:

Line 3903: FND_MSG_PUB.Count_And_Get(

3899: CLOSE contract_csr ;
3900: END IF;
3901: ROLLBACK TO version_contract_usages_PVT;
3902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3903: FND_MSG_PUB.Count_And_Get(
3904: p_count => x_msg_count,
3905: p_data => x_msg_data
3906: );
3907:

Line 3926: FND_MSG_PUB.Count_And_Get(

3922: p_token2 => G_SQLERRM_TOKEN,
3923: p_token2_value => sqlerrm);
3924: ROLLBACK TO version_contract_usages_PVT;
3925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3926: FND_MSG_PUB.Count_And_Get(
3927: p_count => x_msg_count,
3928: p_data => x_msg_data
3929: );
3930: END version_contract_usages;

Line 3999: FND_MSG_PUB.initialize;

3995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3996: END IF;
3997: -- Initialize message list if p_init_msg_list is set to TRUE.
3998: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3999: FND_MSG_PUB.initialize;
4000: END IF;
4001:
4002: -- Initialize API return status to success
4003: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4416: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
4420: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');

Line 4437: FND_MSG_PUB.Count_And_Get(

4433: CLOSE contract_csr ;
4434: END IF;
4435: ROLLBACK TO version_contract_details_PVT;
4436: x_return_status := FND_API.G_RET_STS_ERROR;
4437: FND_MSG_PUB.Count_And_Get(
4438: p_count => x_msg_count,
4439: p_data => x_msg_data
4440: );
4441:

Line 4454: FND_MSG_PUB.Count_And_Get(

4450: CLOSE contract_csr ;
4451: END IF;
4452: ROLLBACK TO version_contract_details_PVT;
4453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4454: FND_MSG_PUB.Count_And_Get(
4455: p_count => x_msg_count,
4456: p_data => x_msg_data
4457: );
4458:

Line 4477: FND_MSG_PUB.Count_And_Get(

4473: IF (contract_csr%ISOPEN) THEN
4474: CLOSE contract_csr ;
4475: END IF;
4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4477: FND_MSG_PUB.Count_And_Get(
4478: p_count => x_msg_count,
4479: p_data => x_msg_data
4480: );
4481: END version_contract_details;

Line 4558: FND_MSG_PUB.initialize;

4554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4555: END IF;
4556: -- Initialize message list if p_init_msg_list is set to TRUE.
4557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4558: FND_MSG_PUB.initialize;
4559: END IF;
4560:
4561: -- Initialize API return status to success
4562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
4837: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

Line 4857: FND_MSG_PUB.Count_And_Get(

4853: CLOSE arch_contract_csr ;
4854: END IF;
4855: ROLLBACK TO sign_contract_PVT;
4856: x_return_status := FND_API.G_RET_STS_ERROR;
4857: FND_MSG_PUB.Count_And_Get(
4858: p_count => x_msg_count,
4859: p_data => x_msg_data
4860: );
4861:

Line 4877: FND_MSG_PUB.Count_And_Get(

4873: CLOSE arch_contract_csr ;
4874: END IF;
4875: ROLLBACK TO sign_contract_PVT;
4876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4877: FND_MSG_PUB.Count_And_Get(
4878: p_count => x_msg_count,
4879: p_data => x_msg_data
4880: );
4881:

Line 4903: FND_MSG_PUB.Count_And_Get(

4899: IF (arch_contract_csr%ISOPEN) THEN
4900: CLOSE arch_contract_csr ;
4901: END IF;
4902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4903: FND_MSG_PUB.Count_And_Get(
4904: p_count => x_msg_count,
4905: p_data => x_msg_data
4906: );
4907: END sign_contract;

Line 4993: FND_MSG_PUB.initialize;

4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: END IF;
4991: -- Initialize message list if p_init_msg_list is set to TRUE.
4992: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4993: FND_MSG_PUB.initialize;
4994: END IF;
4995: -- Initialize API return status to success
4996: x_return_status := FND_API.G_RET_STS_SUCCESS;
4997:

Line 5236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
5240: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.Esign_contract');

Line 5256: FND_MSG_PUB.Count_And_Get(

5252: CLOSE contract_csr ;
5253: END IF;
5254: ROLLBACK TO Esign_contract;
5255: x_return_status := FND_API.G_RET_STS_ERROR;
5256: FND_MSG_PUB.Count_And_Get(
5257: p_count => x_msg_count,
5258: p_data => x_msg_data
5259: );
5260:

Line 5273: FND_MSG_PUB.Count_And_Get(

5269: CLOSE contract_csr ;
5270: END IF;
5271: ROLLBACK TO Esign_contract;
5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5273: FND_MSG_PUB.Count_And_Get(
5274: p_count => x_msg_count,
5275: p_data => x_msg_data
5276: );
5277:

Line 5296: FND_MSG_PUB.Count_And_Get(

5292: p_token2 => G_SQLERRM_TOKEN,
5293: p_token2_value => sqlerrm);
5294: ROLLBACK TO Esign_contract;
5295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5296: FND_MSG_PUB.Count_And_Get(
5297: p_count => x_msg_count,
5298: p_data => x_msg_data
5299: );
5300:

Line 5371: FND_MSG_PUB.initialize;

5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5368: END IF;
5369: -- Initialize message list if p_init_msg_list is set to TRUE.
5370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5371: FND_MSG_PUB.initialize;
5372: END IF;
5373:
5374: -- Initialize API return status to success
5375: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
5535: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');

Line 5552: FND_MSG_PUB.Count_And_Get(

5548: CLOSE contract_csr ;
5549: END IF;
5550: ROLLBACK TO terminate_contract_PVT;
5551: x_return_status := FND_API.G_RET_STS_ERROR;
5552: FND_MSG_PUB.Count_And_Get(
5553: p_count => x_msg_count,
5554: p_data => x_msg_data
5555: );
5556:

Line 5569: FND_MSG_PUB.Count_And_Get(

5565: CLOSE contract_csr ;
5566: END IF;
5567: ROLLBACK TO terminate_contract_PVT;
5568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5569: FND_MSG_PUB.Count_And_Get(
5570: p_count => x_msg_count,
5571: p_data => x_msg_data
5572: );
5573:

Line 5592: FND_MSG_PUB.Count_And_Get(

5588: IF (contract_csr%ISOPEN) THEN
5589: CLOSE contract_csr;
5590: END IF;
5591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5592: FND_MSG_PUB.Count_And_Get(
5593: p_count => x_msg_count,
5594: p_data => x_msg_data
5595: );
5596: END terminate_contract;

Line 5733: FND_MSG_PUB.initialize;

5729: END IF;
5730:
5731: -- Initialize message list if p_init_msg_list is set to TRUE.
5732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5733: FND_MSG_PUB.initialize;
5734: END IF;
5735:
5736: -- Get contact role name
5737: OPEN cur_contact_role;

Line 6001: FND_MSG_PUB.Count_And_Get(

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:
6005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6031: FND_MSG_PUB.Count_And_Get(

6027: END IF;
6028: ROLLBACK TO repository_notifier_pvt;
6029:
6030: x_return_status := FND_API.G_RET_STS_ERROR;
6031: FND_MSG_PUB.Count_And_Get(
6032: p_count => x_msg_count,
6033: p_data => x_msg_data
6034: );
6035:

Line 6053: FND_MSG_PUB.Count_And_Get(

6049: END IF;
6050: ROLLBACK TO repository_notifier_pvt;
6051:
6052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6053: FND_MSG_PUB.Count_And_Get(
6054: p_count => x_msg_count,
6055: p_data => x_msg_data
6056: );
6057:

Line 6083: FND_MSG_PUB.Count_And_Get(

6079: END IF;
6080: ROLLBACK TO repository_notifier_pvt;
6081:
6082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6083: FND_MSG_PUB.Count_And_Get(
6084: p_count => x_msg_count,
6085: p_data => x_msg_data
6086: );
6087:

Line 6157: FND_MSG_PUB.initialize;

6153: END IF;
6154:
6155: -- Initialize message list if p_init_msg_list is set to TRUE.
6156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6157: FND_MSG_PUB.initialize;
6158: END IF;
6159:
6160: -- Initialize API return status to success
6161: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
6305: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');

Line 6321: FND_MSG_PUB.Count_And_Get(

6317: CLOSE contract_csr ;
6318: END IF;
6319: ROLLBACK TO submit_contract_PVT;
6320: x_return_status := FND_API.G_RET_STS_ERROR;
6321: FND_MSG_PUB.Count_And_Get(
6322: p_count => x_msg_count,
6323: p_data => x_msg_data
6324: );
6325:

Line 6338: FND_MSG_PUB.Count_And_Get(

6334: CLOSE contract_csr ;
6335: END IF;
6336: ROLLBACK TO submit_contract_PVT;
6337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6338: FND_MSG_PUB.Count_And_Get(
6339: p_count => x_msg_count,
6340: p_data => x_msg_data
6341: );
6342:

Line 6361: FND_MSG_PUB.Count_And_Get(

6357: p_token2 => G_SQLERRM_TOKEN,
6358: p_token2_value => sqlerrm);
6359: ROLLBACK TO submit_contract_PVT;
6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361: FND_MSG_PUB.Count_And_Get(
6362: p_count => x_msg_count,
6363: p_data => x_msg_data
6364: );
6365:

Line 6467: FND_MSG_PUB.initialize;

6463: END IF;
6464:
6465: -- Initialize message list if p_init_msg_list is set to TRUE.
6466: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6467: FND_MSG_PUB.initialize;
6468: END IF;
6469:
6470: -- Initialize API return status to success
6471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
6573: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');

Line 6594: FND_MSG_PUB.Count_And_Get(

6590: END IF;
6591:
6592: ROLLBACK TO submit_contract_PVT;
6593: x_return_status := FND_API.G_RET_STS_ERROR;
6594: FND_MSG_PUB.Count_And_Get(
6595: p_count => x_msg_count,
6596: p_data => x_msg_data
6597: );
6598:

Line 6616: FND_MSG_PUB.Count_And_Get(

6612: END IF;
6613:
6614: ROLLBACK TO submit_contract_PVT;
6615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6616: FND_MSG_PUB.Count_And_Get(
6617: p_count => x_msg_count,
6618: p_data => x_msg_data
6619: );
6620:

Line 6644: FND_MSG_PUB.Count_And_Get(

6640: p_token2 => G_SQLERRM_TOKEN,
6641: p_token2_value => sqlerrm);
6642: ROLLBACK TO submit_contract_PVT;
6643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6644: FND_MSG_PUB.Count_And_Get(
6645: p_count => x_msg_count,
6646: p_data => x_msg_data
6647: );
6648:

Line 6702: FND_MSG_PUB.initialize;

6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6699: END IF;
6700: -- Initialize message list if p_init_msg_list is set to TRUE.
6701: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6702: FND_MSG_PUB.initialize;
6703: END IF;
6704:
6705: -- Initialize API return status to success
6706: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7066: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
7070: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values');

Line 7083: FND_MSG_PUB.Count_And_Get(

7079: 'Leaving delete_uda_attribute_values:FND_API.G_EXC_ERROR Exception');
7080: END IF;
7081: ROLLBACK TO delete_uda_attr_values_PVT;
7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: FND_MSG_PUB.Count_And_Get(
7084: p_count => x_msg_count,
7085: p_data => x_msg_data
7086: );
7087:

Line 7096: FND_MSG_PUB.Count_And_Get(

7092: 'Leaving delete_uda_attribute_values:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
7093: END IF;
7094: ROLLBACK TO delete_uda_attr_values_PVT;
7095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7096: FND_MSG_PUB.Count_And_Get(
7097: p_count => x_msg_count,
7098: p_data => x_msg_data
7099: );
7100:

Line 7115: FND_MSG_PUB.Count_And_Get(

7111: p_token2 => G_SQLERRM_TOKEN,
7112: p_token2_value => sqlerrm);
7113: ROLLBACK TO delete_uda_attr_values_PVT;
7114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7115: FND_MSG_PUB.Count_And_Get(
7116: p_count => x_msg_count,
7117: p_data => x_msg_data
7118: );
7119:

Line 7195: FND_MSG_PUB.initialize;

7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7192: END IF;
7193: -- Initialize message list if p_init_msg_list is set to TRUE.
7194: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7195: FND_MSG_PUB.initialize;
7196: END IF;
7197:
7198: -- Initialize API return status to success
7199: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7244: FND_MSG_PUB.add;

7240: l_from_where_pk_sql := l_from_where_pk_sql ||l_from_pk_col_value_pairs(l_index).NAME ||' = ''' ||l_from_pk_col_value_pairs(l_index).VALUE ||''' AND ';
7241: END IF;
7242: ELSE
7243: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
7244: FND_MSG_PUB.add;
7245: RAISE FND_API.G_EXC_ERROR;
7246: END IF;
7247: l_index := l_from_pk_col_value_pairs.NEXT(l_index);
7248: END LOOP;

Line 7314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
7318: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values');

Line 7331: FND_MSG_PUB.Count_And_Get(

7327: 'Leaving copy_uda_attribute_values:FND_API.G_EXC_ERROR Exception');
7328: END IF;
7329: ROLLBACK TO copy_uda_attribute_values_PVT;
7330: x_return_status := FND_API.G_RET_STS_ERROR;
7331: FND_MSG_PUB.Count_And_Get(
7332: p_count => x_msg_count,
7333: p_data => x_msg_data
7334: );
7335:

Line 7344: FND_MSG_PUB.Count_And_Get(

7340: 'Leaving copy_uda_attribute_values:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
7341: END IF;
7342: ROLLBACK TO copy_uda_attribute_values_PVT;
7343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7344: FND_MSG_PUB.Count_And_Get(
7345: p_count => x_msg_count,
7346: p_data => x_msg_data
7347: );
7348:

Line 7363: FND_MSG_PUB.Count_And_Get(

7359: p_token2 => G_SQLERRM_TOKEN,
7360: p_token2_value => sqlerrm);
7361: ROLLBACK TO copy_uda_attribute_values_PVT;
7362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7363: FND_MSG_PUB.Count_And_Get(
7364: p_count => x_msg_count,
7365: p_data => x_msg_data
7366: );
7367: END copy_uda_attribute_values;

Line 7430: FND_MSG_PUB.initialize;

7426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7427: END IF;
7428: -- Initialize message list if p_init_msg_list is set to TRUE.
7429: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7430: FND_MSG_PUB.initialize;
7431: END IF;
7432:
7433: -- Initialize API return status to success
7434: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7781: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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,
7785: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_uda_attribute_values');

Line 7798: FND_MSG_PUB.Count_And_Get(

7794: 'Leaving version_uda_attribute_values:FND_API.G_EXC_ERROR Exception');
7795: END IF;
7796: ROLLBACK TO version_uda_attr_values_PVT;
7797: x_return_status := FND_API.G_RET_STS_ERROR;
7798: FND_MSG_PUB.Count_And_Get(
7799: p_count => x_msg_count,
7800: p_data => x_msg_data
7801: );
7802:

Line 7811: FND_MSG_PUB.Count_And_Get(

7807: 'Leaving version_uda_attribute_values:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
7808: END IF;
7809: ROLLBACK TO version_uda_attr_values_PVT;
7810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7811: FND_MSG_PUB.Count_And_Get(
7812: p_count => x_msg_count,
7813: p_data => x_msg_data
7814: );
7815:

Line 7830: FND_MSG_PUB.Count_And_Get(

7826: p_token2 => G_SQLERRM_TOKEN,
7827: p_token2_value => sqlerrm);
7828: ROLLBACK TO version_uda_attr_values_PVT;
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7830: FND_MSG_PUB.Count_And_Get(
7831: p_count => x_msg_count,
7832: p_data => x_msg_data
7833: );
7834: