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.9 2010/07/02 07:27:16 amakrish ship $ */
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 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 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 1792: l_api_name varchar2(30) := 'PSP_PREGEN';

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

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

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

2845: close check_code_combination_csr;
2846: return;
2847: End VALIDATE_GL_CC_ID;
2848:
2849: END PSP_PREGEN; -- End of Package Body