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.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_MESSAGE_S

Line 205: PSB_MESSAGE_S.INSERT_ERROR

201: l_msg_data := FND_MSG_PUB.Get
202: (p_msg_index => FND_MSG_PUB.G_NEXT,
203: p_encoded => FND_API.G_FALSE);
204:
205: PSB_MESSAGE_S.INSERT_ERROR
206: (p_source_process => 'DATA_EXTRACT_VALIDATION',
207: p_process_id => p_data_extract_id,
208: p_msg_count => l_msg_count,
209: p_msg_data => l_msg_data);

Line 701: PSB_MESSAGE_S.Print_Success;

697: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
698: raise FND_API.G_EXC_ERROR;
699: end if;
700:
701: PSB_MESSAGE_S.Print_Success;
702: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.OUTPUT,
703: p_print_header => FND_API.G_FALSE);
704: retcode := 0 ;
705: --

Line 702: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.OUTPUT,

698: raise FND_API.G_EXC_ERROR;
699: end if;
700:
701: PSB_MESSAGE_S.Print_Success;
702: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.OUTPUT,
703: p_print_header => FND_API.G_FALSE);
704: retcode := 0 ;
705: --
706: COMMIT WORK;

Line 721: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

717: p_concurrency_entity_name => 'DATA_EXTRACT',
718: p_concurrency_entity_id => p_data_extract_id);
719:
720:
721: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
722: p_print_header => FND_API.G_TRUE );
723: retcode := 2 ;
724: COMMIT WORK ;
725: --

Line 736: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

732: p_concurrency_class => 'DATAEXTRACT_CREATION',
733: p_concurrency_entity_name => 'DATA_EXTRACT',
734: p_concurrency_entity_id => p_data_extract_id);
735:
736: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
737: p_print_header => FND_API.G_TRUE );
738: retcode := 2 ;
739: COMMIT WORK ;
740: --

Line 757: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

753: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
754: l_api_name ) ;
755: END IF ;
756: --
757: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
758: p_print_header => FND_API.G_TRUE );
759: --
760: retcode := 2 ;
761: COMMIT WORK ;

Line 911: PSB_MESSAGE_S.Print_Success;

907:
908: end if;
909: --
910:
911: PSB_MESSAGE_S.Print_Success;
912: retcode := 0 ;
913: --
914: COMMIT WORK;
915:

Line 934: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.LOG,

930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
931: l_api_name ) ;
932: END IF ;
933: --
934: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.LOG,
935: p_print_header => FND_API.G_TRUE);
936: --
937: retcode := 2 ;
938: --

Line 1174: PSB_MESSAGE_S.INSERT_ERROR

1170: l_msg_data := FND_MSG_PUB.Get
1171: (p_msg_index => FND_MSG_PUB.G_NEXT,
1172: p_encoded => FND_API.G_FALSE);
1173:
1174: PSB_MESSAGE_S.INSERT_ERROR
1175: (p_source_process => 'DATA_EXTRACT_VALIDATION',
1176: p_process_id => p_data_extract_id,
1177: p_msg_count => l_msg_count,
1178: p_msg_data => l_msg_data);

Line 1182: PSB_MESSAGE_S.Print_Success;

1178: p_msg_data => l_msg_data);
1179:
1180: END IF;
1181:
1182: PSB_MESSAGE_S.Print_Success;
1183: retcode := 0 ;
1184:
1185: COMMIT WORK;
1186:

Line 1191: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1187: EXCEPTION
1188:
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: --
1191: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1192: p_print_header => FND_API.G_TRUE );
1193: retcode := 2 ;
1194: COMMIT WORK ;
1195: --

Line 1198: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1194: COMMIT WORK ;
1195: --
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: --
1198: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1199: p_print_header => FND_API.G_TRUE );
1200: retcode := 2 ;
1201: COMMIT WORK ;
1202: --

Line 1214: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1210: END IF ;
1211: --
1212: l_return_status := FND_API.G_RET_STS_ERROR;
1213:
1214: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1215: p_print_header => FND_API.G_TRUE );
1216: --
1217: retcode := 2 ;
1218: COMMIT WORK ;

Line 1307: PSB_MESSAGE_S.INSERT_ERROR

1303: l_msg_data := FND_MSG_PUB.Get
1304: (p_msg_index => FND_MSG_PUB.G_NEXT,
1305: p_encoded => FND_API.G_FALSE);
1306:
1307: PSB_MESSAGE_S.INSERT_ERROR
1308: (p_source_process => 'DATA_EXTRACT_VALIDATION',
1309: p_process_id => p_data_extract_id,
1310: p_msg_count => l_msg_count,
1311: p_msg_data => l_msg_data);

Line 1316: PSB_MESSAGE_S.Print_Success;

1312:
1313: END IF;
1314:
1315: FND_FILE.put_line(FND_FILE.LOG,'After Call');
1316: PSB_MESSAGE_S.Print_Success;
1317: retcode := 0 ;
1318:
1319: COMMIT WORK;
1320:

Line 1325: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1321: EXCEPTION
1322:
1323: WHEN FND_API.G_EXC_ERROR THEN
1324: --
1325: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1326: p_print_header => FND_API.G_TRUE );
1327: retcode := 2 ;
1328: COMMIT WORK ;
1329: --

Line 1332: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1328: COMMIT WORK ;
1329: --
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331: --
1332: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1333: p_print_header => FND_API.G_TRUE );
1334: retcode := 2 ;
1335: COMMIT WORK ;
1336: --

Line 1348: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1344: END IF ;
1345: --
1346: l_return_status := FND_API.G_RET_STS_ERROR;
1347:
1348: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1349: p_print_header => FND_API.G_TRUE );
1350: --
1351: retcode := 2 ;
1352: COMMIT WORK ;

Line 1434: PSB_MESSAGE_S.INSERT_ERROR

1430: l_msg_data := FND_MSG_PUB.Get
1431: (p_msg_index => FND_MSG_PUB.G_NEXT,
1432: p_encoded => FND_API.G_FALSE);
1433:
1434: PSB_MESSAGE_S.INSERT_ERROR
1435: (p_source_process => 'DATA_EXTRACT_VALIDATION',
1436: p_process_id => p_data_extract_id,
1437: p_msg_count => l_msg_count,
1438: p_msg_data => l_msg_data);

Line 1442: PSB_MESSAGE_S.Print_Success;

1438: p_msg_data => l_msg_data);
1439:
1440: END IF;
1441:
1442: PSB_MESSAGE_S.Print_Success;
1443: retcode := 0 ;
1444:
1445: EXCEPTION
1446:

Line 1449: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1445: EXCEPTION
1446:
1447: WHEN FND_API.G_EXC_ERROR THEN
1448: --
1449: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1450: p_print_header => FND_API.G_TRUE );
1451: retcode := 2 ;
1452: COMMIT WORK ;
1453: --

Line 1456: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1452: COMMIT WORK ;
1453: --
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1455: --
1456: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1457: p_print_header => FND_API.G_TRUE );
1458: retcode := 2 ;
1459: COMMIT WORK ;
1460: --

Line 1472: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1468: END IF ;
1469: --
1470: l_return_status := FND_API.G_RET_STS_ERROR;
1471:
1472: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1473: p_print_header => FND_API.G_TRUE );
1474: --
1475: retcode := 2 ;
1476: COMMIT WORK ;

Line 1556: PSB_MESSAGE_S.INSERT_ERROR

1552: l_msg_data := FND_MSG_PUB.Get
1553: (p_msg_index => FND_MSG_PUB.G_NEXT,
1554: p_encoded => FND_API.G_FALSE);
1555:
1556: PSB_MESSAGE_S.INSERT_ERROR
1557: (p_source_process => 'DATA_EXTRACT_VALIDATION',
1558: p_process_id => p_data_extract_id,
1559: p_msg_count => l_msg_count,
1560: p_msg_data => l_msg_data);

Line 1564: PSB_MESSAGE_S.Print_Success;

1560: p_msg_data => l_msg_data);
1561:
1562: END IF;
1563:
1564: PSB_MESSAGE_S.Print_Success;
1565: retcode := 0 ;
1566:
1567: EXCEPTION
1568:

Line 1571: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1567: EXCEPTION
1568:
1569: WHEN FND_API.G_EXC_ERROR THEN
1570: --
1571: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1572: p_print_header => FND_API.G_TRUE );
1573: retcode := 2 ;
1574: COMMIT WORK ;
1575: --

Line 1578: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1574: COMMIT WORK ;
1575: --
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577: --
1578: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1579: p_print_header => FND_API.G_TRUE );
1580: retcode := 2 ;
1581: COMMIT WORK ;
1582: --

Line 1594: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1590: END IF ;
1591: --
1592: l_return_status := FND_API.G_RET_STS_ERROR;
1593:
1594: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1595: p_print_header => FND_API.G_TRUE );
1596: --
1597: retcode := 2 ;
1598: COMMIT WORK ;

Line 1678: PSB_MESSAGE_S.INSERT_ERROR

1674: l_msg_data := FND_MSG_PUB.Get
1675: (p_msg_index => FND_MSG_PUB.G_NEXT,
1676: p_encoded => FND_API.G_FALSE);
1677:
1678: PSB_MESSAGE_S.INSERT_ERROR
1679: (p_source_process => 'DATA_EXTRACT_VALIDATION',
1680: p_process_id => p_data_extract_id,
1681: p_msg_count => l_msg_count,
1682: p_msg_data => l_msg_data);

Line 1685: PSB_MESSAGE_S.Print_Success;

1681: p_msg_count => l_msg_count,
1682: p_msg_data => l_msg_data);
1683:
1684: END IF;
1685: PSB_MESSAGE_S.Print_Success;
1686: retcode := 0 ;
1687:
1688: EXCEPTION
1689:

Line 1692: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1688: EXCEPTION
1689:
1690: WHEN FND_API.G_EXC_ERROR THEN
1691: --
1692: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1693: p_print_header => FND_API.G_TRUE );
1694: retcode := 2 ;
1695: COMMIT WORK ;
1696: --

Line 1699: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1695: COMMIT WORK ;
1696: --
1697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1698: --
1699: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1700: p_print_header => FND_API.G_TRUE );
1701: retcode := 2 ;
1702: COMMIT WORK ;
1703: --

Line 1715: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1711: END IF ;
1712: --
1713: l_return_status := FND_API.G_RET_STS_ERROR;
1714:
1715: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1716: p_print_header => FND_API.G_TRUE );
1717: --
1718: retcode := 2 ;
1719: COMMIT WORK ;

Line 1859: PSB_MESSAGE_S.INSERT_ERROR

1855: l_msg_data := FND_MSG_PUB.Get
1856: (p_msg_index => FND_MSG_PUB.G_NEXT,
1857: p_encoded => FND_API.G_FALSE);
1858:
1859: PSB_MESSAGE_S.INSERT_ERROR
1860: (p_source_process => 'DATA_EXTRACT_VALIDATION',
1861: p_process_id => p_data_extract_id,
1862: p_msg_count => l_msg_count,
1863: p_msg_data => l_msg_data);

Line 1866: PSB_MESSAGE_S.Print_Success;

1862: p_msg_count => l_msg_count,
1863: p_msg_data => l_msg_data);
1864:
1865: END IF;
1866: PSB_MESSAGE_S.Print_Success;
1867: retcode := 0 ;
1868:
1869: COMMIT WORK ;
1870:

Line 1875: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1871: EXCEPTION
1872:
1873: WHEN FND_API.G_EXC_ERROR THEN
1874: --
1875: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1876: p_print_header => FND_API.G_TRUE );
1877: retcode := 2 ;
1878: COMMIT WORK ;
1879: --

Line 1882: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1878: COMMIT WORK ;
1879: --
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1881: --
1882: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1883: p_print_header => FND_API.G_TRUE );
1884: retcode := 2 ;
1885: COMMIT WORK ;
1886: --

Line 1897: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

1893: l_api_name ) ;
1894: END IF ;
1895: --
1896:
1897: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1898: p_print_header => FND_API.G_TRUE );
1899: --
1900: retcode := 2 ;
1901: COMMIT WORK ;

Line 2042: PSB_MESSAGE_S.INSERT_ERROR

2038: l_msg_data := FND_MSG_PUB.Get
2039: (p_msg_index => FND_MSG_PUB.G_NEXT,
2040: p_encoded => FND_API.G_FALSE);
2041:
2042: PSB_MESSAGE_S.INSERT_ERROR
2043: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2044: p_process_id => p_data_extract_id,
2045: p_msg_count => l_msg_count,
2046: p_msg_data => l_msg_data);

Line 2049: PSB_MESSAGE_S.Print_Success;

2045: p_msg_count => l_msg_count,
2046: p_msg_data => l_msg_data);
2047:
2048: END IF;
2049: PSB_MESSAGE_S.Print_Success;
2050: retcode := 0 ;
2051:
2052: COMMIT WORK;
2053:

Line 2066: PSB_MESSAGE_S.INSERT_ERROR

2062: l_msg_data := FND_MSG_PUB.Get
2063: (p_msg_index => FND_MSG_PUB.G_NEXT,
2064: p_encoded => FND_API.G_FALSE);
2065:
2066: PSB_MESSAGE_S.INSERT_ERROR
2067: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2068: p_process_id => p_data_extract_id,
2069: p_msg_count => l_msg_count,
2070: p_msg_data => l_msg_data);

Line 2074: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2070: p_msg_data => l_msg_data);
2071:
2072: END IF;
2073:
2074: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2075: p_print_header => FND_API.G_TRUE );
2076: retcode := 2 ;
2077: COMMIT WORK ;
2078: --

Line 2081: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2077: COMMIT WORK ;
2078: --
2079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2080: --
2081: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2082: p_print_header => FND_API.G_TRUE );
2083: retcode := 2 ;
2084: COMMIT WORK ;
2085: --

Line 2096: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2092: l_api_name ) ;
2093: END IF ;
2094: --
2095:
2096: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2097: p_print_header => FND_API.G_TRUE );
2098: --
2099: retcode := 2 ;
2100: COMMIT WORK ;

Line 2241: PSB_MESSAGE_S.INSERT_ERROR

2237: l_msg_data := FND_MSG_PUB.Get
2238: (p_msg_index => FND_MSG_PUB.G_NEXT,
2239: p_encoded => FND_API.G_FALSE);
2240:
2241: PSB_MESSAGE_S.INSERT_ERROR
2242: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2243: p_process_id => p_data_extract_id,
2244: p_msg_count => l_msg_count,
2245: p_msg_data => l_msg_data);

Line 2248: PSB_MESSAGE_S.Print_Success;

2244: p_msg_count => l_msg_count,
2245: p_msg_data => l_msg_data);
2246:
2247: END IF;
2248: PSB_MESSAGE_S.Print_Success;
2249: retcode := 0 ;
2250: COMMIT WORK ;
2251:
2252: EXCEPTION

Line 2256: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2252: EXCEPTION
2253:
2254: WHEN FND_API.G_EXC_ERROR THEN
2255: --
2256: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2257: p_print_header => FND_API.G_TRUE );
2258: retcode := 2 ;
2259: COMMIT WORK ;
2260: --

Line 2263: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2259: COMMIT WORK ;
2260: --
2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2262: --
2263: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2264: p_print_header => FND_API.G_TRUE );
2265: retcode := 2 ;
2266: COMMIT WORK ;
2267: --

Line 2278: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2274: l_api_name ) ;
2275: END IF ;
2276: --
2277:
2278: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2279: p_print_header => FND_API.G_TRUE );
2280: --
2281: retcode := 2 ;
2282: COMMIT WORK ;

Line 2423: PSB_MESSAGE_S.INSERT_ERROR

2419: l_msg_data := FND_MSG_PUB.Get
2420: (p_msg_index => FND_MSG_PUB.G_NEXT,
2421: p_encoded => FND_API.G_FALSE);
2422:
2423: PSB_MESSAGE_S.INSERT_ERROR
2424: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2425: p_process_id => p_data_extract_id,
2426: p_msg_count => l_msg_count,
2427: p_msg_data => l_msg_data);

Line 2432: PSB_MESSAGE_S.Print_Success;

2428:
2429: END IF;
2430:
2431: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2432: PSB_MESSAGE_S.Print_Success;
2433: retcode := 0 ;
2434: COMMIT WORK ;
2435:
2436: EXCEPTION

Line 2448: PSB_MESSAGE_S.INSERT_ERROR

2444: l_msg_data := FND_MSG_PUB.Get
2445: (p_msg_index => FND_MSG_PUB.G_NEXT,
2446: p_encoded => FND_API.G_FALSE);
2447:
2448: PSB_MESSAGE_S.INSERT_ERROR
2449: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2450: p_process_id => p_data_extract_id,
2451: p_msg_count => l_msg_count,
2452: p_msg_data => l_msg_data);

Line 2455: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2451: p_msg_count => l_msg_count,
2452: p_msg_data => l_msg_data);
2453: END IF;
2454:
2455: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2456: p_print_header => FND_API.G_TRUE );
2457: retcode := 2 ;
2458: COMMIT WORK ;
2459: --

Line 2462: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2458: COMMIT WORK ;
2459: --
2460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2461: --
2462: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2463: p_print_header => FND_API.G_TRUE );
2464: retcode := 2 ;
2465: COMMIT WORK ;
2466: --

Line 2477: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2473: l_api_name ) ;
2474: END IF ;
2475: --
2476:
2477: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2478: p_print_header => FND_API.G_TRUE );
2479: --
2480: retcode := 2 ;
2481: COMMIT WORK ;

Line 2541: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2537: );
2538:
2539: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2540: /* Bug 3677529 Start */
2541: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2542: p_print_header => FND_API.G_TRUE );
2543: /* Bug 3677529 End */
2544: FND_FILE.put_line(FND_FILE.LOG,'Get Cost Distributions Failed');
2545: FND_MSG_PUB.Initialize;

Line 2621: PSB_MESSAGE_S.INSERT_ERROR

2617: l_msg_data := FND_MSG_PUB.Get
2618: (p_msg_index => FND_MSG_PUB.G_NEXT,
2619: p_encoded => FND_API.G_FALSE);
2620:
2621: PSB_MESSAGE_S.INSERT_ERROR
2622: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2623: p_process_id => p_data_extract_id,
2624: p_msg_count => l_msg_count,
2625: p_msg_data => l_msg_data);

Line 2630: PSB_MESSAGE_S.Print_Success;

2626:
2627: END IF;
2628:
2629: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2630: PSB_MESSAGE_S.Print_Success;
2631: retcode := 0 ;
2632:
2633: COMMIT WORK;
2634:

Line 2639: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2635: EXCEPTION
2636:
2637: WHEN FND_API.G_EXC_ERROR THEN
2638: --
2639: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2640: p_print_header => FND_API.G_TRUE );
2641: retcode := 2 ;
2642: COMMIT WORK ;
2643: --

Line 2646: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2642: COMMIT WORK ;
2643: --
2644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2645: --
2646: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2647: p_print_header => FND_API.G_TRUE );
2648: retcode := 2 ;
2649: COMMIT WORK ;
2650: --

Line 2661: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2657: l_api_name ) ;
2658: END IF ;
2659: --
2660:
2661: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2662: p_print_header => FND_API.G_TRUE );
2663: --
2664: retcode := 2 ;
2665: COMMIT WORK ;

Line 2799: PSB_MESSAGE_S.INSERT_ERROR

2795: l_msg_data := FND_MSG_PUB.Get
2796: (p_msg_index => FND_MSG_PUB.G_NEXT,
2797: p_encoded => FND_API.G_FALSE);
2798:
2799: PSB_MESSAGE_S.INSERT_ERROR
2800: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2801: p_process_id => p_data_extract_id,
2802: p_msg_count => l_msg_count,
2803: p_msg_data => l_msg_data);

Line 2807: PSB_MESSAGE_S.Print_Success;

2803: p_msg_data => l_msg_data);
2804:
2805: END IF;
2806: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2807: PSB_MESSAGE_S.Print_Success;
2808: retcode := 0 ;
2809:
2810: COMMIT WORK;
2811:

Line 2816: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2812: EXCEPTION
2813:
2814: WHEN FND_API.G_EXC_ERROR THEN
2815: --
2816: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2817: p_print_header => FND_API.G_TRUE );
2818: retcode := 2 ;
2819: COMMIT WORK ;
2820: --

Line 2823: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2819: COMMIT WORK ;
2820: --
2821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2822: --
2823: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2824: p_print_header => FND_API.G_TRUE );
2825: retcode := 2 ;
2826: COMMIT WORK ;
2827: --

Line 2838: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2834: l_api_name ) ;
2835: END IF ;
2836: --
2837:
2838: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2839: p_print_header => FND_API.G_TRUE );
2840: --
2841: retcode := 2 ;
2842: COMMIT WORK ;

Line 2920: PSB_MESSAGE_S.INSERT_ERROR

2916: l_msg_data := FND_MSG_PUB.Get
2917: (p_msg_index => FND_MSG_PUB.G_NEXT,
2918: p_encoded => FND_API.G_FALSE);
2919:
2920: PSB_MESSAGE_S.INSERT_ERROR
2921: (p_source_process => 'DATA_EXTRACT_VALIDATION',
2922: p_process_id => p_data_extract_id,
2923: p_msg_count => l_msg_count,
2924: p_msg_data => l_msg_data);

Line 2954: PSB_MESSAGE_S.Print_Success;

2950: end if;
2951:
2952: end if;
2953: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2954: PSB_MESSAGE_S.Print_Success;
2955: retcode := 0 ;
2956:
2957:
2958: EXCEPTION

Line 2962: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2958: EXCEPTION
2959:
2960: WHEN FND_API.G_EXC_ERROR THEN
2961: --
2962: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2963: p_print_header => FND_API.G_TRUE );
2964: retcode := 2 ;
2965: COMMIT WORK ;
2966: --

Line 2969: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2965: COMMIT WORK ;
2966: --
2967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2968: --
2969: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2970: p_print_header => FND_API.G_TRUE );
2971: retcode := 2 ;
2972: COMMIT WORK ;
2973: --

Line 2984: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

2980: l_api_name ) ;
2981: END IF ;
2982: --
2983:
2984: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2985: p_print_header => FND_API.G_TRUE );
2986: --
2987: retcode := 2 ;
2988: COMMIT WORK ;

Line 3256: PSB_MESSAGE_S.Print_Success;

3252: where data_extract_id = p_data_extract_id;
3253: end if;
3254: end if;
3255:
3256: PSB_MESSAGE_S.Print_Success;
3257: retcode := 0 ;
3258:
3259: EXCEPTION
3260:

Line 3263: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

3259: EXCEPTION
3260:
3261: WHEN FND_API.G_EXC_ERROR THEN
3262: --
3263: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3264: p_print_header => FND_API.G_TRUE );
3265: retcode := 2 ;
3266: COMMIT WORK ;
3267: --

Line 3270: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

3266: COMMIT WORK ;
3267: --
3268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3269: --
3270: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3271: p_print_header => FND_API.G_TRUE );
3272: retcode := 2 ;
3273: COMMIT WORK ;
3274: --

Line 3285: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

3281: l_api_name ) ;
3282: END IF ;
3283: --
3284:
3285: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
3286: p_print_header => FND_API.G_TRUE );
3287: --
3288: retcode := 2 ;
3289: COMMIT WORK ;

Line 3964: PSB_MESSAGE_S.Print_Error

3960: END IF;
3961:
3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: PSB_MESSAGE_S.Print_Error
3965: ( p_mode => FND_FILE.LOG,
3966: p_print_header => FND_API.G_TRUE
3967: );
3968: retcode := 2;

Line 3971: PSB_MESSAGE_S.Print_Error

3967: );
3968: retcode := 2;
3969:
3970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3971: PSB_MESSAGE_S.Print_Error
3972: ( p_mode => FND_FILE.LOG,
3973: p_print_header => FND_API.G_TRUE
3974: );
3975: retcode := 2;

Line 3982: PSB_MESSAGE_S.Print_Error

3978: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3979: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3980: end if;
3981:
3982: PSB_MESSAGE_S.Print_Error
3983: ( p_mode => FND_FILE.LOG,
3984: p_print_header => FND_API.G_TRUE
3985: );
3986: retcode := 2;