DBA Data[Home] [Help]

APPS.IGS_PE_VISAPASS_PUB dependencies on IGS_AD_IMP_026

Line 242: IF igs_ad_imp_026.validate_visa_pub(api_visa_rec => l_visa_rec, p_err_code => l_error_code) THEN

238: IF l_visa_rec.visa_issuing_country = FND_API.G_MISS_CHAR THEN
239: l_visa_rec.visa_issuing_country := NULL;
240: END IF;
241:
242: IF igs_ad_imp_026.validate_visa_pub(api_visa_rec => l_visa_rec, p_err_code => l_error_code) THEN
243:
244: IGS_PE_VISA_PKG.INSERT_ROW(
245: X_ROWID => l_rowid,
246: X_VISA_ID => x_visa_id,

Line 673: IF igs_ad_imp_026.validate_visa_pub(api_visa_rec => l_visa_rec, p_err_code => l_error_code) THEN

669: END IF;
670:
671: x_msg_count := 0;
672:
673: IF igs_ad_imp_026.validate_visa_pub(api_visa_rec => l_visa_rec, p_err_code => l_error_code) THEN
674:
675: IGS_PE_VISA_PKG.UPDATE_ROW (
676: X_ROWID => dup_visa_rec.rowid,
677: X_VISA_ID => l_visa_rec.visa_id,

Line 877: IF igs_ad_imp_026.Validate_visit_histry_pub(api_visit_rec => l_visit_hstry_rec, p_err_code => l_error_code) THEN

873: IF l_visit_hstry_rec.remarks = FND_API.G_MISS_CHAR THEN
874: l_visit_hstry_rec.remarks := NULL;
875: END IF;
876:
877: IF igs_ad_imp_026.Validate_visit_histry_pub(api_visit_rec => l_visit_hstry_rec, p_err_code => l_error_code) THEN
878:
879: igs_pe_visit_histry_pkg.insert_row(
880: X_ROWID => l_rowid,
881: X_PORT_OF_ENTRY => l_visit_hstry_rec.port_of_entry,

Line 1098: IF igs_ad_imp_026.Validate_visit_histry_pub(api_visit_rec => l_visit_hstry_rec, p_err_code => l_error_code) THEN

1094: ELSIF l_visit_hstry_rec.remarks IS NULL THEN
1095: l_visit_hstry_rec.remarks := dup_visit_rec.remarks;
1096: END IF;
1097:
1098: IF igs_ad_imp_026.Validate_visit_histry_pub(api_visit_rec => l_visit_hstry_rec, p_err_code => l_error_code) THEN
1099:
1100: igs_pe_visit_histry_pkg.update_row(
1101: X_ROWID => dup_visit_rec.rowid,
1102: X_PORT_OF_ENTRY => l_visit_hstry_rec.port_of_entry,

Line 1282: IF igs_ad_imp_026.Validate_passport_pub(api_pass_rec => l_passport_rec, p_err_code => l_error_code) THEN

1278: igs_ge_msg_stack.add;
1279: app_exception.raise_exception;
1280: END IF;
1281:
1282: IF igs_ad_imp_026.Validate_passport_pub(api_pass_rec => l_passport_rec, p_err_code => l_error_code) THEN
1283:
1284: IGS_PE_PASSPORT_PKG.INSERT_ROW(
1285: X_ROWID => l_rowid,
1286: X_PASSPORT_ID => x_passport_id ,

Line 1524: IF igs_ad_imp_026.Validate_passport_pub(api_pass_rec => l_passport_rec, p_err_code => l_error_code) THEN

1520: igs_ge_msg_stack.add;
1521: app_exception.raise_exception;
1522: END IF;
1523:
1524: IF igs_ad_imp_026.Validate_passport_pub(api_pass_rec => l_passport_rec, p_err_code => l_error_code) THEN
1525:
1526: igs_pe_passport_pkg.update_row(
1527: X_ROWID => dup_pass_rec.rowid,
1528: X_PASSPORT_ID => dup_pass_rec.passport_id,