1031:
1032: EXCEPTION
1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1034: -- print the error message in the output file
1035: IF (fnd_msg_pub.count_msg > 0) THEN
1036: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1037: LOOP
1038: fnd_msg_pub.get(
1039: p_msg_index => l_counter,
1032: EXCEPTION
1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1034: -- print the error message in the output file
1035: IF (fnd_msg_pub.count_msg > 0) THEN
1036: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1037: LOOP
1038: fnd_msg_pub.get(
1039: p_msg_index => l_counter,
1040: p_encoded => 'F',
1034: -- print the error message in the output file
1035: IF (fnd_msg_pub.count_msg > 0) THEN
1036: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1037: LOOP
1038: fnd_msg_pub.get(
1039: p_msg_index => l_counter,
1040: p_encoded => 'F',
1041: p_data => l_data,
1042: p_msg_index_out => l_msg_index_out);
1046: x_req_status := 'E';
1047:
1048: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1049: -- print the error message in the output file
1050: IF (fnd_msg_pub.count_msg > 0) THEN
1051: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1052: LOOP
1053: fnd_msg_pub.get(
1054: p_msg_index => l_counter,
1047:
1048: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1049: -- print the error message in the output file
1050: IF (fnd_msg_pub.count_msg > 0) THEN
1051: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1052: LOOP
1053: fnd_msg_pub.get(
1054: p_msg_index => l_counter,
1055: p_encoded => 'F',
1049: -- print the error message in the output file
1050: IF (fnd_msg_pub.count_msg > 0) THEN
1051: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1052: LOOP
1053: fnd_msg_pub.get(
1054: p_msg_index => l_counter,
1055: p_encoded => 'F',
1056: p_data => l_data,
1057: p_msg_index_out => l_msg_index_out);
1061: x_req_status := 'E';
1062:
1063: WHEN OTHERS THEN
1064: -- print the error message in the output file
1065: IF (fnd_msg_pub.count_msg > 0) THEN
1066: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1067: LOOP
1068: fnd_msg_pub.get(
1069: p_msg_index => l_counter,
1062:
1063: WHEN OTHERS THEN
1064: -- print the error message in the output file
1065: IF (fnd_msg_pub.count_msg > 0) THEN
1066: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1067: LOOP
1068: fnd_msg_pub.get(
1069: p_msg_index => l_counter,
1070: p_encoded => 'F',
1064: -- print the error message in the output file
1065: IF (fnd_msg_pub.count_msg > 0) THEN
1066: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1067: LOOP
1068: fnd_msg_pub.get(
1069: p_msg_index => l_counter,
1070: p_encoded => 'F',
1071: p_data => l_data,
1072: p_msg_index_out => l_msg_index_out);
1390: x_msg_data => l_msg_data,
1391: p_api_type => g_api_type);*/
1392:
1393: -- print the error message in the output file
1394: IF (fnd_msg_pub.count_msg > 0) THEN
1395: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1396: LOOP
1397: fnd_msg_pub.get(
1398: p_msg_index => l_counter,
1391: p_api_type => g_api_type);*/
1392:
1393: -- print the error message in the output file
1394: IF (fnd_msg_pub.count_msg > 0) THEN
1395: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1396: LOOP
1397: fnd_msg_pub.get(
1398: p_msg_index => l_counter,
1399: p_encoded => 'F',
1393: -- print the error message in the output file
1394: IF (fnd_msg_pub.count_msg > 0) THEN
1395: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1396: LOOP
1397: fnd_msg_pub.get(
1398: p_msg_index => l_counter,
1399: p_encoded => 'F',
1400: p_data => l_data,
1401: p_msg_index_out => l_msg_index_out);
1422: x_msg_data => l_msg_data,
1423: p_api_type => g_api_type);*/
1424:
1425: -- print the error message in the output file
1426: IF (fnd_msg_pub.count_msg > 0) THEN
1427: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1428: LOOP
1429: fnd_msg_pub.get(
1430: p_msg_index => l_counter,
1423: p_api_type => g_api_type);*/
1424:
1425: -- print the error message in the output file
1426: IF (fnd_msg_pub.count_msg > 0) THEN
1427: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1428: LOOP
1429: fnd_msg_pub.get(
1430: p_msg_index => l_counter,
1431: p_encoded => 'F',
1425: -- print the error message in the output file
1426: IF (fnd_msg_pub.count_msg > 0) THEN
1427: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1428: LOOP
1429: fnd_msg_pub.get(
1430: p_msg_index => l_counter,
1431: p_encoded => 'F',
1432: p_data => l_data,
1433: p_msg_index_out => l_msg_index_out);
1455: x_msg_data => l_msg_data,
1456: p_api_type => g_api_type);*/
1457:
1458: -- print the error message in the output file
1459: IF (fnd_msg_pub.count_msg > 0) THEN
1460: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1461: LOOP
1462: fnd_msg_pub.get(
1463: p_msg_index => l_counter,
1456: p_api_type => g_api_type);*/
1457:
1458: -- print the error message in the output file
1459: IF (fnd_msg_pub.count_msg > 0) THEN
1460: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1461: LOOP
1462: fnd_msg_pub.get(
1463: p_msg_index => l_counter,
1464: p_encoded => 'F',
1458: -- print the error message in the output file
1459: IF (fnd_msg_pub.count_msg > 0) THEN
1460: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1461: LOOP
1462: fnd_msg_pub.get(
1463: p_msg_index => l_counter,
1464: p_encoded => 'F',
1465: p_data => l_data,
1466: p_msg_index_out => l_msg_index_out);
1627: CLOSE book_ctrl_trx_csr;
1628: END IF;
1629:
1630: -- print the error message in the output file
1631: IF (fnd_msg_pub.count_msg > 0) THEN
1632: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1633: LOOP
1634: fnd_msg_pub.get(
1635: p_msg_index => l_counter,
1628: END IF;
1629:
1630: -- print the error message in the output file
1631: IF (fnd_msg_pub.count_msg > 0) THEN
1632: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1633: LOOP
1634: fnd_msg_pub.get(
1635: p_msg_index => l_counter,
1636: p_encoded => 'F',
1630: -- print the error message in the output file
1631: IF (fnd_msg_pub.count_msg > 0) THEN
1632: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1633: LOOP
1634: fnd_msg_pub.get(
1635: p_msg_index => l_counter,
1636: p_encoded => 'F',
1637: p_data => l_data,
1638: p_msg_index_out => l_msg_index_out);
1860: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1862:
1863: --print the error message in the output file
1864: IF (fnd_msg_pub.count_msg > 0) THEN
1865: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1866: LOOP
1867: fnd_msg_pub.get(
1868: p_msg_index => l_counter,
1861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1862:
1863: --print the error message in the output file
1864: IF (fnd_msg_pub.count_msg > 0) THEN
1865: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1866: LOOP
1867: fnd_msg_pub.get(
1868: p_msg_index => l_counter,
1869: p_encoded => 'F',
1863: --print the error message in the output file
1864: IF (fnd_msg_pub.count_msg > 0) THEN
1865: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1866: LOOP
1867: fnd_msg_pub.get(
1868: p_msg_index => l_counter,
1869: p_encoded => 'F',
1870: p_data => l_data,
1871: p_msg_index_out => l_msg_index_out);
1900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1902:
1903: -- print the error message in the output file
1904: IF (fnd_msg_pub.count_msg > 0) THEN
1905: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1906: LOOP
1907: fnd_msg_pub.get(
1908: p_msg_index => l_counter,
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1902:
1903: -- print the error message in the output file
1904: IF (fnd_msg_pub.count_msg > 0) THEN
1905: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1906: LOOP
1907: fnd_msg_pub.get(
1908: p_msg_index => l_counter,
1909: p_encoded => 'F',
1903: -- print the error message in the output file
1904: IF (fnd_msg_pub.count_msg > 0) THEN
1905: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1906: LOOP
1907: fnd_msg_pub.get(
1908: p_msg_index => l_counter,
1909: p_encoded => 'F',
1910: p_data => l_data,
1911: p_msg_index_out => l_msg_index_out);
1941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1943:
1944: -- print the error message in the output file
1945: IF (fnd_msg_pub.count_msg > 0) THEN
1946: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1947: LOOP
1948: fnd_msg_pub.get(
1949: p_msg_index => l_counter,
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
1943:
1944: -- print the error message in the output file
1945: IF (fnd_msg_pub.count_msg > 0) THEN
1946: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1947: LOOP
1948: fnd_msg_pub.get(
1949: p_msg_index => l_counter,
1950: p_encoded => 'F',
1944: -- print the error message in the output file
1945: IF (fnd_msg_pub.count_msg > 0) THEN
1946: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
1947: LOOP
1948: fnd_msg_pub.get(
1949: p_msg_index => l_counter,
1950: p_encoded => 'F',
1951: p_data => l_data,
1952: p_msg_index_out => l_msg_index_out);
2182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2183: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2184:
2185: -- print the error message in the output file
2186: IF (fnd_msg_pub.count_msg > 0) THEN
2187: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2188: LOOP
2189: fnd_msg_pub.get(
2190: p_msg_index => l_counter,
2183: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2184:
2185: -- print the error message in the output file
2186: IF (fnd_msg_pub.count_msg > 0) THEN
2187: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2188: LOOP
2189: fnd_msg_pub.get(
2190: p_msg_index => l_counter,
2191: p_encoded => 'F',
2185: -- print the error message in the output file
2186: IF (fnd_msg_pub.count_msg > 0) THEN
2187: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2188: LOOP
2189: fnd_msg_pub.get(
2190: p_msg_index => l_counter,
2191: p_encoded => 'F',
2192: p_data => l_data,
2193: p_msg_index_out => l_msg_index_out);
2225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2227:
2228: -- print the error message in the output file
2229: IF (fnd_msg_pub.count_msg > 0) THEN
2230: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2231: LOOP
2232: fnd_msg_pub.get(
2233: p_msg_index => l_counter,
2226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2227:
2228: -- print the error message in the output file
2229: IF (fnd_msg_pub.count_msg > 0) THEN
2230: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2231: LOOP
2232: fnd_msg_pub.get(
2233: p_msg_index => l_counter,
2234: p_encoded => 'F',
2228: -- print the error message in the output file
2229: IF (fnd_msg_pub.count_msg > 0) THEN
2230: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2231: LOOP
2232: fnd_msg_pub.get(
2233: p_msg_index => l_counter,
2234: p_encoded => 'F',
2235: p_data => l_data,
2236: p_msg_index_out => l_msg_index_out);
2269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2271:
2272: -- print the error message in the output file
2273: IF (fnd_msg_pub.count_msg > 0) THEN
2274: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2275: LOOP
2276: fnd_msg_pub.get(
2277: p_msg_index => l_counter,
2270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2271:
2272: -- print the error message in the output file
2273: IF (fnd_msg_pub.count_msg > 0) THEN
2274: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2275: LOOP
2276: fnd_msg_pub.get(
2277: p_msg_index => l_counter,
2278: p_encoded => 'F',
2272: -- print the error message in the output file
2273: IF (fnd_msg_pub.count_msg > 0) THEN
2274: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2275: LOOP
2276: fnd_msg_pub.get(
2277: p_msg_index => l_counter,
2278: p_encoded => 'F',
2279: p_data => l_data,
2280: p_msg_index_out => l_msg_index_out);
2450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2452:
2453: -- print the error message in the output file
2454: IF (fnd_msg_pub.count_msg > 0) THEN
2455: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2456: LOOP
2457: fnd_msg_pub.get(
2458: p_msg_index => l_counter,
2451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2452:
2453: -- print the error message in the output file
2454: IF (fnd_msg_pub.count_msg > 0) THEN
2455: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2456: LOOP
2457: fnd_msg_pub.get(
2458: p_msg_index => l_counter,
2459: p_encoded => 'F',
2453: -- print the error message in the output file
2454: IF (fnd_msg_pub.count_msg > 0) THEN
2455: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2456: LOOP
2457: fnd_msg_pub.get(
2458: p_msg_index => l_counter,
2459: p_encoded => 'F',
2460: p_data => l_data,
2461: p_msg_index_out => l_msg_index_out);
2487: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2489:
2490: -- print the error message in the output file
2491: IF (fnd_msg_pub.count_msg > 0) THEN
2492: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2493: LOOP
2494: fnd_msg_pub.get(
2495: p_msg_index => l_counter,
2488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2489:
2490: -- print the error message in the output file
2491: IF (fnd_msg_pub.count_msg > 0) THEN
2492: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2493: LOOP
2494: fnd_msg_pub.get(
2495: p_msg_index => l_counter,
2496: p_encoded => 'F',
2490: -- print the error message in the output file
2491: IF (fnd_msg_pub.count_msg > 0) THEN
2492: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2493: LOOP
2494: fnd_msg_pub.get(
2495: p_msg_index => l_counter,
2496: p_encoded => 'F',
2497: p_data => l_data,
2498: p_msg_index_out => l_msg_index_out);
2525: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2526: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2527:
2528: -- print the error message in the output file
2529: IF (fnd_msg_pub.count_msg > 0) THEN
2530: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2531: LOOP
2532: fnd_msg_pub.get(
2533: p_msg_index => l_counter,
2526: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2527:
2528: -- print the error message in the output file
2529: IF (fnd_msg_pub.count_msg > 0) THEN
2530: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2531: LOOP
2532: fnd_msg_pub.get(
2533: p_msg_index => l_counter,
2534: p_encoded => 'F',
2528: -- print the error message in the output file
2529: IF (fnd_msg_pub.count_msg > 0) THEN
2530: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2531: LOOP
2532: fnd_msg_pub.get(
2533: p_msg_index => l_counter,
2534: p_encoded => 'F',
2535: p_data => l_data,
2536: p_msg_index_out => l_msg_index_out);
2652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2654:
2655: -- print the error message in the output file
2656: IF (fnd_msg_pub.count_msg > 0) THEN
2657: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2658: LOOP
2659: fnd_msg_pub.get(
2660: p_msg_index => l_counter,
2653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2654:
2655: -- print the error message in the output file
2656: IF (fnd_msg_pub.count_msg > 0) THEN
2657: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2658: LOOP
2659: fnd_msg_pub.get(
2660: p_msg_index => l_counter,
2661: p_encoded => 'F',
2655: -- print the error message in the output file
2656: IF (fnd_msg_pub.count_msg > 0) THEN
2657: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2658: LOOP
2659: fnd_msg_pub.get(
2660: p_msg_index => l_counter,
2661: p_encoded => 'F',
2662: p_data => l_data,
2663: p_msg_index_out => l_msg_index_out);
2683: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2684: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2685:
2686: -- print the error message in the output file
2687: IF (fnd_msg_pub.count_msg > 0) THEN
2688: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2689: LOOP
2690: fnd_msg_pub.get(
2691: p_msg_index => l_counter,
2684: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2685:
2686: -- print the error message in the output file
2687: IF (fnd_msg_pub.count_msg > 0) THEN
2688: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2689: LOOP
2690: fnd_msg_pub.get(
2691: p_msg_index => l_counter,
2692: p_encoded => 'F',
2686: -- print the error message in the output file
2687: IF (fnd_msg_pub.count_msg > 0) THEN
2688: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2689: LOOP
2690: fnd_msg_pub.get(
2691: p_msg_index => l_counter,
2692: p_encoded => 'F',
2693: p_data => l_data,
2694: p_msg_index_out => l_msg_index_out);
2715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2717:
2718: -- print the error message in the output file
2719: IF (fnd_msg_pub.count_msg > 0) THEN
2720: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2721: LOOP
2722: fnd_msg_pub.get(
2723: p_msg_index => l_counter,
2716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2717:
2718: -- print the error message in the output file
2719: IF (fnd_msg_pub.count_msg > 0) THEN
2720: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2721: LOOP
2722: fnd_msg_pub.get(
2723: p_msg_index => l_counter,
2724: p_encoded => 'F',
2718: -- print the error message in the output file
2719: IF (fnd_msg_pub.count_msg > 0) THEN
2720: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2721: LOOP
2722: fnd_msg_pub.get(
2723: p_msg_index => l_counter,
2724: p_encoded => 'F',
2725: p_data => l_data,
2726: p_msg_index_out => l_msg_index_out);
2822: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2825: -- print the error message in the output file
2826: IF (fnd_msg_pub.count_msg > 0) THEN
2827: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2828: LOOP
2829: fnd_msg_pub.get(
2830: p_msg_index => l_counter,
2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2825: -- print the error message in the output file
2826: IF (fnd_msg_pub.count_msg > 0) THEN
2827: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2828: LOOP
2829: fnd_msg_pub.get(
2830: p_msg_index => l_counter,
2831: p_encoded => 'F',
2825: -- print the error message in the output file
2826: IF (fnd_msg_pub.count_msg > 0) THEN
2827: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2828: LOOP
2829: fnd_msg_pub.get(
2830: p_msg_index => l_counter,
2831: p_encoded => 'F',
2832: p_data => l_data,
2833: p_msg_index_out => l_msg_index_out);
2872: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2873: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2874:
2875: -- print the error message in the output file
2876: IF (fnd_msg_pub.count_msg > 0) THEN
2877: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2878: LOOP
2879: fnd_msg_pub.get(
2880: p_msg_index => l_counter,
2873: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2874:
2875: -- print the error message in the output file
2876: IF (fnd_msg_pub.count_msg > 0) THEN
2877: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2878: LOOP
2879: fnd_msg_pub.get(
2880: p_msg_index => l_counter,
2881: p_encoded => 'F',
2875: -- print the error message in the output file
2876: IF (fnd_msg_pub.count_msg > 0) THEN
2877: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2878: LOOP
2879: fnd_msg_pub.get(
2880: p_msg_index => l_counter,
2881: p_encoded => 'F',
2882: p_data => l_data,
2883: p_msg_index_out => l_msg_index_out);
2903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2905:
2906: -- print the error message in the output file
2907: IF (fnd_msg_pub.count_msg > 0) THEN
2908: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2909: LOOP
2910: fnd_msg_pub.get(
2911: p_msg_index => l_counter,
2904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2905:
2906: -- print the error message in the output file
2907: IF (fnd_msg_pub.count_msg > 0) THEN
2908: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2909: LOOP
2910: fnd_msg_pub.get(
2911: p_msg_index => l_counter,
2912: p_encoded => 'F',
2906: -- print the error message in the output file
2907: IF (fnd_msg_pub.count_msg > 0) THEN
2908: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2909: LOOP
2910: fnd_msg_pub.get(
2911: p_msg_index => l_counter,
2912: p_encoded => 'F',
2913: p_data => l_data,
2914: p_msg_index_out => l_msg_index_out);
2935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
2936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2937:
2938: -- print the error message in the output file
2939: IF (fnd_msg_pub.count_msg > 0) THEN
2940: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2941: LOOP
2942: fnd_msg_pub.get(
2943: p_msg_index => l_counter,
2936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
2937:
2938: -- print the error message in the output file
2939: IF (fnd_msg_pub.count_msg > 0) THEN
2940: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2941: LOOP
2942: fnd_msg_pub.get(
2943: p_msg_index => l_counter,
2944: p_encoded => 'F',
2938: -- print the error message in the output file
2939: IF (fnd_msg_pub.count_msg > 0) THEN
2940: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
2941: LOOP
2942: fnd_msg_pub.get(
2943: p_msg_index => l_counter,
2944: p_encoded => 'F',
2945: p_data => l_data,
2946: p_msg_index_out => l_msg_index_out);
3854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3855:
3856: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
3857: -- print the error message in the output file
3858: IF (fnd_msg_pub.count_msg > 0) THEN
3859: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3860: LOOP
3861: fnd_msg_pub.get(
3862: p_msg_index => l_counter,
3855:
3856: IF (l_process_status = OKL_API.G_RET_STS_ERROR OR l_process_status = OKL_API.G_RET_STS_WARNING) THEN
3857: -- print the error message in the output file
3858: IF (fnd_msg_pub.count_msg > 0) THEN
3859: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3860: LOOP
3861: fnd_msg_pub.get(
3862: p_msg_index => l_counter,
3863: p_encoded => 'F',
3857: -- print the error message in the output file
3858: IF (fnd_msg_pub.count_msg > 0) THEN
3859: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3860: LOOP
3861: fnd_msg_pub.get(
3862: p_msg_index => l_counter,
3863: p_encoded => 'F',
3864: p_data => l_data,
3865: p_msg_index_out => l_msg_index_out);
3900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3902:
3903: -- print the error message in the output file
3904: IF (fnd_msg_pub.count_msg > 0) THEN
3905: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3906: LOOP
3907: fnd_msg_pub.get(
3908: p_msg_index => l_counter,
3901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3902:
3903: -- print the error message in the output file
3904: IF (fnd_msg_pub.count_msg > 0) THEN
3905: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3906: LOOP
3907: fnd_msg_pub.get(
3908: p_msg_index => l_counter,
3909: p_encoded => 'F',
3903: -- print the error message in the output file
3904: IF (fnd_msg_pub.count_msg > 0) THEN
3905: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3906: LOOP
3907: fnd_msg_pub.get(
3908: p_msg_index => l_counter,
3909: p_encoded => 'F',
3910: p_data => l_data,
3911: p_msg_index_out => l_msg_index_out);
3932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3934:
3935: -- print the error message in the output file
3936: IF (fnd_msg_pub.count_msg > 0) THEN
3937: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3938: LOOP
3939: fnd_msg_pub.get(
3940: p_msg_index => l_counter,
3933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3934:
3935: -- print the error message in the output file
3936: IF (fnd_msg_pub.count_msg > 0) THEN
3937: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3938: LOOP
3939: fnd_msg_pub.get(
3940: p_msg_index => l_counter,
3941: p_encoded => 'F',
3935: -- print the error message in the output file
3936: IF (fnd_msg_pub.count_msg > 0) THEN
3937: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3938: LOOP
3939: fnd_msg_pub.get(
3940: p_msg_index => l_counter,
3941: p_encoded => 'F',
3942: p_data => l_data,
3943: p_msg_index_out => l_msg_index_out);
3965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_LLA_BOOK_STATUS'));
3966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3967:
3968: -- print the error message in the output file
3969: IF (fnd_msg_pub.count_msg > 0) THEN
3970: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3971: LOOP
3972: fnd_msg_pub.get(
3973: p_msg_index => l_counter,
3966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-------');
3967:
3968: -- print the error message in the output file
3969: IF (fnd_msg_pub.count_msg > 0) THEN
3970: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3971: LOOP
3972: fnd_msg_pub.get(
3973: p_msg_index => l_counter,
3974: p_encoded => 'F',
3968: -- print the error message in the output file
3969: IF (fnd_msg_pub.count_msg > 0) THEN
3970: FOR l_counter IN 1 .. fnd_msg_pub.count_msg
3971: LOOP
3972: fnd_msg_pub.get(
3973: p_msg_index => l_counter,
3974: p_encoded => 'F',
3975: p_data => l_data,
3976: p_msg_index_out => l_msg_index_out);