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.JTF_DSP_SECTION_GRP dependencies on FND_MESSAGE

Line 853: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_DSP_NAME');

849: -- display_name
850: IF ((p_display_name IS NULL) OR
851: (p_display_name = FND_API.G_MISS_CHAR))
852: THEN
853: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_DSP_NAME');
854: FND_MSG_PUB.Add;
855: RAISE FND_API.G_EXC_ERROR;
856: END IF;
857:

Line 862: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_SCT_TYPE');

858: -- section_type_code
859: IF ((p_section_type_code IS NULL) OR
860: (p_section_type_code = FND_API.G_MISS_CHAR))
861: THEN
862: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_SCT_TYPE');
863: FND_MSG_PUB.Add;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:

Line 871: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_STATUS');

867: -- status_code
868: IF ((p_status_code IS NULL) OR
869: (p_status_code = FND_API.G_MISS_CHAR))
870: THEN
871: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_STATUS');
872: FND_MSG_PUB.Add;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:

Line 880: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_START_DATE');

876: -- start_date_active
877: IF ((p_start_date_active IS NULL) OR
878: (p_start_date_active = FND_API.G_MISS_DATE))
879: THEN
880: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_START_DATE');
881: FND_MSG_PUB.Add;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884:

Line 895: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AVL_FLAG');

891: THEN
892: IF(p_available_in_all_sites_flag <> 'Y' AND
893: p_available_in_all_sites_flag <> 'N')
894: THEN
895: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AVL_FLAG');
896: FND_MSG_PUB.Add;
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;
899: END IF;

Line 914: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');

910:
911: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
914: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');
915: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;

Line 915: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);

911: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
914: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');
915: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919:

Line 936: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');

932:
933: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
936: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');
937: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;

Line 937: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);

933: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
936: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');
937: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941:

Line 956: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_DUPLICATE_SECT');

952:
953: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
956: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_DUPLICATE_SECT');
957: FND_MSG_PUB.Add;
958: RAISE FND_API.G_EXC_ERROR; -- duplicate section
959: END IF;
960:

Line 973: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');

969: SELECT context_id INTO l_display_context_id FROM jtf_dsp_context_b
970: WHERE context_id = p_display_context_id;
971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN
973: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');
974: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
975: FND_MSG_PUB.Add;
976: RAISE FND_API.G_EXC_ERROR;
977: WHEN OTHERS THEN

Line 974: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);

970: WHERE context_id = p_display_context_id;
971: EXCEPTION
972: WHEN NO_DATA_FOUND THEN
973: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');
974: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
975: FND_MSG_PUB.Add;
976: RAISE FND_API.G_EXC_ERROR;
977: WHEN OTHERS THEN
978: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');

Line 978: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');

974: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
975: FND_MSG_PUB.Add;
976: RAISE FND_API.G_EXC_ERROR;
977: WHEN OTHERS THEN
978: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');
979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
981: END;
982: END IF;

Line 993: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');

989: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
990: WHERE item_id = p_deliverable_id;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');
994: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
995: FND_MSG_PUB.Add;
996: RAISE FND_API.G_EXC_ERROR;
997: WHEN OTHERS THEN

Line 994: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);

990: WHERE item_id = p_deliverable_id;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');
994: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
995: FND_MSG_PUB.Add;
996: RAISE FND_API.G_EXC_ERROR;
997: WHEN OTHERS THEN
998: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');

Line 998: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');

994: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
995: FND_MSG_PUB.Add;
996: RAISE FND_API.G_EXC_ERROR;
997: WHEN OTHERS THEN
998: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');
999: FND_MSG_PUB.Add;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: END;
1002: END IF;

Line 1013: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');

1009: lookup_code = p_section_type_code AND
1010: language = USERENV('LANG');
1011: EXCEPTION
1012: WHEN NO_DATA_FOUND THEN
1013: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');
1014: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1015: FND_MSG_PUB.Add;
1016: RAISE FND_API.G_EXC_ERROR;
1017: WHEN OTHERS THEN

Line 1014: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);

1010: language = USERENV('LANG');
1011: EXCEPTION
1012: WHEN NO_DATA_FOUND THEN
1013: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');
1014: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1015: FND_MSG_PUB.Add;
1016: RAISE FND_API.G_EXC_ERROR;
1017: WHEN OTHERS THEN
1018: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');

Line 1018: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');

1014: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1015: FND_MSG_PUB.Add;
1016: RAISE FND_API.G_EXC_ERROR;
1017: WHEN OTHERS THEN
1018: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');
1019: FND_MSG_PUB.Add;
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1021: END;
1022:

Line 1029: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');

1025: OPEN c3(p_status_code);
1026: FETCH c3 INTO l_tmp_str;
1027: IF (c3%NOTFOUND) THEN
1028: CLOSE c3;
1029: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');
1030: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1031: FND_MSG_PUB.Add;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;

Line 1030: FND_MESSAGE.Set_Token('STATUS', p_status_code);

1026: FETCH c3 INTO l_tmp_str;
1027: IF (c3%NOTFOUND) THEN
1028: CLOSE c3;
1029: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');
1030: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1031: FND_MSG_PUB.Add;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: CLOSE c3;

Line 1144: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_SCT_ID');

1140: -- Check null values for required fields
1141: --
1142: -- section_id
1143: IF (p_section_id IS NULL) THEN
1144: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_SCT_ID');
1145: FND_MSG_PUB.Add;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:

Line 1151: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_DSP_NAME');

1147: END IF;
1148:
1149: -- display_name
1150: IF (p_display_name IS NULL) THEN
1151: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_DSP_NAME');
1152: FND_MSG_PUB.Add;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155:

Line 1158: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_SCT_TYPE');

1154: END IF;
1155:
1156: -- section_type_code
1157: IF (p_section_type_code IS NULL) THEN
1158: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_SCT_TYPE');
1159: FND_MSG_PUB.Add;
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:

Line 1165: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_STATUS');

1161: END IF;
1162:
1163: -- status_code
1164: IF (p_status_code IS NULL) THEN
1165: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_STATUS');
1166: FND_MSG_PUB.Add;
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169:

Line 1172: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_START_DATE');

1168: END IF;
1169:
1170: -- start_date_active
1171: IF (p_start_date_active IS NULL) THEN
1172: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NULL_START_DATE');
1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:

Line 1184: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AVL_FLAG');

1180: THEN
1181: IF(p_available_in_all_sites_flag <> 'Y' AND
1182: p_available_in_all_sites_flag <> 'N')
1183: THEN
1184: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AVL_FLAG');
1185: FND_MSG_PUB.Add;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: END IF;

Line 1203: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');

1199:
1200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1203: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');
1204: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
1205: FND_MSG_PUB.Add;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

Line 1204: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);

1200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1203: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_AUTO_PLACE');
1204: FND_MESSAGE.Set_Token('AUTO_PLACEMENT_RULE', p_auto_placement_rule);
1205: FND_MSG_PUB.Add;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:

Line 1225: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');

1221:
1222: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1225: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');
1226: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
1227: FND_MSG_PUB.Add;
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;

Line 1226: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);

1222: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1225: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_ORDER_BY');
1226: FND_MESSAGE.Set_Token('ORDER_BY_CLAUSE', p_order_by_clause);
1227: FND_MSG_PUB.Add;
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:

Line 1246: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_DUPLICATE_SECT');

1242:
1243: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1246: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_DUPLICATE_SECT');
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR; -- duplicate fields
1249: END IF;
1250:

Line 1263: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');

1259: SELECT context_id INTO l_display_context_id FROM jtf_dsp_context_b
1260: WHERE context_id = p_display_context_id;
1261: EXCEPTION
1262: WHEN NO_DATA_FOUND THEN
1263: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');
1264: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: WHEN OTHERS THEN

Line 1264: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);

1260: WHERE context_id = p_display_context_id;
1261: EXCEPTION
1262: WHEN NO_DATA_FOUND THEN
1263: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DSP_CTX');
1264: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: WHEN OTHERS THEN
1268: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');

Line 1268: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');

1264: FND_MESSAGE.Set_Token('DISPLAY_CONTEXT', p_display_context_id);
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: WHEN OTHERS THEN
1268: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DSP_CTX');
1269: FND_MSG_PUB.Add;
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END;
1272: END IF;

Line 1283: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');

1279: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
1280: WHERE item_id = p_deliverable_id;
1281: EXCEPTION
1282: WHEN NO_DATA_FOUND THEN
1283: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');
1284: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
1285: FND_MSG_PUB.Add;
1286: RAISE FND_API.G_EXC_ERROR;
1287: WHEN OTHERS THEN

Line 1284: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);

1280: WHERE item_id = p_deliverable_id;
1281: EXCEPTION
1282: WHEN NO_DATA_FOUND THEN
1283: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');
1284: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
1285: FND_MSG_PUB.Add;
1286: RAISE FND_API.G_EXC_ERROR;
1287: WHEN OTHERS THEN
1288: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');

Line 1288: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');

1284: FND_MESSAGE.Set_Token('DELIVERABLE', p_deliverable_id);
1285: FND_MSG_PUB.Add;
1286: RAISE FND_API.G_EXC_ERROR;
1287: WHEN OTHERS THEN
1288: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_DLVRBL');
1289: FND_MSG_PUB.Add;
1290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1291: END;
1292: END IF;

Line 1304: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');

1300: lookup_code = p_section_type_code AND
1301: language = USERENV('LANG');
1302: EXCEPTION
1303: WHEN NO_DATA_FOUND THEN
1304: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');
1305: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1306: FND_MSG_PUB.Add;
1307: RAISE FND_API.G_EXC_ERROR;
1308: WHEN OTHERS THEN

Line 1305: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);

1301: language = USERENV('LANG');
1302: EXCEPTION
1303: WHEN NO_DATA_FOUND THEN
1304: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_TYPE');
1305: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1306: FND_MSG_PUB.Add;
1307: RAISE FND_API.G_EXC_ERROR;
1308: WHEN OTHERS THEN
1309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');

Line 1309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');

1305: FND_MESSAGE.Set_Token('SECTION_TYPE', p_section_type_code);
1306: FND_MSG_PUB.Add;
1307: RAISE FND_API.G_EXC_ERROR;
1308: WHEN OTHERS THEN
1309: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_TYPE');
1310: FND_MSG_PUB.Add;
1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END;
1313: END IF;

Line 1322: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');

1318: OPEN c3(p_status_code);
1319: FETCH c3 INTO l_tmp_str;
1320: IF (c3%NOTFOUND) THEN
1321: CLOSE c3;
1322: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');
1323: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1324: FND_MSG_PUB.Add;
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;

Line 1323: FND_MESSAGE.Set_Token('STATUS', p_status_code);

1319: FETCH c3 INTO l_tmp_str;
1320: IF (c3%NOTFOUND) THEN
1321: CLOSE c3;
1322: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_STATUS');
1323: FND_MESSAGE.Set_Token('STATUS', p_status_code);
1324: FND_MSG_PUB.Add;
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327: CLOSE c3;

Line 1486: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_CREATE');

1482:
1483: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1486: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_CREATE');
1487: FND_MSG_PUB.Add;
1488: RAISE FND_API.G_EXC_ERROR; -- invalid section
1489: END IF;
1490:

Line 1539: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');

1535: x_section_id
1536: );
1537: EXCEPTION
1538: WHEN NO_DATA_FOUND THEN
1539: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');
1540: FND_MSG_PUB.Add;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN OTHERS THEN
1543: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');

Line 1543: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');

1539: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');
1540: FND_MSG_PUB.Add;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN OTHERS THEN
1543: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INSERT_FAIL');
1544: FND_MSG_PUB.Add;
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: END;
1547:

Line 1685: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');

1681: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b
1682: WHERE access_name = p_access_name;
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1686: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1687: FND_MSG_PUB.Add;
1688: RAISE FND_API.G_EXC_ERROR;
1689: WHEN OTHERS THEN

Line 1686: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);

1682: WHERE access_name = p_access_name;
1683: EXCEPTION
1684: WHEN NO_DATA_FOUND THEN
1685: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1686: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1687: FND_MSG_PUB.Add;
1688: RAISE FND_API.G_EXC_ERROR;
1689: WHEN OTHERS THEN
1690: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ACSS_NAME');

Line 1690: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ACSS_NAME');

1686: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1687: FND_MSG_PUB.Add;
1688: RAISE FND_API.G_EXC_ERROR;
1689: WHEN OTHERS THEN
1690: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ACSS_NAME');
1691: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END;

Line 1691: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);

1687: FND_MSG_PUB.Add;
1688: RAISE FND_API.G_EXC_ERROR;
1689: WHEN OTHERS THEN
1690: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ACSS_NAME');
1691: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END;
1695: ELSE

Line 1697: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_ID_OR_ACSS');

1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END;
1695: ELSE
1696: -- neither section_id nor access_name is specified
1697: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_ID_OR_ACSS');
1698: FND_MSG_PUB.Add;
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;
1701:

Line 1750: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_CREATE');

1746:
1747: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1750: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_INVALID_CREATE');
1751: FND_MSG_PUB.Add;
1752: RAISE FND_API.G_EXC_ERROR; -- invalid section
1753: END IF;
1754:

Line 1797: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');

1793: FND_GLOBAL.login_id
1794: );
1795: EXCEPTION
1796: WHEN NO_DATA_FOUND THEN
1797: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');
1798: FND_MSG_PUB.Add;
1799: RAISE FND_API.G_EXC_ERROR;
1800: WHEN OTHERS THEN
1801: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');

Line 1801: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');

1797: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');
1798: FND_MSG_PUB.Add;
1799: RAISE FND_API.G_EXC_ERROR;
1800: WHEN OTHERS THEN
1801: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');
1802: FND_MSG_PUB.Add;
1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804: END;
1805:

Line 1922: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');

1918: SELECT section_id INTO l_section_id FROM jtf_dsp_sections_b
1919: WHERE access_name = p_access_name;
1920: EXCEPTION
1921: WHEN NO_DATA_FOUND THEN
1922: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1923: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1924: FND_MSG_PUB.Add;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN OTHERS THEN

Line 1923: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);

1919: WHERE access_name = p_access_name;
1920: EXCEPTION
1921: WHEN NO_DATA_FOUND THEN
1922: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1923: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1924: FND_MSG_PUB.Add;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN OTHERS THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');

Line 1927: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');

1923: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1924: FND_MSG_PUB.Add;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN OTHERS THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1928: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1929: FND_MSG_PUB.Add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END;

Line 1928: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);

1924: FND_MSG_PUB.Add;
1925: RAISE FND_API.G_EXC_ERROR;
1926: WHEN OTHERS THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ACSS_NAME');
1928: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1929: FND_MSG_PUB.Add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END;
1932: ELSE

Line 1934: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_ID_OR_ACSS');

1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END;
1932: ELSE
1933: -- neither section_id nor access_name is specified, therefore cannot delete
1934: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_ID_OR_ACSS');
1935: FND_MSG_PUB.Add;
1936: RAISE FND_API.G_EXC_ERROR;
1937: END IF;
1938:

Line 1948: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_MSITE_REF');

1944: -- If yes, then cannot delete this section
1945: OPEN c3(l_section_id);
1946: FETCH c3 INTO l_mini_site_id;
1947: IF (c3%FOUND) THEN
1948: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_MSITE_REF');
1949: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
1950: FND_MESSAGE.Set_Token('MINI_SITE_ID', l_mini_site_id);
1951: FND_MSG_PUB.Add;
1952: RAISE FND_API.G_EXC_ERROR;

Line 1949: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);

1945: OPEN c3(l_section_id);
1946: FETCH c3 INTO l_mini_site_id;
1947: IF (c3%FOUND) THEN
1948: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_MSITE_REF');
1949: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
1950: FND_MESSAGE.Set_Token('MINI_SITE_ID', l_mini_site_id);
1951: FND_MSG_PUB.Add;
1952: RAISE FND_API.G_EXC_ERROR;
1953: END IF;

Line 1950: FND_MESSAGE.Set_Token('MINI_SITE_ID', l_mini_site_id);

1946: FETCH c3 INTO l_mini_site_id;
1947: IF (c3%FOUND) THEN
1948: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_MSITE_REF');
1949: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
1950: FND_MESSAGE.Set_Token('MINI_SITE_ID', l_mini_site_id);
1951: FND_MSG_PUB.Add;
1952: RAISE FND_API.G_EXC_ERROR;
1953: END IF;
1954: