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.

[Home] [Help]

APPS.PSP_ARCHIVE_RETRIEVE dependencies on FND_API

Line 262: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

258: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
259: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
260: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
261: fnd_msg_pub.add;
262: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:
265: --For bug fixing 1769523
266: --Checking if any Effort Reports are pending for Certification ,in which Archiving cannot be done

Line 288: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

284: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
285: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
286: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
287: fnd_msg_pub.add;
288: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290: --End of Bug Fix
291:
292: -- Archiving data into the new archival tables and purging the data from the history tables

Line 596: p_print_header=>FND_API.G_FALSE);

592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
593: fnd_msg_pub.add;
594: --psp_message_s.print_success;
595: psp_message_s.print_error(p_mode=>FND_FILE.log,
596: p_print_header=>FND_API.G_FALSE);
597: retcode := 0;
598: EXCEPTION
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

596: p_print_header=>FND_API.G_FALSE);
597: retcode := 0;
598: EXCEPTION
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: /* Following added for bug 2482603 */
602: g_error_api_path := SUBSTR('ARCHIVE_DISTRIBUTION '||g_error_api_path,1,230);
603: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
604: psp_message_s.print_error( p_mode => FND_FILE.LOG,

Line 605: p_print_header => FND_API.G_TRUE);

601: /* Following added for bug 2482603 */
602: g_error_api_path := SUBSTR('ARCHIVE_DISTRIBUTION '||g_error_api_path,1,230);
603: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
604: psp_message_s.print_error( p_mode => FND_FILE.LOG,
605: p_print_header => FND_API.G_TRUE);
606: retcode := 2;
607:
608: WHEN OTHERS THEN
609: /* Following added for bug 2482603 */

Line 613: p_print_header => FND_API.G_TRUE);

609: /* Following added for bug 2482603 */
610: g_error_api_path := SUBSTR('ARCHIVE_DISTRIBUTION '||g_error_api_path,1,230);
611: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
612: psp_message_s.print_error( p_mode => FND_FILE.LOG,
613: p_print_header => FND_API.G_TRUE);
614: retcode := 2;
615: END archive_distribution;
616:
617: /****************************************************************************************

Line 1017: p_print_header=>FND_API.G_FALSE);

1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1014: fnd_msg_pub.add;
1015: --psp_message_s.print_success;
1016: psp_message_s.print_error(p_mode=>FND_FILE.log,
1017: p_print_header=>FND_API.G_FALSE);
1018: retcode := 0;
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: /* Following Added for bug 2482603 */

Line 1025: p_print_header => FND_API.G_TRUE);

1021: /* Following Added for bug 2482603 */
1022: g_error_api_path := SUBSTR('RETRIEVE_DISTRIBUTION '||g_error_api_path,1,230);
1023: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1024: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1025: p_print_header => FND_API.G_TRUE);
1026: retcode := 2;
1027: END retrieve_distribution;
1028:
1029: /****************************************************************************************

Line 1151: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1147: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1148: fnd_msg_pub.add;
1149:
1150: -- Raise Unexpected Error exception to end the Procedure
1151: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1152: End If;
1153:
1154: -- The valid period loop starts here
1155: Open valid_period_cur;

Line 1299: p_print_header => FND_API.G_FALSE);

1295: fnd_msg_pub.add;
1296:
1297: -- Write all the accumulated messages into the log
1298: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1299: p_print_header => FND_API.G_FALSE);
1300: retcode := 0;
1301:
1302: --Exception handling starts here
1303: Exception

Line 1305: When FND_API.G_EXC_UNEXPECTED_ERROR Then

1301:
1302: --Exception handling starts here
1303: Exception
1304: -- The following Exception occurs as part of user call for invalid time periods
1305: When FND_API.G_EXC_UNEXPECTED_ERROR Then
1306: -- Update the log with the messages accumulated so far
1307: /* Following added for bug 2482603 */
1308: g_error_api_path := SUBSTR('ARCHIVE_ENCUMBRANCE '||g_error_api_path,1,230);
1309: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

Line 1311: p_print_header => FND_API.G_TRUE);

1307: /* Following added for bug 2482603 */
1308: g_error_api_path := SUBSTR('ARCHIVE_ENCUMBRANCE '||g_error_api_path,1,230);
1309: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1310: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1311: p_print_header => FND_API.G_TRUE);
1312: retcode := 2;
1313:
1314: -- For any other exception, ROLLBACK
1315: When OTHERS Then

Line 1320: p_print_header => FND_API.G_TRUE);

1316: /* Following added for bug 2482603 */
1317: g_error_api_path := SUBSTR('ARCHIVE_ENCUMBRANCE '||g_error_api_path,1,230);
1318: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1319: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1320: p_print_header => FND_API.G_TRUE);
1321: retcode := 2;
1322: End archive_encumbrance;
1323:
1324: /****************************************************************************************

Line 1551: p_print_header => FND_API.G_FALSE);

1547: fnd_msg_pub.add;
1548:
1549: -- Write all messages into Log
1550: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1551: p_print_header => FND_API.G_FALSE);
1552: retcode := 0;
1553:
1554: --Exception handling starts here
1555: Exception

Line 1562: p_print_header => FND_API.G_TRUE);

1558: /* Folllowing is added for bug 2482603 */
1559: g_error_api_path := SUBSTR('RETRIEVE_ENCUMBRANCE '||g_error_api_path,1,230);
1560: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);
1561: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1562: p_print_header => FND_API.G_TRUE);
1563: retcode := 2;
1564: End retrieve_encumbrance;
1565:
1566: /****************************************************************************************