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.OKL_POOL_PVT dependencies on FND_MSG_PUB

Line 117: Fnd_Msg_Pub.initialize;

113: END IF;
114:
115: -- Initialize message list if requested
116: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
117: Fnd_Msg_Pub.initialize;
118: END IF;
119:
120: -- Initialize API status to success
121: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 187: Fnd_Msg_Pub.Count_And_Get

183:
184: /*** End API body ******************************************************/
185:
186: -- Get message count and if count is 1, get message info
187: Fnd_Msg_Pub.Count_And_Get
188: (p_count => x_msg_count,
189: p_data => x_msg_data);
190:
191: EXCEPTION

Line 195: Fnd_Msg_Pub.Count_And_Get

191: EXCEPTION
192: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
193: ROLLBACK TO update_pool_status_PVT;
194: x_return_status := Okl_Api.G_RET_STS_ERROR;
195: Fnd_Msg_Pub.Count_And_Get
196: (p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 202: Fnd_Msg_Pub.Count_And_Get

198:
199: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
200: ROLLBACK TO update_pool_status_PVT;
201: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
202: Fnd_Msg_Pub.Count_And_Get
203: (p_count => x_msg_count,
204: p_data => x_msg_data);
205:
206: WHEN OTHERS THEN

Line 215: Fnd_Msg_Pub.Count_And_Get

211: p_token1 => G_SQLCODE_TOKEN,
212: p_token1_value => SQLCODE,
213: p_token2 => G_SQLERRM_TOKEN,
214: p_token2_value => SQLERRM);
215: Fnd_Msg_Pub.Count_And_Get
216: (p_count => x_msg_count,
217: p_data => x_msg_data);
218:
219: END update_pool_status;

Line 264: Fnd_Msg_Pub.initialize;

260: END IF;
261:
262: -- Initialize message list if requested
263: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
264: Fnd_Msg_Pub.initialize;
265: END IF;
266:
267: -- Initialize API status to success
268: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 295: Fnd_Msg_Pub.Count_And_Get

291:
292: /*** End API body ******************************************************/
293:
294: -- Get message count and if count is 1, get message info
295: Fnd_Msg_Pub.Count_And_Get
296: (p_count => x_msg_count,
297: p_data => x_msg_data);
298:
299: EXCEPTION

Line 303: Fnd_Msg_Pub.Count_And_Get

299: EXCEPTION
300: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
301: ROLLBACK TO create_pool_PVT;
302: x_return_status := Okl_Api.G_RET_STS_ERROR;
303: Fnd_Msg_Pub.Count_And_Get
304: (p_count => x_msg_count,
305: p_data => x_msg_data);
306:
307: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 310: Fnd_Msg_Pub.Count_And_Get

306:
307: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
308: ROLLBACK TO create_pool_PVT;
309: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
310: Fnd_Msg_Pub.Count_And_Get
311: (p_count => x_msg_count,
312: p_data => x_msg_data);
313:
314: WHEN OTHERS THEN

Line 329: Fnd_Msg_Pub.Count_And_Get

325: p_token1 => G_SQLCODE_TOKEN,
326: p_token1_value => SQLCODE,
327: p_token2 => G_SQLERRM_TOKEN,
328: p_token2_value => SQLERRM);
329: Fnd_Msg_Pub.Count_And_Get
330: (p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: END create_pool;

Line 376: Fnd_Msg_Pub.initialize;

372: END IF;
373:
374: -- Initialize message list if requested
375: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
376: Fnd_Msg_Pub.initialize;
377: END IF;
378:
379: -- Initialize API status to success
380: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 437: Fnd_Msg_Pub.Count_And_Get

433:
434: /*** End API body ******************************************************/
435:
436: -- Get message count and if count is 1, get message info
437: Fnd_Msg_Pub.Count_And_Get
438: (p_count => x_msg_count,
439: p_data => x_msg_data);
440:
441: EXCEPTION

Line 445: Fnd_Msg_Pub.Count_And_Get

441: EXCEPTION
442: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
443: ROLLBACK TO update_pool_PVT;
444: x_return_status := Okl_Api.G_RET_STS_ERROR;
445: Fnd_Msg_Pub.Count_And_Get
446: (p_count => x_msg_count,
447: p_data => x_msg_data);
448:
449: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 452: Fnd_Msg_Pub.Count_And_Get

448:
449: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
450: ROLLBACK TO update_pool_PVT;
451: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
452: Fnd_Msg_Pub.Count_And_Get
453: (p_count => x_msg_count,
454: p_data => x_msg_data);
455:
456:

Line 469: Fnd_Msg_Pub.Count_And_Get

465: p_token1 => G_SQLCODE_TOKEN,
466: p_token1_value => SQLCODE,
467: p_token2 => G_SQLERRM_TOKEN,
468: p_token2_value => SQLERRM);
469: Fnd_Msg_Pub.Count_And_Get
470: (p_count => x_msg_count,
471: p_data => x_msg_data);
472: END update_pool;
473: ----------------------------------------------------------------------------------

Line 514: Fnd_Msg_Pub.initialize;

510: END IF;
511:
512: -- Initialize message list if requested
513: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
514: Fnd_Msg_Pub.initialize;
515: END IF;
516:
517: -- Initialize API status to success
518: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 540: Fnd_Msg_Pub.Count_And_Get

536:
537: /*** End API body ******************************************************/
538:
539: -- Get message count and if count is 1, get message info
540: Fnd_Msg_Pub.Count_And_Get
541: (p_count => x_msg_count,
542: p_data => x_msg_data);
543:
544: EXCEPTION

Line 548: Fnd_Msg_Pub.Count_And_Get

544: EXCEPTION
545: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
546: ROLLBACK TO delete_pool_PVT;
547: x_return_status := Okl_Api.G_RET_STS_ERROR;
548: Fnd_Msg_Pub.Count_And_Get
549: (p_count => x_msg_count,
550: p_data => x_msg_data);
551:
552: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 555: Fnd_Msg_Pub.Count_And_Get

551:
552: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
553: ROLLBACK TO delete_pool_PVT;
554: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
555: Fnd_Msg_Pub.Count_And_Get
556: (p_count => x_msg_count,
557: p_data => x_msg_data);
558:
559: WHEN OTHERS THEN

Line 568: Fnd_Msg_Pub.Count_And_Get

564: p_token1 => G_SQLCODE_TOKEN,
565: p_token1_value => SQLCODE,
566: p_token2 => G_SQLERRM_TOKEN,
567: p_token2_value => SQLERRM);
568: Fnd_Msg_Pub.Count_And_Get
569: (p_count => x_msg_count,
570: p_data => x_msg_data);
571: END delete_pool;
572: ----------------------------------------------------------------------------------

Line 619: Fnd_Msg_Pub.initialize;

615: END IF;
616:
617: -- Initialize message list if requested
618: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
619: Fnd_Msg_Pub.initialize;
620: END IF;
621:
622: -- Initialize API status to success
623: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 679: Fnd_Msg_Pub.Count_And_Get

675:
676: /*** End API body ******************************************************/
677:
678: -- Get message count and if count is 1, get message info
679: Fnd_Msg_Pub.Count_And_Get
680: (p_count => x_msg_count,
681: p_data => x_msg_data);
682:
683: EXCEPTION

Line 687: Fnd_Msg_Pub.Count_And_Get

683: EXCEPTION
684: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
685: ROLLBACK TO create_pool_contents_PVT;
686: x_return_status := Okl_Api.G_RET_STS_ERROR;
687: Fnd_Msg_Pub.Count_And_Get
688: (p_count => x_msg_count,
689: p_data => x_msg_data);
690:
691: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 694: Fnd_Msg_Pub.Count_And_Get

690:
691: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
692: ROLLBACK TO create_pool_contents_pvt;
693: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
694: Fnd_Msg_Pub.Count_And_Get
695: (p_count => x_msg_count,
696: p_data => x_msg_data);
697:
698: WHEN OTHERS THEN

Line 707: Fnd_Msg_Pub.Count_And_Get

703: p_token1 => G_SQLCODE_TOKEN,
704: p_token1_value => SQLCODE,
705: p_token2 => G_SQLERRM_TOKEN,
706: p_token2_value => SQLERRM);
707: Fnd_Msg_Pub.Count_And_Get
708: (p_count => x_msg_count,
709: p_data => x_msg_data);
710:
711: END create_pool_contents;

Line 756: Fnd_Msg_Pub.initialize;

752: END IF;
753:
754: -- Initialize message list if requested
755: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
756: Fnd_Msg_Pub.initialize;
757: END IF;
758:
759: -- Initialize API status to success
760: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 792: Fnd_Msg_Pub.Count_And_Get

788:
789: /*** End API body ******************************************************/
790:
791: -- Get message count and if count is 1, get message info
792: Fnd_Msg_Pub.Count_And_Get
793: (p_count => x_msg_count,
794: p_data => x_msg_data);
795:
796: EXCEPTION

Line 800: Fnd_Msg_Pub.Count_And_Get

796: EXCEPTION
797: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
798: ROLLBACK TO create_pool_contents_PVT2;
799: x_return_status := Okl_Api.G_RET_STS_ERROR;
800: Fnd_Msg_Pub.Count_And_Get
801: (p_count => x_msg_count,
802: p_data => x_msg_data);
803:
804: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 807: Fnd_Msg_Pub.Count_And_Get

803:
804: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
805: ROLLBACK TO create_pool_contents_pvt2;
806: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
807: Fnd_Msg_Pub.Count_And_Get
808: (p_count => x_msg_count,
809: p_data => x_msg_data);
810:
811: WHEN OTHERS THEN

Line 820: Fnd_Msg_Pub.Count_And_Get

816: p_token1 => G_SQLCODE_TOKEN,
817: p_token1_value => SQLCODE,
818: p_token2 => G_SQLERRM_TOKEN,
819: p_token2_value => SQLERRM);
820: Fnd_Msg_Pub.Count_And_Get
821: (p_count => x_msg_count,
822: p_data => x_msg_data);
823:
824: END create_pool_contents;

Line 876: Fnd_Msg_Pub.initialize;

872: END IF;
873:
874: -- Initialize message list if requested
875: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
876: Fnd_Msg_Pub.initialize;
877: END IF;
878:
879: -- Initialize API status to success
880: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 925: Fnd_Msg_Pub.Count_And_Get

921:
922: /*** End API body ******************************************************/
923:
924: -- Get message count and if count is 1, get message info
925: Fnd_Msg_Pub.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data);
928:
929:

Line 938: Fnd_Msg_Pub.Count_And_Get

934:
935:
936:
937: x_return_status := Okl_Api.G_RET_STS_ERROR;
938: Fnd_Msg_Pub.Count_And_Get
939: (p_count => x_msg_count,
940: p_data => x_msg_data);
941:
942: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 945: Fnd_Msg_Pub.Count_And_Get

941:
942: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
943: ROLLBACK TO update_pool_contents_pvt;
944: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
945: Fnd_Msg_Pub.Count_And_Get
946: (p_count => x_msg_count,
947: p_data => x_msg_data);
948:
949: WHEN OTHERS THEN

Line 958: Fnd_Msg_Pub.Count_And_Get

954: p_token1 => G_SQLCODE_TOKEN,
955: p_token1_value => SQLCODE,
956: p_token2 => G_SQLERRM_TOKEN,
957: p_token2_value => SQLERRM);
958: Fnd_Msg_Pub.Count_And_Get
959: (p_count => x_msg_count,
960: p_data => x_msg_data);
961:
962: END update_pool_contents;

Line 1007: Fnd_Msg_Pub.initialize;

1003: END IF;
1004:
1005: -- Initialize message list if requested
1006: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1007: Fnd_Msg_Pub.initialize;
1008: END IF;
1009:
1010: -- Initialize API status to success
1011: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1043: Fnd_Msg_Pub.Count_And_Get

1039:
1040: /*** End API body ******************************************************/
1041:
1042: -- Get message count and if count is 1, get message info
1043: Fnd_Msg_Pub.Count_And_Get
1044: (p_count => x_msg_count,
1045: p_data => x_msg_data);
1046:
1047: EXCEPTION

Line 1051: Fnd_Msg_Pub.Count_And_Get

1047: EXCEPTION
1048: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1049: ROLLBACK TO update_pool_contents_PVT2;
1050: x_return_status := Okl_Api.G_RET_STS_ERROR;
1051: Fnd_Msg_Pub.Count_And_Get
1052: (p_count => x_msg_count,
1053: p_data => x_msg_data);
1054:
1055: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1058: Fnd_Msg_Pub.Count_And_Get

1054:
1055: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1056: ROLLBACK TO update_pool_contents_pvt2;
1057: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1058: Fnd_Msg_Pub.Count_And_Get
1059: (p_count => x_msg_count,
1060: p_data => x_msg_data);
1061:
1062: WHEN OTHERS THEN

Line 1071: Fnd_Msg_Pub.Count_And_Get

1067: p_token1 => G_SQLCODE_TOKEN,
1068: p_token1_value => SQLCODE,
1069: p_token2 => G_SQLERRM_TOKEN,
1070: p_token2_value => SQLERRM);
1071: Fnd_Msg_Pub.Count_And_Get
1072: (p_count => x_msg_count,
1073: p_data => x_msg_data);
1074:
1075: END update_pool_contents;

Line 1127: Fnd_Msg_Pub.initialize;

1123: END IF;
1124:
1125: -- Initialize message list if requested
1126: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1127: Fnd_Msg_Pub.initialize;
1128: END IF;
1129:
1130: -- Initialize API status to success
1131: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1174: Fnd_Msg_Pub.Count_And_Get

1170:
1171: /*** End API body ******************************************************/
1172:
1173: -- Get message count and if count is 1, get message info
1174: Fnd_Msg_Pub.Count_And_Get
1175: (p_count => x_msg_count,
1176: p_data => x_msg_data);
1177:
1178: EXCEPTION

Line 1182: Fnd_Msg_Pub.Count_And_Get

1178: EXCEPTION
1179: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1180: ROLLBACK TO delete_pool_contents_PVT;
1181: x_return_status := Okl_Api.G_RET_STS_ERROR;
1182: Fnd_Msg_Pub.Count_And_Get
1183: (p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:
1186: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1189: Fnd_Msg_Pub.Count_And_Get

1185:
1186: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1187: ROLLBACK TO delete_pool_contents_pvt;
1188: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1189: Fnd_Msg_Pub.Count_And_Get
1190: (p_count => x_msg_count,
1191: p_data => x_msg_data);
1192:
1193: WHEN OTHERS THEN

Line 1202: Fnd_Msg_Pub.Count_And_Get

1198: p_token1 => G_SQLCODE_TOKEN,
1199: p_token1_value => SQLCODE,
1200: p_token2 => G_SQLERRM_TOKEN,
1201: p_token2_value => SQLERRM);
1202: Fnd_Msg_Pub.Count_And_Get
1203: (p_count => x_msg_count,
1204: p_data => x_msg_data);
1205:
1206: END delete_pool_contents;

Line 1253: Fnd_Msg_Pub.initialize;

1249: END IF;
1250:
1251: -- Initialize message list if requested
1252: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1253: Fnd_Msg_Pub.initialize;
1254: END IF;
1255:
1256: -- Initialize API status to success
1257: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1290: Fnd_Msg_Pub.Count_And_Get

1286:
1287: /*** End API body ******************************************************/
1288:
1289: -- Get message count and if count is 1, get message info
1290: Fnd_Msg_Pub.Count_And_Get
1291: (p_count => x_msg_count,
1292: p_data => x_msg_data);
1293:
1294: EXCEPTION

Line 1298: Fnd_Msg_Pub.Count_And_Get

1294: EXCEPTION
1295: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1296: ROLLBACK TO delete_pool_contents_PVT2;
1297: x_return_status := Okl_Api.G_RET_STS_ERROR;
1298: Fnd_Msg_Pub.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:
1302: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1305: Fnd_Msg_Pub.Count_And_Get

1301:
1302: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO delete_pool_contents_pvt2;
1304: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1305: Fnd_Msg_Pub.Count_And_Get
1306: (p_count => x_msg_count,
1307: p_data => x_msg_data);
1308:
1309: WHEN OTHERS THEN

Line 1318: Fnd_Msg_Pub.Count_And_Get

1314: p_token1 => G_SQLCODE_TOKEN,
1315: p_token1_value => SQLCODE,
1316: p_token2 => G_SQLERRM_TOKEN,
1317: p_token2_value => SQLERRM);
1318: Fnd_Msg_Pub.Count_And_Get
1319: (p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:
1322: END delete_pool_contents;

Line 1368: Fnd_Msg_Pub.initialize;

1364: END IF;
1365:
1366: -- Initialize message list if requested
1367: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1368: Fnd_Msg_Pub.initialize;
1369: END IF;
1370:
1371: -- Initialize API status to success
1372: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1395: Fnd_Msg_Pub.Count_And_Get

1391:
1392: /*** End API body ******************************************************/
1393:
1394: -- Get message count and if count is 1, get message info
1395: Fnd_Msg_Pub.Count_And_Get
1396: (p_count => x_msg_count,
1397: p_data => x_msg_data);
1398:
1399: EXCEPTION

Line 1403: Fnd_Msg_Pub.Count_And_Get

1399: EXCEPTION
1400: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1401: ROLLBACK TO create_pool_transaction_PVT;
1402: x_return_status := Okl_Api.G_RET_STS_ERROR;
1403: Fnd_Msg_Pub.Count_And_Get
1404: (p_count => x_msg_count,
1405: p_data => x_msg_data);
1406:
1407: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1410: Fnd_Msg_Pub.Count_And_Get

1406:
1407: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1408: ROLLBACK TO create_pool_transaction_pvt;
1409: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1410: Fnd_Msg_Pub.Count_And_Get
1411: (p_count => x_msg_count,
1412: p_data => x_msg_data);
1413:
1414: WHEN OTHERS THEN

Line 1423: Fnd_Msg_Pub.Count_And_Get

1419: p_token1 => G_SQLCODE_TOKEN,
1420: p_token1_value => SQLCODE,
1421: p_token2 => G_SQLERRM_TOKEN,
1422: p_token2_value => SQLERRM);
1423: Fnd_Msg_Pub.Count_And_Get
1424: (p_count => x_msg_count,
1425: p_data => x_msg_data);
1426: END create_pool_transaction;
1427:

Line 1471: Fnd_Msg_Pub.initialize;

1467: END IF;
1468:
1469: -- Initialize message list if requested
1470: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1471: Fnd_Msg_Pub.initialize;
1472: END IF;
1473:
1474: -- Initialize API status to success
1475: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1500: Fnd_Msg_Pub.Count_And_Get

1496: /*** End API body ******************************************************/
1497:
1498:
1499: -- Get message count and if count is 1, get message info
1500: Fnd_Msg_Pub.Count_And_Get
1501: (p_count => x_msg_count,
1502: p_data => x_msg_data);
1503:
1504: EXCEPTION

Line 1508: Fnd_Msg_Pub.Count_And_Get

1504: EXCEPTION
1505: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1506: ROLLBACK TO update_pool_transaction_PVT;
1507: x_return_status := Okl_Api.G_RET_STS_ERROR;
1508: Fnd_Msg_Pub.Count_And_Get
1509: (p_count => x_msg_count,
1510: p_data => x_msg_data);
1511:
1512: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1515: Fnd_Msg_Pub.Count_And_Get

1511:
1512: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1513: ROLLBACK TO update_pool_transaction_pvt;
1514: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1515: Fnd_Msg_Pub.Count_And_Get
1516: (p_count => x_msg_count,
1517: p_data => x_msg_data);
1518:
1519: WHEN OTHERS THEN

Line 1528: Fnd_Msg_Pub.Count_And_Get

1524: p_token1 => G_SQLCODE_TOKEN,
1525: p_token1_value => SQLCODE,
1526: p_token2 => G_SQLERRM_TOKEN,
1527: p_token2_value => SQLERRM);
1528: Fnd_Msg_Pub.Count_And_Get
1529: (p_count => x_msg_count,
1530: p_data => x_msg_data);
1531:
1532: END update_pool_transaction;

Line 1578: Fnd_Msg_Pub.initialize;

1574: END IF;
1575:
1576: -- Initialize message list if requested
1577: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1578: Fnd_Msg_Pub.initialize;
1579: END IF;
1580:
1581: -- Initialize API status to success
1582: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1605: Fnd_Msg_Pub.Count_And_Get

1601:
1602: /*** End API body ******************************************************/
1603:
1604: -- Get message count and if count is 1, get message info
1605: Fnd_Msg_Pub.Count_And_Get
1606: (p_count => x_msg_count,
1607: p_data => x_msg_data);
1608:
1609: EXCEPTION

Line 1613: Fnd_Msg_Pub.Count_And_Get

1609: EXCEPTION
1610: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1611: ROLLBACK TO delete_pool_transaction_PVT2;
1612: x_return_status := Okl_Api.G_RET_STS_ERROR;
1613: Fnd_Msg_Pub.Count_And_Get
1614: (p_count => x_msg_count,
1615: p_data => x_msg_data);
1616:
1617: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1620: Fnd_Msg_Pub.Count_And_Get

1616:
1617: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1618: ROLLBACK TO delete_pool_transaction_pvt2;
1619: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1620: Fnd_Msg_Pub.Count_And_Get
1621: (p_count => x_msg_count,
1622: p_data => x_msg_data);
1623:
1624: WHEN OTHERS THEN

Line 1633: Fnd_Msg_Pub.Count_And_Get

1629: p_token1 => G_SQLCODE_TOKEN,
1630: p_token1_value => SQLCODE,
1631: p_token2 => G_SQLERRM_TOKEN,
1632: p_token2_value => SQLERRM);
1633: Fnd_Msg_Pub.Count_And_Get
1634: (p_count => x_msg_count,
1635: p_data => x_msg_data);
1636:
1637: END delete_pool_transaction;

Line 1896: Fnd_Msg_Pub.initialize;

1892: END IF;
1893:
1894: -- Initialize message list if requested
1895: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1896: Fnd_Msg_Pub.initialize;
1897: END IF;
1898:
1899: -- Initialize API status to success
1900: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1910: Fnd_Msg_Pub.Count_And_Get

1906:
1907: /*** End API body ******************************************************/
1908:
1909: -- Get message count and if count is 1, get message info
1910: Fnd_Msg_Pub.Count_And_Get
1911: (p_count => x_msg_count,
1912:
1913: p_data => x_msg_data);
1914:

Line 1919: Fnd_Msg_Pub.Count_And_Get

1915: EXCEPTION
1916: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1917: ROLLBACK TO get_tot_recv_amt_pend_pvt2;
1918: x_return_status := Okl_Api.G_RET_STS_ERROR;
1919: Fnd_Msg_Pub.Count_And_Get
1920: (p_count => x_msg_count,
1921: p_data => x_msg_data);
1922:
1923: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1926: Fnd_Msg_Pub.Count_And_Get

1922:
1923: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1924: ROLLBACK TO get_tot_recv_amt_pend_pvt2;
1925: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1926: Fnd_Msg_Pub.Count_And_Get
1927: (p_count => x_msg_count,
1928: p_data => x_msg_data);
1929:
1930: WHEN OTHERS THEN

Line 1939: Fnd_Msg_Pub.Count_And_Get

1935: p_token1 => G_SQLCODE_TOKEN,
1936: p_token1_value => SQLCODE,
1937: p_token2 => G_SQLERRM_TOKEN,
1938: p_token2_value => SQLERRM);
1939: Fnd_Msg_Pub.Count_And_Get
1940: (p_count => x_msg_count,
1941: p_data => x_msg_data);
1942:
1943: END get_tot_recei_amt_pend;

Line 1992: Fnd_Msg_Pub.initialize;

1988: END IF;
1989:
1990: -- Initialize message list if requested
1991: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
1992: Fnd_Msg_Pub.initialize;
1993: END IF;
1994:
1995: -- Initialize API status to success
1996: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 2006: Fnd_Msg_Pub.Count_And_Get

2002:
2003: /*** End API body ******************************************************/
2004:
2005: -- Get message count and if count is 1, get message info
2006: Fnd_Msg_Pub.Count_And_Get
2007: (p_count => x_msg_count,
2008:
2009: p_data => x_msg_data);
2010:

Line 2015: Fnd_Msg_Pub.Count_And_Get

2011: EXCEPTION
2012: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2013: ROLLBACK TO get_tot_receivable_amt_pvt2;
2014: x_return_status := Okl_Api.G_RET_STS_ERROR;
2015: Fnd_Msg_Pub.Count_And_Get
2016: (p_count => x_msg_count,
2017: p_data => x_msg_data);
2018:
2019: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2022: Fnd_Msg_Pub.Count_And_Get

2018:
2019: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2020: ROLLBACK TO get_tot_receivable_amt_pvt2;
2021: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2022: Fnd_Msg_Pub.Count_And_Get
2023: (p_count => x_msg_count,
2024: p_data => x_msg_data);
2025:
2026: WHEN OTHERS THEN

Line 2035: Fnd_Msg_Pub.Count_And_Get

2031: p_token1 => G_SQLCODE_TOKEN,
2032: p_token1_value => SQLCODE,
2033: p_token2 => G_SQLERRM_TOKEN,
2034: p_token2_value => SQLERRM);
2035: Fnd_Msg_Pub.Count_And_Get
2036: (p_count => x_msg_count,
2037: p_data => x_msg_data);
2038:
2039: END get_tot_recei_amt;

Line 2088: Fnd_Msg_Pub.initialize;

2084: END IF;
2085:
2086: -- Initialize message list if requested
2087: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
2088: Fnd_Msg_Pub.initialize;
2089:
2090: END IF;
2091:
2092:

Line 2109: Fnd_Msg_Pub.Count_And_Get

2105:
2106: /*** End API body ******************************************************/
2107:
2108: -- Get message count and if count is 1, get message info
2109: Fnd_Msg_Pub.Count_And_Get
2110: (p_count => x_msg_count,
2111: p_data => x_msg_data);
2112:
2113: EXCEPTION

Line 2117: Fnd_Msg_Pub.Count_And_Get

2113: EXCEPTION
2114: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2115: ROLLBACK TO get_tot_receivable_amt_pvt2;
2116: x_return_status := Okl_Api.G_RET_STS_ERROR;
2117: Fnd_Msg_Pub.Count_And_Get
2118:
2119:
2120: (p_count => x_msg_count,
2121: p_data => x_msg_data);

Line 2126: Fnd_Msg_Pub.Count_And_Get

2122:
2123: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2124: ROLLBACK TO get_tot_receivable_amt_pvt2;
2125: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2126: Fnd_Msg_Pub.Count_And_Get
2127: (p_count => x_msg_count,
2128: p_data => x_msg_data);
2129:
2130: WHEN OTHERS THEN

Line 2139: Fnd_Msg_Pub.Count_And_Get

2135: p_token1 => G_SQLCODE_TOKEN,
2136: p_token1_value => SQLCODE,
2137: p_token2 => G_SQLERRM_TOKEN,
2138: p_token2_value => SQLERRM);
2139: Fnd_Msg_Pub.Count_And_Get
2140: (p_count => x_msg_count,
2141: p_data => x_msg_data);
2142:
2143: END get_tot_receivable_amt;

Line 2340: Fnd_Msg_Pub.initialize;

2336: END IF;
2337:
2338: -- Initialize message list if requested
2339: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
2340: Fnd_Msg_Pub.initialize;
2341: END IF;
2342:
2343: -- Initialize API status to success
2344: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 2380: Fnd_Msg_Pub.Count_And_Get

2376:
2377: /*** End API body ******************************************************/
2378:
2379: -- Get message count and if count is 1, get message info
2380: Fnd_Msg_Pub.Count_And_Get
2381: (p_count => x_msg_count,
2382: p_data => x_msg_data);
2383:
2384: EXCEPTION

Line 2388: Fnd_Msg_Pub.Count_And_Get

2384: EXCEPTION
2385: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2386: ROLLBACK TO recal_tot_princ_amt_pvt;
2387: x_return_status := Okl_Api.G_RET_STS_ERROR;
2388: Fnd_Msg_Pub.Count_And_Get
2389: (p_count => x_msg_count,
2390: p_data => x_msg_data);
2391:
2392: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2396: Fnd_Msg_Pub.Count_And_Get

2392: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2393: ROLLBACK TO recal_tot_princ_amt_pvt;
2394:
2395: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2396: Fnd_Msg_Pub.Count_And_Get
2397:
2398: (p_count => x_msg_count,
2399: p_data => x_msg_data);
2400:

Line 2410: Fnd_Msg_Pub.Count_And_Get

2406: p_token1 => G_SQLCODE_TOKEN,
2407: p_token1_value => SQLCODE,
2408: p_token2 => G_SQLERRM_TOKEN,
2409: p_token2_value => SQLERRM);
2410: Fnd_Msg_Pub.Count_And_Get
2411: (p_count => x_msg_count,
2412: p_data => x_msg_data);
2413: END recal_tot_princ_amt;
2414:

Line 2465: Fnd_Msg_Pub.initialize;

2461: END IF;
2462:
2463: -- Initialize message list if requested
2464: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
2465: Fnd_Msg_Pub.initialize;
2466: END IF;
2467:
2468: -- Initialize API status to success
2469: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 2508: Fnd_Msg_Pub.Count_And_Get

2504:
2505: /*** End API body ******************************************************/
2506:
2507: -- Get message count and if count is 1, get message info
2508: Fnd_Msg_Pub.Count_And_Get
2509: (p_count => x_msg_count,
2510: p_data => x_msg_data);
2511:
2512: EXCEPTION

Line 2517: Fnd_Msg_Pub.Count_And_Get

2513: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2514:
2515: ROLLBACK TO recal_tot_principal_amt_pvt;
2516: x_return_status := Okl_Api.G_RET_STS_ERROR;
2517: Fnd_Msg_Pub.Count_And_Get
2518: (p_count => x_msg_count,
2519: p_data => x_msg_data);
2520:
2521: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2524: Fnd_Msg_Pub.Count_And_Get

2520:
2521: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2522: ROLLBACK TO recal_tot_principal_amt_pvt;
2523: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2524: Fnd_Msg_Pub.Count_And_Get
2525: (p_count => x_msg_count,
2526: p_data => x_msg_data);
2527:
2528: WHEN OTHERS THEN

Line 2537: Fnd_Msg_Pub.Count_And_Get

2533: p_token1 => G_SQLCODE_TOKEN,
2534: p_token1_value => SQLCODE,
2535: p_token2 => G_SQLERRM_TOKEN,
2536: p_token2_value => SQLERRM);
2537: Fnd_Msg_Pub.Count_And_Get
2538: (p_count => x_msg_count,
2539: p_data => x_msg_data);
2540:
2541: END recal_tot_principal_amt;

Line 2868: FND_MSG_PUB.initialize;

2864: END IF;
2865:
2866: -- Initialize message list if requested
2867: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2868: FND_MSG_PUB.initialize;
2869: END IF;
2870:
2871: -- Initialize API status to success
2872: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2976: FND_MSG_PUB.Count_And_Get

2972:
2973: --/*** End API body ******************************************************
2974:
2975: -- Get message count and if count is 1, get message info
2976: FND_MSG_PUB.Count_And_Get
2977: (p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:
2980: EXCEPTION

Line 2987: FND_MSG_PUB.Count_And_Get

2983: x_row_count := 0;
2984:
2985:
2986: x_return_status := OKL_API.G_RET_STS_ERROR;
2987: FND_MSG_PUB.Count_And_Get
2988: (p_count => x_msg_count,
2989: p_data => x_msg_data);
2990:
2991: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2996: FND_MSG_PUB.Count_And_Get

2992: ROLLBACK TO add_pool_contents_pvt;
2993: x_row_count := 0;
2994:
2995: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2996: FND_MSG_PUB.Count_And_Get
2997: (p_count => x_msg_count,
2998: p_data => x_msg_data);
2999:
3000: WHEN OTHERS THEN

Line 3011: FND_MSG_PUB.Count_And_Get

3007: p_token1 => G_SQLCODE_TOKEN,
3008: p_token1_value => SQLCODE,
3009: p_token2 => G_SQLERRM_TOKEN,
3010: p_token2_value => SQLERRM);
3011: FND_MSG_PUB.Count_And_Get
3012: (p_count => x_msg_count,
3013: p_data => x_msg_data);
3014:
3015: END add_pool_contents;

Line 5109: Fnd_Msg_Pub.initialize;

5105: END IF;
5106:
5107: -- Initialize message list if requested
5108: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
5109: Fnd_Msg_Pub.initialize;
5110: END IF;
5111:
5112: -- Initialize API status to success
5113: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 5136: Fnd_Msg_Pub.Count_And_Get

5132:
5133: /*** End API body ******************************************************/
5134:
5135: -- Get message count and if count is 1, get message info
5136: Fnd_Msg_Pub.Count_And_Get
5137: (p_count => x_msg_count,
5138: p_data => x_msg_data);
5139:
5140: EXCEPTION

Line 5144: Fnd_Msg_Pub.Count_And_Get

5140: EXCEPTION
5141: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
5142: ROLLBACK TO update_pool_status_active_PVT;
5143: x_return_status := Okl_Api.G_RET_STS_ERROR;
5144: Fnd_Msg_Pub.Count_And_Get
5145: (p_count => x_msg_count,
5146: p_data => x_msg_data);
5147:
5148: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5152: Fnd_Msg_Pub.Count_And_Get

5148: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
5149:
5150: ROLLBACK TO update_pool_status_active_PVT;
5151: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
5152: Fnd_Msg_Pub.Count_And_Get
5153: (p_count => x_msg_count,
5154: p_data => x_msg_data);
5155:
5156: WHEN OTHERS THEN

Line 5165: Fnd_Msg_Pub.Count_And_Get

5161: p_token1 => G_SQLCODE_TOKEN,
5162: p_token1_value => SQLCODE,
5163: p_token2 => G_SQLERRM_TOKEN,
5164: p_token2_value => SQLERRM);
5165: Fnd_Msg_Pub.Count_And_Get
5166: (p_count => x_msg_count,
5167: p_data => x_msg_data);
5168:
5169: END update_pool_status_active;

Line 5210: Fnd_Msg_Pub.initialize;

5206: END IF;
5207:
5208: -- Initialize message list if requested
5209: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
5210: Fnd_Msg_Pub.initialize;
5211: END IF;
5212:
5213: -- Initialize API status to success
5214: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 5237: Fnd_Msg_Pub.Count_And_Get

5233:
5234: /*** End API body ******************************************************/
5235:
5236: -- Get message count and if count is 1, get message info
5237: Fnd_Msg_Pub.Count_And_Get
5238: (p_count => x_msg_count,
5239: p_data => x_msg_data);
5240:
5241: EXCEPTION

Line 5245: Fnd_Msg_Pub.Count_And_Get

5241: EXCEPTION
5242: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
5243: ROLLBACK TO update_pool_status_expired_PVT;
5244: x_return_status := Okl_Api.G_RET_STS_ERROR;
5245: Fnd_Msg_Pub.Count_And_Get
5246: (p_count => x_msg_count,
5247: p_data => x_msg_data);
5248:
5249: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5252: Fnd_Msg_Pub.Count_And_Get

5248:
5249: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
5250: ROLLBACK TO update_pool_status_expired_PVT;
5251: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
5252: Fnd_Msg_Pub.Count_And_Get
5253: (p_count => x_msg_count,
5254: p_data => x_msg_data);
5255:
5256: WHEN OTHERS THEN

Line 5266: Fnd_Msg_Pub.Count_And_Get

5262: p_token1_value => SQLCODE,
5263:
5264: p_token2 => G_SQLERRM_TOKEN,
5265: p_token2_value => SQLERRM);
5266: Fnd_Msg_Pub.Count_And_Get
5267: (p_count => x_msg_count,
5268: p_data => x_msg_data);
5269:
5270: END update_pool_status_expired;

Line 5467: Fnd_Msg_Pub.initialize;

5463: END IF;
5464:
5465: -- Initialize message list if requested
5466: IF (Fnd_Api.to_Boolean(p_init_msg_list)) THEN
5467: Fnd_Msg_Pub.initialize;
5468: END IF;
5469:
5470: --update validation for pool id when the pool is in active or new status
5471: IF l_action = 'update_pool' THEN

Line 5527: Fnd_Msg_Pub.Count_And_Get

5523:
5524: END IF; --l_action
5525:
5526: -- Get message count and if count is 1, get message info
5527: Fnd_Msg_Pub.Count_And_Get
5528: (p_count => x_msg_count,
5529: p_data => x_msg_data);
5530:
5531: EXCEPTION

Line 5534: Fnd_Msg_Pub.Count_And_Get

5530:
5531: EXCEPTION
5532: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
5533: x_return_status := Okl_Api.G_RET_STS_ERROR;
5534: Fnd_Msg_Pub.Count_And_Get
5535: (p_count => x_msg_count,
5536: p_data => x_msg_data);
5537:
5538: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5540: Fnd_Msg_Pub.Count_And_Get

5536: p_data => x_msg_data);
5537:
5538: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
5539: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
5540: Fnd_Msg_Pub.Count_And_Get
5541: (p_count => x_msg_count,
5542: p_data => x_msg_data);
5543:
5544: WHEN OTHERS THEN

Line 5553: Fnd_Msg_Pub.Count_And_Get

5549: p_token1 => G_SQLCODE_TOKEN,
5550: p_token1_value => SQLCODE,
5551: p_token2 => G_SQLERRM_TOKEN,
5552: p_token2_value => SQLERRM);
5553: Fnd_Msg_Pub.Count_And_Get
5554: (p_count => x_msg_count,
5555: p_data => x_msg_data);
5556:
5557: END validate_pool;