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

Line 133: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_DEFECTIVE_QUANTITY');

129: l_reservation_rec.sub_inventory_code := Null;
130: l_reservation_rec.line_id := Null;
131:
132: If l_defective_parts_rec.defective_quantity <= 0 then
133: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_DEFECTIVE_QUANTITY');
134: FND_MSG_PUB.ADD;
135: RAISE EXCP_USER_DEFINED;
136: End if;
137:

Line 150: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');

146: ,x_msg_count
147: );
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: L_SOURCE_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_source_organization_id);
150: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
151: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);
152: FND_MSG_PUB.ADD;
153: RAISE EXCP_USER_DEFINED;
154: END IF;

Line 151: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);

147: );
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: L_SOURCE_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_source_organization_id);
150: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
151: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);
152: FND_MSG_PUB.ADD;
153: RAISE EXCP_USER_DEFINED;
154: END IF;
155:

Line 168: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');

164: ,x_msg_count
165: );
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
167: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
168: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
169: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
170: FND_MSG_PUB.ADD;
171: RAISE EXCP_USER_DEFINED;
172: END IF;

Line 169: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);

165: );
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
167: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
168: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
169: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
170: FND_MSG_PUB.ADD;
171: RAISE EXCP_USER_DEFINED;
172: END IF;
173:

Line 245: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');

241: and NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
242: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
243: Exception
244: When No_Data_Found then
245: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');
246: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);
247: FND_MSG_PUB.ADD;
248: RAISE EXCP_USER_DEFINED;
249: End;

Line 246: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);

242: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
243: Exception
244: When No_Data_Found then
245: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');
246: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);
247: FND_MSG_PUB.ADD;
248: RAISE EXCP_USER_DEFINED;
249: End;
250:

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

258: where ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
259: and ORG_INFORMATION3 = P_repair_supplier_id; ---> 1159 (Vendor Id parameter)
260: Exception
261: When No_Data_Found then
262: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
263: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
264: --(OR) No organization is linked with the repair supplier Id.
265: FND_MSG_PUB.ADD;
266: RAISE EXCP_USER_DEFINED;

Line 263: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);

259: and ORG_INFORMATION3 = P_repair_supplier_id; ---> 1159 (Vendor Id parameter)
260: Exception
261: When No_Data_Found then
262: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
263: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
264: --(OR) No organization is linked with the repair supplier Id.
265: FND_MSG_PUB.ADD;
266: RAISE EXCP_USER_DEFINED;
267: End;

Line 295: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');

291: and NVL(a.START_DATE_ACTIVE,SYSDATE) <= SYSDATE
292: and NVL(a.END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
293: Exception
294: When no_data_found then
295: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');
296: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);
297: FND_MSG_PUB.ADD;
298: RAISE EXCP_USER_DEFINED;
299: End;

Line 296: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);

292: and NVL(a.END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
293: Exception
294: When no_data_found then
295: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');
296: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);
297: FND_MSG_PUB.ADD;
298: RAISE EXCP_USER_DEFINED;
299: End;
300: */

Line 317: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_PROGRAM');

313: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
314: and lookup_code = p_repair_program;
315: Exception
316: When no_data_found then
317: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_PROGRAM');
318: FND_MSG_PUB.ADD;
319: RAISE EXCP_USER_DEFINED;
320: End;
321:

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

329:
330: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
331:
332: If L_REPAIR_ORGANIZATION_NAME is null then
333: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
334: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
335: --(OR) No organization is linked with the repair supplier Id.
336: FND_MSG_PUB.ADD;
337: RAISE EXCP_USER_DEFINED;

Line 334: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);

330: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
331:
332: If L_REPAIR_ORGANIZATION_NAME is null then
333: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
334: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
335: --(OR) No organization is linked with the repair supplier Id.
336: FND_MSG_PUB.ADD;
337: RAISE EXCP_USER_DEFINED;
338:

Line 351: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');

347: ,x_msg_data
348: ,x_msg_count
349: );
350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
352: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
353: FND_MSG_PUB.ADD;
354: RAISE EXCP_USER_DEFINED;
355: END IF;

Line 352: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);

348: ,x_msg_count
349: );
350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
352: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
353: FND_MSG_PUB.ADD;
354: RAISE EXCP_USER_DEFINED;
355: END IF;
356:

Line 365: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');

361: WHERE ORGANIZATION_ID = L_repair_supplier_org_id;
362: Exception
363: When no_data_found then
364: --l_supplier_org_location_id := Null;
365: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');
366: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
367: FND_MSG_PUB.ADD;
368: RAISE EXCP_USER_DEFINED;
369: End;

Line 366: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);

362: Exception
363: When no_data_found then
364: --l_supplier_org_location_id := Null;
365: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');
366: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
367: FND_MSG_PUB.ADD;
368: RAISE EXCP_USER_DEFINED;
369: End;
370:

Line 378: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');

374: a customer must be associated with this location in Purchasing*/
375:
376: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
377: If L_DEST_ORGANIZATION_NAME is null then
378: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');
379: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);
380: FND_MSG_PUB.ADD;
381: RAISE EXCP_USER_DEFINED;
382: Elsif L_DEST_ORGANIZATION_NAME is not null then

Line 379: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);

375:
376: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
377: If L_DEST_ORGANIZATION_NAME is null then
378: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');
379: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);
380: FND_MSG_PUB.ADD;
381: RAISE EXCP_USER_DEFINED;
382: Elsif L_DEST_ORGANIZATION_NAME is not null then
383:

Line 395: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');

391: ,x_msg_data
392: ,x_msg_count
393: );
394: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
395: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');
396: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);
397: FND_MSG_PUB.ADD;
398: RAISE EXCP_USER_DEFINED;
399: END IF;

Line 396: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);

392: ,x_msg_count
393: );
394: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
395: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');
396: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);
397: FND_MSG_PUB.ADD;
398: RAISE EXCP_USER_DEFINED;
399: END IF;
400:

Line 409: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');

405: WHERE ORGANIZATION_ID = P_dest_organization_id;
406: Exception
407: When no_data_found then
408: --l_ship_to_location_id := Null;
409: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
410: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;
413: End;

Line 410: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);

406: Exception
407: When no_data_found then
408: --l_ship_to_location_id := Null;
409: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
410: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
411: FND_MSG_PUB.ADD;
412: RAISE EXCP_USER_DEFINED;
413: End;
414: End if;

Line 430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');

426: Exception
427: When no_data_found then
428: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
429: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
431: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
432: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
433: FND_MSG_PUB.ADD;
434: RAISE EXCP_USER_DEFINED;

Line 431: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);

427: When no_data_found then
428: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
429: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
431: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
432: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
433: FND_MSG_PUB.ADD;
434: RAISE EXCP_USER_DEFINED;
435: End;

Line 432: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);

428: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
429: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
430: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
431: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
432: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
433: FND_MSG_PUB.ADD;
434: RAISE EXCP_USER_DEFINED;
435: End;
436:

Line 438: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_QTY');

434: RAISE EXCP_USER_DEFINED;
435: End;
436:
437: If nvl(P_quantity,0) <= 0 then
438: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_QTY');
439: FND_MSG_PUB.ADD;
440: RAISE EXCP_USER_DEFINED;
441: End if;
442:

Line 444: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_DATE');

440: RAISE EXCP_USER_DEFINED;
441: End if;
442:
443: If trunc(nvl(P_need_by_date,sysdate)) <= trunc(sysdate) then
444: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_DATE');
445: FND_MSG_PUB.ADD;
446: RAISE EXCP_USER_DEFINED;
447: End if;
448:

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

753: ,X_MSG_DATA => X_MSG_DATA
754: ,X_RETURN_STATUS => X_RETURN_STATUS);
755: WHEN OTHERS THEN
756: Rollback to CREATE_REPAIR_PO_PUB;
757: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
758: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
759: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
760: FND_MSG_PUB.ADD;
761: fnd_msg_pub.count_and_get

Line 758: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

754: ,X_RETURN_STATUS => X_RETURN_STATUS);
755: WHEN OTHERS THEN
756: Rollback to CREATE_REPAIR_PO_PUB;
757: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
758: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
759: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
760: FND_MSG_PUB.ADD;
761: fnd_msg_pub.count_and_get
762: (p_count => x_msg_count

Line 759: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

755: WHEN OTHERS THEN
756: Rollback to CREATE_REPAIR_PO_PUB;
757: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
758: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
759: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
760: FND_MSG_PUB.ADD;
761: fnd_msg_pub.count_and_get
762: (p_count => x_msg_count
763: ,p_data => x_msg_data);

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

821: CLOSE item_cur;
822:
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
827: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
828: FND_MSG_PUB.ADD;
829: fnd_msg_pub.count_and_get

Line 826: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

822:
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
827: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
828: FND_MSG_PUB.ADD;
829: fnd_msg_pub.count_and_get
830: (p_count => x_msg_count

Line 827: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
826: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
827: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
828: FND_MSG_PUB.ADD;
829: fnd_msg_pub.count_and_get
830: (p_count => x_msg_count
831: ,p_data => x_msg_data);