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_MSG_PUB

Line 261: FND_MSG_PUB.Initialize;

257:
258: BEGIN
259: ---hr_utility.trace_on('Y', 'PREGEN');
260: g_use_pre_gen_suspense := FND_PROFILE.VALUE('PSP_USE_PREGEN_SUSPENSE'); -- Bug 2007521
261: FND_MSG_PUB.Initialize;
262: --dbms_output.PUT_LINE('................0');
263:
264: -- l_set_of_books_id := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS');
265: l_set_of_books_id := p_set_of_books_id;

Line 269: fnd_msg_pub.add;

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:
273: Begin

Line 319: fnd_msg_pub.add;

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:
323: OPEN currency_code_cur;

Line 394: fnd_msg_pub.add;

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:
398: /* Bug 2007521: Optimization, Run this part only if autopop is OFF */

Line 704: fnd_msg_pub.add;

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
708: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 811: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while inserting data');

807: WHERE batch_name = p_batch_name and
808: T.time_period_id = a.time_period_id and
809: susp.organization_account_id(+) = a.suspense_org_account_id;
810: if sql%NOTFOUND then
811: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while inserting data');
812: raise FND_API.G_EXC_UNEXPECTED_ERROR;
813: end if;
814: --dbms_output.PUT_LINE('...Crossed First Insert ' );
815: --dbms_output.PUT_LINE('...L_gl_count ' || to_char(l_gl_count) );

Line 825: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while Updating Transfer status ');

821: SET status_code = 'T'
822: WHERE batch_name = p_batch_name;
823: --dbms_output.PUT_LINE('...Crossed Update ' );
824: if sql%NOTFOUND then
825: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while Updating Transfer status ');
826: raise FND_API.G_EXC_UNEXPECTED_ERROR;
827: end if;
828:
829: -- Total up all records by source_code, time_period_id to write into payroll_control table

Line 903: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while inserting data in Payroll Controls');

899: -- Introduced the following for bug fix 2916848
900: x_currency_code => g_currency_code,
901: x_exchange_rate_type => l_exchange_rate_type);
902: if sql%NOTFOUND then
903: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while inserting data in Payroll Controls');
904: raise FND_API.G_EXC_UNEXPECTED_ERROR;
905: end if;
906: --dbms_output.PUT_LINE('...Before Updating control_id in pre gen ' );
907: UPDATE psp_pre_gen_dist_lines

Line 916: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while updating control_id in pre-gen-dist-lines ');

912: source_code = l_ft_source_code and
913: set_of_books_id= l_set_of_books_id and
914: business_group_id = p_business_group_id;
915: if sql%NOTFOUND then
916: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while updating control_id in pre-gen-dist-lines ');
917: raise FND_API.G_EXC_UNEXPECTED_ERROR;
918: end if;
919:
920: l_ft_source_code := g_for_total_rec.source_code;

Line 991: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while inserting data in Payroll Controls');

987: x_currency_code => g_currency_code,
988: x_exchange_rate_type => l_exchange_rate_type);
989:
990: if sql%NOTFOUND then
991: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while inserting data in Payroll Controls');
992: raise FND_API.G_EXC_UNEXPECTED_ERROR;
993: end if;
994: --dbms_output.PUT_LINE('...Before Updating control_id in pre gen ' );
995: UPDATE psp_pre_gen_dist_lines

Line 1004: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while updating control_id in pre-gen-dist-lines ');

1000: source_code = l_ft_source_code and
1001: set_of_books_id= l_set_of_books_id and
1002: business_group_id = p_business_group_id;
1003: if sql%NOTFOUND then
1004: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Error while updating control_id in pre-gen-dist-lines ');
1005: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1006: end if;
1007: close get_for_total_csr;
1008: end if;

Line 1031: fnd_msg_pub.add;

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);
1035: PSP_MESSAGE_S.Print_Success;

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

1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1039: ----dbms_output.put_line('Unexpected Error...........');
1040: /*
1041: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1042: p_encoded => FND_API.G_FALSE,
1043: p_data => l_msg_data,
1044: p_msg_index_out => l_msg_count);
1045:

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

1052: return;
1053: WHEN OTHERS then
1054: ----dbms_output.put_line('When others Error...........');
1055: /*
1056: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1057: p_encoded => FND_API.G_FALSE,
1058: p_data => l_msg_data,
1059: p_msg_index_out => l_msg_count);
1060:

Line 1141: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Person_id : Unexpected Error');

1137: x_return_code := 'INV_PER';
1138: close check_person_csr;
1139: return;
1140: when OTHERS then
1141: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Person_id : Unexpected Error');
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: x_return_code := 'OTHER';
1144: close check_person_csr;
1145: End Validate_Person_ID;

Line 1190: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Assignment_id : Unexpected Error');

1186: x_return_code := 'INV_ASG';
1187: close check_assg_csr;
1188: return;
1189: when OTHERS then
1190: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Assignment_id : Unexpected Error');
1191: x_return_status := FND_API.G_RET_STS_ERROR;
1192: x_return_code := 'OTHER';
1193: close check_assg_csr;
1194: End Validate_Assignment_ID;

Line 1248: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Payroll_id : Unexpected Error');

1244: close check_payroll_csr;
1245: return;
1246: when OTHERS then
1247: ----dbms_output.put_line('OTHERS ');
1248: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Payroll_id : Unexpected Error');
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: x_return_code := 'OTHER';
1251: close check_payroll_csr;
1252: return;

Line 1294: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Period_id : Unexpected Error');

1290: x_return_code := 'INV_TPI';
1291: close check_period_csr;
1292: return;
1293: when OTHERS then
1294: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Period_id : Unexpected Error');
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: x_return_code := 'OTHER';
1297: close check_period_csr;
1298: return;

Line 1336: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Payroll_Source_Code : Unexpected Error');

1332: close check_source_csr;
1333: return;
1334: when OTHERS then
1335: --dbms_output.PUT_LINE('Enter Too_many_rows....8');
1336: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Payroll_Source_Code : Unexpected Error');
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: x_return_code := 'OTHER';
1339: close check_source_csr;
1340: return;

Line 1397: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Element_Type_Id : Unexpected Error');

1393: x_return_code := 'INV_ELE';
1394: close check_element_csr;
1395: return;
1396: when OTHERS then
1397: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Element_Type_Id : Unexpected Error');
1398: x_return_status := FND_API.G_RET_STS_ERROR;
1399: x_return_code := 'OTHER';
1400: close check_element_csr;
1401: return;

Line 1606: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Project_Details : Unexpected Error');

1602: ************************************************************************************/
1603:
1604: EXCEPTION
1605: when OTHERS then
1606: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Validate_Project_Details : Unexpected Error');
1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608: x_return_code := 'OTHER';
1609: /*************************************************************************************
1610: Commenting for bug 2096440

Line 1647: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_error : Error while updating');

1643: --dbms_output.PUT_LINE('.....Update Record With Error ');
1644: x_return_status := FND_API.G_RET_STS_SUCCESS;
1645: EXCEPTION
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1647: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_error : Error while updating');
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: WHEN OTHERS then
1650: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_error : Unexpected error');
1651: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1650: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_error : Unexpected error');

1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1647: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_error : Error while updating');
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: WHEN OTHERS then
1650: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_error : Unexpected error');
1651: x_return_status := FND_API.G_RET_STS_ERROR;
1652:
1653: end;
1654: --

Line 1673: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_valid : Error while updating');

1669:
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1673: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_valid : Error while updating');
1674: x_return_status := FND_API.G_RET_STS_ERROR;
1675: WHEN OTHERS then
1676: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_valid : Unexpected error');
1677: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1676: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_valid : Unexpected error');

1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1673: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_valid : Error while updating');
1674: x_return_status := FND_API.G_RET_STS_ERROR;
1675: WHEN OTHERS then
1676: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_valid : Unexpected error');
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678:
1679: end;
1680: --

Line 1736: -- fnd_msg_pub.add_exc_msg('PSP_PREGEN','GET_LEAST_DATE');

1732: end if;
1733: --
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: -- fnd_msg_pub.add_exc_msg('PSP_PREGEN','GET_LEAST_DATE');
1737: return x_distribution_date;
1738: END get_least_date;
1739: --
1740:

Line 1818: fnd_msg_pub.add;

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:
1822: open get_all_from_interface_csr;

Line 2323: fnd_msg_pub.add;

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;
2327: end if;

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

2338:
2339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2340: ----dbms_output.put_line('Unexpected Error...........');
2341: /*******************************************************************************************************
2342: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2343: p_encoded => FND_API.G_FALSE,
2344: p_data => l_msg_data,
2345: p_msg_index_out => l_msg_count);
2346:

Line 2350: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Autopop-Unexpected Error');

2346:
2347: Printed from Message Stack
2348: **********************************************************************************************************/
2349: -- errbuf := SUBSTR(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10),1,230);
2350: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Autopop-Unexpected Error');
2351: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2352:
2353: rollback;
2354: return;

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

2355: WHEN OTHERS then
2356: ----dbms_output.put_line('When others Error...........');
2357:
2358: /*********************************************************************************************************
2359: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2360: p_encoded => FND_API.G_FALSE,
2361: p_data => l_msg_data,
2362: p_msg_index_out => l_msg_count);
2363: -- errbuf := SUBSTR(l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10),1,230);

Line 2368: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Autopop-Error');

2364:
2365: printed from mesasge stack
2366: **********************************************************************************************************/
2367: rollback;
2368: fnd_msg_pub.add_exc_msg('PSP_PREGEN','Autopop-Error');
2369: x_return_status := FND_API.G_RET_STS_ERROR;
2370: --- x_retcode := 2;
2371: return;
2372: END Autopop;

Line 2395: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_exp : Error while updating');

2391:
2392: x_return_status := FND_API.G_RET_STS_SUCCESS;
2393: EXCEPTION
2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2395: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_exp : Error while updating');
2396: x_return_status := FND_API.G_RET_STS_ERROR;
2397: WHEN OTHERS then
2398: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_exp : Unexpected error');
2399: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2398: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_exp : Unexpected error');

2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2395: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_exp : Error while updating');
2396: x_return_status := FND_API.G_RET_STS_ERROR;
2397: WHEN OTHERS then
2398: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_exp : Unexpected error');
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400:
2401: end;
2402:

Line 2423: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_na : Error while updating');

2419:
2420: x_return_status := FND_API.G_RET_STS_SUCCESS;
2421: EXCEPTION
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2423: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_na : Error while updating');
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425: WHEN OTHERS then
2426: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_na : Unexpected error');
2427: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2426: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_na : Unexpected error');

2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2423: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_na : Error while updating');
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425: WHEN OTHERS then
2426: fnd_msg_pub.add_exc_msg('PSP_PREGEN','update_record_with_na : Unexpected error');
2427: x_return_status := FND_API.G_RET_STS_ERROR;
2428:
2429: end;
2430:

Line 2631: fnd_msg_pub.add;

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;
2635: x_suspense_auto_exp_type := l_new_exp_type;

Line 2668: fnd_msg_pub.add;

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

Line 2675: fnd_msg_pub.add;

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

Line 2682: fnd_msg_pub.add;

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
2686: /* Following added for bug 2514611 */

Line 2694: fnd_msg_pub.add;

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
2698: if org_suspense_cur%isopen then

Line 2704: fnd_msg_pub.add_exc_msg('PSP_PREGEN','GET_SUSPENSE_ACCOUNT');

2700: end if;
2701: if org_suspense_cur2%isopen then
2702: close org_suspense_cur2;
2703: end if;
2704: fnd_msg_pub.add_exc_msg('PSP_PREGEN','GET_SUSPENSE_ACCOUNT');
2705: x_return_status := fnd_api.g_ret_sts_unexp_error;
2706: END;
2707: ---================================= STICK_SUSPENSE_ACCOUNT ===================
2708: /* Bug fix 2007521: Created this procedure.

Line 2776: fnd_msg_pub.add_exc_msg('PSP_PREGEN','STICK_SUSPENSE_ACCOUNT-(Assign ORG)');

2772: end if;
2773: p_return_status := FND_API.G_RET_STS_SUCCESS;
2774: EXCEPTION
2775: When ASSIGN_ORG_NOT_FOUND then
2776: fnd_msg_pub.add_exc_msg('PSP_PREGEN','STICK_SUSPENSE_ACCOUNT-(Assign ORG)');
2777: p_return_status := fnd_api.g_ret_sts_unexp_error;
2778: When others then
2779: if org_name_cur%isopen then
2780: close org_name_cur;

Line 2782: fnd_msg_pub.add_exc_msg('PSP_PREGEN','STICK_SUSPENSE_ACCOUNT');

2778: When others then
2779: if org_name_cur%isopen then
2780: close org_name_cur;
2781: end if;
2782: fnd_msg_pub.add_exc_msg('PSP_PREGEN','STICK_SUSPENSE_ACCOUNT');
2783: p_return_status := fnd_api.g_ret_sts_unexp_error;
2784: END;
2785:
2786: /* Bug fix 2985061: Created this procedure.

Line 2802: fnd_msg_pub.add_exc_msg('PSP_PREGEN','VALIDATE_DR_CR_FLAG : Unexpected Error');

2798: x_return_code := 'INV_D_C';
2799: end if;
2800: EXCEPTION
2801: when OTHERS then
2802: fnd_msg_pub.add_exc_msg('PSP_PREGEN','VALIDATE_DR_CR_FLAG : Unexpected Error');
2803: x_return_status := FND_API.G_RET_STS_ERROR;
2804: x_return_code := 'OTHER';
2805: return;
2806: END VALIDATE_DR_CR_FLAG;

Line 2839: fnd_msg_pub.add_exc_msg('PSP_PREGEN','VALIDATE_GL_CODE_COMBINATION_ID : Unexpected Error');

2835: x_return_code := 'INV_GLC';
2836: close check_code_combination_csr;
2837: return;
2838: when OTHERS then
2839: fnd_msg_pub.add_exc_msg('PSP_PREGEN','VALIDATE_GL_CODE_COMBINATION_ID : Unexpected Error');
2840: x_return_status := FND_API.G_RET_STS_ERROR;
2841: x_return_code := 'OTHER';
2842: close check_code_combination_csr;
2843: return;