APPS.JTF_DSPMGRVALIDATION_GRP dependencies on FND_MESSAGE

Line 68: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');

64: EXCEPTION
65:
66: WHEN l_ath_not_exists_exception THEN
67: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
68: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');
69: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
70: FND_MSG_PUB.ADD;
71: END IF;
72: RETURN l_return_status;

Line 69: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));

65:
66: WHEN l_ath_not_exists_exception THEN
67: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
68: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');
69: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
70: FND_MSG_PUB.ADD;
71: END IF;
72: RETURN l_return_status;
73:

Line 123: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');

119: EXCEPTION
120:
121: WHEN l_ath_not_exists_exception THEN
122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
123: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');
124: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
125: FND_MSG_PUB.ADD;
126: END IF;
127: RETURN NULL;

Line 124: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));

120:
121: WHEN l_ath_not_exists_exception THEN
122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
123: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');
124: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
125: FND_MSG_PUB.ADD;
126: END IF;
127: RETURN NULL;
128:

Line 164: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');

160: FETCH context_type_cur INTO l_type_code;
161:
162: IF context_type_cur%NOTFOUND
163: THEN
164: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
165: FND_MESSAGE.set_token('ID', p_context_id);
166: FND_MSG_PUB.ADD;
167: END IF;
168: CLOSE context_type_cur;

Line 165: FND_MESSAGE.set_token('ID', p_context_id);

161:
162: IF context_type_cur%NOTFOUND
163: THEN
164: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
165: FND_MESSAGE.set_token('ID', p_context_id);
166: FND_MSG_PUB.ADD;
167: END IF;
168: CLOSE context_type_cur;
169:

Line 222: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');

218: OPEN context_cur(p_context_id ,l_context_type);
219: FETCH context_cur INTO l_exists;
220: IF context_cur%NOTFOUND
221: THEN
222: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
223: FND_MESSAGE.set_token('ID', p_context_id);
224: FND_MSG_PUB.ADD;
225: ELSE
226: l_return_status := true;

Line 223: FND_MESSAGE.set_token('ID', p_context_id);

219: FETCH context_cur INTO l_exists;
220: IF context_cur%NOTFOUND
221: THEN
222: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
223: FND_MESSAGE.set_token('ID', p_context_id);
224: FND_MSG_PUB.ADD;
225: ELSE
226: l_return_status := true;
227: END IF;

Line 234: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');

230: OPEN context_version_cur(p_context_id ,l_context_type, p_object_version_number);
231: FETCH context_version_cur INTO l_exists;
232: IF context_version_cur%NOTFOUND
233: THEN
234: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
235: FND_MESSAGE.set_token('ID', p_context_id);
236: FND_MSG_PUB.ADD;
237: ELSE
238: l_return_status := true;

Line 235: FND_MESSAGE.set_token('ID', p_context_id);

231: FETCH context_version_cur INTO l_exists;
232: IF context_version_cur%NOTFOUND
233: THEN
234: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
235: FND_MESSAGE.set_token('ID', p_context_id);
236: FND_MSG_PUB.ADD;
237: ELSE
238: l_return_status := true;
239: END IF;

Line 281: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_TYPE_INVLD');

277: OPEN valid_context_cur(l_context_type);
278: FETCH valid_context_cur into l_exists;
279:
280: IF valid_context_cur%NOTFOUND then
281: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_TYPE_INVLD');
282: FND_MESSAGE.set_token('TYPE', l_context_type);
283: FND_MESSAGE.set_token('ID', to_char(null));
284: FND_MSG_PUB.ADD;
285: l_return_status := false;

Line 282: FND_MESSAGE.set_token('TYPE', l_context_type);

278: FETCH valid_context_cur into l_exists;
279:
280: IF valid_context_cur%NOTFOUND then
281: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_TYPE_INVLD');
282: FND_MESSAGE.set_token('TYPE', l_context_type);
283: FND_MESSAGE.set_token('ID', to_char(null));
284: FND_MSG_PUB.ADD;
285: l_return_status := false;
286: ELSE

Line 283: FND_MESSAGE.set_token('ID', to_char(null));

279:
280: IF valid_context_cur%NOTFOUND then
281: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_TYPE_INVLD');
282: FND_MESSAGE.set_token('TYPE', l_context_type);
283: FND_MESSAGE.set_token('ID', to_char(null));
284: FND_MSG_PUB.ADD;
285: l_return_status := false;
286: ELSE
287: l_return_status := true;

Line 345: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_OBJTYPE_INVLD');

341:
342: OPEN valid_object_cur(l_object_type_code);
343: FETCH valid_object_cur into l_exists;
344: IF valid_object_cur%NOTFOUND then
345: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_OBJTYPE_INVLD');
346: FND_MESSAGE.set_token('TYPE', l_object_type_code);
347: FND_MSG_PUB.ADD;
348: l_return_status := false;
349: ELSE

Line 346: FND_MESSAGE.set_token('TYPE', l_object_type_code);

342: OPEN valid_object_cur(l_object_type_code);
343: FETCH valid_object_cur into l_exists;
344: IF valid_object_cur%NOTFOUND then
345: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_OBJTYPE_INVLD');
346: FND_MESSAGE.set_token('TYPE', l_object_type_code);
347: FND_MSG_PUB.ADD;
348: l_return_status := false;
349: ELSE
350: l_return_status := true;

Line 425: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ACCNAME_EXISTS');

421: CLOSE context_accessname_id_cur;
422: end if;
423:
424: if not l_return_status then
425: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ACCNAME_EXISTS');
426: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);
427: FND_MSG_PUB.ADD;
428: end if;
429:

Line 426: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);

422: end if;
423:
424: if not l_return_status then
425: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ACCNAME_EXISTS');
426: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);
427: FND_MSG_PUB.ADD;
428: end if;
429:
430: return l_return_status;

Line 506: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_NOT_EXISTS');

502: OPEN category_cur(p_category_id );
503: FETCH category_cur INTO l_exists;
504: IF category_cur%NOTFOUND
505: THEN
506: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_NOT_EXISTS');
507: FND_MESSAGE.set_token('ID',p_category_id);
508: FND_MSG_PUB.ADD;
509: ELSE
510: l_return_status := true;

Line 507: FND_MESSAGE.set_token('ID',p_category_id);

503: FETCH category_cur INTO l_exists;
504: IF category_cur%NOTFOUND
505: THEN
506: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_NOT_EXISTS');
507: FND_MESSAGE.set_token('ID',p_category_id);
508: FND_MSG_PUB.ADD;
509: ELSE
510: l_return_status := true;
511: END IF;

Line 552: FND_MESSAGE.set_name('JTF','JTF_DSP_ITEM_NOT_EXISTS');

548: OPEN item_cur(p_item_id );
549: FETCH item_cur INTO l_exists;
550: IF item_cur%NOTFOUND
551: THEN
552: FND_MESSAGE.set_name('JTF','JTF_DSP_ITEM_NOT_EXISTS');
553: FND_MESSAGE.set_token('ID',p_item_id);
554: FND_MSG_PUB.ADD;
555: ELSE
556: l_return_status := true;

Line 553: FND_MESSAGE.set_token('ID',p_item_id);

549: FETCH item_cur INTO l_exists;
550: IF item_cur%NOTFOUND
551: THEN
552: FND_MESSAGE.set_name('JTF','JTF_DSP_ITEM_NOT_EXISTS');
553: FND_MESSAGE.set_token('ID',p_item_id);
554: FND_MSG_PUB.ADD;
555: ELSE
556: l_return_status := true;
557: END IF;

Line 597: FND_MESSAGE.set_name('JTF','JTF_DSP_SECTION_NOT_EXISTS');

593: OPEN section_cur(p_section_id );
594: FETCH section_cur INTO l_exists;
595: IF section_cur%NOTFOUND
596: THEN
597: FND_MESSAGE.set_name('JTF','JTF_DSP_SECTION_NOT_EXISTS');
598: FND_MESSAGE.set_token('ID',p_section_id);
599:
600: FND_MSG_PUB.ADD;
601: ELSE

Line 598: FND_MESSAGE.set_token('ID',p_section_id);

594: FETCH section_cur INTO l_exists;
595: IF section_cur%NOTFOUND
596: THEN
597: FND_MESSAGE.set_name('JTF','JTF_DSP_SECTION_NOT_EXISTS');
598: FND_MESSAGE.set_token('ID',p_section_id);
599:
600: FND_MSG_PUB.ADD;
601: ELSE
602: l_return_status := true;

Line 640: FND_MESSAGE.set_name('JTF','JTF_MSITE_RSECID_INVLD');

636: OPEN section_cur(p_root_section_id );
637: FETCH section_cur INTO l_exists;
638: IF section_cur%NOTFOUND
639: THEN
640: FND_MESSAGE.set_name('JTF','JTF_MSITE_RSECID_INVLD');
641: FND_MESSAGE.set_token('ID',p_root_section_id);
642: FND_MSG_PUB.ADD;
643: ELSE
644: l_return_status := true;

Line 641: FND_MESSAGE.set_token('ID',p_root_section_id);

637: FETCH section_cur INTO l_exists;
638: IF section_cur%NOTFOUND
639: THEN
640: FND_MESSAGE.set_name('JTF','JTF_MSITE_RSECID_INVLD');
641: FND_MESSAGE.set_token('ID',p_root_section_id);
642: FND_MSG_PUB.ADD;
643: ELSE
644: l_return_status := true;
645: END IF;

Line 767: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_TYPE_NOT_EXISTS');

763: CLOSE deliverable_type_app_cur;
764: end if;
765:
766: if l_return_status = false then
767: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_TYPE_NOT_EXISTS');
768: FND_MESSAGE.set_token('ID', p_deliverable_id);
769: FND_MESSAGE.set_token('TYPE', p_item_type);
770: FND_MSG_PUB.add;
771: end if;

Line 768: FND_MESSAGE.set_token('ID', p_deliverable_id);

764: end if;
765:
766: if l_return_status = false then
767: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_TYPE_NOT_EXISTS');
768: FND_MESSAGE.set_token('ID', p_deliverable_id);
769: FND_MESSAGE.set_token('TYPE', p_item_type);
770: FND_MSG_PUB.add;
771: end if;
772:

Line 769: FND_MESSAGE.set_token('TYPE', p_item_type);

765:
766: if l_return_status = false then
767: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_TYPE_NOT_EXISTS');
768: FND_MESSAGE.set_token('ID', p_deliverable_id);
769: FND_MESSAGE.set_token('TYPE', p_item_type);
770: FND_MSG_PUB.add;
771: end if;
772:
773: return l_return_status;

Line 852: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_NOT_EXISTS');

848: EXCEPTION
849:
850: WHEN l_dlv_not_exists_exception THEN
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_NOT_EXISTS');
853: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
854: FND_MSG_PUB.add;
855: END IF;
856: RETURN l_return_status;

Line 853: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));

849:
850: WHEN l_dlv_not_exists_exception THEN
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_NOT_EXISTS');
853: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
854: FND_MSG_PUB.add;
855: END IF;
856: RETURN l_return_status;
857:

Line 903: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');

899: OPEN lgl_ctnt_cur(p_lgl_ctnt_id );
900: FETCH lgl_ctnt_cur INTO l_exists;
901: IF lgl_ctnt_cur%NOTFOUND
902: THEN
903: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');
904: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
905: FND_MSG_PUB.ADD;
906: ELSE
907: l_return_status := true;

Line 904: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);

900: FETCH lgl_ctnt_cur INTO l_exists;
901: IF lgl_ctnt_cur%NOTFOUND
902: THEN
903: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');
904: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
905: FND_MSG_PUB.ADD;
906: ELSE
907: l_return_status := true;
908: END IF;

Line 915: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');

911: OPEN lgl_ctnt_version_cur(p_lgl_ctnt_id ,p_object_version_number);
912: FETCH lgl_ctnt_version_cur INTO l_exists;
913: IF lgl_ctnt_version_cur%NOTFOUND
914: THEN
915: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');
916: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
917: FND_MSG_PUB.ADD;
918: ELSE
919: l_return_status := true;

Line 916: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);

912: FETCH lgl_ctnt_version_cur INTO l_exists;
913: IF lgl_ctnt_version_cur%NOTFOUND
914: THEN
915: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');
916: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
917: FND_MSG_PUB.ADD;
918: ELSE
919: l_return_status := true;
920: END IF;

Line 972: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ATH_FILENAME_REQ');

968: BEGIN
969:
970: IF TRIM(p_file_name) IS NULL THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
972: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ATH_FILENAME_REQ');
973: FND_MSG_PUB.add;
974: END IF;
975:
976: ELSE

Line 1005: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_FILENAME_EXISTS');

1001: EXCEPTION
1002:
1003: WHEN l_dup_file_exception THEN
1004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1005: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_FILENAME_EXISTS');
1006: FND_MESSAGE.set_token('FILE_NAME', p_file_name);
1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RETURN l_return_status;

Line 1006: FND_MESSAGE.set_token('FILE_NAME', p_file_name);

1002:
1003: WHEN l_dup_file_exception THEN
1004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1005: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_FILENAME_EXISTS');
1006: FND_MESSAGE.set_token('FILE_NAME', p_file_name);
1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RETURN l_return_status;
1010:

Line 1088: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_NOT_EXISTS');

1084: EXCEPTION
1085:
1086: WHEN l_msite_not_exists_exception THEN
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1088: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_NOT_EXISTS');
1089: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1090: FND_MSG_PUB.add;
1091: END IF;
1092: RETURN l_return_status;

Line 1089: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));

1085:
1086: WHEN l_msite_not_exists_exception THEN
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1088: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_NOT_EXISTS');
1089: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1090: FND_MSG_PUB.add;
1091: END IF;
1092: RETURN l_return_status;
1093:

Line 1145: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');

1141: EXCEPTION
1142:
1143: WHEN l_map_not_exists_exception THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1145: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
1146: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RETURN l_return_status;

Line 1146: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));

1142:
1143: WHEN l_map_not_exists_exception THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1145: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
1146: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RETURN l_return_status;
1150:

Line 1196: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_REQ');

1192: BEGIN
1193:
1194: IF TRIM(p_access_name) IS NULL THEN
1195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1196: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_REQ');
1197: FND_MSG_PUB.add;
1198: END IF;
1199:
1200: ELSE

Line 1230: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_EXISTS');

1226: EXCEPTION
1227:
1228: WHEN l_dup_access_exception THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1230: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_EXISTS');
1231: FND_MESSAGE.set_token('ACC_NAME', p_access_name);
1232: FND_MSG_PUB.add;
1233: END IF;
1234: RETURN l_return_status;

Line 1231: FND_MESSAGE.set_token('ACC_NAME', p_access_name);

1227:
1228: WHEN l_dup_access_exception THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1230: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_EXISTS');
1231: FND_MESSAGE.set_token('ACC_NAME', p_access_name);
1232: FND_MSG_PUB.add;
1233: END IF;
1234: RETURN l_return_status;
1235:

Line 1295: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_LANG_NOT_SUPP' );

1291: EXCEPTION
1292:
1293: WHEN l_lang_not_supp_exception THEN
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1295: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_LANG_NOT_SUPP' );
1296: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1297: FND_MESSAGE.set_token('LANG', p_language_code);
1298: FND_MSG_PUB.add;
1299: END IF;

Line 1296: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));

1292:
1293: WHEN l_lang_not_supp_exception THEN
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1295: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_LANG_NOT_SUPP' );
1296: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1297: FND_MESSAGE.set_token('LANG', p_language_code);
1298: FND_MSG_PUB.add;
1299: END IF;
1300: return l_return_status;

Line 1297: FND_MESSAGE.set_token('LANG', p_language_code);

1293: WHEN l_lang_not_supp_exception THEN
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1295: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_LANG_NOT_SUPP' );
1296: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1297: FND_MESSAGE.set_token('LANG', p_language_code);
1298: FND_MSG_PUB.add;
1299: END IF;
1300: return l_return_status;
1301:

Line 1341: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_INVLD');

1337:
1338: CLOSE item_dlv_cur;
1339:
1340: if l_return_status = false then
1341: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_INVLD');
1342: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1343: FND_MESSAGE.set_token('ID', p_deliverable_id);
1344: FND_MSG_PUB.add;
1345: END IF;

Line 1342: FND_MESSAGE.set_token('ITEM_ID', p_item_id);

1338: CLOSE item_dlv_cur;
1339:
1340: if l_return_status = false then
1341: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_INVLD');
1342: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1343: FND_MESSAGE.set_token('ID', p_deliverable_id);
1344: FND_MSG_PUB.add;
1345: END IF;
1346: else

Line 1343: FND_MESSAGE.set_token('ID', p_deliverable_id);

1339:
1340: if l_return_status = false then
1341: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_INVLD');
1342: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1343: FND_MESSAGE.set_token('ID', p_deliverable_id);
1344: FND_MSG_PUB.add;
1345: END IF;
1346: else
1347: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_REQ');

Line 1347: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_REQ');

1343: FND_MESSAGE.set_token('ID', p_deliverable_id);
1344: FND_MSG_PUB.add;
1345: END IF;
1346: else
1347: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_REQ');
1348: FND_MSG_PUB.add;
1349: END IF;
1350:
1351:

Line 1392: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_INVLD');

1388: open category_dlv_cur(p_category_id,p_deliverable_id);
1389: FETCH category_dlv_cur INTO l_exists;
1390: IF category_dlv_cur%NOTFOUND THEN
1391: CLOSE category_dlv_cur;
1392: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_INVLD');
1393: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1394: FND_MESSAGE.set_token('ID', p_deliverable_id);
1395: FND_MSG_PUB.add;
1396: l_return_status := false;

Line 1393: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);

1389: FETCH category_dlv_cur INTO l_exists;
1390: IF category_dlv_cur%NOTFOUND THEN
1391: CLOSE category_dlv_cur;
1392: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_INVLD');
1393: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1394: FND_MESSAGE.set_token('ID', p_deliverable_id);
1395: FND_MSG_PUB.add;
1396: l_return_status := false;
1397: else

Line 1394: FND_MESSAGE.set_token('ID', p_deliverable_id);

1390: IF category_dlv_cur%NOTFOUND THEN
1391: CLOSE category_dlv_cur;
1392: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_INVLD');
1393: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1394: FND_MESSAGE.set_token('ID', p_deliverable_id);
1395: FND_MSG_PUB.add;
1396: l_return_status := false;
1397: else
1398: CLOSE category_dlv_cur;

Line 1402: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_REQ');

1398: CLOSE category_dlv_cur;
1399: l_return_status := true;
1400: END IF;
1401: else
1402: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_REQ');
1403: FND_MSG_PUB.add;
1404: END IF;
1405:
1406: return l_return_status;

Line 1439: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_MASTER_NOT_EXISTS');

1435: FETCH msite_cur INTO l_msite_id;
1436: close msite_cur;
1437:
1438: if l_msite_id is null then
1439: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_MASTER_NOT_EXISTS');
1440: FND_MSG_PUB.add;
1441: END IF;
1442:
1443: return l_msite_id;

Line 1570: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_ATH_INVLD');

1566: END IF;
1567:
1568: IF NOT l_return_status THEN
1569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_ATH_INVLD');
1571: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1572: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1573: FND_MSG_PUB.ADD;
1574: END IF;

Line 1571: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));

1567:
1568: IF NOT l_return_status THEN
1569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_ATH_INVLD');
1571: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1572: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1573: FND_MSG_PUB.ADD;
1574: END IF;
1575: END IF;

Line 1572: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));

1568: IF NOT l_return_status THEN
1569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_ATH_INVLD');
1571: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1572: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1573: FND_MSG_PUB.ADD;
1574: END IF;
1575: END IF;
1576:

Line 1648: FND_MESSAGE.set_name('JTF','JTF_MSITE_DUP_ACCNAME');

1644: Fetch C_Exists INTO l_exists;
1645: If C_Exists%FOUND Then
1646: l_status := FALSE ;
1647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MESSAGE.set_name('JTF','JTF_MSITE_DUP_ACCNAME');
1649: FND_MESSAGE.set_token('ACCNAME',p_access_name);
1650: FND_MSG_PUB.ADD;
1651: END IF;
1652: Else

Line 1649: FND_MESSAGE.set_token('ACCNAME',p_access_name);

1645: If C_Exists%FOUND Then
1646: l_status := FALSE ;
1647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MESSAGE.set_name('JTF','JTF_MSITE_DUP_ACCNAME');
1649: FND_MESSAGE.set_token('ACCNAME',p_access_name);
1650: FND_MSG_PUB.ADD;
1651: END IF;
1652: Else
1653: l_status := TRUE ;