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 99: FND_MSG_PUB.initialize;

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

Line 134: FND_MSG_PUB.ADD;

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:
138: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 152: FND_MSG_PUB.ADD;

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:
156: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 170: FND_MSG_PUB.ADD;

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:
174: l_reservation_rec.item_uom_code := X_PRIMARY_UOM_CODE;

Line 247: FND_MSG_PUB.ADD;

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:
251: ---------------------------------------------------------------

Line 265: FND_MSG_PUB.ADD;

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;
268:
269: /*

Line 297: FND_MSG_PUB.ADD;

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: */
301:

Line 318: FND_MSG_PUB.ADD;

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:
322: select csp_repair_po_headers_s1.nextval

Line 336: FND_MSG_PUB.ADD;

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:
339: Elsif L_REPAIR_ORGANIZATION_NAME is not null then
340: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 353: FND_MSG_PUB.ADD;

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:
357: Begin

Line 367: FND_MSG_PUB.ADD;

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:
371: End if;

Line 380: FND_MSG_PUB.ADD;

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:
384: CSP_REPAIR_PO_GRP.GET_ITEM_DETAILS

Line 397: FND_MSG_PUB.ADD;

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:
401: Begin

Line 411: FND_MSG_PUB.ADD;

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;
415: -------- No shipping network between Org's with Default shipping method assigned ---------

Line 433: FND_MSG_PUB.ADD;

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:
437: If nvl(P_quantity,0) <= 0 then

Line 439: FND_MSG_PUB.ADD;

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:
443: If trunc(nvl(P_need_by_date,sysdate)) <= trunc(sysdate) then

Line 445: FND_MSG_PUB.ADD;

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:
449: l_header_rec.ship_to_location_id := l_ship_to_location_id;

Line 734: fnd_msg_pub.count_and_get

730: EXCEPTION
731: WHEN EXCP_USER_DEFINED THEN
732: Rollback to CREATE_REPAIR_PO_PUB;
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: fnd_msg_pub.count_and_get
735: (p_count => x_msg_count
736: ,p_data => x_msg_data);
737: WHEN FND_API.G_EXC_ERROR THEN
738: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

737: WHEN FND_API.G_EXC_ERROR THEN
738: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
739: P_API_NAME => L_API_NAME
740: ,P_PKG_NAME => G_PKG_NAME
741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
742: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
743: ,X_MSG_COUNT => X_MSG_COUNT
744: ,X_MSG_DATA => X_MSG_DATA
745: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 750: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 760: FND_MSG_PUB.ADD;

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);
764: x_return_status := FND_API.G_RET_STS_ERROR;

Line 761: fnd_msg_pub.count_and_get

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);
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: END;

Line 828: FND_MSG_PUB.ADD;

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);
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 829: fnd_msg_pub.count_and_get

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);
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: return;