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.IGS_AD_IMP_006 dependencies on FND_LOG

Line 146: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

142: l_rowid VARCHAR2(25);
143: l_error_code IGS_AD_EMP_INT.Error_Code%TYPE;
144: BEGIN
145:
146: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
147:
148: IF (l_request_id IS NULL) THEN
149: l_request_id := fnd_global.conc_request_id;
150: END IF;

Line 155: fnd_log.string_with_context( fnd_log.level_procedure,

151:
152: l_label := 'igs.plsql.igs_ad_imp_006.crt_pe_alias.begin';
153: l_debug_str := 'Interface Alias Id : ' || person_alias_rec.INTERFACE_ALIAS_ID;
154:
155: fnd_log.string_with_context( fnd_log.level_procedure,
156: l_label,
157: l_debug_str, NULL,
158: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
159: END IF;

Line 198: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

194: SET ERROR_CODE = 'E322',
195: STATUS = '3'
196: WHERE INTERFACE_ALIAS_ID = person_alias_rec.INTERFACE_ALIAS_ID;
197:
198: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
199:
200: IF (l_request_id IS NULL) THEN
201: l_request_id := fnd_global.conc_request_id;
202: END IF;

Line 210: fnd_log.string_with_context( fnd_log.level_exception,

206: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Alias.Crt_Pe_Alias ' ||
207: 'Interface Alias Id : ' || person_alias_rec.INTERFACE_ALIAS_ID ||
208: ' Status : 3 ' || 'ErrorCode : E322 ' || SQLERRM;
209:
210: fnd_log.string_with_context( fnd_log.level_exception,
211: l_label,
212: l_debug_str, NULL,
213: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
214: END IF;

Line 502: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

498:
499: l_employer_party_id NUMBER;
500: BEGIN
501:
502: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
503: IF (l_request_id IS NULL) THEN
504: l_request_id := fnd_global.conc_request_id;
505: END IF;
506: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.begin';

Line 508: fnd_log.string_with_context( fnd_log.level_procedure,

504: l_request_id := fnd_global.conc_request_id;
505: END IF;
506: l_label := 'igs.plsql.igs_ad_imp_006.crt_emp_dtls.begin';
507: l_debug_str := 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id;
508: fnd_log.string_with_context( fnd_log.level_procedure,
509: l_label,
510: l_debug_str, NULL,
511: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
512: );

Line 554: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

550: SET status = '3',
551: error_code = 'E322'
552: WHERE INTERFACE_EMP_ID = PERSON_EMP_REC.INTERFACE_EMP_ID;
553:
554: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
555: IF (l_request_id IS NULL) THEN
556: l_request_id := fnd_global.conc_request_id;
557: END IF;
558:

Line 565: fnd_log.string_with_context( fnd_log.level_exception,

561: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls.crt_emp_dtls ' ||
562: 'INTERFACE Emp Id : ' || IGS_GE_NUMBER.TO_CANN(Person_Emp_Rec.Interface_Emp_Id) ||
563: ' Status : 3 ' || 'ErrorCode : E322 '|| l_msg_data;
564:
565: fnd_log.string_with_context( fnd_log.level_exception,
566: l_label,
567: l_debug_str, NULL,
568: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
569: END IF;

Line 795: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

791: SET error_code = 'E014',
792: status = '3'
793: WHERE interface_emp_id = person_emp_rec.interface_emp_id;
794:
795: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
796:
797: IF (l_request_id IS NULL) THEN
798: l_request_id := fnd_global.conc_request_id;
799: END IF;

Line 807: fnd_log.string_with_context( fnd_log.level_exception,

803: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
804: 'INTERFACE Emp Id : ' || IGS_GE_NUMBER.TO_CANN(Person_Emp_Rec.Interface_Emp_Id) ||
805: ' Status : 3 ' || 'ErrorCode : E014 '||l_msg_data;
806:
807: fnd_log.string_with_context( fnd_log.level_exception,
808: l_label,
809: l_debug_str, NULL,
810: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
811: END IF;

Line 831: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

827: SET ERROR_CODE = 'E014',
828: STATUS = '3'
829: WHERE interface_emp_id = person_emp_rec.interface_emp_id;
830:
831: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
832:
833: IF (l_request_id IS NULL) THEN
834: l_request_id := fnd_global.conc_request_id;
835: END IF;

Line 843: fnd_log.string_with_context( fnd_log.level_exception,

839: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
840: 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id ||
841: ' Status : 3 ' || 'ErrorCode : E014 '||SQLERRM;
842:
843: fnd_log.string_with_context( fnd_log.level_exception,
844: l_label,
845: l_debug_str, NULL,
846: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id)
847: );

Line 899: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

895: SET error_code = 'E014',
896: status = '3'
897: WHERE interface_emp_id = person_emp_rec.interface_emp_id;
898:
899: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
900: IF (l_request_id IS NULL) THEN
901: l_request_id := fnd_global.conc_request_id;
902: END IF;
903:

Line 910: fnd_log.string_with_context( fnd_log.level_exception,

906: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Empnt_Dtls ' ||
907: 'INTERFACE Emp Id : ' || Person_Emp_Rec.Interface_Emp_Id ||
908: ' Status : 3 ' || 'ErrorCode : E014 '|| l_msg_data;
909:
910: fnd_log.string_with_context( fnd_log.level_exception,
911: l_label,
912: l_debug_str, NULL,
913: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
914: END IF;

Line 1160: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1156: l_object_version_number NUMBER;
1157:
1158: BEGIN
1159:
1160: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1161:
1162: IF (l_request_id IS NULL) THEN
1163: l_request_id := fnd_global.conc_request_id;
1164: END IF;

Line 1169: fnd_log.string_with_context( fnd_log.level_procedure,

1165:
1166: l_label := 'igs.plsql.igs_ad_imp_006.crt_extra_cur.Begin';
1167: l_debug_str := 'INTERFACE Excurr Id : ' || extracurr_rec.interface_excurr_id;
1168:
1169: fnd_log.string_with_context( fnd_log.level_procedure,
1170: l_label,
1171: l_debug_str, NULL,
1172: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1173: END IF;

Line 1226: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1222: WHERE
1223: INTERFACE_EXCURR_ID = extracurr_rec.INTERFACE_EXCURR_ID;
1224:
1225:
1226: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1227:
1228: IF (l_request_id IS NULL) THEN
1229: l_request_id := fnd_global.conc_request_id;
1230: END IF;

Line 1238: fnd_log.string_with_context( fnd_log.level_exception,

1234: l_debug_str := 'IGS_AD_IMP_006.Prc_Pe_Extclr_Dtls ' ||
1235: 'INTERFACE Excurr Id : ' || EXTRACURR_REC.INTERFACE_EXCURR_ID ||
1236: ' Status : 3 ' || 'ErrorCode : E322 '|| l_msg_data;
1237:
1238: fnd_log.string_with_context( fnd_log.level_exception,
1239: l_label,
1240: l_debug_str, NULL,
1241: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1242: END IF;

Line 1265: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

1261: SET STATUS = '3',
1262: ERROR_CODE = 'E322'
1263: WHERE INTERFACE_EXCURR_ID = EXTRACURR_REC.INTERFACE_EXCURR_ID;
1264:
1265: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1266:
1267: IF (l_request_id IS NULL) THEN
1268: l_request_id := fnd_global.conc_request_id;
1269: END IF;

Line 1277: fnd_log.string_with_context( fnd_log.level_exception,

1273: l_debug_str := 'Igs_Ad_Imp_006.Prc_Pe_Extclr_Dtls ' ||
1274: 'INTERFACE Excurr Id : ' || IGS_GE_NUMBER.TO_CANN(EXTRACURR_REC.INTERFACE_EXCURR_ID) ||
1275: ' Status : 3 ' || 'ErrorCode : E322 ' || SQLERRM;
1276:
1277: fnd_log.string_with_context( fnd_log.level_exception,
1278: l_label,
1279: l_debug_str, NULL,
1280: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1281: END IF;