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 485: fnd_msg_pub.add;

481: CLOSE c_cnt_default_org;
482:
483: IF l_count = 0 THEN
484: fnd_message.set_name('PSP', 'PSP_ENC_GEN_PERIOD_NOT_FOUND');
485: fnd_msg_pub.add;
486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488:
489: OPEN time_pct_def_cur;

Line 494: fnd_msg_pub.add;

490: FETCH time_pct_def_cur INTO p_enc_org_end_date, l_enc_end_date_id, l_prev_enc_end_date;
491: IF ( time_pct_def_cur%ROWCOUNT> 1) THEN
492: p_enc_org_end_date := NULL;
493: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
494: fnd_msg_pub.add;
495: g_error_message := fnd_message.get;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: CLOSE time_pct_def_cur;

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

508: WHEN OTHERS THEN
509: IF (g_error_message IS NULL) THEN
510: g_error_message := 'OBTAIN_ENC_ORG_END_DATE: ' || SQLERRM;
511: END IF;
512: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');
513: p_return_status := fnd_api.g_ret_sts_unexp_error;
514: return;
515: End obtain_enc_org_end_date;
516:

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

553: IF (g_error_message IS NULL) THEN
554: g_error_message := 'OBTAIN_ENC_POETA_END_DATE: ' || SQLERRM;
555: END IF;
556: g_error_api_path := SUBSTR(' OBTAIN_ENC_POETA_END_DATE:'||g_error_api_path,1,230);
557: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' OBTAIN_ENC_POETA_END_DATE ');
558: p_return_status := fnd_api.g_ret_sts_unexp_error;
559: END obtain_enc_poeta_end_date;
560:
561:

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

1318:
1319: p_return_status := fnd_api.g_ret_sts_success;
1320: EXCEPTION
1321: WHEN DIVIDE_BY_ZERO THEN
1322: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1323: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1324: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1325: p_return_status := fnd_api.g_ret_sts_unexp_error;
1326: WHEN OTHERS THEN

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

1326: WHEN OTHERS THEN
1327: IF (g_error_message IS NULL) THEN
1328: g_error_message := l_proc_name || ': ' || SQLERRM;
1329: END IF;
1330: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1331: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1333: p_return_status := fnd_api.g_ret_sts_unexp_error;
1334: END determine_enc_amount;

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

3133: l_proc_step := 210;
3134: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3135: EXCEPTION
3136: WHEN suspense_autopop_failed THEN
3137: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3138: p_return_status := fnd_api.g_ret_sts_unexp_error;
3139: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3140: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3141: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

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

3142: WHEN OTHERS THEN
3143: IF (g_error_message IS NULL) THEN
3144: g_error_message := l_proc_name || ': ' || SQLERRM;
3145: END IF;
3146: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3147: p_return_status := fnd_api.g_ret_sts_unexp_error;
3148: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3149: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3150: END create_lines;

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

3334: WHEN OTHERS THEN
3335: IF (g_error_message IS NULL) THEN
3336: g_error_message := 'INSERT_INTO_ENC_LINES: ' || SQLERRM;
3337: END IF;
3338: fnd_msg_pub.add_exc_msg('PSP_ENC_LINES','INSERT_INTO_ENC_LINES');
3339: p_return_status := fnd_api.g_ret_sts_unexp_error;
3340: END insert_into_enc_lines;
3341:
3342: --------------------------- INSERT INTO CONTROL TABLES --------------------------------------

Line 3443: FND_MSG_PUB.ADD;

3439: g_error_message := 'CREATE_CONTROLS: ' || SQLERRM;
3440: END IF;
3441: p_return_status := fnd_api.g_ret_sts_unexp_error;
3442: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');
3443: FND_MSG_PUB.ADD;
3444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3445: END create_controls;
3446:
3447: /**********************************************************

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

3627:
3628: EXCEPTION
3629: WHEN DIVIDE_BY_ZERO THEN
3630: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3631: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3632: p_return_status := fnd_api.g_ret_sts_unexp_error;
3633:
3634: WHEN OTHERS THEN
3635: IF (g_error_message IS NULL) THEN

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

3635: IF (g_error_message IS NULL) THEN
3636: g_error_message := 'DETERMINE_PRO_RATA_DATES: ' || SQLERRM;
3637: END IF;
3638: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3639: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3640: p_return_status := fnd_api.g_ret_sts_unexp_error;
3641:
3642: END determine_pro_rata_dates;
3643:

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

3837: IF (g_error_message IS NULL) THEN
3838: g_error_message := 'INSERT_ENC_LINES_FROM_ARRAYS: ' || SQLERRM;
3839: END IF;
3840: g_error_api_path := SUBSTR(' INSERT_ENC_LINES_FROM_ARRAYS:'||g_error_api_path,1,230);
3841: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' INSERT_ENC_LINES_FROM_ARRAYS');
3842: p_return_status := fnd_api.g_ret_sts_unexp_error;
3843: END insert_enc_lines_from_arrays;
3844:
3845: -- Introduced the following procedure for bug fix 3462452

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

6338: IF (g_error_message IS NULL) THEN
6339: g_error_message := l_proc_name || ': ' || SQLERRM;
6340: END IF;
6341: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6342: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6343: p_return_status := fnd_api.g_ret_sts_unexp_error;
6344: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6345: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6346: END sub_slice_asg_chunk;

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

6352: NULL;
6353: -- spc_track_cel('Init', NULL, 'End');
6354: EXCEPTION
6355: WHEN OTHERS THEN
6356: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6357: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6358: p_print_header => FND_API.G_TRUE);
6359: END cel_init;
6360:

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

6480: WHEN NO_UPDATE_REC_FOUND THEN
6481: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6482: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6483: WHEN OTHERS THEN
6484: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6485: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6486: p_print_header => FND_API.G_TRUE);
6487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6488: END cel_range_code;

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

7407: p_information1 => NULL,
7408: p_return_status => l_return_status);
7409: END IF;
7410: END IF;
7411: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7412: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7413: 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 ||')');
7414: ROLLBACK TO CEL_ARCHIVE;
7415: RAISE;

Line 7501: fnd_msg_pub.add;

7497:
7498: IF l_request_id = 0 THEN
7499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7500: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7501: fnd_msg_pub.add;
7502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7503: END IF;
7504: COMMIT;
7505: RAISE fnd_api.g_exc_unexpected_error;

Line 7644: fnd_msg_pub.add;

7640:
7641: IF l_request_id = 0 THEN
7642: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7643: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7644: fnd_msg_pub.add;
7645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7646: END IF;
7647: COMMIT;
7648:

Line 7671: fnd_msg_pub.add;

7667:
7668: IF l_request_id = 0 THEN
7669: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7670: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7671: fnd_msg_pub.add;
7672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7673: END IF;
7674:
7675: UPDATE psp_enc_processes

Line 7689: fnd_msg_pub.add;

7685:
7686: IF call_status = FALSE THEN
7687: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
7688: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
7689: fnd_msg_pub.add;
7690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7691: END IF;
7692: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
7693: ELSE

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

8140: IF (g_error_message IS NULL) THEN
8141: g_error_message := 'VERIFY_CHANGES: ' || SQLERRM;
8142: END IF;
8143: g_error_api_path := SUBSTR('VERIFY_CHANGES:' || g_error_api_path,1,230);
8144: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES', 'VERIFY_CHANGES');
8145: l_retcode := fnd_api.g_ret_sts_unexp_error;
8146: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8147: p_payroll_id: ' || p_payroll_id || '
8148: p_assignment_id: ' || p_assignment_id || '

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

8236: IF (g_error_message IS NULL) THEN
8237: g_error_message := 'CREATE_LIQ_LINES: ' || SQLERRM;
8238: END IF;
8239: g_error_api_path := SUBSTR('CREATE_LIQ_LINES:' || g_error_api_path,1,230);
8240: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LIQ_LINES');
8241: p_return_status := fnd_api.g_ret_sts_unexp_error;
8242: END create_liq_lines;
8243:
8244: PROCEDURE create_sum_lines (p_payroll_action_id IN NUMBER,

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

8456: IF (g_error_message IS NULL) THEN
8457: g_error_message := 'CREATE_SUM_LINES: ' || SQLERRM;
8458: END IF;
8459: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
8460: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_SUM_LINES');
8461: p_return_status := fnd_api.g_ret_sts_unexp_error;
8462: END create_sum_lines;
8463:
8464: PROCEDURE enc_pre_process (p_payroll_action_id IN NUMBER,

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

9429: WHEN OTHERS THEN
9430: IF (g_error_message IS NULL) THEN
9431: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
9432: END IF;
9433: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9434: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
9435: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
9436: p_payroll_action_id: ' || p_payroll_action_id || '
9437: p_payroll_id: ' || p_payroll_id || '

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

9682: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9683: retcode := fnd_api.g_ret_sts_success;
9684: EXCEPTION
9685: WHEN OTHERS THEN
9686: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9687: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
9688: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9689: retcode := fnd_api.g_ret_sts_unexp_error;
9690: END rollback_cel;

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

10937: IF (g_error_message IS NULL) THEN
10938: g_error_message := 'LOAD_SCH_HIERARCHY: ' || SQLERRM;
10939: END IF;
10940: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
10941: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
10942: p_return_status := fnd_api.g_ret_sts_unexp_error;
10943: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
10944: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
10945: END load_sch_hierarchy;

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

11507: IF (g_error_message IS NULL) THEN
11508: g_error_message := 'UPDATE_HIERARCHY_DATES: ' || SQLERRM;
11509: END IF;
11510: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
11511: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');
11512: p_return_status := fnd_api.g_ret_sts_unexp_error;
11513: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
11514: END update_hierarchy_dates;
11515: