APPS.IGS_AD_IMP_002 dependencies on IGS_PE_PERSON_PKG

Line 424: IGS_PE_PERSON_PKG.INSERT_ROW( X_MSG_COUNT => l_msg_count,

420: ELSE
421: l_preferred_given_name := p_person_rec.preferred_given_name;
422: END IF;
423:
424: IGS_PE_PERSON_PKG.INSERT_ROW( X_MSG_COUNT => l_msg_count,
425: X_MSG_DATA => l_msg_data,
426: X_RETURN_STATUS=> l_return_status,
427: X_ROWID=> l_rowid,
428: X_PERSON_ID => l_person_id,

Line 596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||

592: END IF;
593:
594: l_label := 'igs.plsql.igs_ad_imp_002.create_person.exception'||l_error_code;
595:
596: l_debug_str := 'IGS_AD_IMP_002.Create_Person' || ' Exception from IGS_PE_PERSON_PKG '|| ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
597: ' Status : 3' || ' ErrorCode:'||l_error_code||' SQLERRM '|| SQLERRM ;
598:
599: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
600: END IF;

Line 1378: IGS_PE_PERSON_PKG.UPDATE_ROW(

1374: SAVEPOINT BEFORE_UPDATE;
1375:
1376: BEGIN
1377: -- Update Person
1378: IGS_PE_PERSON_PKG.UPDATE_ROW(
1379: X_LAST_UPDATE_DATE => l_last_update_date,
1380: X_MSG_COUNT => l_msg_count,
1381: X_MSG_DATA => l_msg_data,
1382: X_RETURN_STATUS=> l_return_status,

Line 1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||

1517: END IF;
1518:
1519: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||l_error_code;
1520:
1521: l_debug_str := 'IGS_AD_IMP_002.Update_Person' || ' Exception from IGS_PE_PERSON_PKG ' ||
1522: ' Interface Id : ' || ( P_person_rec.INTERFACE_ID) ||
1523: ' Status : 3' || ' ErrorCode : '||l_error_code||' SQLERRM:' || SQLERRM;
1524:
1525: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||

1549: END IF;
1550:
1551: l_label := 'igs.plsql.igs_ad_imp_002.update_person.exception'||'E014';
1552:
1553: l_debug_str := 'IGS_AD_IMP_002.Update_Person ' || 'Error from IGS_PE_PERSON_PKG. HzMesg : ' || l_msg_data ||
1554: ' Interface Id : ' || (P_person_rec.INTERFACE_ID) ||
1555: ' Status : 3' || ' ErrorCode : E014';
1556:
1557: fnd_log.string_with_context( fnd_log.level_exception,