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: -- Commented for bug 9857299

Line 322: fnd_msg_pub.add;

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

Line 397: fnd_msg_pub.add;

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

Line 707: fnd_msg_pub.add;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1034: fnd_msg_pub.add;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1821: fnd_msg_pub.add;

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

Line 2326: fnd_msg_pub.add;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2634: fnd_msg_pub.add;

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

Line 2671: fnd_msg_pub.add;

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

Line 2678: fnd_msg_pub.add;

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

Line 2685: fnd_msg_pub.add;

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

Line 2697: fnd_msg_pub.add;

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

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

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

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

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

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

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

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

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

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

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