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 FND_MESSAGE

Line 100: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

96: l_visa_rec.visa_expiry_date := TRUNC(l_visa_rec.visa_expiry_date);
97:
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;

Line 101: fnd_message.set_token('PARAM','PERSON_ID');

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

Line 107: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
108: fnd_message.set_token('PARAM','VISA_TYPE');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;

Line 108: fnd_message.set_token('PARAM','VISA_TYPE');

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');
108: fnd_message.set_token('PARAM','VISA_TYPE');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112:

Line 114: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
115: fnd_message.set_token('PARAM','VISA_NUMBER');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;

Line 115: fnd_message.set_token('PARAM','VISA_NUMBER');

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');
115: fnd_message.set_token('PARAM','VISA_NUMBER');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:

Line 121: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
122: fnd_message.set_token('PARAM','VISA_ISSUE_DATE');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;

Line 122: fnd_message.set_token('PARAM','VISA_ISSUE_DATE');

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');
122: fnd_message.set_token('PARAM','VISA_ISSUE_DATE');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:

Line 128: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
129: fnd_message.set_token('PARAM','visa_expiry_date');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;

Line 129: fnd_message.set_token('PARAM','visa_expiry_date');

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');
129: fnd_message.set_token('PARAM','visa_expiry_date');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:

Line 312: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

308: );
309: WHEN OTHERS THEN
310: ROLLBACK TO Create_Visa_PUB;
311:
312: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
313: x_msg_count := 1;
314:
315: IF l_message_name IN('IGS_PE_VIS_ASOC_PASS_EXP','IGS_FOREIGN_KEY_REFERENCE','IGS_PE_VISA_DATE_OVERLAP','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR') THEN
316: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 320: fnd_message.set_name ('IGS', 'IGS_EN_INV');

316: x_return_status := FND_API.G_RET_STS_ERROR ;
317: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
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

Line 321: fnd_message.set_token('PARAM','PERSON_ID');

317: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
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 ;

Line 326: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');

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

Line 327: fnd_message.set_token('COLUMN','PERSON_ID,VISA_TYPE,VISA_ISSUE_DATE');

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

Line 433: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

429: l_visa_rec.visa_issue_date := TRUNC(l_visa_rec.visa_issue_date);
430: l_visa_rec.visa_expiry_date := TRUNC(l_visa_rec.visa_expiry_date);
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;

Line 434: fnd_message.set_token('PARAM','VISA_ID');

430: l_visa_rec.visa_expiry_date := TRUNC(l_visa_rec.visa_expiry_date);
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:

Line 442: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_UPD_ERR');

438:
439: OPEN null_handlng_cur(p_visa_rec);
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;

Line 443: fnd_message.set_token('VALUES','VISA_ID=' || p_visa_rec.visa_id);

439: OPEN null_handlng_cur(p_visa_rec);
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;

Line 450: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

446: END IF;
447: CLOSE null_handlng_cur;
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

Line 451: fnd_message.set_token('PARAM','PERSON_ID');

447: CLOSE null_handlng_cur;
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;

Line 457: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

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');
458: fnd_message.set_token('COLUMN','PERSON_ID');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;

Line 458: fnd_message.set_token('COLUMN','PERSON_ID');

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');
458: fnd_message.set_token('COLUMN','PERSON_ID');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: END IF;
462:

Line 464: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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

Line 465: fnd_message.set_token('PARAM','VISA_TYPE');

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

Line 471: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

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');
472: fnd_message.set_token('COLUMN','VISA_TYPE');
473: igs_ge_msg_stack.add;
474: app_exception.raise_exception;
475: END IF;

Line 472: fnd_message.set_token('COLUMN','VISA_TYPE');

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');
472: fnd_message.set_token('COLUMN','VISA_TYPE');
473: igs_ge_msg_stack.add;
474: app_exception.raise_exception;
475: END IF;
476:

Line 478: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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

Line 479: fnd_message.set_token('PARAM','VISA_NUMBER');

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

Line 487: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

483: l_visa_rec.visa_number := dup_visa_rec.visa_number;
484: END IF;
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

Line 488: fnd_message.set_token('PARAM','VISA_ISSUE_DATE');

484: END IF;
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;

Line 494: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

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');
495: fnd_message.set_token('COLUMN','VISA_ISSUE_DATE');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;

Line 495: fnd_message.set_token('COLUMN','VISA_ISSUE_DATE');

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');
495: fnd_message.set_token('COLUMN','VISA_ISSUE_DATE');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:

Line 501: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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

Line 502: fnd_message.set_token('PARAM','VISA_EXPIRY_DATE');

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

Line 729: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');

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

Line 748: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

744: p_data => x_msg_data
745: );
746: WHEN OTHERS THEN
747: ROLLBACK TO Update_Visa_PUB;
748: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
749:
750: x_msg_count := 1;
751: IF l_message_name IN('IGS_PE_VIS_ASOC_PASS_EXP','IGS_PE_VISA_DUP_EXISTS','IGS_PE_VISA_DATE_OVERLAP','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR','IGS_PE_VIPS_COL_NONUPD','FORM_RECORD_DELETED') THEN
752: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 842: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

838: x_msg_count := 0;
839:
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;

Line 843: fnd_message.set_token('PARAM','PORT_OF_ENTRY');

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

Line 849: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
850: fnd_message.set_token('PARAM','CNTRY_ENTRY_FORM_NUM');
851: igs_ge_msg_stack.add;
852: app_exception.raise_exception;
853: END IF;

Line 850: fnd_message.set_token('PARAM','CNTRY_ENTRY_FORM_NUM');

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

Line 856: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
857: fnd_message.set_token('PARAM','VISA_ID');
858: igs_ge_msg_stack.add;
859: app_exception.raise_exception;
860: END IF;

Line 857: fnd_message.set_token('PARAM','VISA_ID');

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');
857: fnd_message.set_token('PARAM','VISA_ID');
858: igs_ge_msg_stack.add;
859: app_exception.raise_exception;
860: END IF;
861:

Line 863: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
864: fnd_message.set_token('PARAM','VISIT_START_DATE');
865: igs_ge_msg_stack.add;
866: app_exception.raise_exception;
867: END IF;

Line 864: fnd_message.set_token('PARAM','VISIT_START_DATE');

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');
864: fnd_message.set_token('PARAM','VISIT_START_DATE');
865: igs_ge_msg_stack.add;
866: app_exception.raise_exception;
867: END IF;
868:

Line 933: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

929: );
930: WHEN OTHERS THEN
931: ROLLBACK TO Create_VisitHistry_PUB;
932:
933: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
934:
935: x_msg_count := 1;
936:
937: IF l_message_name IN('IGS_PE_PORT_DATE_OVERLAP','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR','IGS_PE_VIPS_COL_NONUPD') THEN

Line 942: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');

938: x_return_status := FND_API.G_RET_STS_ERROR ;
939: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
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

Line 943: fnd_message.set_token('COLUMN','PORT_OF_ENTRY,CNTRY_ENTRY_FORM_NUM');

939: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
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;

Line 1044: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1040: -- Start here
1041: x_msg_count := 0;
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;

Line 1045: fnd_message.set_token('PARAM','PORT_OF_ENTRY');

1041: x_msg_count := 0;
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:

Line 1051: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
1052: fnd_message.set_token('PARAM','CNTRY_ENTRY_FORM_NUM');
1053: igs_ge_msg_stack.add;
1054: app_exception.raise_exception;
1055: END IF;

Line 1052: fnd_message.set_token('PARAM','CNTRY_ENTRY_FORM_NUM');

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

Line 1061: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_UPD_ERR');

1057: OPEN null_handlng_cur(p_visit_hstry_rec);
1058: FETCH null_handlng_cur INTO dup_visit_rec;
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;

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

1058: FETCH null_handlng_cur INTO dup_visit_rec;
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;

Line 1069: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1065: END IF;
1066: CLOSE null_handlng_cur;
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

Line 1070: fnd_message.set_token('PARAM','VISA_ID');

1066: CLOSE null_handlng_cur;
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;

Line 1078: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1074: l_visit_hstry_rec.visa_id := dup_visit_rec.visa_id;
1075: END IF;
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

Line 1079: fnd_message.set_token('PARAM','VISIT_START_DATE');

1075: END IF;
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;

Line 1142: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');

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

Line 1162: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

1158: );
1159: WHEN OTHERS THEN
1160: ROLLBACK TO Update_VisitHistry_PUB;
1161:
1162: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1163:
1164: x_msg_count := 1;
1165:
1166: IF l_message_name IN('IGS_PE_PORT_DUP_EXISTS','IGS_PE_PORT_DATE_OVERLAP','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR','IGS_PE_VIPS_COL_NONUPD') THEN

Line 1255: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1251:
1252: x_msg_count := 0;
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;

Line 1256: fnd_message.set_token('PARAM','PERSON_ID');

1252: x_msg_count := 0;
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:

Line 1262: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
1263: fnd_message.set_token('PARAM','PASSPORT_NUMBER');
1264: igs_ge_msg_stack.add;
1265: app_exception.raise_exception;
1266: END IF;

Line 1263: fnd_message.set_token('PARAM','PASSPORT_NUMBER');

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');
1263: fnd_message.set_token('PARAM','PASSPORT_NUMBER');
1264: igs_ge_msg_stack.add;
1265: app_exception.raise_exception;
1266: END IF;
1267:

Line 1269: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
1270: fnd_message.set_token('PARAM','PASSPORT_EXPIRY_DATE');
1271: igs_ge_msg_stack.add;
1272: app_exception.raise_exception;
1273: END IF;

Line 1270: fnd_message.set_token('PARAM','PASSPORT_EXPIRY_DATE');

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');
1270: fnd_message.set_token('PARAM','PASSPORT_EXPIRY_DATE');
1271: igs_ge_msg_stack.add;
1272: app_exception.raise_exception;
1273: END IF;
1274:

Line 1276: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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');
1277: fnd_message.set_token('PARAM','PASSPORT_CNTRY_CODE');
1278: igs_ge_msg_stack.add;
1279: app_exception.raise_exception;
1280: END IF;

Line 1277: fnd_message.set_token('PARAM','PASSPORT_CNTRY_CODE');

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');
1277: fnd_message.set_token('PARAM','PASSPORT_CNTRY_CODE');
1278: igs_ge_msg_stack.add;
1279: app_exception.raise_exception;
1280: END IF;
1281:

Line 1341: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

1337: p_data => x_msg_data
1338: );
1339: WHEN OTHERS THEN
1340: ROLLBACK TO Create_Passport_PUB;
1341: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
1342:
1343: x_msg_count := 1;
1344:
1345: IF l_message_name IN('IGS_PE_VIS_ASOC_PASS_EXP','IGS_EN_INV','IGS_PS_LGCY_MANDATORY', 'IGS_PE_VIPS_UPD_ERR','IGS_PE_VIPS_COL_NONUPD') THEN

Line 1350: fnd_message.set_name ('IGS', 'IGS_EN_INV');

1346: x_return_status := FND_API.G_RET_STS_ERROR ;
1347: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
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

Line 1351: fnd_message.set_token('PARAM','PERSON_ID');

1347: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_FIRST, p_encoded => 'F');
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 ;

Line 1356: fnd_message.set_name ('IGS', 'IGS_PE_UNIQUE_FAILED');

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

Line 1357: fnd_message.set_token('COLUMN','PERSON_ID,PASSPORT_CNTRY_CODE,PASSPORT_NUMBER');

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

Line 1457: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1453:
1454: x_msg_count := 0;
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;

Line 1458: fnd_message.set_token('PARAM','PASSPORT_ID');

1454: x_msg_count := 0;
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:

Line 1466: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_UPD_ERR');

1462:
1463: OPEN null_handlng_cur(p_passport_rec);
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;

Line 1467: fnd_message.set_token('VALUES','PASSPORT_ID=' || p_passport_rec.passport_id );

1463: OPEN null_handlng_cur(p_passport_rec);
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;

Line 1474: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1470: END IF;
1471: CLOSE null_handlng_cur;
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

Line 1475: fnd_message.set_token('PARAM','PERSON_ID');

1471: CLOSE null_handlng_cur;
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;

Line 1481: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

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');
1482: fnd_message.set_token('COLUMN','PERSON_ID');
1483: igs_ge_msg_stack.add;
1484: app_exception.raise_exception;
1485: END IF;

Line 1482: fnd_message.set_token('COLUMN','PERSON_ID');

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');
1482: fnd_message.set_token('COLUMN','PERSON_ID');
1483: igs_ge_msg_stack.add;
1484: app_exception.raise_exception;
1485: END IF;
1486:

Line 1488: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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

Line 1489: fnd_message.set_token('PARAM','PASSPORT_NUMBER');

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

Line 1495: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

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');
1496: fnd_message.set_token('COLUMN','PASSPORT_NUMBER');
1497: igs_ge_msg_stack.add;
1498: app_exception.raise_exception;
1499: END IF;

Line 1496: fnd_message.set_token('COLUMN','PASSPORT_NUMBER');

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');
1496: fnd_message.set_token('COLUMN','PASSPORT_NUMBER');
1497: igs_ge_msg_stack.add;
1498: app_exception.raise_exception;
1499: END IF;
1500:

Line 1502: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

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

Line 1503: fnd_message.set_token('PARAM','PASSPORT_EXPIRY_DATE');

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

Line 1511: fnd_message.set_name ('IGS', 'IGS_PS_LGCY_MANDATORY');

1507: l_passport_rec.passport_expiry_date := dup_pass_rec.passport_expiry_date;
1508: END IF;
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

Line 1512: fnd_message.set_token('PARAM','PASSPORT_CNTRY_CODE');

1508: END IF;
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;

Line 1518: fnd_message.set_name ('IGS', 'IGS_PE_VIPS_COL_NONUPD');

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');
1519: fnd_message.set_token('COLUMN','PASSPORT_CNTRY_CODE');
1520: igs_ge_msg_stack.add;
1521: app_exception.raise_exception;
1522: END IF;

Line 1519: fnd_message.set_token('COLUMN','PASSPORT_CNTRY_CODE');

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');
1519: fnd_message.set_token('COLUMN','PASSPORT_CNTRY_CODE');
1520: igs_ge_msg_stack.add;
1521: app_exception.raise_exception;
1522: END IF;
1523:

Line 1569: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_LOCKED');

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

Line 1589: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

1585: );
1586: WHEN OTHERS THEN
1587: ROLLBACK TO Update_Passport_PUB;
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 ;