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 PSP_PREGEN

Line 1: PACKAGE BODY PSP_PREGEN AS

1: PACKAGE BODY PSP_PREGEN AS
2: /* $Header: PSPLDPGB.pls 120.8 2007/01/26 16:38:34 spchakra noship $ */
3: --
4:
5: -- Introduced the following for bug fix 2916848

Line 223: l_api_name varchar2(30) := 'PSP_PREGEN';

219: l_msg_count number;
220: l_msg_data varchar2(2000);
221: l_msg_index_out number;
222: --
223: l_api_name varchar2(30) := 'PSP_PREGEN';
224: l_subline_message varchar2(200);
225: --
226: l_ft_source_code varchar2(30);
227: l_ft_time_period_id number(15);

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 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 1789: l_api_name varchar2(30) := 'PSP_PREGEN';

1785: l_msg_count number;
1786: l_msg_data varchar2(2000);
1787: l_msg_index_out number;
1788: --
1789: l_api_name varchar2(30) := 'PSP_PREGEN';
1790: l_subline_message varchar2(200);
1791: --
1792:
1793: -- Auto-Population Variables

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 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 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;

Line 2846: END PSP_PREGEN; -- End of Package Body

2842: close check_code_combination_csr;
2843: return;
2844: End VALIDATE_GL_CC_ID;
2845:
2846: END PSP_PREGEN; -- End of Package Body