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 71: FND_MSG_PUB.initialize;

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list ) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: -- Initialize API return status to success
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:

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

225:
226: COMMIT WORK;
227:
228: -- Standard call to get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
230:
231: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
233: 'Leaving OKC_REP_WF_PVT.submit_contract');

Line 249: FND_MSG_PUB.Count_And_Get(

245: CLOSE contract_csr ;
246: END IF;
247: ROLLBACK TO submit_contract_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: FND_MSG_PUB.Count_And_Get(
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:

Line 266: FND_MSG_PUB.Count_And_Get(

262: CLOSE contract_csr ;
263: END IF;
264: ROLLBACK TO submit_contract_PVT;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_And_Get(
267: p_count => x_msg_count,
268: p_data => x_msg_data
269: );
270:

Line 289: FND_MSG_PUB.Count_And_Get(

285: p_token2 => G_SQLERRM_TOKEN,
286: p_token2_value => sqlerrm);
287: ROLLBACK TO submit_contract_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: FND_MSG_PUB.Count_And_Get(
290: p_count => x_msg_count,
291: p_data => x_msg_data
292: );
293:

Line 345: FND_MSG_PUB.initialize;

341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: IF FND_API.to_Boolean( p_init_msg_list ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: -- Initialize API return status to success
349: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

357: COMMIT WORK;
358: END IF;
359:
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
362:
363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
365: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');

Line 378: FND_MSG_PUB.Count_And_Get(

374: 'Leaving delete_contacts:FND_API.G_EXC_ERROR Exception');
375: END IF;
376: ROLLBACK TO delete_contacts_PVT;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get(
379: p_count => x_msg_count,
380: p_data => x_msg_data
381: );
382:

Line 391: FND_MSG_PUB.Count_And_Get(

387: 'Leaving delete_contacts:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
388: END IF;
389: ROLLBACK TO delete_contacts_PVT;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get(
392: p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395:

Line 410: FND_MSG_PUB.Count_And_Get(

406: p_token2 => G_SQLERRM_TOKEN,
407: p_token2_value => sqlerrm);
408: ROLLBACK TO delete_contacts_PVT;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: FND_MSG_PUB.Count_And_Get(
411: p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414: END delete_contacts;

Line 464: FND_MSG_PUB.initialize;

460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: -- Initialize message list if p_init_msg_list is set to TRUE.
463: IF FND_API.to_Boolean( p_init_msg_list ) THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466:
467: -- Initialize API return status to success
468: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

476: COMMIT WORK;
477: END IF;
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
481:
482: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
484: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');

Line 497: FND_MSG_PUB.Count_And_Get(

493: 'Leaving delete_parties:FND_API.G_EXC_ERROR Exception');
494: END IF;
495: ROLLBACK TO delete_parties_PVT;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MSG_PUB.Count_And_Get(
498: p_count => x_msg_count,
499: p_data => x_msg_data
500: );
501:

Line 510: FND_MSG_PUB.Count_And_Get(

506: 'Leaving delete_parties:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
507: END IF;
508: ROLLBACK TO delete_parties_PVT;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: FND_MSG_PUB.Count_And_Get(
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
514:

Line 529: FND_MSG_PUB.Count_And_Get(

525: p_token2 => G_SQLERRM_TOKEN,
526: p_token2_value => sqlerrm);
527: ROLLBACK TO delete_parties_PVT;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MSG_PUB.Count_And_Get(
530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533: END delete_parties;

Line 591: FND_MSG_PUB.initialize;

587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: END IF;
589: -- Initialize message list if p_init_msg_list is set to TRUE.
590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
591: FND_MSG_PUB.initialize;
592: END IF;
593:
594: -- Initialize API return status to success
595: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

621: COMMIT WORK;
622: END IF;
623:
624: -- Standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
626:
627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
629: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');

Line 646: FND_MSG_PUB.Count_And_Get(

642: CLOSE contract_csr ;
643: END IF;
644: ROLLBACK TO delete_risks_PVT;
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: FND_MSG_PUB.Count_And_Get(
647: p_count => x_msg_count,
648: p_data => x_msg_data
649: );
650:

Line 663: FND_MSG_PUB.Count_And_Get(

659: CLOSE contract_csr ;
660: END IF;
661: ROLLBACK TO delete_risks_PVT;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667:

Line 686: FND_MSG_PUB.Count_And_Get(

682: p_token2 => G_SQLERRM_TOKEN,
683: p_token2_value => sqlerrm);
684: ROLLBACK TO delete_risks_PVT;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get(
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );
690: END delete_risks;

Line 740: FND_MSG_PUB.initialize;

736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738: -- Initialize message list if p_init_msg_list is set to TRUE.
739: IF FND_API.to_Boolean( p_init_msg_list ) THEN
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: -- Initialize API return status to success
744: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

752: COMMIT WORK;
753: END IF;
754:
755: -- Standard call to get message count and if count is 1, get message info.
756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
757:
758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
760: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');

Line 773: FND_MSG_PUB.Count_And_Get(

769: 'Leaving delete_related_contracts:FND_API.G_EXC_ERROR Exception');
770: END IF;
771: ROLLBACK TO delete_related_contracts_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.Count_And_Get(
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777:

Line 786: FND_MSG_PUB.Count_And_Get(

782: 'Leaving delete_related_contracts:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
783: END IF;
784: ROLLBACK TO delete_related_contracts_PVT;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: FND_MSG_PUB.Count_And_Get(
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790:

Line 805: FND_MSG_PUB.Count_And_Get(

801: p_token2 => G_SQLERRM_TOKEN,
802: p_token2_value => sqlerrm);
803: ROLLBACK TO delete_related_contracts_PVT;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: FND_MSG_PUB.Count_And_Get(
806: p_count => x_msg_count,
807: p_data => x_msg_data
808: );
809: END delete_related_contracts;

Line 877: FND_MSG_PUB.initialize;

873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875: -- Initialize message list if p_init_msg_list is set to TRUE.
876: IF FND_API.to_Boolean( p_init_msg_list ) THEN
877: FND_MSG_PUB.initialize;
878: END IF;
879:
880: -- Initialize API return status to success
881: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

923: COMMIT WORK;
924: END IF;
925:
926: -- Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
928:
929: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
931: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');

Line 948: FND_MSG_PUB.Count_And_Get(

944: CLOSE acl_csr ;
945: END IF;
946: ROLLBACK TO delete_ACL_PVT;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: FND_MSG_PUB.Count_And_Get(
949: p_count => x_msg_count,
950: p_data => x_msg_data
951: );
952:

Line 964: FND_MSG_PUB.Count_And_Get(

960: CLOSE acl_csr ;
961: END IF;
962: ROLLBACK TO delete_ACL_PVT;
963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
964: FND_MSG_PUB.Count_And_Get(
965: p_count => x_msg_count,
966: p_data => x_msg_data
967: );
968:

Line 986: FND_MSG_PUB.Count_And_Get(

982: p_token2 => G_SQLERRM_TOKEN,
983: p_token2_value => sqlerrm);
984: ROLLBACK TO delete_ACL_PVT;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986: FND_MSG_PUB.Count_And_Get(
987: p_count => x_msg_count,
988: p_data => x_msg_data
989: );
990: END delete_ACL;

Line 1046: FND_MSG_PUB.initialize;

1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044: -- Initialize message list if p_init_msg_list is set to TRUE.
1045: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049: -- Initialize API return status to success
1050: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1059: COMMIT WORK;
1060: END IF;
1061:
1062: -- Standard call to get message count and if count is 1, get message info.
1063: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1064:
1065: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1067: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');

Line 1080: FND_MSG_PUB.Count_And_Get(

1076: 'Leaving delete_status_history:FND_API.G_EXC_ERROR Exception');
1077: END IF;
1078: ROLLBACK TO delete_status_history_PVT;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: FND_MSG_PUB.Count_And_Get(
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1084:

Line 1093: FND_MSG_PUB.Count_And_Get(

1089: 'Leaving delete_status_history:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1090: END IF;
1091: ROLLBACK TO delete_status_history_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 1112: FND_MSG_PUB.Count_And_Get(

1108: p_token2 => G_SQLERRM_TOKEN,
1109: p_token2_value => sqlerrm);
1110: ROLLBACK TO delete_status_history_PVT;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: FND_MSG_PUB.Count_And_Get(
1113: p_count => x_msg_count,
1114: p_data => x_msg_data
1115: );
1116: END delete_status_history;

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_approval_history');

Line 1209: FND_MSG_PUB.Count_And_Get(

1205: 'Leaving delete_approval_history:FND_API.G_EXC_ERROR Exception');
1206: END IF;
1207: ROLLBACK TO delete_approval_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_approval_history:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1219: END IF;
1220: ROLLBACK TO delete_approval_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_approval_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_approval_history;

Line 1298: FND_MSG_PUB.initialize;

1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296: -- Initialize message list if p_init_msg_list is set to TRUE.
1297: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1298: FND_MSG_PUB.initialize;
1299: END IF;
1300:
1301: -- Initialize API return status to success
1302: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1314: COMMIT WORK;
1315: END IF;
1316:
1317: -- Standard call to get message count and if count is 1, get message info.
1318: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1319:
1320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1322: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');

Line 1335: FND_MSG_PUB.Count_And_Get(

1331: 'Leaving delete_bookmarks:FND_API.G_EXC_ERROR Exception');
1332: END IF;
1333: ROLLBACK TO delete_bookmarks_PVT;
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: FND_MSG_PUB.Count_And_Get(
1336: p_count => x_msg_count,
1337: p_data => x_msg_data
1338: );
1339:

Line 1348: FND_MSG_PUB.Count_And_Get(

1344: 'Leaving delete_bookmarks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1345: END IF;
1346: ROLLBACK TO delete_bookmarks_PVT;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: FND_MSG_PUB.Count_And_Get(
1349: p_count => x_msg_count,
1350: p_data => x_msg_data
1351: );
1352:

Line 1367: FND_MSG_PUB.Count_And_Get(

1363: p_token2 => G_SQLERRM_TOKEN,
1364: p_token2_value => sqlerrm);
1365: ROLLBACK TO delete_bookmarks_PVT;
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: FND_MSG_PUB.Count_And_Get(
1368: p_count => x_msg_count,
1369: p_data => x_msg_data
1370: );
1371: END delete_bookmarks;

Line 1644: FND_MSG_PUB.initialize;

1640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1641: END IF;
1642: -- Initialize message list if p_init_msg_list is set to TRUE.
1643: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1644: FND_MSG_PUB.initialize;
1645: END IF;
1646:
1647: -- Initialize API return status to success
1648: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2237: END IF;
2238:
2239: CLOSE contract_csr;
2240: -- Standard call to get message count and if count is 1, get message info.
2241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2242:
2243: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2244: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2245: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');

Line 2262: FND_MSG_PUB.Count_And_Get(

2258: CLOSE contract_csr ;
2259: END IF;
2260: ROLLBACK TO delete_contract_PVT;
2261: x_return_status := FND_API.G_RET_STS_ERROR;
2262: FND_MSG_PUB.Count_And_Get(
2263: p_count => x_msg_count,
2264: p_data => x_msg_data
2265: );
2266:

Line 2279: FND_MSG_PUB.Count_And_Get(

2275: CLOSE contract_csr ;
2276: END IF;
2277: ROLLBACK TO delete_contract_PVT;
2278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2279: FND_MSG_PUB.Count_And_Get(
2280: p_count => x_msg_count,
2281: p_data => x_msg_data
2282: );
2283:

Line 2302: FND_MSG_PUB.Count_And_Get(

2298: IF (contract_csr%ISOPEN) THEN
2299: CLOSE contract_csr ;
2300: END IF;
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2302: FND_MSG_PUB.Count_And_Get(
2303: p_count => x_msg_count,
2304: p_data => x_msg_data
2305: );
2306: END delete_contract;

Line 2372: FND_MSG_PUB.initialize;

2368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2369: END IF;
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2372: FND_MSG_PUB.initialize;
2373: END IF;
2374:
2375: -- Initialize API return status to success
2376: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2424: COMMIT WORK;
2425: END IF;
2426:
2427: -- Standard call to get message count and if count is 1, get message info.
2428: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2429:
2430: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2431: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2432: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');

Line 2445: FND_MSG_PUB.Count_And_Get(

2441: 'Leaving copy_contacts:FND_API.G_EXC_ERROR Exception');
2442: END IF;
2443: ROLLBACK TO copy_contacts_PVT;
2444: x_return_status := FND_API.G_RET_STS_ERROR;
2445: FND_MSG_PUB.Count_And_Get(
2446: p_count => x_msg_count,
2447: p_data => x_msg_data
2448: );
2449:

Line 2458: FND_MSG_PUB.Count_And_Get(

2454: 'Leaving copy_contacts:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2455: END IF;
2456: ROLLBACK TO copy_contacts_PVT;
2457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2458: FND_MSG_PUB.Count_And_Get(
2459: p_count => x_msg_count,
2460: p_data => x_msg_data
2461: );
2462:

Line 2477: FND_MSG_PUB.Count_And_Get(

2473: p_token2 => G_SQLERRM_TOKEN,
2474: p_token2_value => sqlerrm);
2475: ROLLBACK TO copy_contacts_PVT;
2476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2477: FND_MSG_PUB.Count_And_Get(
2478: p_count => x_msg_count,
2479: p_data => x_msg_data
2480: );
2481: END copy_contacts;

Line 2547: FND_MSG_PUB.initialize;

2543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2544: END IF;
2545: -- Initialize message list if p_init_msg_list is set to TRUE.
2546: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2547: FND_MSG_PUB.initialize;
2548: END IF;
2549:
2550: -- Initialize API return status to success
2551: 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_parties');

Line 2615: FND_MSG_PUB.Count_And_Get(

2611: 'Leaving copy_parties:FND_API.G_EXC_ERROR Exception');
2612: END IF;
2613: ROLLBACK TO copy_parties_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_parties:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2625: END IF;
2626: ROLLBACK TO copy_parties_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_parties_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_parties;

Line 2728: FND_MSG_PUB.initialize;

2724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: END IF;
2726: -- Initialize message list if p_init_msg_list is set to TRUE.
2727: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2728: FND_MSG_PUB.initialize;
2729: END IF;
2730:
2731: -- Initialize API return status to success
2732: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2821: COMMIT WORK;
2822: END IF;
2823:
2824: -- Standard call to get message count and if count is 1, get message info.
2825: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2826:
2827: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2829: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');

Line 2846: FND_MSG_PUB.Count_And_Get(

2842: CLOSE contract_csr ;
2843: END IF;
2844: ROLLBACK TO copy_risks_PVT;
2845: x_return_status := FND_API.G_RET_STS_ERROR;
2846: FND_MSG_PUB.Count_And_Get(
2847: p_count => x_msg_count,
2848: p_data => x_msg_data
2849: );
2850:

Line 2863: FND_MSG_PUB.Count_And_Get(

2859: CLOSE contract_csr ;
2860: END IF;
2861: ROLLBACK TO copy_risks_PVT;
2862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2863: FND_MSG_PUB.Count_And_Get(
2864: p_count => x_msg_count,
2865: p_data => x_msg_data
2866: );
2867:

Line 2886: FND_MSG_PUB.Count_And_Get(

2882: p_token2 => G_SQLERRM_TOKEN,
2883: p_token2_value => sqlerrm);
2884: ROLLBACK TO copy_risks_PVT;
2885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2886: FND_MSG_PUB.Count_And_Get(
2887: p_count => x_msg_count,
2888: p_data => x_msg_data
2889: );
2890: END copy_risks;

Line 2968: FND_MSG_PUB.initialize;

2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2965: END IF;
2966: -- Initialize message list if p_init_msg_list is set to TRUE.
2967: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2968: FND_MSG_PUB.initialize;
2969: END IF;
2970:
2971: -- Initialize API return status to success
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3021: COMMIT WORK;
3022: END IF;
3023:
3024: -- Standard call to get message count and if count is 1, get message info.
3025: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3026:
3027: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3028: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3029: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');

Line 3042: FND_MSG_PUB.Count_And_Get(

3038: 'Leaving copy_ACL:FND_API.G_EXC_ERROR Exception');
3039: END IF;
3040: ROLLBACK TO copy_ACL_PVT;
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042: FND_MSG_PUB.Count_And_Get(
3043: p_count => x_msg_count,
3044: p_data => x_msg_data
3045: );
3046:

Line 3055: FND_MSG_PUB.Count_And_Get(

3051: 'Leaving copy_ACL:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3052: END IF;
3053: ROLLBACK TO copy_ACL_PVT;
3054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3055: FND_MSG_PUB.Count_And_Get(
3056: p_count => x_msg_count,
3057: p_data => x_msg_data
3058: );
3059:

Line 3074: FND_MSG_PUB.Count_And_Get(

3070: p_token2 => G_SQLERRM_TOKEN,
3071: p_token2_value => sqlerrm);
3072: ROLLBACK TO copy_ACL_PVT;
3073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3074: FND_MSG_PUB.Count_And_Get(
3075: p_count => x_msg_count,
3076: p_data => x_msg_data
3077: );
3078: END copy_ACL;

Line 3166: FND_MSG_PUB.initialize;

3162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3163: END IF;
3164: -- Initialize message list if p_init_msg_list is set to TRUE.
3165: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3166: FND_MSG_PUB.initialize;
3167: END IF;
3168:
3169: -- Initialize API return status to success
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3409: COMMIT WORK;
3410: END IF;
3411:
3412: -- Standard call to get message count and if count is 1, get message info.
3413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3414:
3415: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3416: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3417: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');

Line 3437: FND_MSG_PUB.Count_And_Get(

3433: CLOSE party_csr ;
3434: END IF;
3435: ROLLBACK TO copy_contract_details_PVT;
3436: x_return_status := FND_API.G_RET_STS_ERROR;
3437: FND_MSG_PUB.Count_And_Get(
3438: p_count => x_msg_count,
3439: p_data => x_msg_data
3440: );
3441:

Line 3457: FND_MSG_PUB.Count_And_Get(

3453: CLOSE party_csr ;
3454: END IF;
3455: ROLLBACK TO copy_contract_details_PVT;
3456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3457: FND_MSG_PUB.Count_And_Get(
3458: p_count => x_msg_count,
3459: p_data => x_msg_data
3460: );
3461:

Line 3483: FND_MSG_PUB.Count_And_Get(

3479: IF (party_csr%ISOPEN) THEN
3480: CLOSE party_csr ;
3481: END IF;
3482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3483: FND_MSG_PUB.Count_And_Get(
3484: p_count => x_msg_count,
3485: p_data => x_msg_data
3486: );
3487: END copy_contract_details;

Line 3556: FND_MSG_PUB.initialize;

3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: END IF;
3554: -- Initialize message list if p_init_msg_list is set to TRUE.
3555: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3556: FND_MSG_PUB.initialize;
3557: END IF;
3558:
3559: -- Initialize API return status to success
3560: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3905: COMMIT WORK;
3906: END IF;
3907:
3908: -- Standard call to get message count and if count is 1, get message info.
3909: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3910:
3911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3913: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');

Line 3930: FND_MSG_PUB.Count_And_Get(

3926: CLOSE contract_csr ;
3927: END IF;
3928: ROLLBACK TO version_contract_details_PVT;
3929: x_return_status := FND_API.G_RET_STS_ERROR;
3930: FND_MSG_PUB.Count_And_Get(
3931: p_count => x_msg_count,
3932: p_data => x_msg_data
3933: );
3934:

Line 3947: FND_MSG_PUB.Count_And_Get(

3943: CLOSE contract_csr ;
3944: END IF;
3945: ROLLBACK TO version_contract_details_PVT;
3946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3947: FND_MSG_PUB.Count_And_Get(
3948: p_count => x_msg_count,
3949: p_data => x_msg_data
3950: );
3951:

Line 3970: FND_MSG_PUB.Count_And_Get(

3966: IF (contract_csr%ISOPEN) THEN
3967: CLOSE contract_csr ;
3968: END IF;
3969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3970: FND_MSG_PUB.Count_And_Get(
3971: p_count => x_msg_count,
3972: p_data => x_msg_data
3973: );
3974: END version_contract_details;

Line 4051: FND_MSG_PUB.initialize;

4047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4048: END IF;
4049: -- Initialize message list if p_init_msg_list is set to TRUE.
4050: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4051: FND_MSG_PUB.initialize;
4052: END IF;
4053:
4054: -- Initialize API return status to success
4055: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4322: COMMIT WORK;
4323: END IF;
4324:
4325: -- Standard call to get message count and if count is 1, get message info.
4326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4327:
4328: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4330: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

Line 4350: FND_MSG_PUB.Count_And_Get(

4346: CLOSE arch_contract_csr ;
4347: END IF;
4348: ROLLBACK TO sign_contract_PVT;
4349: x_return_status := FND_API.G_RET_STS_ERROR;
4350: FND_MSG_PUB.Count_And_Get(
4351: p_count => x_msg_count,
4352: p_data => x_msg_data
4353: );
4354:

Line 4370: FND_MSG_PUB.Count_And_Get(

4366: CLOSE arch_contract_csr ;
4367: END IF;
4368: ROLLBACK TO sign_contract_PVT;
4369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4370: FND_MSG_PUB.Count_And_Get(
4371: p_count => x_msg_count,
4372: p_data => x_msg_data
4373: );
4374:

Line 4396: FND_MSG_PUB.Count_And_Get(

4392: IF (arch_contract_csr%ISOPEN) THEN
4393: CLOSE arch_contract_csr ;
4394: END IF;
4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4396: FND_MSG_PUB.Count_And_Get(
4397: p_count => x_msg_count,
4398: p_data => x_msg_data
4399: );
4400: END sign_contract;

Line 4469: FND_MSG_PUB.initialize;

4465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4466: END IF;
4467: -- Initialize message list if p_init_msg_list is set to TRUE.
4468: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4469: FND_MSG_PUB.initialize;
4470: END IF;
4471:
4472: -- Initialize API return status to success
4473: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4625: COMMIT WORK;
4626: END IF;
4627:
4628: -- Standard call to get message count and if count is 1, get message info.
4629: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4630:
4631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4632: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4633: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');

Line 4650: FND_MSG_PUB.Count_And_Get(

4646: CLOSE contract_csr ;
4647: END IF;
4648: ROLLBACK TO terminate_contract_PVT;
4649: x_return_status := FND_API.G_RET_STS_ERROR;
4650: FND_MSG_PUB.Count_And_Get(
4651: p_count => x_msg_count,
4652: p_data => x_msg_data
4653: );
4654:

Line 4667: FND_MSG_PUB.Count_And_Get(

4663: CLOSE contract_csr ;
4664: END IF;
4665: ROLLBACK TO terminate_contract_PVT;
4666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4667: FND_MSG_PUB.Count_And_Get(
4668: p_count => x_msg_count,
4669: p_data => x_msg_data
4670: );
4671:

Line 4690: FND_MSG_PUB.Count_And_Get(

4686: IF (contract_csr%ISOPEN) THEN
4687: CLOSE contract_csr;
4688: END IF;
4689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4690: FND_MSG_PUB.Count_And_Get(
4691: p_count => x_msg_count,
4692: p_data => x_msg_data
4693: );
4694: END terminate_contract;

Line 4819: FND_MSG_PUB.initialize;

4815: END IF;
4816:
4817: -- Initialize message list if p_init_msg_list is set to TRUE.
4818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4819: FND_MSG_PUB.initialize;
4820: END IF;
4821:
4822: FOR contract_contacts_rec in CONTRACT_CONTACTS(p_contract_id) LOOP
4823:

Line 5049: FND_MSG_PUB.Count_And_Get(

5045:
5046: END IF;
5047:
5048: -- Standard call to get message count and if count is 1, get message info.
5049: FND_MSG_PUB.Count_And_Get(
5050: p_count => x_msg_count,
5051: p_data => x_msg_data );
5052:
5053: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5079: FND_MSG_PUB.Count_And_Get(

5075: END IF;
5076: ROLLBACK TO repository_notifier_pvt;
5077:
5078: x_return_status := FND_API.G_RET_STS_ERROR;
5079: FND_MSG_PUB.Count_And_Get(
5080: p_count => x_msg_count,
5081: p_data => x_msg_data
5082: );
5083:

Line 5101: FND_MSG_PUB.Count_And_Get(

5097: END IF;
5098: ROLLBACK TO repository_notifier_pvt;
5099:
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101: FND_MSG_PUB.Count_And_Get(
5102: p_count => x_msg_count,
5103: p_data => x_msg_data
5104: );
5105:

Line 5131: FND_MSG_PUB.Count_And_Get(

5127: END IF;
5128: ROLLBACK TO repository_notifier_pvt;
5129:
5130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5131: FND_MSG_PUB.Count_And_Get(
5132: p_count => x_msg_count,
5133: p_data => x_msg_data
5134: );
5135:

Line 5200: FND_MSG_PUB.initialize;

5196: END IF;
5197:
5198: -- Initialize message list if p_init_msg_list is set to TRUE.
5199: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5200: FND_MSG_PUB.initialize;
5201: END IF;
5202:
5203: -- Initialize API return status to success
5204: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5314:
5315: COMMIT WORK;
5316:
5317: -- Standard call to get message count and if count is 1, get message info.
5318: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5319:
5320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5322: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');

Line 5338: FND_MSG_PUB.Count_And_Get(

5334: CLOSE contract_csr ;
5335: END IF;
5336: ROLLBACK TO submit_contract_PVT;
5337: x_return_status := FND_API.G_RET_STS_ERROR;
5338: FND_MSG_PUB.Count_And_Get(
5339: p_count => x_msg_count,
5340: p_data => x_msg_data
5341: );
5342:

Line 5355: FND_MSG_PUB.Count_And_Get(

5351: CLOSE contract_csr ;
5352: END IF;
5353: ROLLBACK TO submit_contract_PVT;
5354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5355: FND_MSG_PUB.Count_And_Get(
5356: p_count => x_msg_count,
5357: p_data => x_msg_data
5358: );
5359:

Line 5378: FND_MSG_PUB.Count_And_Get(

5374: p_token2 => G_SQLERRM_TOKEN,
5375: p_token2_value => sqlerrm);
5376: ROLLBACK TO submit_contract_PVT;
5377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5378: FND_MSG_PUB.Count_And_Get(
5379: p_count => x_msg_count,
5380: p_data => x_msg_data
5381: );
5382:

Line 5484: FND_MSG_PUB.initialize;

5480: END IF;
5481:
5482: -- Initialize message list if p_init_msg_list is set to TRUE.
5483: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5484: FND_MSG_PUB.initialize;
5485: END IF;
5486:
5487: -- Initialize API return status to success
5488: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5581: END IF;
5582:
5583:
5584: -- Standard call to get message count and if count is 1, get message info.
5585: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5586:
5587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5588: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5589: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');

Line 5610: FND_MSG_PUB.Count_And_Get(

5606: END IF;
5607:
5608: ROLLBACK TO submit_contract_PVT;
5609: x_return_status := FND_API.G_RET_STS_ERROR;
5610: FND_MSG_PUB.Count_And_Get(
5611: p_count => x_msg_count,
5612: p_data => x_msg_data
5613: );
5614:

Line 5632: FND_MSG_PUB.Count_And_Get(

5628: END IF;
5629:
5630: ROLLBACK TO submit_contract_PVT;
5631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5632: FND_MSG_PUB.Count_And_Get(
5633: p_count => x_msg_count,
5634: p_data => x_msg_data
5635: );
5636:

Line 5660: FND_MSG_PUB.Count_And_Get(

5656: p_token2 => G_SQLERRM_TOKEN,
5657: p_token2_value => sqlerrm);
5658: ROLLBACK TO submit_contract_PVT;
5659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5660: FND_MSG_PUB.Count_And_Get(
5661: p_count => x_msg_count,
5662: p_data => x_msg_data
5663: );
5664: