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 45: fnd_msg_pub.initialize;

41:
42: BEGIN
43: ---hr_utility.trace_on('Y','SandT');
44: g_error_api_path := '';
45: fnd_msg_pub.initialize;
46: psp_general.TRANSACTION_CHANGE_PURGEBLE;
47:
48: /* Following three variables initialized to faciliate calling mark_batch_end procedure
49: from GL_TIE_BACK procedure: Bug 1929317 */

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

255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
260: p_encoded => FND_API.G_FALSE,
261: p_data => l_msg_data,
262: p_msg_index_out => l_msg_count); */
263:

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

283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
288: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
289: p_encoded => FND_API.G_FALSE,
290: p_data => l_msg_data,
291: p_msg_index_out => l_msg_count); */

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

284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
288: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
289: p_encoded => FND_API.G_FALSE,
290: p_data => l_msg_data,
291: p_msg_index_out => l_msg_count); */
292:

Line 385: fnd_msg_pub.add;

381: if (l_ti_not_complete > 0) then
382: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
383: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
384: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
385: fnd_msg_pub.add;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: end if;
388:
389: end if;

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

393: /* Introduced as part of Bug fix #1776606 */
394: EXCEPTION
395: WHEN OTHERS THEN
396: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
397: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
398: p_return_status := fnd_api.g_ret_sts_unexp_error;
399: RAISE;
400: END;
401: -------------------- MARK BATCH END ---------------------------------------------

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

564: /* Introduced as part of Bug fix #1776606 */
565: EXCEPTION
566: WHEN OTHERS THEN
567: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
568: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
569: p_return_status := fnd_api.g_ret_sts_unexp_error;
570: RAISE;
571: END;
572: -------------------- CREATE GL SUM LINES -----------------------------------------------

Line 801: fnd_msg_pub.add;

797: l_table := 'PER_TIME_PERIODS';
798: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
799: fnd_message.set_token('VALUE',l_value);
800: fnd_message.set_token('TABLE',l_table);
801: fnd_msg_pub.add;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;
804:
805:

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

1039: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1040: p_return_status := fnd_api.g_ret_sts_unexp_error;
1041: WHEN OTHERS THEN
1042: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1043: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1044: p_return_status := fnd_api.g_ret_sts_unexp_error;
1045:
1046: END;
1047:

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

1188: EXCEPTION
1189: WHEN OTHERS THEN
1190: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1191: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1192: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1193: p_return_status := fnd_api.g_ret_sts_unexp_error;
1194: END;
1195:
1196: ------------------------ GL INTERFACE --------------------------------------------------

Line 1368: fnd_msg_pub.add;

1364: l_table := 'PER_TIME_PERIODS';
1365: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1366: fnd_message.set_token('VALUE',l_value);
1367: fnd_message.set_token('TABLE',l_table);
1368: fnd_msg_pub.add;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: END;
1371:
1372: If gl_batch_rec.phase = 'Summarize_GL_Lines' then --- added for 2444657

Line 1522: fnd_msg_pub.add;

1518:
1519: IF req_id = 0 THEN
1520:
1521: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1522: fnd_msg_pub.add;
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524:
1525: ELSE
1526:

Line 1548: fnd_msg_pub.add;

1544:
1545: IF call_status = FALSE THEN
1546:
1547: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1548: fnd_msg_pub.add;
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550:
1551: END IF;
1552:

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

1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: WHEN OTHERS THEN
1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:
1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1632: fnd_msg_pub.add;

1628: l_product := 'GL';
1629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1630: fnd_message.set_token('ERROR',l_error);
1631: fnd_message.set_token('PRODUCT',l_product);
1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');

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

1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1637: p_return_status := fnd_api.g_ret_sts_unexp_error;
1638: END;
1639:
1640: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 1657: fnd_msg_pub.add;

1653: l_product := 'GL';
1654: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1655: fnd_message.set_token('ERROR',l_error);
1656: fnd_message.set_token('PRODUCT',l_product);
1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN
1660: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1661: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');

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

1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN
1660: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1661: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1662: p_return_status := fnd_api.g_ret_sts_unexp_error;
1663: END;
1664:
1665: ---------------------- GET_ENCUM_TYPE_ID -----------------------------------------------

Line 1684: fnd_msg_pub.add;

1680: l_product := 'GL';
1681: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1682: fnd_message.set_token('ERROR',l_error);
1683: fnd_message.set_token('PRODUCT',l_product);
1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN
1687: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1688: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');

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

1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN
1687: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1688: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;
1690: END;
1691:
1692:

Line 1962: fnd_msg_pub.add;

1958:
1959: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
1960: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
1961: fnd_message.set_token('GROUP_ID',p_group_id);
1962: fnd_msg_pub.add;
1963: -- uncommented following statement for 2444657
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1965:
1966: end if;

Line 2180: fnd_msg_pub.add;

2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2179: fnd_message.set_token('EFF_DATE',l_distribution_date);
2180: fnd_msg_pub.add;
2181: else
2182: if l_acct_type = 'E' then
2183: l_expenditure_type := l_new_expenditure_type;
2184: else

Line 2264: fnd_msg_pub.add;

2260:
2261: IF l_reversal_ac_failed = 'Y' THEN
2262: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
2263: fnd_message.set_token('GLCCID',x_lines_glccid);
2264: fnd_msg_pub.add;
2265:
2266: /* Added the following for the Bug 3065866 */
2267:
2268: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 2319: fnd_msg_pub.add;

2315: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2316: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2317: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2318: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2319: fnd_msg_pub.add;
2320: end if;
2321:
2322: /* Added the following for Bug 3065866 */
2323:

Line 2372: fnd_msg_pub.add; */

2368: /* commented following code for 2479579
2369: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2370: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2371: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2372: fnd_msg_pub.add; */
2373:
2374: /* Introduced the following check as part of Bug fix #1776606 */
2375: if p_mode = 'N' then
2376: /* introduced mark batch end Bug: 1929317 */

Line 2525: fnd_msg_pub.add;

2521: /* Added Exceptions for bug 2056877 */
2522: WHEN NO_PROFILE_EXISTS THEN
2523: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2524: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2525: fnd_msg_pub.add;
2526: p_return_status := fnd_api.g_ret_sts_unexp_error;
2527:
2528: WHEN NO_VAL_DATE_MATCHES THEN
2529: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);

Line 2533: fnd_msg_pub.add;

2529: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2530: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2531: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2532: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2533: fnd_msg_pub.add;
2534: p_return_status := fnd_api.g_ret_sts_unexp_error;
2535:
2536: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2537: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);

Line 2541: fnd_msg_pub.add;

2537: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2538: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2539: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2540: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2541: fnd_msg_pub.add;
2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2543:
2544: WHEN OTHERS THEN
2545: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;

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

2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2543:
2544: WHEN OTHERS THEN
2545: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2546: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2547: p_return_status := fnd_api.g_ret_sts_unexp_error;
2548: END;
2549:
2550:

Line 2672: fnd_msg_pub.add;

2668: AND pdl.status_code = 'N';
2669:
2670: IF l_cr_amount <> l_dr_amount then
2671: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');
2672: fnd_msg_pub.add;
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2675:
2676: ELSIF p_source_type = 'P' THEN

Line 2691: fnd_msg_pub.add;

2687: AND payroll_id = l_payroll_id; -- Added for bug 5592964
2688: EXCEPTION
2689: WHEN NO_DATA_FOUND THEN
2690: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2691: fnd_msg_pub.add;
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: END;
2694:
2695: delete from psp_pre_gen_dist_lines

Line 2749: fnd_msg_pub.add;

2745: and pos.gl_code_combination_id is not null)); */
2746:
2747: IF l_cr_amount <> l_dr_amount then
2748: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');
2749: fnd_msg_pub.add;
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752:
2753: END IF;

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

2759: p_return_status := fnd_api.g_ret_sts_unexp_error;
2760:
2761: WHEN OTHERS THEN
2762: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2763: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2764: p_return_status := fnd_api.g_ret_sts_unexp_error;
2765: END;
2766:
2767: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

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

2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');
2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2937: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2938: p_return_status := fnd_api.g_ret_sts_unexp_error;
2939: END;
2940:
2941: -------------------- CREATE GMS SUM LINES -----------------------------------------------

Line 3199: fnd_msg_pub.add;

3195: l_table := 'PER_TIME_PERIODS';
3196: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3197: fnd_message.set_token('VALUE',l_value);
3198: fnd_message.set_token('TABLE',l_table);
3199: fnd_msg_pub.add;
3200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3201: END;
3202:
3203:

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

3454: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3455: p_return_status := fnd_api.g_ret_sts_unexp_error;
3456: WHEN OTHERS THEN
3457: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3458: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3459: p_return_status := fnd_api.g_ret_sts_unexp_error;
3460:
3461: END;
3462:

Line 3593: fnd_msg_pub.add;

3589: l_product := 'PA';
3590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3591: fnd_message.set_token('ERROR',l_error);
3592: fnd_message.set_token('PRODUCT',l_product);
3593: fnd_msg_pub.add;
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END;
3596:
3597: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859

Line 3610: fnd_msg_pub.add;

3606: l_product := 'GMS';
3607: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3608: fnd_message.set_token('ERROR',l_error);
3609: fnd_message.set_token('PRODUCT',l_product);
3610: fnd_msg_pub.add;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END;
3613: end if;
3614:

Line 3638: fnd_msg_pub.add;

3634: l_table := 'PER_TIME_PERIODS';
3635: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3636: fnd_message.set_token('VALUE',l_value);
3637: fnd_message.set_token('TABLE',l_table);
3638: fnd_msg_pub.add;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END;
3641:
3642: -- R12 MOAC Uptake .. org_id array to always populate 5090047

Line 3708: fnd_msg_pub.add;

3704: l_table := 'PER_PEOPLE_F';
3705: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3706: fnd_message.set_token('VALUE',l_value);
3707: fnd_message.set_token('TABLE',l_table);
3708: fnd_msg_pub.add;
3709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3710: END;
3711:
3712: -- get the employee's organization name

Line 3726: fnd_msg_pub.add;

3722: l_table := 'HR_ORGANIZATION_UNITS';
3723: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3724: fnd_message.set_token('VALUE',l_value);
3725: fnd_message.set_token('TABLE',l_table);
3726: fnd_msg_pub.add;
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: --l_org_name := NULL;
3729: --l_org_name := 'LDM_ORG_NAME_INVALID';
3730: END;

Line 3745: fnd_msg_pub.add;

3741: l_table := 'PA_PROJECTS_ALL';
3742: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3743: fnd_message.set_token('VALUE',l_value);
3744: fnd_message.set_token('TABLE',l_table);
3745: fnd_msg_pub.add;
3746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3747: END;
3748:
3749: -- R12 MOAC Uptake. Org_id is stored in psp_summary_line Table

Line 3764: fnd_msg_pub.add;

3760: l_table := 'PA_PROJECTS_ALL';
3761: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3762: fnd_message.set_token('VALUE',l_value);
3763: fnd_message.set_token('TABLE',l_table);
3764: fnd_msg_pub.add;
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766: END;
3767: */
3768:

Line 3782: fnd_msg_pub.add;

3778: l_table := 'PA_TASKS';
3779: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3780: fnd_message.set_token('VALUE',l_value);
3781: fnd_message.set_token('TABLE',l_table);
3782: fnd_msg_pub.add;
3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3784: END;
3785:
3786: -- Get the transaction_interface_id. We need this to populate the gms_interface table.

Line 3946: fnd_msg_pub.add;

3942: l_gms_batch_name);
3943:
3944: IF req_id = 0 THEN
3945: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3946: fnd_msg_pub.add;
3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3948: END IF;
3949: END LOOP;
3950: update psp_payroll_controls

Line 3962: fnd_msg_pub.add;

3958: call_status_tab(I) := fnd_concurrent.wait_for_request(req_id_tab(I), 20, 0,
3959: rphase, rstatus, dphase, dstatus, message);
3960: IF call_status_tab(I) = FALSE then
3961: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3962: fnd_msg_pub.add;
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: END IF;
3965: END LOOP;
3966: gms_batch_rec.phase := 'Submitted_TI_Request'; ---2444657

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

4028: p_return_status := fnd_api.g_ret_sts_success;
4029:
4030: WHEN OTHERS THEN
4031: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4032: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4033: p_return_status := fnd_api.g_ret_sts_unexp_error;
4034: END;
4035:
4036:

Line 4354: fnd_msg_pub.add;

4350: if (l_no_run_status = 'I') then
4351: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4352: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4353: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4354: fnd_msg_pub.add;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: end if;
4357: end if;
4358: hr_utility.trace('entered gms_tie_back2');

Line 4705: fnd_msg_pub.add;

4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
4704: fnd_message.set_token('EFF_DATE',l_distribution_date);
4705: fnd_msg_pub.add;
4706: else
4707: if l_acct_type = 'E' then
4708: l_expenditure_type := l_new_expenditure_type;
4709: else

Line 4786: fnd_msg_pub.add;

4782: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
4783: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4784: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4785: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
4786: fnd_msg_pub.add;
4787: end if;
4788:
4789: /* Added this code for Bug 3065866 */
4790: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 4839: fnd_msg_pub.add; */

4835: /* commented for 2479579
4836: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4837: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4838: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4839: fnd_msg_pub.add; */
4840:
4841: /* Added the following code for Bug 3065866 */
4842:
4843: IF p_source_type = 'O' OR p_source_type = 'N' THEN

Line 5064: fnd_msg_pub.add;

5060: /* Added Exceptions for bug 2056877 */
5061: WHEN NO_PROFILE_EXISTS THEN
5062: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5063: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5064: fnd_msg_pub.add;
5065: p_return_status := fnd_api.g_ret_sts_unexp_error;
5066:
5067: WHEN NO_VAL_DATE_MATCHES THEN
5068: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);

Line 5072: fnd_msg_pub.add;

5068: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5069: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5070: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5071: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5072: fnd_msg_pub.add;
5073: p_return_status := fnd_api.g_ret_sts_unexp_error;
5074:
5075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5076: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);

Line 5080: fnd_msg_pub.add;

5076: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5078: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5079: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5080: fnd_msg_pub.add;
5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5082:
5083: WHEN OTHERS THEN
5084: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;

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

5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5082:
5083: WHEN OTHERS THEN
5084: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5085: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5086: p_return_status := fnd_api.g_ret_sts_unexp_error;
5087: END;
5088:
5089: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------

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

5198:
5199: WHEN OTHERS THEN
5200: -- dbms_output.put_line('Error while inserting .........................');
5201: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5202: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5203: p_return_status := fnd_api.g_ret_sts_unexp_error;
5204: END;
5205:
5206: /* Created this procedure on 4-Nov-2004.

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

5855: EXCEPTION
5856: when others then
5857:
5858: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);
5859: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');
5860: raise;
5861: END GET_RECEIVER_TYPES;
5862:
5863: PROCEDURE CALL_WF(p_supercede_reqid_str in varchar2,

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

5960: itemkey => l_wf_itemkey);
5961: EXCEPTION
5962: when others then
5963: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);
5964: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');
5965: raise;
5966: END CALL_WF;
5967:
5968:

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

6079: end if;
6080: EXCEPTION
6081: when others then
6082: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);
6083: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');
6084: raise;
6085: END SEND_NOTIFICATIONS;
6086: BEGIN ----SUPERCEDE_ER
6087: --- comment trace.. debug

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

6449: hr_utility.trace( 'SandT_Supercede--> EXITING');
6450: EXCEPTION
6451: when others then
6452: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6454: p_return_status := fnd_api.g_ret_sts_unexp_error;
6455: END supercede_er;
6456:
6457: END PSP_SUM_TRANS;