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_MSG_PUB

Line 100: FND_MSG_PUB.initialize;

96: SAVEPOINT CREATE_REPAIR_PO_PUB;
97:
98: /*----------- Initialize Message List ------------ */
99: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: /*----------- Standard call to check for call compatibility --------- */
104: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 137: FND_MSG_PUB.ADD;

133: l_reservation_rec.line_id := l_demand_source_line_id;
134:
135: If l_defective_parts_rec.defective_quantity <= 0 then
136: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_DEFECTIVE_QUANTITY');
137: FND_MSG_PUB.ADD;
138: RAISE EXCP_USER_DEFINED;
139: End if;
140:
141: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 155: FND_MSG_PUB.ADD;

151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: L_SOURCE_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_source_organization_id);
153: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_DEFECTORG');
154: FND_MESSAGE.SET_TOKEN ('DEFECTIVE_ORG_NAME', L_SOURCE_ORGANIZATION_NAME,TRUE);
155: FND_MSG_PUB.ADD;
156: RAISE EXCP_USER_DEFINED;
157: END IF;
158:
159: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 173: FND_MSG_PUB.ADD;

169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: L_REPAIR_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_repair_supplier_org_id);
171: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFECTITEM_AT_REPAIRORG');
172: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
173: FND_MSG_PUB.ADD;
174: RAISE EXCP_USER_DEFINED;
175: END IF;
176:
177: l_reservation_rec.item_uom_code := X_PRIMARY_UOM_CODE;

Line 250: FND_MSG_PUB.ADD;

246: Exception
247: When No_Data_Found then
248: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_SUPPLIER');
249: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ID',to_char(P_repair_supplier_id), TRUE);
250: FND_MSG_PUB.ADD;
251: RAISE EXCP_USER_DEFINED;
252: End;
253:
254: ---------------------------------------------------------------

Line 269: FND_MSG_PUB.ADD;

265: When No_Data_Found then
266: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
267: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
268: --(OR) No organization is linked with the repair supplier Id.
269: FND_MSG_PUB.ADD;
270: RAISE EXCP_USER_DEFINED;
271: End;
272: End if;
273:

Line 302: FND_MSG_PUB.ADD;

298: Exception
299: When no_data_found then
300: FND_MESSAGE.SET_NAME ('CSP','CSP_MISSING_PARAMETERS');
301: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'Repair Supplier ID cannot be null', TRUE);
302: FND_MSG_PUB.ADD;
303: RAISE EXCP_USER_DEFINED;
304: End;
305: */
306:

Line 323: FND_MSG_PUB.ADD;

319: and lookup_code = p_repair_program;
320: Exception
321: When no_data_found then
322: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_REPAIR_PROGRAM');
323: FND_MSG_PUB.ADD;
324: RAISE EXCP_USER_DEFINED;
325: End;
326:
327: select csp_repair_po_headers_s1.nextval

Line 341: FND_MSG_PUB.ADD;

337: If L_REPAIR_ORGANIZATION_NAME is null then
338: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIR_SUPPLIER_ORG');
339: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_NAME', l_VENDOR_NAME, TRUE);
340: --(OR) No organization is linked with the repair supplier Id.
341: FND_MSG_PUB.ADD;
342: RAISE EXCP_USER_DEFINED;
343:
344: Elsif L_REPAIR_ORGANIZATION_NAME is not null then
345: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 358: FND_MSG_PUB.ADD;

354: );
355: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_REPAIRORG');
357: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG_NAME', L_REPAIR_ORGANIZATION_NAME,TRUE);
358: FND_MSG_PUB.ADD;
359: RAISE EXCP_USER_DEFINED;
360: END IF;
361:
362: Begin

Line 372: FND_MSG_PUB.ADD;

368: When no_data_found then
369: --l_supplier_org_location_id := Null;
370: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPFROM_LOCATION_ID');
371: FND_MESSAGE.SET_TOKEN ('REPAIR_SUPPLIER_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
372: FND_MSG_PUB.ADD;
373: RAISE EXCP_USER_DEFINED;
374: End;
375:
376: End if;

Line 385: FND_MSG_PUB.ADD;

381: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
382: If L_DEST_ORGANIZATION_NAME is null then
383: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_VALID_DEST_ORG');
384: FND_MESSAGE.SET_TOKEN ('DEST_ORG_ID', to_char(P_dest_organization_id), TRUE);
385: FND_MSG_PUB.ADD;
386: RAISE EXCP_USER_DEFINED;
387: Elsif L_DEST_ORGANIZATION_NAME is not null then
388:
389: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 402: FND_MSG_PUB.ADD;

398: );
399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_REPAIRITEM_AT_DESTORG');
401: FND_MESSAGE.SET_TOKEN ('DEST_ORG_NAME', L_DEST_ORGANIZATION_NAME,TRUE);
402: FND_MSG_PUB.ADD;
403: RAISE EXCP_USER_DEFINED;
404: END IF;
405:
406: Begin

Line 416: FND_MSG_PUB.ADD;

412: When no_data_found then
413: --l_ship_to_location_id := Null;
414: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_SHIPTO_LOCATION_ID');
415: FND_MESSAGE.SET_TOKEN ('DESTINATION_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;
418: End;
419: End if;
420: -------- No shipping network between Org's with Default shipping method assigned ---------

Line 438: FND_MSG_PUB.ADD;

434: L_DEST_ORGANIZATION_NAME := GET_ORGANIZATION_NAME(P_dest_organization_id);
435: FND_MESSAGE.SET_NAME ('CSP','CSP_NO_DEFAULT_SHIPPING_METHOD');
436: FND_MESSAGE.SET_TOKEN ('FROM_ORG', L_REPAIR_ORGANIZATION_NAME, TRUE);
437: FND_MESSAGE.SET_TOKEN ('TO_ORG', L_DEST_ORGANIZATION_NAME, TRUE);
438: FND_MSG_PUB.ADD;
439: RAISE EXCP_USER_DEFINED;
440: End;
441: else
442: l_shipping_method_code := p_shipping_method;

Line 446: FND_MSG_PUB.ADD;

442: l_shipping_method_code := p_shipping_method;
443: end if ;
444: If nvl(P_quantity,0) <= 0 then
445: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_QTY');
446: FND_MSG_PUB.ADD;
447: RAISE EXCP_USER_DEFINED;
448: End if;
449:
450: If trunc(nvl(P_need_by_date,sysdate)) <= trunc(sysdate) then

Line 452: FND_MSG_PUB.ADD;

448: End if;
449:
450: If trunc(nvl(P_need_by_date,sysdate)) <= trunc(sysdate) then
451: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_REPAIRPO_NEED_DATE');
452: FND_MSG_PUB.ADD;
453: RAISE EXCP_USER_DEFINED;
454: End if;
455:
456: l_header_rec.ship_to_location_id := l_ship_to_location_id;

Line 741: fnd_msg_pub.count_and_get

737: EXCEPTION
738: WHEN EXCP_USER_DEFINED THEN
739: Rollback to CREATE_REPAIR_PO_PUB;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: fnd_msg_pub.count_and_get
742: (p_count => x_msg_count
743: ,p_data => x_msg_data);
744: WHEN FND_API.G_EXC_ERROR THEN
745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 748: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

744: WHEN FND_API.G_EXC_ERROR THEN
745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
746: P_API_NAME => L_API_NAME
747: ,P_PKG_NAME => G_PKG_NAME
748: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
749: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
750: ,X_MSG_COUNT => X_MSG_COUNT
751: ,X_MSG_DATA => X_MSG_DATA
752: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
755: P_API_NAME => L_API_NAME
756: ,P_PKG_NAME => G_PKG_NAME
757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
758: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
759: ,X_MSG_COUNT => X_MSG_COUNT
760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 767: FND_MSG_PUB.ADD;

763: Rollback to CREATE_REPAIR_PO_PUB;
764: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
765: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
766: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
767: FND_MSG_PUB.ADD;
768: fnd_msg_pub.count_and_get
769: (p_count => x_msg_count
770: ,p_data => x_msg_data);
771: x_return_status := FND_API.G_RET_STS_ERROR;

Line 768: fnd_msg_pub.count_and_get

764: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
765: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
766: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
767: FND_MSG_PUB.ADD;
768: fnd_msg_pub.count_and_get
769: (p_count => x_msg_count
770: ,p_data => x_msg_data);
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: END;

Line 837: FND_MSG_PUB.ADD;

833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
835: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
836: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
837: FND_MSG_PUB.ADD;
838: fnd_msg_pub.count_and_get
839: (p_count => x_msg_count
840: ,p_data => x_msg_data);
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 838: fnd_msg_pub.count_and_get

834: FND_MESSAGE.SET_NAME('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
835: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
836: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
837: FND_MSG_PUB.ADD;
838: fnd_msg_pub.count_and_get
839: (p_count => x_msg_count
840: ,p_data => x_msg_data);
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: return;