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_ENC_CREATE_LINES dependencies on FND_MSG_PUB

Line 685: fnd_msg_pub.add;

681: CLOSE c_cnt_default_org;
682:
683: IF l_count = 0 THEN
684: fnd_message.set_name('PSP', 'PSP_ENC_GEN_PERIOD_NOT_FOUND');
685: fnd_msg_pub.add;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END IF;
688:
689: OPEN time_pct_def_cur;

Line 694: fnd_msg_pub.add;

690: FETCH time_pct_def_cur INTO p_enc_org_end_date, l_enc_end_date_id, l_prev_enc_end_date;
691: IF ( time_pct_def_cur%ROWCOUNT> 1) THEN
692: p_enc_org_end_date := NULL;
693: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
694: fnd_msg_pub.add;
695: g_error_message := fnd_message.get;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698: CLOSE time_pct_def_cur;

Line 713: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');

709: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
710: IF (g_error_message IS NULL) THEN
711: g_error_message := 'OBTAIN_ENC_ORG_END_DATE: ' || SQLERRM;
712: END IF;
713: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');
714: p_return_status := fnd_api.g_ret_sts_unexp_error;
715: return;
716: End obtain_enc_org_end_date;
717:

Line 759: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' OBTAIN_ENC_POETA_END_DATE ');

755: IF (g_error_message IS NULL) THEN
756: g_error_message := 'OBTAIN_ENC_POETA_END_DATE: ' || SQLERRM;
757: END IF;
758: g_error_api_path := SUBSTR(' OBTAIN_ENC_POETA_END_DATE:'||g_error_api_path,1,230);
759: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' OBTAIN_ENC_POETA_END_DATE ');
760: p_return_status := fnd_api.g_ret_sts_unexp_error;
761: END obtain_enc_poeta_end_date;
762:
763:

Line 1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');

1532:
1533: p_return_status := fnd_api.g_ret_sts_success;
1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN

Line 1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');

1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1542: IF (g_error_message IS NULL) THEN
1543: g_error_message := l_proc_name || ': ' || SQLERRM;
1544: END IF;
1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1546: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1547: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: END determine_enc_amount;

Line 3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');

3363: l_proc_step := 210;
3364: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3365: EXCEPTION
3366: WHEN suspense_autopop_failed THEN
3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

Line 3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');

3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3374: IF (g_error_message IS NULL) THEN
3375: g_error_message := l_proc_name || ': ' || SQLERRM;
3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3378: p_return_status := fnd_api.g_ret_sts_unexp_error;
3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3381: END create_lines;

Line 3570: fnd_msg_pub.add_exc_msg('PSP_ENC_LINES','INSERT_INTO_ENC_LINES');

3566: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3567: IF (g_error_message IS NULL) THEN
3568: g_error_message := 'INSERT_INTO_ENC_LINES: ' || SQLERRM;
3569: END IF;
3570: fnd_msg_pub.add_exc_msg('PSP_ENC_LINES','INSERT_INTO_ENC_LINES');
3571: p_return_status := fnd_api.g_ret_sts_unexp_error;
3572: END insert_into_enc_lines;
3573:
3574: --------------------------- INSERT INTO CONTROL TABLES --------------------------------------

Line 3676: FND_MSG_PUB.ADD;

3672: g_error_message := 'CREATE_CONTROLS: ' || SQLERRM;
3673: END IF;
3674: p_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');
3676: FND_MSG_PUB.ADD;
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END create_controls;
3679:
3680: /**********************************************************

Line 3864: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');

3860:
3861: EXCEPTION
3862: WHEN DIVIDE_BY_ZERO THEN
3863: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3864: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3865: p_return_status := fnd_api.g_ret_sts_unexp_error;
3866:
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 3873: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');

3869: IF (g_error_message IS NULL) THEN
3870: g_error_message := 'DETERMINE_PRO_RATA_DATES: ' || SQLERRM;
3871: END IF;
3872: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3873: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3874: p_return_status := fnd_api.g_ret_sts_unexp_error;
3875:
3876: END determine_pro_rata_dates;
3877:

Line 4076: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' INSERT_ENC_LINES_FROM_ARRAYS');

4072: IF (g_error_message IS NULL) THEN
4073: g_error_message := 'INSERT_ENC_LINES_FROM_ARRAYS: ' || SQLERRM;
4074: END IF;
4075: g_error_api_path := SUBSTR(' INSERT_ENC_LINES_FROM_ARRAYS:'||g_error_api_path,1,230);
4076: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' INSERT_ENC_LINES_FROM_ARRAYS');
4077: p_return_status := fnd_api.g_ret_sts_unexp_error;
4078: END insert_enc_lines_from_arrays;
4079:
4080: -- Introduced the following procedure for bug fix 3462452

Line 6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');

6575: IF (g_error_message IS NULL) THEN
6576: g_error_message := l_proc_name || ': ' || SQLERRM;
6577: END IF;
6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6580: p_return_status := fnd_api.g_ret_sts_unexp_error;
6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6583: END sub_slice_asg_chunk;

Line 6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

6608: -- spc_track_cel('Init', NULL, 'End');
6609: EXCEPTION
6610: WHEN OTHERS THEN
6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6614: p_print_header => FND_API.G_TRUE);
6615: END cel_init;
6616:

Line 6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6745: END cel_range_code;

Line 7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

7719: p_information1 => NULL,
7720: p_return_status => l_return_status);
7721: END IF;
7722: END IF;
7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7726: ROLLBACK TO CEL_ARCHIVE;
7727: RAISE;

Line 7813: fnd_msg_pub.add;

7809:
7810: IF l_request_id = 0 THEN
7811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7812: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7813: fnd_msg_pub.add;
7814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7815: END IF;
7816: COMMIT;
7817: RAISE fnd_api.g_exc_unexpected_error;

Line 7956: fnd_msg_pub.add;

7952:
7953: IF l_request_id = 0 THEN
7954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7955: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7956: fnd_msg_pub.add;
7957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7958: END IF;
7959: COMMIT;
7960:

Line 7991: fnd_msg_pub.add;

7987:
7988: IF l_request_id = 0 THEN
7989: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7990: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7991: fnd_msg_pub.add;
7992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7993: END IF;
7994:
7995: UPDATE psp_enc_processes

Line 8009: fnd_msg_pub.add;

8005:
8006: IF call_status = FALSE THEN
8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
8008: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
8009: fnd_msg_pub.add;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END IF;
8012: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
8013: ELSE

Line 8465: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES', 'VERIFY_CHANGES');

8461: IF (g_error_message IS NULL) THEN
8462: g_error_message := 'VERIFY_CHANGES: ' || SQLERRM;
8463: END IF;
8464: g_error_api_path := SUBSTR('VERIFY_CHANGES:' || g_error_api_path,1,230);
8465: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES', 'VERIFY_CHANGES');
8466: l_retcode := fnd_api.g_ret_sts_unexp_error;
8467: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8468: p_payroll_id: ' || p_payroll_id || '
8469: p_assignment_id: ' || p_assignment_id || '

Line 8562: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LIQ_LINES');

8558: IF (g_error_message IS NULL) THEN
8559: g_error_message := 'CREATE_LIQ_LINES: ' || SQLERRM;
8560: END IF;
8561: g_error_api_path := SUBSTR('CREATE_LIQ_LINES:' || g_error_api_path,1,230);
8562: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LIQ_LINES');
8563: p_return_status := fnd_api.g_ret_sts_unexp_error;
8564: END create_liq_lines;
8565:
8566: PROCEDURE create_sum_lines (p_payroll_action_id IN NUMBER,

Line 8783: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_SUM_LINES');

8779: IF (g_error_message IS NULL) THEN
8780: g_error_message := 'CREATE_SUM_LINES: ' || SQLERRM;
8781: END IF;
8782: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
8783: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_SUM_LINES');
8784: p_return_status := fnd_api.g_ret_sts_unexp_error;
8785: END create_sum_lines;
8786:
8787: PROCEDURE enc_pre_process (p_payroll_action_id IN NUMBER,

Line 10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

10058: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10059: IF (g_error_message IS NULL) THEN
10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '

Line 10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

10312: retcode := fnd_api.g_ret_sts_success;
10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;

Line 11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');

11568: IF (g_error_message IS NULL) THEN
11569: g_error_message := 'LOAD_SCH_HIERARCHY: ' || SQLERRM;
11570: END IF;
11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
11573: p_return_status := fnd_api.g_ret_sts_unexp_error;
11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11576: END load_sch_hierarchy;

Line 12143: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');

12139: IF (g_error_message IS NULL) THEN
12140: g_error_message := 'UPDATE_HIERARCHY_DATES: ' || SQLERRM;
12141: END IF;
12142: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
12143: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');
12144: p_return_status := fnd_api.g_ret_sts_unexp_error;
12145: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12146: END update_hierarchy_dates;
12147: