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_PREGEN dependencies on FND_MESSAGE

Line 268: fnd_message.set_name('PSP','PSP_PI_NO_PROFILE_FOR_SOB');

264: -- l_set_of_books_id := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS');
265: l_set_of_books_id := p_set_of_books_id;
266: if NVL(l_set_of_books_id,0) = 0 then
267: l_error_api_name := 'IMPORT_PREGEN_LINES';
268: fnd_message.set_name('PSP','PSP_PI_NO_PROFILE_FOR_SOB');
269: fnd_msg_pub.add;
270: raise FND_API.G_EXC_UNEXPECTED_ERROR;
271: end if;
272:

Line 317: fnd_message.set_name('PSP', 'PSP_PI_INVALID_CURRENCY');

313: FETCH currency_count_cur INTO l_currency_count;
314: CLOSE currency_count_cur;
315:
316: IF (l_currency_count > 1) THEN
317: fnd_message.set_name('PSP', 'PSP_PI_INVALID_CURRENCY');
318: fnd_message.set_token('BATCH_NAME', p_batch_name);
319: fnd_msg_pub.add;
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;

Line 318: fnd_message.set_token('BATCH_NAME', p_batch_name);

314: CLOSE currency_count_cur;
315:
316: IF (l_currency_count > 1) THEN
317: fnd_message.set_name('PSP', 'PSP_PI_INVALID_CURRENCY');
318: fnd_message.set_token('BATCH_NAME', p_batch_name);
319: fnd_msg_pub.add;
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:

Line 392: fnd_message.set_name('PSP','PSP_PI_INVALID_BATCH_NAME');

388: fetch get_batch_name_csr into l_batch_name_count;
389: close get_batch_name_csr;
390:
391: if NVL(l_batch_name_count,0) > 0 then
392: fnd_message.set_name('PSP','PSP_PI_INVALID_BATCH_NAME');
393: fnd_message.set_token('PSP_BATCH_NAME',p_batch_name);
394: fnd_msg_pub.add;
395: raise FND_API.G_EXC_UNEXPECTED_ERROR;
396: end if;

Line 393: fnd_message.set_token('PSP_BATCH_NAME',p_batch_name);

389: close get_batch_name_csr;
390:
391: if NVL(l_batch_name_count,0) > 0 then
392: fnd_message.set_name('PSP','PSP_PI_INVALID_BATCH_NAME');
393: fnd_message.set_token('PSP_BATCH_NAME',p_batch_name);
394: fnd_msg_pub.add;
395: raise FND_API.G_EXC_UNEXPECTED_ERROR;
396: end if;
397:

Line 703: fnd_message.set_name('PSP','PSP_BATCH_HAS_ERRORS');

699: status_code = 'E'
700: where batch_name = p_batch_name and
701: suspense_org_account_id is not null;
702: end if;
703: fnd_message.set_name('PSP','PSP_BATCH_HAS_ERRORS');
704: fnd_msg_pub.add;
705: -- This comment was added by Chandra to commit records
706: -- in the PSP_DISTRIBUTION_INTERFACE table with the status
707: commit; -- Added by Chandra

Line 1019: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');

1015:
1016: EXCEPTION
1017: -- Included the following exception handling as part of bug fix 2094036
1018: WHEN RECORD_ALREADY_LOCKED THEN
1019: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');
1020: fnd_message.set_token('BATCH_NAME', p_batch_name);
1021: l_subline_message := fnd_message.get;
1022: errbuf := l_error_api_name ||fnd_global.local_chr(10)||l_subline_message;
1023: retcode:= 2;

Line 1020: fnd_message.set_token('BATCH_NAME', p_batch_name);

1016: EXCEPTION
1017: -- Included the following exception handling as part of bug fix 2094036
1018: WHEN RECORD_ALREADY_LOCKED THEN
1019: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');
1020: fnd_message.set_token('BATCH_NAME', p_batch_name);
1021: l_subline_message := fnd_message.get;
1022: errbuf := l_error_api_name ||fnd_global.local_chr(10)||l_subline_message;
1023: retcode:= 2;
1024: WHEN NO_DATA_FOUND then

Line 1021: l_subline_message := fnd_message.get;

1017: -- Included the following exception handling as part of bug fix 2094036
1018: WHEN RECORD_ALREADY_LOCKED THEN
1019: fnd_message.set_name('PSP', 'PSP_PI_BATCH_IN_PROGRESS');
1020: fnd_message.set_token('BATCH_NAME', p_batch_name);
1021: l_subline_message := fnd_message.get;
1022: errbuf := l_error_api_name ||fnd_global.local_chr(10)||l_subline_message;
1023: retcode:= 2;
1024: WHEN NO_DATA_FOUND then
1025: close get_all_from_interface_csr;

Line 1026: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');

1022: errbuf := l_error_api_name ||fnd_global.local_chr(10)||l_subline_message;
1023: retcode:= 2;
1024: WHEN NO_DATA_FOUND then
1025: close get_all_from_interface_csr;
1026: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');
1027: l_subline_message := fnd_message.get;
1028: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_subline_message;
1029: retcode := 0;
1030: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;

Line 1027: l_subline_message := fnd_message.get;

1023: retcode:= 2;
1024: WHEN NO_DATA_FOUND then
1025: close get_all_from_interface_csr;
1026: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');
1027: l_subline_message := fnd_message.get;
1028: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_subline_message;
1029: retcode := 0;
1030: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1031: fnd_msg_pub.add;

Line 1030: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;

1026: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');
1027: l_subline_message := fnd_message.get;
1028: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_subline_message;
1029: retcode := 0;
1030: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1031: fnd_msg_pub.add;
1032:
1033: psp_message_s.print_error(p_mode=>FND_FILE.log,
1034: p_print_header=>FND_API.G_FALSE);

Line 1816: fnd_message.set_name('PSP','PSP_PI_INVALID_BATCH_NAME');

1812: fetch get_batch_name_csr into l_batch_name_count;
1813: close get_batch_name_csr;
1814:
1815: if NVL(l_batch_name_count,0) > 0 then
1816: fnd_message.set_name('PSP','PSP_PI_INVALID_BATCH_NAME');
1817: fnd_message.set_token('PSP_BATCH_NAME',x_batch_name);
1818: fnd_msg_pub.add;
1819: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1820: end if;

Line 1817: fnd_message.set_token('PSP_BATCH_NAME',x_batch_name);

1813: close get_batch_name_csr;
1814:
1815: if NVL(l_batch_name_count,0) > 0 then
1816: fnd_message.set_name('PSP','PSP_PI_INVALID_BATCH_NAME');
1817: fnd_message.set_token('PSP_BATCH_NAME',x_batch_name);
1818: fnd_msg_pub.add;
1819: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1820: end if;
1821:

Line 2322: fnd_message.set_name('PSP','PSP_BATCH_HAS_ERRORS');

2318: where batch_name = x_batch_name and
2319: suspense_org_account_id is not null;
2320: end if;
2321:
2322: fnd_message.set_name('PSP','PSP_BATCH_HAS_ERRORS');
2323: fnd_msg_pub.add;
2324: x_return_status:=FND_API.G_RET_STS_ERROR;
2325: else
2326: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 2333: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');

2329: return;
2330: EXCEPTION
2331: WHEN NO_DATA_FOUND then
2332: close get_all_from_interface_csr;
2333: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');
2334: l_subline_message := fnd_message.get;
2335: -- errbuf := SUBSTR(l_error_api_name ||fnd_global.local_chr(10) || l_subline_message,1,230);
2336: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2337: return;

Line 2334: l_subline_message := fnd_message.get;

2330: EXCEPTION
2331: WHEN NO_DATA_FOUND then
2332: close get_all_from_interface_csr;
2333: FND_MESSAGE.SET_NAME('PSP','PSP_LD_NO_TRANS');
2334: l_subline_message := fnd_message.get;
2335: -- errbuf := SUBSTR(l_error_api_name ||fnd_global.local_chr(10) || l_subline_message,1,230);
2336: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2337: return;
2338:

Line 2624: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');

2620: suspense_rec.award_id,
2621: l_new_exp_type,
2622: suspense_rec.expenditure_organization_id);
2623: end if;
2624: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

Line 2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);

2621: l_new_exp_type,
2622: suspense_rec.expenditure_organization_id);
2623: end if;
2624: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

Line 2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);

2622: suspense_rec.expenditure_organization_id);
2623: end if;
2624: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2630: fnd_message.set_token('EFF_DATE',p_effective_date);

Line 2627: fnd_message.set_token('ASG_NUM',l_assignment_number);

2623: end if;
2624: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2630: fnd_message.set_token('EFF_DATE',p_effective_date);
2631: fnd_msg_pub.add;

Line 2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

2624: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2630: fnd_message.set_token('EFF_DATE',p_effective_date);
2631: fnd_msg_pub.add;
2632: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

2625: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2630: fnd_message.set_token('EFF_DATE',p_effective_date);
2631: fnd_msg_pub.add;
2632: x_return_status := fnd_api.g_ret_sts_unexp_error;
2633: else

Line 2630: fnd_message.set_token('EFF_DATE',p_effective_date);

2626: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
2627: fnd_message.set_token('ASG_NUM',l_assignment_number);
2628: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2629: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2630: fnd_message.set_token('EFF_DATE',p_effective_date);
2631: fnd_msg_pub.add;
2632: x_return_status := fnd_api.g_ret_sts_unexp_error;
2633: else
2634: x_suspense_auto_glccid := l_new_glccid;

Line 2667: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');

2663: end if;
2664: x_suspense_account := suspense_rec.organization_account_id;
2665: EXCEPTION
2666: WHEN NO_PROFILE_EXISTS THEN
2667: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2668: fnd_msg_pub.add;
2669: x_return_status := fnd_api.g_ret_sts_unexp_error;
2670:
2671: WHEN NO_VAL_DATE_MATCHES THEN

Line 2672: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

2668: fnd_msg_pub.add;
2669: x_return_status := fnd_api.g_ret_sts_unexp_error;
2670:
2671: WHEN NO_VAL_DATE_MATCHES THEN
2672: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2673: fnd_message.set_token('ORG_NAME',p_organization_name);
2674: fnd_message.set_token('PAYROLL_DATE',p_effective_date);
2675: fnd_msg_pub.add;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2673: fnd_message.set_token('ORG_NAME',p_organization_name);

2669: x_return_status := fnd_api.g_ret_sts_unexp_error;
2670:
2671: WHEN NO_VAL_DATE_MATCHES THEN
2672: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2673: fnd_message.set_token('ORG_NAME',p_organization_name);
2674: fnd_message.set_token('PAYROLL_DATE',p_effective_date);
2675: fnd_msg_pub.add;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677:

Line 2674: fnd_message.set_token('PAYROLL_DATE',p_effective_date);

2670:
2671: WHEN NO_VAL_DATE_MATCHES THEN
2672: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2673: fnd_message.set_token('ORG_NAME',p_organization_name);
2674: fnd_message.set_token('PAYROLL_DATE',p_effective_date);
2675: fnd_msg_pub.add;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677:
2678: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 2679: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

2675: fnd_msg_pub.add;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677:
2678: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2679: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2680: fnd_message.set_token('ORG_NAME',p_organization_name);
2681: fnd_message.set_token('PAYROLL_DATE',p_effective_date);
2682: fnd_msg_pub.add;
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2680: fnd_message.set_token('ORG_NAME',p_organization_name);

2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677:
2678: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2679: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2680: fnd_message.set_token('ORG_NAME',p_organization_name);
2681: fnd_message.set_token('PAYROLL_DATE',p_effective_date);
2682: fnd_msg_pub.add;
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;
2684:

Line 2681: fnd_message.set_token('PAYROLL_DATE',p_effective_date);

2677:
2678: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2679: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2680: fnd_message.set_token('ORG_NAME',p_organization_name);
2681: fnd_message.set_token('PAYROLL_DATE',p_effective_date);
2682: fnd_msg_pub.add;
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;
2684:
2685: WHEN SUSPENSE_AC_INVALID THEN

Line 2690: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');

2686: /* Following added for bug 2514611 */
2687: OPEN employee_name_cur;
2688: FETCH employee_name_cur INTO l_employee_name;
2689: CLOSE employee_name_cur;
2690: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
2691: fnd_message.set_token('ORG_NAME',p_organization_name);
2692: fnd_message.set_token('PATC_STATUS',v_return_code);
2693: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
2694: fnd_msg_pub.add;

Line 2691: fnd_message.set_token('ORG_NAME',p_organization_name);

2687: OPEN employee_name_cur;
2688: FETCH employee_name_cur INTO l_employee_name;
2689: CLOSE employee_name_cur;
2690: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
2691: fnd_message.set_token('ORG_NAME',p_organization_name);
2692: fnd_message.set_token('PATC_STATUS',v_return_code);
2693: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
2694: fnd_msg_pub.add;
2695: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2692: fnd_message.set_token('PATC_STATUS',v_return_code);

2688: FETCH employee_name_cur INTO l_employee_name;
2689: CLOSE employee_name_cur;
2690: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
2691: fnd_message.set_token('ORG_NAME',p_organization_name);
2692: fnd_message.set_token('PATC_STATUS',v_return_code);
2693: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
2694: fnd_msg_pub.add;
2695: x_return_status := fnd_api.g_ret_sts_unexp_error;
2696:

Line 2693: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611

2689: CLOSE employee_name_cur;
2690: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
2691: fnd_message.set_token('ORG_NAME',p_organization_name);
2692: fnd_message.set_token('PATC_STATUS',v_return_code);
2693: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
2694: fnd_msg_pub.add;
2695: x_return_status := fnd_api.g_ret_sts_unexp_error;
2696:
2697: WHEN OTHERS THEN