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 320: fnd_message.set_name('PSP', 'PSP_PI_INVALID_CURRENCY');

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1024: l_subline_message := fnd_message.get;

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

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

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

Line 1030: l_subline_message := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

Line 2337: l_subline_message := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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