DBA Data[Home] [Help]

APPS.CSP_PLANNED_ORDERS dependencies on FND_MESSAGE

Line 179: FND_MESSAGE.SET_NAME('CSP', 'CSP_REPAIR_ASSIGNMENT_NULL');

175: End loop;
176: Close c_supplier;
177:
178: If l_supplier_available = 0 then
179: FND_MESSAGE.SET_NAME('CSP', 'CSP_REPAIR_ASSIGNMENT_NULL');
180: FND_MSG_PUB.ADD;
181: RAISE EXCP_USER_DEFINED;
182: End if;
183:

Line 202: FND_MESSAGE.SET_NAME('CSP', 'CSP_REPAIR_SUPPLIER_NULL');

198: and sourcing_level not in (2,9))
199: order by misl.rank;
200: */
201: IF (l_source_type = 3 and l_repair_supplier_id IS NULL) THEN
202: FND_MESSAGE.SET_NAME('CSP', 'CSP_REPAIR_SUPPLIER_NULL');
203: FND_MSG_PUB.ADD;
204: RAISE EXCP_USER_DEFINED;
205: END IF;
206: /*

Line 209: FND_MESSAGE.SET_NAME('CSP', 'CSP_REPAIR_ASSIGNMENT_NULL');

205: END IF;
206: /*
207: exception
208: WHEN NO_DATA_FOUND THEN
209: FND_MESSAGE.SET_NAME('CSP', 'CSP_REPAIR_ASSIGNMENT_NULL');
210: FND_MSG_PUB.ADD;
211: RAISE EXCP_USER_DEFINED;
212: end;
213: */

Line 282: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');

278: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END If;
281: ELSE
282: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
283: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);
284: FND_MSG_PUB.ADD;
285: RAISE EXCP_USER_DEFINED;
286: END IF;

Line 283: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);

279: RAISE FND_API.G_EXC_ERROR;
280: END If;
281: ELSE
282: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
283: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);
284: FND_MSG_PUB.ADD;
285: RAISE EXCP_USER_DEFINED;
286: END IF;
287: exception

Line 289: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');

285: RAISE EXCP_USER_DEFINED;
286: END IF;
287: exception
288: when no_data_found then
289: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
290: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);
291: FND_MSG_PUB.ADD;
292: RAISE EXCP_USER_DEFINED;
293: end;

Line 290: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);

286: END IF;
287: exception
288: when no_data_found then
289: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
290: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', to_char(null), TRUE);
291: FND_MSG_PUB.ADD;
292: RAISE EXCP_USER_DEFINED;
293: end;
294: END IF;

Line 310: FND_MESSAGE.SET_NAME('CSP', 'CSP_WIP_ORDER_ERROR');

306: FROM dual;
307:
308: IF (l_item_attr_rec.build_in_wip <> 'Y' OR
309: l_item_attr_rec.pick_components <> 'N') THEN
310: FND_MESSAGE.SET_NAME('CSP', 'CSP_WIP_ORDER_ERROR');
311: FND_MSG_PUB.ADD;
312: RAISE EXCP_USER_DEFINED;
313: END IF;
314:

Line 347: FND_MESSAGE.SET_NAME('CSP', 'CSP_CREATE_REQ_ERROR');

343: */
344: IF ((l_item_attr_Rec.src_type IS NULL) OR
345: (l_item_Attr_Rec.src_type = 1 AND l_item_attr_rec.order_flag <> 'Y') OR
346: (l_item_attr_rec.src_type = 2 AND l_item_attr_rec.purch_flag <> 'Y')) THEN
347: FND_MESSAGE.SET_NAME('CSP', 'CSP_CREATE_REQ_ERROR');
348: FND_MSG_PUB.ADD;
349: RAISE EXCP_USER_DEFINED;
350: END IF;
351:

Line 441: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

437: ,X_MSG_DATA => X_MSG_DATA
438: ,X_RETURN_STATUS => X_RETURN_STATUS);
439: WHEN OTHERS THEN
440: Rollback to create_orders_pub;
441: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
442: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
443: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
444: FND_MSG_PUB.ADD;
445: fnd_msg_pub.count_and_get

Line 442: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

438: ,X_RETURN_STATUS => X_RETURN_STATUS);
439: WHEN OTHERS THEN
440: Rollback to create_orders_pub;
441: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
442: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
443: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
444: FND_MSG_PUB.ADD;
445: fnd_msg_pub.count_and_get
446: ( p_count => x_msg_count

Line 443: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

439: WHEN OTHERS THEN
440: Rollback to create_orders_pub;
441: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
442: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
443: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
444: FND_MSG_PUB.ADD;
445: fnd_msg_pub.count_and_get
446: ( p_count => x_msg_count
447: , p_data => x_msg_data);