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_PE_VISAPASS_PUB dependencies on APP_EXCEPTION

Line 103: app_exception.raise_exception;

99: IF l_visa_rec.person_id IS NULL OR l_visa_rec.person_id = FND_API.G_MISS_NUM THEN
100: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
101: fnd_message.set_token('PARAM','PERSON_ID');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
106: IF l_visa_rec.visa_type IS NULL OR l_visa_rec.visa_type = FND_API.G_MISS_CHAR THEN
107: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 110: app_exception.raise_exception;

106: IF l_visa_rec.visa_type IS NULL OR l_visa_rec.visa_type = FND_API.G_MISS_CHAR THEN
107: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
108: fnd_message.set_token('PARAM','VISA_TYPE');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112:
113: IF l_visa_rec.visa_number IS NULL OR l_visa_rec.visa_number = FND_API.G_MISS_CHAR THEN
114: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 117: app_exception.raise_exception;

113: IF l_visa_rec.visa_number IS NULL OR l_visa_rec.visa_number = FND_API.G_MISS_CHAR THEN
114: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
115: fnd_message.set_token('PARAM','VISA_NUMBER');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF l_visa_rec.visa_issue_date IS NULL OR l_visa_rec.visa_issue_date = FND_API.G_MISS_DATE THEN
121: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 124: app_exception.raise_exception;

120: IF l_visa_rec.visa_issue_date IS NULL OR l_visa_rec.visa_issue_date = FND_API.G_MISS_DATE THEN
121: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
122: fnd_message.set_token('PARAM','VISA_ISSUE_DATE');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: IF l_visa_rec.visa_expiry_date IS NULL OR l_visa_rec.visa_expiry_date = FND_API.G_MISS_DATE THEN
128: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 131: app_exception.raise_exception;

127: IF l_visa_rec.visa_expiry_date IS NULL OR l_visa_rec.visa_expiry_date = FND_API.G_MISS_DATE THEN
128: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
129: fnd_message.set_token('PARAM','visa_expiry_date');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
134: IF l_visa_rec.visa_issuing_post = FND_API.G_MISS_CHAR THEN
135: l_visa_rec.visa_issuing_post := NULL;

Line 436: app_exception.raise_exception;

432: IF l_visa_rec.visa_id IS NULL OR l_visa_rec.visa_id = FND_API.G_MISS_NUM THEN
433: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
434: fnd_message.set_token('PARAM','VISA_ID');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438:
439: OPEN null_handlng_cur(p_visa_rec);
440: FETCH null_handlng_cur INTO dup_visa_rec;

Line 445: app_exception.raise_exception;

441: IF null_handlng_cur%NOTFOUND THEN
442: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_UPD_ERR');
443: fnd_message.set_token('VALUES','VISA_ID=' || p_visa_rec.visa_id);
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447: CLOSE null_handlng_cur;
448:
449: IF l_visa_rec.person_id = FND_API.G_MISS_NUM THEN

Line 453: app_exception.raise_exception;

449: IF l_visa_rec.person_id = FND_API.G_MISS_NUM THEN
450: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
451: fnd_message.set_token('PARAM','PERSON_ID');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: ELSIF l_visa_rec.person_id IS NULL THEN
455: l_visa_rec.person_id := dup_visa_rec.person_id;
456: ELSIF l_visa_rec.person_id <> dup_visa_rec.person_id THEN
457: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

Line 460: app_exception.raise_exception;

456: ELSIF l_visa_rec.person_id <> dup_visa_rec.person_id THEN
457: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');
458: fnd_message.set_token('COLUMN','PERSON_ID');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;
462:
463: IF l_visa_rec.visa_type = FND_API.G_MISS_CHAR THEN
464: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 467: app_exception.raise_exception;

463: IF l_visa_rec.visa_type = FND_API.G_MISS_CHAR THEN
464: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
465: fnd_message.set_token('PARAM','VISA_TYPE');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: ELSIF l_visa_rec.visa_type IS NULL THEN
469: l_visa_rec.visa_type := dup_visa_rec.visa_type;
470: ELSIF l_visa_rec.visa_type <> dup_visa_rec.visa_type THEN
471: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

Line 474: app_exception.raise_exception;

470: ELSIF l_visa_rec.visa_type <> dup_visa_rec.visa_type THEN
471: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');
472: fnd_message.set_token('COLUMN','VISA_TYPE');
473: igs_ge_msg_stack.add;
474: app_exception.raise_exception;
475: END IF;
476:
477: IF l_visa_rec.visa_number = FND_API.G_MISS_CHAR THEN
478: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 481: app_exception.raise_exception;

477: IF l_visa_rec.visa_number = FND_API.G_MISS_CHAR THEN
478: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
479: fnd_message.set_token('PARAM','VISA_NUMBER');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: ELSIF l_visa_rec.visa_number IS NULL THEN
483: l_visa_rec.visa_number := dup_visa_rec.visa_number;
484: END IF;
485:

Line 490: app_exception.raise_exception;

486: IF l_visa_rec.visa_issue_date = FND_API.G_MISS_DATE THEN
487: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
488: fnd_message.set_token('PARAM','VISA_ISSUE_DATE');
489: igs_ge_msg_stack.add;
490: app_exception.raise_exception;
491: ELSIF l_visa_rec.visa_issue_date IS NULL THEN
492: l_visa_rec.visa_issue_date := dup_visa_rec.visa_issue_date;
493: ELSIF l_visa_rec.visa_issue_date <> dup_visa_rec.visa_issue_date THEN
494: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

Line 497: app_exception.raise_exception;

493: ELSIF l_visa_rec.visa_issue_date <> dup_visa_rec.visa_issue_date THEN
494: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');
495: fnd_message.set_token('COLUMN','VISA_ISSUE_DATE');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:
500: IF l_visa_rec.visa_expiry_date = FND_API.G_MISS_DATE THEN
501: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 504: app_exception.raise_exception;

500: IF l_visa_rec.visa_expiry_date = FND_API.G_MISS_DATE THEN
501: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
502: fnd_message.set_token('PARAM','VISA_EXPIRY_DATE');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: ELSIF l_visa_rec.visa_expiry_date IS NULL THEN
506: l_visa_rec.visa_expiry_date := dup_visa_rec.visa_expiry_date;
507: END IF;
508:

Line 845: app_exception.raise_exception;

841: IF l_visit_hstry_rec.port_of_entry IS NULL OR l_visit_hstry_rec.port_of_entry = FND_API.G_MISS_CHAR THEN
842: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
843: fnd_message.set_token('PARAM','PORT_OF_ENTRY');
844: igs_ge_msg_stack.add;
845: app_exception.raise_exception;
846: END IF;
847:
848: IF l_visit_hstry_rec.cntry_entry_form_num IS NULL OR l_visit_hstry_rec.cntry_entry_form_num = FND_API.G_MISS_CHAR THEN
849: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 852: app_exception.raise_exception;

848: IF l_visit_hstry_rec.cntry_entry_form_num IS NULL OR l_visit_hstry_rec.cntry_entry_form_num = FND_API.G_MISS_CHAR THEN
849: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
850: fnd_message.set_token('PARAM','CNTRY_ENTRY_FORM_NUM');
851: igs_ge_msg_stack.add;
852: app_exception.raise_exception;
853: END IF;
854:
855: IF l_visit_hstry_rec.visa_id IS NULL OR l_visit_hstry_rec.visa_id = FND_API.G_MISS_NUM THEN
856: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 859: app_exception.raise_exception;

855: IF l_visit_hstry_rec.visa_id IS NULL OR l_visit_hstry_rec.visa_id = FND_API.G_MISS_NUM THEN
856: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
857: fnd_message.set_token('PARAM','VISA_ID');
858: igs_ge_msg_stack.add;
859: app_exception.raise_exception;
860: END IF;
861:
862: IF l_visit_hstry_rec.visit_start_date IS NULL OR l_visit_hstry_rec.visit_start_date = FND_API.G_MISS_DATE THEN
863: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 866: app_exception.raise_exception;

862: IF l_visit_hstry_rec.visit_start_date IS NULL OR l_visit_hstry_rec.visit_start_date = FND_API.G_MISS_DATE THEN
863: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
864: fnd_message.set_token('PARAM','VISIT_START_DATE');
865: igs_ge_msg_stack.add;
866: app_exception.raise_exception;
867: END IF;
868:
869: IF l_visit_hstry_rec.visit_end_date = FND_API.G_MISS_DATE THEN
870: l_visit_hstry_rec.visit_end_date := NULL;

Line 1047: app_exception.raise_exception;

1043: IF p_visit_hstry_rec.port_of_entry IS NULL OR p_visit_hstry_rec.port_of_entry = FND_API.G_MISS_CHAR THEN
1044: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1045: fnd_message.set_token('PARAM','PORT_OF_ENTRY');
1046: igs_ge_msg_stack.add;
1047: app_exception.raise_exception;
1048: END IF;
1049:
1050: IF p_visit_hstry_rec.cntry_entry_form_num IS NULL OR p_visit_hstry_rec.cntry_entry_form_num = FND_API.G_MISS_CHAR THEN
1051: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 1054: app_exception.raise_exception;

1050: IF p_visit_hstry_rec.cntry_entry_form_num IS NULL OR p_visit_hstry_rec.cntry_entry_form_num = FND_API.G_MISS_CHAR THEN
1051: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1052: fnd_message.set_token('PARAM','CNTRY_ENTRY_FORM_NUM');
1053: igs_ge_msg_stack.add;
1054: app_exception.raise_exception;
1055: END IF;
1056:
1057: OPEN null_handlng_cur(p_visit_hstry_rec);
1058: FETCH null_handlng_cur INTO dup_visit_rec;

Line 1064: app_exception.raise_exception;

1060: CLOSE null_handlng_cur;
1061: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_UPD_ERR');
1062: fnd_message.set_token('VALUES','CNTRY_ENTRY_FORM_NUM=' || p_visit_hstry_rec.cntry_entry_form_num || ', PORT_OF_ENTRY=' || p_visit_hstry_rec.port_of_entry );
1063: igs_ge_msg_stack.add;
1064: app_exception.raise_exception;
1065: END IF;
1066: CLOSE null_handlng_cur;
1067:
1068: IF l_visit_hstry_rec.visa_id = FND_API.G_MISS_NUM THEN

Line 1072: app_exception.raise_exception;

1068: IF l_visit_hstry_rec.visa_id = FND_API.G_MISS_NUM THEN
1069: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1070: fnd_message.set_token('PARAM','VISA_ID');
1071: igs_ge_msg_stack.add;
1072: app_exception.raise_exception;
1073: ELSIF l_visit_hstry_rec.visa_id IS NULL THEN
1074: l_visit_hstry_rec.visa_id := dup_visit_rec.visa_id;
1075: END IF;
1076:

Line 1081: app_exception.raise_exception;

1077: IF l_visit_hstry_rec.visit_start_date = FND_API.G_MISS_DATE THEN
1078: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1079: fnd_message.set_token('PARAM','VISIT_START_DATE');
1080: igs_ge_msg_stack.add;
1081: app_exception.raise_exception;
1082: ELSIF l_visit_hstry_rec.visit_start_date IS NULL THEN
1083: l_visit_hstry_rec.visit_start_date := dup_visit_rec.visit_start_date;
1084: END IF;
1085:

Line 1258: app_exception.raise_exception;

1254: IF l_passport_rec.person_id IS NULL OR l_passport_rec.person_id = FND_API.G_MISS_NUM THEN
1255: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1256: fnd_message.set_token('PARAM','PERSON_ID');
1257: igs_ge_msg_stack.add;
1258: app_exception.raise_exception;
1259: END IF;
1260:
1261: IF l_passport_rec.passport_number IS NULL OR l_passport_rec.passport_number = FND_API.G_MISS_CHAR THEN
1262: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 1265: app_exception.raise_exception;

1261: IF l_passport_rec.passport_number IS NULL OR l_passport_rec.passport_number = FND_API.G_MISS_CHAR THEN
1262: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1263: fnd_message.set_token('PARAM','PASSPORT_NUMBER');
1264: igs_ge_msg_stack.add;
1265: app_exception.raise_exception;
1266: END IF;
1267:
1268: IF l_passport_rec.passport_expiry_date IS NULL OR l_passport_rec.passport_expiry_date = FND_API.G_MISS_DATE THEN
1269: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 1272: app_exception.raise_exception;

1268: IF l_passport_rec.passport_expiry_date IS NULL OR l_passport_rec.passport_expiry_date = FND_API.G_MISS_DATE THEN
1269: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1270: fnd_message.set_token('PARAM','PASSPORT_EXPIRY_DATE');
1271: igs_ge_msg_stack.add;
1272: app_exception.raise_exception;
1273: END IF;
1274:
1275: IF l_passport_rec.passport_cntry_code IS NULL OR l_passport_rec.passport_cntry_code = FND_API.G_MISS_CHAR THEN
1276: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 1279: app_exception.raise_exception;

1275: IF l_passport_rec.passport_cntry_code IS NULL OR l_passport_rec.passport_cntry_code = FND_API.G_MISS_CHAR THEN
1276: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1277: fnd_message.set_token('PARAM','PASSPORT_CNTRY_CODE');
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:

Line 1460: app_exception.raise_exception;

1456: IF p_passport_rec.passport_id IS NULL OR p_passport_rec.passport_id = FND_API.G_MISS_NUM THEN
1457: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1458: fnd_message.set_token('PARAM','PASSPORT_ID');
1459: igs_ge_msg_stack.add;
1460: app_exception.raise_exception;
1461: END IF;
1462:
1463: OPEN null_handlng_cur(p_passport_rec);
1464: FETCH null_handlng_cur INTO dup_pass_rec;

Line 1469: app_exception.raise_exception;

1465: IF null_handlng_cur%NOTFOUND THEN
1466: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_UPD_ERR');
1467: fnd_message.set_token('VALUES','PASSPORT_ID=' || p_passport_rec.passport_id );
1468: igs_ge_msg_stack.add;
1469: app_exception.raise_exception;
1470: END IF;
1471: CLOSE null_handlng_cur;
1472:
1473: IF l_passport_rec.person_id = FND_API.G_MISS_NUM THEN

Line 1477: app_exception.raise_exception;

1473: IF l_passport_rec.person_id = FND_API.G_MISS_NUM THEN
1474: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1475: fnd_message.set_token('PARAM','PERSON_ID');
1476: igs_ge_msg_stack.add;
1477: app_exception.raise_exception;
1478: ELSIF l_passport_rec.person_id IS NULL THEN
1479: l_passport_rec.person_id := dup_pass_rec.person_id;
1480: ELSIF l_passport_rec.person_id <> dup_pass_rec.person_id THEN
1481: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

Line 1484: app_exception.raise_exception;

1480: ELSIF l_passport_rec.person_id <> dup_pass_rec.person_id THEN
1481: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');
1482: fnd_message.set_token('COLUMN','PERSON_ID');
1483: igs_ge_msg_stack.add;
1484: app_exception.raise_exception;
1485: END IF;
1486:
1487: IF l_passport_rec.passport_number = FND_API.G_MISS_CHAR THEN
1488: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 1491: app_exception.raise_exception;

1487: IF l_passport_rec.passport_number = FND_API.G_MISS_CHAR THEN
1488: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1489: fnd_message.set_token('PARAM','PASSPORT_NUMBER');
1490: igs_ge_msg_stack.add;
1491: app_exception.raise_exception;
1492: ELSIF l_passport_rec.passport_number IS NULL THEN
1493: l_passport_rec.passport_number := dup_pass_rec.passport_number;
1494: ELSIF l_passport_rec.passport_number <> dup_pass_rec.passport_number THEN
1495: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

Line 1498: app_exception.raise_exception;

1494: ELSIF l_passport_rec.passport_number <> dup_pass_rec.passport_number THEN
1495: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');
1496: fnd_message.set_token('COLUMN','PASSPORT_NUMBER');
1497: igs_ge_msg_stack.add;
1498: app_exception.raise_exception;
1499: END IF;
1500:
1501: IF l_passport_rec.passport_expiry_date = FND_API.G_MISS_DATE THEN
1502: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

Line 1505: app_exception.raise_exception;

1501: IF l_passport_rec.passport_expiry_date = FND_API.G_MISS_DATE THEN
1502: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1503: fnd_message.set_token('PARAM','PASSPORT_EXPIRY_DATE');
1504: igs_ge_msg_stack.add;
1505: app_exception.raise_exception;
1506: ELSIF l_passport_rec.passport_expiry_date IS NULL THEN
1507: l_passport_rec.passport_expiry_date := dup_pass_rec.passport_expiry_date;
1508: END IF;
1509:

Line 1514: app_exception.raise_exception;

1510: IF l_passport_rec.passport_cntry_code = FND_API.G_MISS_CHAR THEN
1511: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');
1512: fnd_message.set_token('PARAM','PASSPORT_CNTRY_CODE');
1513: igs_ge_msg_stack.add;
1514: app_exception.raise_exception;
1515: ELSIF l_passport_rec.passport_cntry_code IS NULL THEN
1516: l_passport_rec.passport_cntry_code := dup_pass_rec.passport_cntry_code;
1517: ELSIF l_passport_rec.passport_cntry_code <> dup_pass_rec.passport_cntry_code THEN
1518: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

Line 1521: app_exception.raise_exception;

1517: ELSIF l_passport_rec.passport_cntry_code <> dup_pass_rec.passport_cntry_code THEN
1518: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');
1519: fnd_message.set_token('COLUMN','PASSPORT_CNTRY_CODE');
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: