APPS.IGS_PE_VISAPASS_PUB dependencies on IGS_PE_PASSPORT

Line 1284: IGS_PE_PASSPORT_PKG.INSERT_ROW(

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 ,
1287: X_PERSON_ID => l_passport_rec.person_id,
1288: X_PASSPORT_NUMBER => l_passport_rec.passport_number,

Line 1354: ELSIF l_message_name = 'IGS_PE_PASSPORT_DUP_EXISTS' THEN

1350: fnd_message.set_name ('IGS', 'IGS_EN_INV');
1351: fnd_message.set_token('PARAM','PERSON_ID');
1352: igs_ge_msg_stack.add;
1353: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
1354: ELSIF l_message_name = 'IGS_PE_PASSPORT_DUP_EXISTS' THEN
1355: x_return_status := FND_API.G_RET_STS_ERROR ;
1356: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');
1357: fnd_message.set_token('COLUMN','PERSON_ID,PASSPORT_CNTRY_CODE,PASSPORT_NUMBER');
1358: igs_ge_msg_stack.add;

Line 1420: FROM IGS_PE_PASSPORT

1416:
1417: CURSOR null_handlng_cur(cp_pass IN passport_rec_type) IS
1418: SELECT rowid,
1419: PASSPORT_ID, PERSON_ID, PASSPORT_NUMBER, PASSPORT_EXPIRY_DATE, PASSPORT_CNTRY_CODE
1420: FROM IGS_PE_PASSPORT
1421: WHERE passport_id = cp_pass.passport_id FOR UPDATE NOWAIT;
1422:
1423: dup_pass_rec null_handlng_cur%ROWTYPE;
1424: l_error_code VARCHAR2(30);

Line 1526: igs_pe_passport_pkg.update_row(

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,
1529: X_PERSON_ID => l_passport_rec.person_id,
1530: X_PASSPORT_NUMBER => l_passport_rec.passport_number,

Line 1592: IF l_message_name IN('IGS_PE_VIS_ASOC_PASS_EXP','IGS_PE_PASSPORT_DUP_EXISTS','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR','IGS_PE_VIPS_COL_NONUPD') THEN

1588:
1589: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1590:
1591: x_msg_count := 1;
1592: IF l_message_name IN('IGS_PE_VIS_ASOC_PASS_EXP','IGS_PE_PASSPORT_DUP_EXISTS','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR','IGS_PE_VIPS_COL_NONUPD') THEN
1593: x_return_status := FND_API.G_RET_STS_ERROR ;
1594: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
1595: ELSE
1596: x_msg_data := ' ' || SQLERRM;