DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on FND_FILE

Line 834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

830: -- information correct has to be 'Yes'.
831: if p_info_crct_flag = 'N' then
832: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_SUB_VER_MAND_CP');
833: l_err_msg := FND_MESSAGE.GET;
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
835: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
836: l_err_count := l_err_count + 1;
837: end if;
838: -- Subcontractor verification is mandatory

Line 842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

838: -- Subcontractor verification is mandatory
839: if p_nil_return_flag = 'N' and p_subcont_verify_flag is null then
840: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_SUB_VER_MAND_CP');
841: l_err_msg := FND_MESSAGE.GET;
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
843: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
844: l_err_count := l_err_count + 1;
845: end if;
846: -- Employment Status declaration is mandatory

Line 850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

846: -- Employment Status declaration is mandatory
847: if p_nil_return_flag = 'N' and p_emp_status_flag is null then
848: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_EMP_STAT_MAND_CP');
849: l_err_msg := FND_MESSAGE.GET;
850: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
851: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
852: l_err_count := l_err_count + 1;
853: --IGI_CIS2007_EMP_STAT_MAND_CP
854: end if;

Line 871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

867: if l_period_allowed = 0 then
868: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_MTH_RET_NA');
869: FND_MESSAGE.SET_TOKEN('PERIOD', p_period_name);
870: l_err_msg := FND_MESSAGE.GET;
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
872: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
873: raise e_validation_exception;
874: End if;
875:

Line 897: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

893: If l_nil_ret_count > 0 then
894: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_NIL_RET_EXISTS');
895: FND_MESSAGE.SET_TOKEN('PERIOD_NAME', p_period_name);
896: l_err_msg := FND_MESSAGE.GET;
897: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
898: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
899: raise e_validation_exception;
900: End if;
901: --

Line 908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

904: If l_non_nil_ret_count > 0 then
905: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_MTH_RET_EXISTS');
906: FND_MESSAGE.SET_TOKEN('PERIOD_NAME', p_period_name);
907: l_err_msg := FND_MESSAGE.GET;
908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
909: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
910: raise e_validation_exception;
911: End if;
912: -- Procedure call to calculate the payments

Line 929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

925: if l_pay_count > 0 and p_nil_return_flag = 'Y' then
926: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_VENDORS_PAID');
927: FND_MESSAGE.SET_TOKEN('PERIOD', p_period_name);
928: l_err_msg := FND_MESSAGE.GET;
929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
930: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
931: raise e_validation_exception;
932: end if;
933: --

Line 940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);

936: if l_pay_count = 0 and p_nil_return_flag = 'N' then
937: FND_MESSAGE.SET_NAME('IGI','IGI_CIS2007_NO_VENDORS_PAID');
938: FND_MESSAGE.SET_TOKEN('PERIOD', p_period_name);
939: l_err_msg := FND_MESSAGE.GET;
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_err_msg);
941: l_err_all_msg := l_err_all_msg ||' '|| l_err_msg;
942: raise e_validation_exception;
943: end if;
944: --

Line 1026: FND_FILE.PUT_LINE(FND_FILE.LOG,l_err_msg);

1022: -- for debugging
1023: log(C_STATE_LEVEL, l_procedure_name, 'l_rep_ent_exist='||l_rep_ent_exist);
1024: if l_rep_ent_exist <> 1 then
1025: l_err_msg := 'Reporting Entites Not Found';
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,l_err_msg);
1027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_err_msg);
1028: raise e_rep_ent_not_found_error;
1029: End if;
1030: --

Line 1027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_err_msg);

1023: log(C_STATE_LEVEL, l_procedure_name, 'l_rep_ent_exist='||l_rep_ent_exist);
1024: if l_rep_ent_exist <> 1 then
1025: l_err_msg := 'Reporting Entites Not Found';
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,l_err_msg);
1027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_err_msg);
1028: raise e_rep_ent_not_found_error;
1029: End if;
1030: --
1031: -- populate the lines table

Line 1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'igi_cis_mth_ret_pay_t populate with '||SQL%ROWCOUNT);

1236: sysdate,
1237: FND_GLOBAL.USER_ID()
1238: from igi_cis_mth_ret_pay_gt;
1239: -- for debugging
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'igi_cis_mth_ret_pay_t populate with '||SQL%ROWCOUNT);
1241: commit;
1242: --
1243: -- submit the CP request to run the subcontractor deduction report
1244: --

Line 1355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records moved to History tables successfully ');

1351: if p_mth_ret_mode = 'F' then
1352: MOVE_TO_HISTORY(l_prelim_hdr_id, 'C');
1353: --- commit and run the report
1354: commit;
1355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records moved to History tables successfully ');
1356: --
1357: -- submit the CP request to run the subcontractor deduction report
1358: --
1359: IF (p_mth_report_template is NULL OR p_mth_report_format is NULL) THEN

Line 1431: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in processing' || sqlerrm);

1427: retcode := 2;
1428: log(C_STATE_LEVEL, l_procedure_name, 'END EXCEPTION 5='||errbuf);
1429: when others then
1430: -- for debugging
1431: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in processing' || sqlerrm);
1432: -- rollback the insert and updates
1433: rollback;
1434: errbuf := sqlerrm;
1435: retcode := 2;