APPS.IGS_AD_IMP_UH_TST_PKG dependencies on IGS_GE_NUMBER

Line 315: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)

311: EXCEPTION
312: WHEN OTHERS THEN
313: l_error_code := 'E002';
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Insertion of Test Result record failed '
315: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
316: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
317: -- Insert Master End
318: END;
319: IF l_error_code IS NULL THEN

Line 316: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );

312: WHEN OTHERS THEN
313: l_error_code := 'E002';
314: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Insertion of Test Result record failed '
315: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
316: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
317: -- Insert Master End
318: END;
319: IF l_error_code IS NULL THEN
320: --

Line 373: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)

369: EXCEPTION
370: WHEN OTHERS THEN
371: l_error_code := 'E004'; -- Active Indicator Update failed
372: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Active Indicator Update failed '
373: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
374: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
375:
376: -- Update Active Ind End
377: END;

Line 374: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );

370: WHEN OTHERS THEN
371: l_error_code := 'E004'; -- Active Indicator Update failed
372: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Active Indicator Update failed '
373: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
374: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
375:
376: -- Update Active Ind End
377: END;
378: END LOOP;

Line 391: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)

387: END IF;
388: IF NOT l_return_status THEN
389: l_error_code := 'E003'; -- Insertion of child record failed
390: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Insertion of child record failed '
391: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
392: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
393:
394: END IF;
395: END IF;

Line 392: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );

388: IF NOT l_return_status THEN
389: l_error_code := 'E003'; -- Insertion of child record failed
390: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Insertion of child record failed '
391: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
392: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
393:
394: END IF;
395: END IF;
396: EXCEPTION

Line 400: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)

396: EXCEPTION
397: WHEN OTHERS THEN
398: l_error_code := 'E005'; -- Test Score Import Failed
399: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Test Score Import Failed '
400: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
401: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
402: -- Outer End
403: END;
404: IF l_error_code IS NULL THEN

Line 401: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );

397: WHEN OTHERS THEN
398: l_error_code := 'E005'; -- Test Score Import Failed
399: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Test Score Import Failed '
400: || ' Person ID :: ' || IGS_GE_NUMBER.TO_CANN ( p_person_id)
401: || ' INTERFACE_TST_ID :: ' || IGS_GE_NUMBER.TO_CANN ( c_tst_rec.interface_tst_id) );
402: -- Outer End
403: END;
404: IF l_error_code IS NULL THEN
405: DELETE FROM