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

Line 72: fnd_msg_pub.initialize;

68: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering sum_and_transfer ');
69:
70: ---hr_utility.trace_on('Y','SandT');
71: g_error_api_path := '';
72: fnd_msg_pub.initialize;
73: psp_general.TRANSACTION_CHANGE_PURGEBLE;
74:
75: /* Following three variables initialized to faciliate calling mark_batch_end procedure
76: from GL_TIE_BACK procedure: Bug 1929317 */

Line 311: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
312: p_encoded => FND_API.G_FALSE,
313: p_data => l_msg_data,
314: p_msg_index_out => l_msg_count); */
315:

Line 340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');

336: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
341: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
342: p_encoded => FND_API.G_FALSE,
343: p_data => l_msg_data,
344: p_msg_index_out => l_msg_count); */

Line 341: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
341: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
342: p_encoded => FND_API.G_FALSE,
343: p_data => l_msg_data,
344: p_msg_index_out => l_msg_count); */
345:

Line 438: fnd_msg_pub.add;

434: if (l_ti_not_complete > 0) then
435: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
436: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
437: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
438: fnd_msg_pub.add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: end if;
441:
442: end if;

Line 452: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');

448: WHEN OTHERS THEN
449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
450:
451: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
452: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
453: p_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE;
455: END;
456: -------------------- MARK BATCH END ---------------------------------------------

Line 625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');

621: WHEN OTHERS THEN
622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
623:
624: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
626: p_return_status := fnd_api.g_ret_sts_unexp_error;
627: RAISE;
628: END;
629: -------------------- CREATE GL SUM LINES -----------------------------------------------

Line 860: fnd_msg_pub.add;

856: l_table := 'PER_TIME_PERIODS';
857: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
858: fnd_message.set_token('VALUE',l_value);
859: fnd_message.set_token('TABLE',l_table);
860: fnd_msg_pub.add;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;
863:
864:

Line 1126: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');

1122: WHEN OTHERS THEN
1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1124:
1125: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1126: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1127: p_return_status := fnd_api.g_ret_sts_unexp_error;
1128:
1129: END;
1130:

Line 1277: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');

1273: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1274:
1275: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1276: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1277: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1278: p_return_status := fnd_api.g_ret_sts_unexp_error;
1279: END;
1280:
1281: ------------------------ GL INTERFACE --------------------------------------------------

Line 1455: fnd_msg_pub.add;

1451: l_table := 'PER_TIME_PERIODS';
1452: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1453: fnd_message.set_token('VALUE',l_value);
1454: fnd_message.set_token('TABLE',l_table);
1455: fnd_msg_pub.add;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;
1458:
1459: If gl_batch_rec.phase = 'Summarize_GL_Lines' then --- added for 2444657

Line 1620: fnd_msg_pub.add;

1616:
1617: IF req_id = 0 THEN
1618:
1619: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1620: fnd_msg_pub.add;
1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1622:
1623: ELSE
1624:

Line 1648: fnd_msg_pub.add;

1644:
1645: IF call_status = FALSE THEN
1646:
1647: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1648: fnd_msg_pub.add;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650:
1651: END IF;
1652:

Line 1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');

1711: WHEN OTHERS THEN
1712: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1713:
1714: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1716: p_return_status := fnd_api.g_ret_sts_unexp_error;
1717: END;
1718:
1719: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1736: fnd_msg_pub.add;

1732: l_product := 'GL';
1733: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1734: fnd_message.set_token('ERROR',l_error);
1735: fnd_message.set_token('PRODUCT',l_product);
1736: fnd_msg_pub.add;
1737: p_return_status := fnd_api.g_ret_sts_unexp_error;
1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:

Line 1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');

1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1743: p_return_status := fnd_api.g_ret_sts_unexp_error;
1744: END;
1745:
1746: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 1763: fnd_msg_pub.add;

1759: l_product := 'GL';
1760: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1761: fnd_message.set_token('ERROR',l_error);
1762: fnd_message.set_token('PRODUCT',l_product);
1763: fnd_msg_pub.add;
1764: p_return_status := fnd_api.g_ret_sts_unexp_error;
1765: WHEN OTHERS THEN
1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1767:

Line 1769: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');

1765: WHEN OTHERS THEN
1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1767:
1768: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1769: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1770: p_return_status := fnd_api.g_ret_sts_unexp_error;
1771: END;
1772:
1773: ---------------------- GET_ENCUM_TYPE_ID -----------------------------------------------

Line 1792: fnd_msg_pub.add;

1788: l_product := 'GL';
1789: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1790: fnd_message.set_token('ERROR',l_error);
1791: fnd_message.set_token('PRODUCT',l_product);
1792: fnd_msg_pub.add;
1793: p_return_status := fnd_api.g_ret_sts_unexp_error;
1794: WHEN OTHERS THEN
1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1796:

Line 1798: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');

1794: WHEN OTHERS THEN
1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1796:
1797: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1798: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1799: p_return_status := fnd_api.g_ret_sts_unexp_error;
1800: END;
1801:
1802:

Line 2086: fnd_msg_pub.add;

2082:
2083: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
2084: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
2085: fnd_message.set_token('GROUP_ID',p_group_id);
2086: fnd_msg_pub.add;
2087: -- uncommented following statement for 2444657
2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2089:
2090: end if;

Line 2307: fnd_msg_pub.add;

2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2306: fnd_message.set_token('EFF_DATE',l_distribution_date);
2307: fnd_msg_pub.add;
2308: else
2309: if l_acct_type = 'E' then
2310: l_expenditure_type := l_new_expenditure_type;
2311: else

Line 2398: fnd_msg_pub.add;

2394:
2395: IF l_reversal_ac_failed = 'Y' THEN
2396: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
2397: fnd_message.set_token('GLCCID',x_lines_glccid);
2398: fnd_msg_pub.add;
2399:
2400: /* Added the following for the Bug 3065866 */
2401:
2402: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 2464: fnd_msg_pub.add;

2460: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2461: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2462: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2463: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2464: fnd_msg_pub.add;
2465: end if;
2466:
2467: /* Added the following for Bug 3065866 */
2468:

Line 2529: fnd_msg_pub.add; */

2525: /* commented following code for 2479579
2526: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2527: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2528: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2529: fnd_msg_pub.add; */
2530:
2531: /* Introduced the following check as part of Bug fix #1776606 */
2532: if p_mode = 'N' then
2533: /* introduced mark batch end Bug: 1929317 */

Line 2701: fnd_msg_pub.add;

2697: /* Added Exceptions for bug 2056877 */
2698: WHEN NO_PROFILE_EXISTS THEN
2699: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2700: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2701: fnd_msg_pub.add;
2702: p_return_status := fnd_api.g_ret_sts_unexp_error;
2703:
2704: WHEN NO_VAL_DATE_MATCHES THEN
2705: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);

Line 2709: fnd_msg_pub.add;

2705: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2707: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2708: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2709: fnd_msg_pub.add;
2710: p_return_status := fnd_api.g_ret_sts_unexp_error;
2711:
2712: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2713: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);

Line 2717: fnd_msg_pub.add;

2713: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2715: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2716: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2717: fnd_msg_pub.add;
2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2719:
2720: WHEN OTHERS THEN
2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 2724: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');

2720: WHEN OTHERS THEN
2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2722:
2723: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2724: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2725: p_return_status := fnd_api.g_ret_sts_unexp_error;
2726: END;
2727:
2728:

Line 2850: fnd_msg_pub.add;

2846: AND pdl.status_code = 'N';
2847:
2848: IF l_cr_amount <> l_dr_amount then
2849: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');
2850: fnd_msg_pub.add;
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2852: END IF;
2853:
2854: ELSIF p_source_type = 'P' THEN

Line 2869: fnd_msg_pub.add;

2865: AND payroll_id = l_payroll_id; -- Added for bug 5592964
2866: EXCEPTION
2867: WHEN NO_DATA_FOUND THEN
2868: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2869: fnd_msg_pub.add;
2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2871: END;
2872:
2873: delete from psp_pre_gen_dist_lines

Line 2927: fnd_msg_pub.add;

2923: and pos.gl_code_combination_id is not null)); */
2924:
2925: IF l_cr_amount <> l_dr_amount then
2926: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');
2927: fnd_msg_pub.add;
2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930:
2931: END IF;

Line 2943: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');

2939: WHEN OTHERS THEN
2940: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2941:
2942: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2943: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2944: p_return_status := fnd_api.g_ret_sts_unexp_error;
2945: END;
2946:
2947: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

Line 3119: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');

3115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3116:
3117: --dbms_output.put_line('Error while inserting .........................');
3118: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
3119: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
3120: p_return_status := fnd_api.g_ret_sts_unexp_error;
3121: END;
3122:
3123: -------------------- CREATE GMS SUM LINES -----------------------------------------------

Line 3384: fnd_msg_pub.add;

3380: l_table := 'PER_TIME_PERIODS';
3381: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3382: fnd_message.set_token('VALUE',l_value);
3383: fnd_message.set_token('TABLE',l_table);
3384: fnd_msg_pub.add;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3386: END;
3387:
3388: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' opening gms_sum_lines_cursor');

Line 3649: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');

3645: WHEN OTHERS THEN
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3647:
3648: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3649: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3650: p_return_status := fnd_api.g_ret_sts_unexp_error;
3651:
3652: END;
3653:

Line 3786: fnd_msg_pub.add;

3782: l_product := 'PA';
3783: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3784: fnd_message.set_token('ERROR',l_error);
3785: fnd_message.set_token('PRODUCT',l_product);
3786: fnd_msg_pub.add;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3788: END;
3789:
3790: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859

Line 3803: fnd_msg_pub.add;

3799: l_product := 'GMS';
3800: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3801: fnd_message.set_token('ERROR',l_error);
3802: fnd_message.set_token('PRODUCT',l_product);
3803: fnd_msg_pub.add;
3804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3805: END;
3806: end if;
3807:

Line 3833: fnd_msg_pub.add;

3829: l_table := 'PER_TIME_PERIODS';
3830: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3831: fnd_message.set_token('VALUE',l_value);
3832: fnd_message.set_token('TABLE',l_table);
3833: fnd_msg_pub.add;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END;
3836:
3837: -- R12 MOAC Uptake .. org_id array to always populate 5090047

Line 3908: fnd_msg_pub.add;

3904: l_table := 'PER_PEOPLE_F';
3905: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3906: fnd_message.set_token('VALUE',l_value);
3907: fnd_message.set_token('TABLE',l_table);
3908: fnd_msg_pub.add;
3909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3910: END;
3911:
3912: -- get the employee's organization name

Line 3926: fnd_msg_pub.add;

3922: l_table := 'HR_ORGANIZATION_UNITS';
3923: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3924: fnd_message.set_token('VALUE',l_value);
3925: fnd_message.set_token('TABLE',l_table);
3926: fnd_msg_pub.add;
3927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3928: --l_org_name := NULL;
3929: --l_org_name := 'LDM_ORG_NAME_INVALID';
3930: END;

Line 3945: fnd_msg_pub.add;

3941: l_table := 'PA_PROJECTS_ALL';
3942: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3943: fnd_message.set_token('VALUE',l_value);
3944: fnd_message.set_token('TABLE',l_table);
3945: fnd_msg_pub.add;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;
3948:
3949: -- R12 MOAC Uptake. Org_id is stored in psp_summary_line Table

Line 3964: fnd_msg_pub.add;

3960: l_table := 'PA_PROJECTS_ALL';
3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3962: fnd_message.set_token('VALUE',l_value);
3963: fnd_message.set_token('TABLE',l_table);
3964: fnd_msg_pub.add;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END;
3967: */
3968:

Line 3982: fnd_msg_pub.add;

3978: l_table := 'PA_TASKS';
3979: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3980: fnd_message.set_token('VALUE',l_value);
3981: fnd_message.set_token('TABLE',l_table);
3982: fnd_msg_pub.add;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END;
3985:
3986: -- Get the transaction_interface_id. We need this to populate the gms_interface table.

Line 4195: fnd_msg_pub.add;

4191: l_gms_batch_name);
4192:
4193: IF req_id = 0 THEN
4194: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4195: fnd_msg_pub.add;
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: END IF;
4198: END LOOP;
4199:

Line 4218: fnd_msg_pub.add;

4214: call_status_tab(I) := fnd_concurrent.wait_for_request(req_id_tab(I), 20, 0,
4215: rphase, rstatus, dphase, dstatus, message);
4216: IF call_status_tab(I) = FALSE then
4217: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4218: fnd_msg_pub.add;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END IF;
4221: END LOOP;
4222:

Line 4295: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');

4291: WHEN OTHERS THEN
4292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4293:
4294: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4295: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4296: p_return_status := fnd_api.g_ret_sts_unexp_error;
4297: END;
4298:
4299:

Line 4633: fnd_msg_pub.add;

4629: if (l_no_run_status = 'I') then
4630: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4631: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4632: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4633: fnd_msg_pub.add;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4635: end if;
4636: end if;
4637: hr_utility.trace('entered gms_tie_back2');

Line 5042: fnd_msg_pub.add;

5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
5041: fnd_message.set_token('EFF_DATE',l_distribution_date);
5042: fnd_msg_pub.add;
5043: else
5044: if l_acct_type = 'E' then
5045: l_expenditure_type := l_new_expenditure_type;
5046: else

Line 5140: fnd_msg_pub.add;

5136: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5137: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5138: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5139: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5140: fnd_msg_pub.add;
5141: end if;
5142:
5143: /* Added this code for Bug 3065866 */
5144: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 5204: fnd_msg_pub.add; */

5200: /* commented for 2479579
5201: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5202: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5203: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5204: fnd_msg_pub.add; */
5205:
5206: /* Added the following code for Bug 3065866 */
5207:
5208: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 5473: fnd_msg_pub.add;

5469: /* Added Exceptions for bug 2056877 */
5470: WHEN NO_PROFILE_EXISTS THEN
5471: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5472: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5473: fnd_msg_pub.add;
5474: p_return_status := fnd_api.g_ret_sts_unexp_error;
5475:
5476: WHEN NO_VAL_DATE_MATCHES THEN
5477: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);

Line 5481: fnd_msg_pub.add;

5477: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5479: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5480: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5481: fnd_msg_pub.add;
5482: p_return_status := fnd_api.g_ret_sts_unexp_error;
5483:
5484: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5485: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);

Line 5489: fnd_msg_pub.add;

5485: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5487: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5488: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5489: fnd_msg_pub.add;
5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5491:
5492: WHEN OTHERS THEN
5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 5495: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');

5491:
5492: WHEN OTHERS THEN
5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5494: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5495: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5496: p_return_status := fnd_api.g_ret_sts_unexp_error;
5497: END;
5498:
5499: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------

Line 5625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');

5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5623: -- dbms_output.put_line('Error while inserting .........................');
5624: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5626: p_return_status := fnd_api.g_ret_sts_unexp_error;
5627: END;
5628:
5629: /* Created this procedure on 4-Nov-2004.

Line 6282: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');

6278: EXCEPTION
6279: when others then
6280: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6281: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);
6282: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');
6283: raise;
6284: END GET_RECEIVER_TYPES;
6285:
6286: PROCEDURE CALL_WF(p_supercede_reqid_str in varchar2,

Line 6389: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');

6385: when others then
6386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6387:
6388: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);
6389: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');
6390: raise;
6391: END CALL_WF;
6392:
6393:

Line 6510: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');

6506: when others then
6507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6508:
6509: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);
6510: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');
6511: raise;
6512: END SEND_NOTIFICATIONS;
6513: BEGIN ----SUPERCEDE_ER
6514: --- comment trace.. debug

Line 6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');

6877: EXCEPTION
6878: when others then
6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6882: p_return_status := fnd_api.g_ret_sts_unexp_error;
6883: END supercede_er;
6884:
6885: END PSP_SUM_TRANS;