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

Line 165: fnd_msg_pub.initialize;

161: valid_period_rec valid_period_cur%ROWTYPE;
162: effort_pending_rec effort_pending_cur%ROWTYPE;
163:
164: BEGIN
165: fnd_msg_pub.initialize;
166: OPEN payroll_name_cur;
167: FETCH payroll_name_cur INTO payroll_name_rec;
168: l_payroll_name := payroll_name_rec.payroll_name;
169: CLOSE payroll_name_cur;

Line 194: fnd_msg_pub.add;

190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
194: fnd_msg_pub.add;
195:
196: -- Checking for periods which have unprocessed lines
197: OPEN error_check_cur;
198: FETCH error_check_cur INTO error_check_rec;

Line 213: fnd_msg_pub.add;

209: IF (error_check_rec.source_type = 'O') THEN
210: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDO_CANNOT_ARCHIVE');
211: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
212: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
213: fnd_msg_pub.add;
214:
215: ELSIF (error_check_rec.source_type = 'N') THEN
216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');
217: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

Line 219: fnd_msg_pub.add;

215: ELSIF (error_check_rec.source_type = 'N') THEN
216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');
217: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
218: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
219: fnd_msg_pub.add;
220:
221: ELSIF (error_check_rec.source_type = 'P') THEN
222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');
223: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

Line 225: fnd_msg_pub.add;

221: ELSIF (error_check_rec.source_type = 'P') THEN
222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');
223: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
224: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
225: fnd_msg_pub.add;
226:
227: ELSIF (error_check_rec.source_type = 'A') THEN
228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');
229: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

Line 231: fnd_msg_pub.add;

227: ELSIF (error_check_rec.source_type = 'A') THEN
228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');
229: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
230: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
231: fnd_msg_pub.add;
232: END IF;
233: END LOOP;
234: CLOSE error_check_cur;
235:

Line 249: fnd_msg_pub.add;

245: l_period_name := effort_pending_rec.period_name;
246: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
247: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
248: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
249: fnd_msg_pub.add;
250: END LOOP;
251: CLOSE effort_pending_cur;
252: END IF;
253: --End of Bug Fix

Line 261: fnd_msg_pub.add;

257: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
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

Line 279: fnd_msg_pub.add;

275: l_period_name := effort_pending_rec.period_name;
276: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
277: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
278: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
279: fnd_msg_pub.add;
280: END LOOP;
281: CLOSE effort_pending_cur;
282:
283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

Line 287: fnd_msg_pub.add;

283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
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:

Line 584: fnd_msg_pub.add;

580: Commit;
581: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_ARCHIVE_PERIOD');
582: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
583: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
584: fnd_msg_pub.add;
585: END LOOP;
586: CLOSE valid_period_cur;
587:
588: l_status:='successful';

Line 593: fnd_msg_pub.add;

589: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
590: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
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;

Line 603: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

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,
605: p_print_header => FND_API.G_TRUE);
606: retcode := 2;
607:

Line 611: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

607:
608: WHEN OTHERS THEN
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;

Line 688: fnd_msg_pub.initialize;

684: end_period_name_rec end_period_name_cur%ROWTYPE;
685: valid_period_rec valid_period_cur%ROWTYPE;
686:
687: BEGIN
688: fnd_msg_pub.initialize;
689: OPEN payroll_name_cur;
690: FETCH payroll_name_cur INTO payroll_name_rec;
691: l_payroll_name := payroll_name_rec.payroll_name;
692: CLOSE payroll_name_cur;

Line 710: fnd_msg_pub.add;

706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
710: fnd_msg_pub.add;
711:
712: OPEN valid_period_cur;
713: LOOP
714: FETCH valid_period_cur INTO valid_period_rec;

Line 1005: fnd_msg_pub.add;

1001: Commit;
1002: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_RETRIEVE_PERIOD');
1003: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1004: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1005: fnd_msg_pub.add;
1006: END LOOP;
1007: CLOSE valid_period_cur;
1008:
1009: l_status:='successful';

Line 1014: fnd_msg_pub.add;

1010: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1011: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
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;

Line 1023: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

1019: EXCEPTION
1020: WHEN OTHERS THEN
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;

Line 1105: fnd_msg_pub.initialize;

1101: l_error_period_count Number(15);
1102:
1103: BEGIN
1104:
1105: fnd_msg_pub.initialize;
1106:
1107: -- Retrieve the payroll name, begin , end period names for process initialization message
1108: Open parameter_cur;
1109: Fetch parameter_cur Into l_payroll_name, l_begin_period, l_end_period;

Line 1119: fnd_msg_pub.add;

1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1119: fnd_msg_pub.add;
1120:
1121: -- Check for Error time periods, If present log their corresponding messages
1122: Open invalid_period_cur;
1123: Fetch invalid_period_cur Into l_period_name;

Line 1132: fnd_msg_pub.add;

1128: -- Print the log message for the current period
1129: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_CANNOT_ARCHIVE');
1130: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1131: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1132: fnd_msg_pub.add;
1133:
1134: Fetch invalid_period_cur Into l_period_name;
1135: Exit When invalid_period_cur%NOTFOUND;
1136: End Loop;

Line 1148: fnd_msg_pub.add;

1144: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1145: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1146: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
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;

Line 1282: fnd_msg_pub.add;

1278: -- Update the log with with current periods message
1279: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD');
1280: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1281: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1282: fnd_msg_pub.add;
1283:
1284: -- Continue with the next period
1285: End Loop;
1286:

Line 1295: fnd_msg_pub.add;

1291: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1292: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1293: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
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);

Line 1309: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

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);
1310: psp_message_s.print_error( p_mode => FND_FILE.LOG,
1311: p_print_header => FND_API.G_TRUE);
1312: retcode := 2;
1313:

Line 1318: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

1314: -- For any other exception, ROLLBACK
1315: When OTHERS Then
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;

Line 1387: fnd_msg_pub.initialize;

1383: l_time_period Number(15);
1384: l_error_period_count Number(15);
1385:
1386: BEGIN
1387: fnd_msg_pub.initialize;
1388:
1389: -- Retrieve the payroll name, begin , end period names for process initialization message
1390: Open parameter_cur;
1391: Fetch parameter_cur Into l_payroll_name, l_begin_period, l_end_period;

Line 1401: fnd_msg_pub.add;

1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1401: fnd_msg_pub.add;
1402:
1403: -- The valid period loop starts here
1404: Open valid_period_cur;
1405: Loop

Line 1534: fnd_msg_pub.add;

1530: -- FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD'); --For Bug 2783253
1531: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_RETRIEVE_PERIOD'); --For Bug 2783253
1532: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1533: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1534: fnd_msg_pub.add;
1535:
1536: -- Continue with the next period
1537: End Loop;
1538:

Line 1547: fnd_msg_pub.add;

1543: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1544: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1545: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
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);

Line 1560: fnd_msg_pub.add_exc_msg('PSP_ARCHIVE_RETRIEVE',g_error_api_path);

1556: -- For any other kind of Exception, ROLLBACK
1557: When OTHERS Then
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;