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 IGS_GE_MSG_STACK

Line 102: igs_ge_msg_stack.add;

98:
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

Line 109: igs_ge_msg_stack.add;

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');
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

Line 116: igs_ge_msg_stack.add;

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');
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

Line 123: igs_ge_msg_stack.add;

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');
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

Line 130: igs_ge_msg_stack.add;

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');
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

Line 322: igs_ge_msg_stack.add;

318: ELSIF l_message_name = 'FORM_RECORD_DELETED' THEN
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: fnd_message.set_name ('IGS', 'IGS_EN_INV');
321: fnd_message.set_token('PARAM','PERSON_ID');
322: igs_ge_msg_stack.add;
323: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
324: ELSIF l_message_name = 'IGS_PE_VISA_DUP_EXISTS' THEN
325: x_return_status := FND_API.G_RET_STS_ERROR ;
326: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');

Line 328: igs_ge_msg_stack.add;

324: ELSIF l_message_name = 'IGS_PE_VISA_DUP_EXISTS' THEN
325: x_return_status := FND_API.G_RET_STS_ERROR ;
326: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');
327: fnd_message.set_token('COLUMN','PERSON_ID,VISA_TYPE,VISA_ISSUE_DATE');
328: igs_ge_msg_stack.add;
329: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
330: ELSE
331: x_msg_data := SQLERRM;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 435: igs_ge_msg_stack.add;

431:
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);

Line 444: igs_ge_msg_stack.add;

440: FETCH null_handlng_cur INTO dup_visa_rec;
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:

Line 452: igs_ge_msg_stack.add;

448:
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

Line 459: igs_ge_msg_stack.add;

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');
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

Line 466: igs_ge_msg_stack.add;

462:
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

Line 473: igs_ge_msg_stack.add;

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');
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

Line 480: igs_ge_msg_stack.add;

476:
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;

Line 489: igs_ge_msg_stack.add;

485:
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

Line 496: igs_ge_msg_stack.add;

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');
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

Line 503: igs_ge_msg_stack.add;

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');
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;

Line 730: igs_ge_msg_stack.add;

726: EXCEPTION
727: WHEN E_RESOURCE_BUSY THEN
728: ROLLBACK TO Update_Visa_PUB;
729: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');
730: igs_ge_msg_stack.add;
731: x_return_status := FND_API.G_RET_STS_ERROR ;
732: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
733: x_msg_count := 1;
734: WHEN FND_API.G_EXC_ERROR THEN

Line 844: igs_ge_msg_stack.add;

840:
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

Line 851: igs_ge_msg_stack.add;

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');
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

Line 858: igs_ge_msg_stack.add;

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');
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

Line 865: igs_ge_msg_stack.add;

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');
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

Line 944: igs_ge_msg_stack.add;

940: ELSIF l_message_name = 'IGS_PE_PORT_DUP_EXISTS' THEN
941: x_return_status := FND_API.G_RET_STS_ERROR ;
942: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');
943: fnd_message.set_token('COLUMN','PORT_OF_ENTRY,CNTRY_ENTRY_FORM_NUM');
944: igs_ge_msg_stack.add;
945: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
946: ELSE
947: x_msg_data := ' ' || SQLERRM;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1046: igs_ge_msg_stack.add;

1042:
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

Line 1053: igs_ge_msg_stack.add;

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');
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);

Line 1063: igs_ge_msg_stack.add;

1059: IF null_handlng_cur%NOTFOUND THEN
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:

Line 1071: igs_ge_msg_stack.add;

1067:
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;

Line 1080: igs_ge_msg_stack.add;

1076:
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;

Line 1143: igs_ge_msg_stack.add;

1139: EXCEPTION
1140: WHEN E_RESOURCE_BUSY THEN
1141: ROLLBACK TO Update_VisitHistry_PUB;
1142: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');
1143: igs_ge_msg_stack.add;
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
1146: x_msg_count := 1;
1147: WHEN FND_API.G_EXC_ERROR THEN

Line 1257: igs_ge_msg_stack.add;

1253:
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

Line 1264: igs_ge_msg_stack.add;

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');
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

Line 1271: igs_ge_msg_stack.add;

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');
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

Line 1278: igs_ge_msg_stack.add;

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');
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

Line 1352: igs_ge_msg_stack.add;

1348: ELSIF l_message_name = 'FORM_RECORD_DELETED' THEN
1349: x_return_status := FND_API.G_RET_STS_ERROR ;
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');

Line 1358: igs_ge_msg_stack.add;

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;
1359: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
1360: ELSE
1361: x_msg_data := ' ' || SQLERRM;
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1459: igs_ge_msg_stack.add;

1455:
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);

Line 1468: igs_ge_msg_stack.add;

1464: FETCH null_handlng_cur INTO dup_pass_rec;
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:

Line 1476: igs_ge_msg_stack.add;

1472:
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

Line 1483: igs_ge_msg_stack.add;

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');
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

Line 1490: igs_ge_msg_stack.add;

1486:
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

Line 1497: igs_ge_msg_stack.add;

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');
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

Line 1504: igs_ge_msg_stack.add;

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');
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;

Line 1513: igs_ge_msg_stack.add;

1509:
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

Line 1520: igs_ge_msg_stack.add;

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');
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

Line 1570: igs_ge_msg_stack.add;

1566: EXCEPTION
1567: WHEN E_RESOURCE_BUSY THEN
1568: ROLLBACK TO Update_Passport_PUB;
1569: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');
1570: igs_ge_msg_stack.add;
1571: x_return_status := FND_API.G_RET_STS_ERROR ;
1572: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
1573: x_msg_count := 1;
1574: WHEN FND_API.G_EXC_ERROR THEN