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.AHL_MM_MTL_MGT_PVT dependencies on FND_API

Line 44: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

40: -- added by sansatpa
41:
42: PROCEDURE CREATE_INTERNAL_ORDER(
43: P_API_VERSION IN NUMBER,
44: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: P_SCH_MTL_ID IN NUMBER,
47: P_SOURCE_ORG IN NUMBER,
48: P_SOURCE_SUB_INV_TBL IN OAF_VARCHAR2_TABLE_100,

Line 45: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

41:
42: PROCEDURE CREATE_INTERNAL_ORDER(
43: P_API_VERSION IN NUMBER,
44: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: P_SCH_MTL_ID IN NUMBER,
47: P_SOURCE_ORG IN NUMBER,
48: P_SOURCE_SUB_INV_TBL IN OAF_VARCHAR2_TABLE_100,
49: P_SOURCE_LOCATOR_TBL IN OAF_NUMBER_TABLE,

Line 77: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

73:
74:
75: PROCEDURE PICK_RELEASE(
76: P_API_VERSION IN NUMBER,
77: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
80: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
81: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 78: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

74:
75: PROCEDURE PICK_RELEASE(
76: P_API_VERSION IN NUMBER,
77: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
80: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
81: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,
82: P_TO_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

90: X_RETURN_STATUS OUT NOCOPY VARCHAR2 );
91:
92: PROCEDURE PICK_RELEASE_CONFIRM(
93: P_API_VERSION IN NUMBER,
94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
97: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
98: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

91:
92: PROCEDURE PICK_RELEASE_CONFIRM(
93: P_API_VERSION IN NUMBER,
94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
97: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
98: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,
99: P_TO_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 132: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

128: -- x_mtl_avl_schld_tbl : AHL_MM_MTL_MGT_PVT.Mtl_Avl_Schld_Rec
129: --
130: PROCEDURE CHECK_AVAILABILITY(
131: P_API_VERSION IN NUMBER,
132: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
133: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
134: P_MODULE_TYPE IN VARCHAR2 := NULL,
135: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,

Line 133: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

129: --
130: PROCEDURE CHECK_AVAILABILITY(
131: P_API_VERSION IN NUMBER,
132: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
133: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
134: P_MODULE_TYPE IN VARCHAR2 := NULL,
135: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
137: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 135: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

131: P_API_VERSION IN NUMBER,
132: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
133: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
134: P_MODULE_TYPE IN VARCHAR2 := NULL,
135: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
137: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
138: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
139: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 178: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

174: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure CHECK_AVAILABILITY');
175: END IF;
176:
177: -- Initialize API return status to success
178: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
179:
180: -- Standard call to check for call compatibility.
181: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 181: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

177: -- Initialize API return status to success
178: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
179:
180: -- Standard call to check for call compatibility.
181: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184:
185: FOR I IN 1 .. P_SCHEDULE_MATERIAL_ID_TBL.COUNT

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
179:
180: -- Standard call to check for call compatibility.
181: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184:
185: FOR I IN 1 .. P_SCHEDULE_MATERIAL_ID_TBL.COUNT
186: LOOP

Line 226: WHEN FND_API.G_EXC_ERROR THEN

222: END IF;
223: END LOOP;
224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
230: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
230: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
230: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;

Line 232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

228: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
229: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
230: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
234: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
235: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
236: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 234: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

230: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
234: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
235: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
236: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
237:
238: WHEN OTHERS THEN

Line 235: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
234: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
235: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
236: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
237:
238: WHEN OTHERS THEN
239: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;

Line 240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

236: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
237:
238: WHEN OTHERS THEN
239: ROLLBACK TO MM_CHECK_AVAILABILITY_SP;
240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
241: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
243: END IF;
244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

Line 244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
241: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
243: END IF;
244: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
245: P_COUNT => X_MSG_COUNT,
246: P_DATA => X_MSG_DATA);
247:
248: END CHECK_AVAILABILITY;

Line 271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

267: -- x_mtl_avl_schld_tbl : Table containing output against schedule material req id
268: --
269: PROCEDURE SCHEDULE_MATERIALS(
270: P_API_VERSION IN NUMBER,
271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_MODULE_TYPE IN VARCHAR2 := NULL,
274: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,

Line 272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

268: --
269: PROCEDURE SCHEDULE_MATERIALS(
270: P_API_VERSION IN NUMBER,
271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_MODULE_TYPE IN VARCHAR2 := NULL,
274: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
276: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 274: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

270: P_API_VERSION IN NUMBER,
271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_MODULE_TYPE IN VARCHAR2 := NULL,
274: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
276: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
277: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
278: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

322: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure SCHEDULE_MATERIALS');
323: END IF;
324:
325: -- Initialize API return status to success
326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 329: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

325: -- Initialize API return status to success
326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332:
333: FOR I IN 1 .. P_SCHEDULE_MATERIAL_ID_TBL.COUNT

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332:
333: FOR I IN 1 .. P_SCHEDULE_MATERIAL_ID_TBL.COUNT
334: LOOP

Line 381: WHEN FND_API.G_EXC_ERROR THEN

377:
378: END LOOP;
379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
385: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
385: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
385: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

383: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
384: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
385: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
389: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
391: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 389: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

385: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
389: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
391: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
392:
393: WHEN OTHERS THEN

Line 390: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
389: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
391: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
392:
393: WHEN OTHERS THEN
394: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

391: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
392:
393: WHEN OTHERS THEN
394: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
398: END IF;
399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

Line 399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
398: END IF;
399: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
400: P_COUNT => X_MSG_COUNT,
401: P_DATA => X_MSG_DATA);
402: END SCHEDULE_MATERIALS;
403: ---------------------------------------------------------------------------------------------------------

Line 416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

412: -- Parameters :
413: --
414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL

Line 417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

413: --
414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL
421: -- This will be null.

Line 418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL
421: -- This will be null.
422: -- Standard OUT Parameters :

Line 433: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

429: -- x_mtl_avl_schld_tbl OUT : Table containing output against schedule material req id
430: --
431: PROCEDURE SCHEDULE_VISIT_MATERIALS(
432: P_API_VERSION IN NUMBER,
433: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
434: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
435: P_MODULE_TYPE IN VARCHAR2 := NULL,
436: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: P_VISIT_ID IN NUMBER,

Line 434: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

430: --
431: PROCEDURE SCHEDULE_VISIT_MATERIALS(
432: P_API_VERSION IN NUMBER,
433: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
434: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
435: P_MODULE_TYPE IN VARCHAR2 := NULL,
436: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: P_VISIT_ID IN NUMBER,
438: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 436: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

432: P_API_VERSION IN NUMBER,
433: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
434: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
435: P_MODULE_TYPE IN VARCHAR2 := NULL,
436: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
437: P_VISIT_ID IN NUMBER,
438: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
439: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
440: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 463: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

459: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure SCHEDULE_MATERIALS');
460: END IF;
461:
462: -- Initialize API return status to success
463: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 466: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

462: -- Initialize API return status to success
463: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: L_LOOP_COUNTER := 1;

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: L_LOOP_COUNTER := 1;
471: FOR SCHEDULE_MATERIAL_ID IN SCHEDULE_MATERIAL_ID_CSR(P_VISIT_ID)

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: X_MSG_COUNT => X_MSG_COUNT,
487: X_MSG_DATA => X_MSG_DATA);
488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
494: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
494: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
494: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
494: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
498: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
499: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
500: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 498: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

494: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
498: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
499: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
500: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
501:
502: WHEN OTHERS THEN

Line 499: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
498: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
499: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
500: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
501:
502: WHEN OTHERS THEN
503: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;

Line 504: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

500: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
501:
502: WHEN OTHERS THEN
503: ROLLBACK TO MM_SCHEDULE_MATERIALS_SP;
504: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
507: END IF;
508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

Line 508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

504: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
507: END IF;
508: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
509: P_COUNT => X_MSG_COUNT,
510: P_DATA => X_MSG_DATA);
511: END Schedule_Visit_Materials;
512:

Line 656: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

652: -- x_mo_lines_tbl number_table_type, Containing the list of all line IDs for MOs
653: --
654: PROCEDURE CREATE_MOVE_ORDER(
655: p_api_version IN NUMBER,
656: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
657: p_commit IN VARCHAR2 := FND_API.G_FALSE,
658: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
659:
660: p_scheduled_material_id IN NUMBER,

Line 657: p_commit IN VARCHAR2 := FND_API.G_FALSE,

653: --
654: PROCEDURE CREATE_MOVE_ORDER(
655: p_api_version IN NUMBER,
656: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
657: p_commit IN VARCHAR2 := FND_API.G_FALSE,
658: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
659:
660: p_scheduled_material_id IN NUMBER,
661: p_supply_tbl_type IN Supply_Tbl_Type,

Line 658: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

654: PROCEDURE CREATE_MOVE_ORDER(
655: p_api_version IN NUMBER,
656: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
657: p_commit IN VARCHAR2 := FND_API.G_FALSE,
658: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
659:
660: p_scheduled_material_id IN NUMBER,
661: p_supply_tbl_type IN Supply_Tbl_Type,
662: x_mo_hdr_id OUT NOCOPY NUMBER,

Line 717: x_return_status := FND_API.G_RET_STS_SUCCESS;

713: 'At the start of the PLSQL procedure CREATE_MOVE_ORDER');
714: END IF;
715:
716: -- Initialize API return status to success
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 720: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

716: -- Initialize API return status to success
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: --Get the primary demand details from ASM ID

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: --Get the primary demand details from ASM ID
725: SELECT ASM.inventory_item_id,

Line 758: RAISE FND_API.G_EXC_ERROR;

754: END IF;
755:
756: FND_MESSAGE.set_name('AHL','AHL_MM_NO_MO_AOG');
757: FND_MSG_PUB.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:
761: --Throw error when demand location is not defined
762: IF(l_dmd_loc_id IS NULL) THEN

Line 770: RAISE FND_API.G_EXC_ERROR;

766: END IF;
767:
768: FND_MESSAGE.set_name('AHL','AHL_MM_NO_LOCATOR');
769: FND_MSG_PUB.add;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772:
773: --Throw error if supply and demand locators are same
774: FOR i in p_supply_tbl_type.FIRST .. p_supply_tbl_type.LAST

Line 779: RAISE FND_API.G_EXC_ERROR;

775: LOOP
776: IF (p_supply_tbl_type(i).Supply_Locator_Id = l_dmd_loc_id) THEN
777: FND_MESSAGE.set_name('AHL','AHL_MM_SAME_LOCATOR');
778: FND_MSG_PUB.add;
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781: END LOOP;
782:
783: --Start populating header record

Line 803: l_from_hdr_rec.db_flag := FND_API.G_TRUE;

799: G_MOVE_ORDER_BACKFLUSH CONSTANT NUMBER := 7;
800: G_MOVE_ORDER_SYSTEM CONSTANT NUMBER := 8;
801: */
802: l_from_hdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
803: l_from_hdr_rec.db_flag := FND_API.G_TRUE;
804: l_from_hdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
805: l_from_hdr_rec.description := 'Move Order for Demand ID: ' || p_scheduled_material_id;
806:
807: --Loop begins

Line 826: , p_init_msg_list => FND_API.G_FALSE

822: l_serial_number_tbl(1).inventory_item_id := l_inv_item_id;
823: l_serial_number_tbl(1).serial_number := p_supply_tbl_type(i).Serial_Number;
824:
825: AHL_MM_RESERVATIONS_PVT.CANCEL_RESERVATION(p_api_version => 1.0
826: , p_init_msg_list => FND_API.G_FALSE
827: , p_commit => FND_API.G_FALSE
828: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
829: , p_module_type => 'INTERNAL'
830: , x_return_status => x_return_status

Line 827: , p_commit => FND_API.G_FALSE

823: l_serial_number_tbl(1).serial_number := p_supply_tbl_type(i).Serial_Number;
824:
825: AHL_MM_RESERVATIONS_PVT.CANCEL_RESERVATION(p_api_version => 1.0
826: , p_init_msg_list => FND_API.G_FALSE
827: , p_commit => FND_API.G_FALSE
828: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
829: , p_module_type => 'INTERNAL'
830: , x_return_status => x_return_status
831: , x_msg_count => x_msg_count

Line 828: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

824:
825: AHL_MM_RESERVATIONS_PVT.CANCEL_RESERVATION(p_api_version => 1.0
826: , p_init_msg_list => FND_API.G_FALSE
827: , p_commit => FND_API.G_FALSE
828: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
829: , p_module_type => 'INTERNAL'
830: , x_return_status => x_return_status
831: , x_msg_count => x_msg_count
832: , x_msg_data => x_msg_data

Line 838: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)

834: , p_reservation_id_tbl => l_reservation_id_tbl
835: );
836:
837: --Write in Log and exit loop when deleting reservation fails
838: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)
839: THEN
840: IF (l_log_statement >= l_log_current_level) THEN
841: FND_LOG.string(l_log_statement, L_DEBUG,
842: 'After CANCEL_RESERVATION, Return Status is :' || x_return_status);

Line 844: RAISE FND_API.G_EXC_ERROR;

840: IF (l_log_statement >= l_log_current_level) THEN
841: FND_LOG.string(l_log_statement, L_DEBUG,
842: 'After CANCEL_RESERVATION, Return Status is :' || x_return_status);
843: END IF;
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846:
847: END IF; --IF l_old_rsrv_id IS NOT NULL
848:

Line 853: l_from_line_tbl(i).line_id := FND_API.G_MISS_NUM;

849: --Start populating lines
850: l_from_line_tbl(i).organization_id := l_org_id;
851: l_from_line_tbl(i).inventory_item_id := l_inv_item_id;
852: l_from_line_tbl(i).date_required := l_dmd_req_date;
853: l_from_line_tbl(i).line_id := FND_API.G_MISS_NUM;
854: l_from_line_tbl(i).line_number := i+1;
855:
856: l_from_line_tbl(i).txn_source_line_detail_id := p_scheduled_material_id;
857: l_from_line_tbl(i).line_status := INV_GLOBALS.G_TO_STATUS_PREAPPROVED;

Line 863: l_from_line_tbl(i).db_flag := FND_API.g_true;

859: l_from_line_tbl(i).quantity := 1;
860: l_from_line_tbl(i).status_date := SYSDATE; --Last date status was changed
861: l_from_line_tbl(i).uom_code := l_uom;
862:
863: l_from_line_tbl(i).db_flag := FND_API.g_true;
864: l_from_line_tbl(i).operation := INV_GLOBALS.g_opr_create;
865: l_from_line_tbl(i).from_subinventory_code := p_supply_tbl_type(i).Supply_Subinv_Code;
866: l_from_line_tbl(i).from_locator_id := p_supply_tbl_type(i).Supply_Locator_Id;
867: l_from_line_tbl(i).to_subinventory_code := l_dmd_subinv_code;

Line 881: , p_init_msg_list => FND_API.G_FALSE

877: END IF;
878:
879: --Used to process move orders (both headers and lines) i.e., to create or update move orders.
880: INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER (p_api_version_number => 1.0
881: , p_init_msg_list => FND_API.G_FALSE
882: , p_commit => FND_API.G_FALSE
883: , x_return_status => x_return_status
884: , x_msg_count => x_msg_count
885: , x_msg_data => x_msg_data

Line 882: , p_commit => FND_API.G_FALSE

878:
879: --Used to process move orders (both headers and lines) i.e., to create or update move orders.
880: INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER (p_api_version_number => 1.0
881: , p_init_msg_list => FND_API.G_FALSE
882: , p_commit => FND_API.G_FALSE
883: , x_return_status => x_return_status
884: , x_msg_count => x_msg_count
885: , x_msg_data => x_msg_data
886: , p_trohdr_rec => l_from_hdr_rec

Line 895: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS

891: , x_trolin_val_tbl => x_line_val_tbl
892: );
893:
894: --Write in Log and exit loop when creating MO fails
895: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS
896: OR l_to_hdr_rec.header_id IS NULL
897: OR l_to_line_tbl.COUNT <= 0)
898: THEN
899: IF (l_log_statement >= l_log_current_level) THEN

Line 903: RAISE FND_API.G_EXC_ERROR;

899: IF (l_log_statement >= l_log_current_level) THEN
900: FND_LOG.string(l_log_statement, L_DEBUG,
901: 'After PROCESS_MOVE_ORDER, Return Status is :' || x_return_status);
902: END IF;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905:
906: FOR i in p_supply_tbl_type.FIRST .. p_supply_tbl_type.LAST
907: LOOP

Line 918: , p_init_msg_list => FND_API.G_FALSE

914: -- Creates pick suggestions and also suggests serial numbers
915: -- The program will use WMS pick/put rules/strategies, if Oracle WMS is installed
916: -- otherwise, rules in mtl_picking_rules will be used.
917: INV_PPENGINE_PVT.CREATE_SUGGESTIONS (p_api_version => 1.0
918: , p_init_msg_list => FND_API.G_FALSE
919: , p_commit => FND_API.G_FALSE
920: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
921: , x_return_status => x_return_status
922: , x_msg_count => x_msg_count

Line 919: , p_commit => FND_API.G_FALSE

915: -- The program will use WMS pick/put rules/strategies, if Oracle WMS is installed
916: -- otherwise, rules in mtl_picking_rules will be used.
917: INV_PPENGINE_PVT.CREATE_SUGGESTIONS (p_api_version => 1.0
918: , p_init_msg_list => FND_API.G_FALSE
919: , p_commit => FND_API.G_FALSE
920: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
921: , x_return_status => x_return_status
922: , x_msg_count => x_msg_count
923: , x_msg_data => x_msg_data

Line 920: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

916: -- otherwise, rules in mtl_picking_rules will be used.
917: INV_PPENGINE_PVT.CREATE_SUGGESTIONS (p_api_version => 1.0
918: , p_init_msg_list => FND_API.G_FALSE
919: , p_commit => FND_API.G_FALSE
920: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
921: , x_return_status => x_return_status
922: , x_msg_count => x_msg_count
923: , x_msg_data => x_msg_data
924: , p_transaction_temp_id => l_to_line_tbl(i).line_id

Line 926: , p_suggest_serial => FND_API.G_TRUE

922: , x_msg_count => x_msg_count
923: , x_msg_data => x_msg_data
924: , p_transaction_temp_id => l_to_line_tbl(i).line_id
925: , p_reservations => l_rsr_type
926: , p_suggest_serial => FND_API.G_TRUE
927: , p_plan_tasks => FALSE
928: , p_quick_pick_flag => 'N'
929: , p_organization_id => l_org_id
930: );

Line 933: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)

929: , p_organization_id => l_org_id
930: );
931:
932: --Write in Log and exit loop when create suggestion fails
933: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)
934: THEN
935: IF (l_log_statement >= l_log_current_level) THEN
936: FND_LOG.string(l_log_statement, L_DEBUG,
937: 'After CREATE_SUGGESTIONS, Return Status is :' || x_return_status);

Line 939: RAISE FND_API.G_EXC_ERROR;

935: IF (l_log_statement >= l_log_current_level) THEN
936: FND_LOG.string(l_log_statement, L_DEBUG,
937: 'After CREATE_SUGGESTIONS, Return Status is :' || x_return_status);
938: END IF;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941:
942: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - START
943: l_trolin_tbl := l_to_line_tbl;

Line 945: IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error

941:
942: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - START
943: l_trolin_tbl := l_to_line_tbl;
944:
945: IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error
946: AND l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_error) THEN
947:
948: --Data from MTL_TXN_REQUEST_LINES table
949: l_trolin_rec := inv_trolin_util.query_row (l_trolin_tbl(i).line_id);

Line 946: AND l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_error) THEN

942: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - START
943: l_trolin_tbl := l_to_line_tbl;
944:
945: IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error
946: AND l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_error) THEN
947:
948: --Data from MTL_TXN_REQUEST_LINES table
949: l_trolin_rec := inv_trolin_util.query_row (l_trolin_tbl(i).line_id);
950: l_trolin_tbl(i) := l_trolin_rec;

Line 997: END IF; --IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error)

993: inv_trolin_util.update_row (l_trolin_tbl (i));
994:
995: END IF; --IF NVL (l_qty_detailed, 0) = 0
996:
997: END IF; --IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error)
998: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - END
999:
1000: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - START
1001: SELECT MSNT.transaction_temp_id, MSNT.fm_serial_number, MSNT.to_serial_number

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: 'Marking required serial number failed for Serial: '
1094: || p_supply_tbl_type(i).Serial_Number
1095: || ' with return status: ' || l_mark_serial_success);
1096: END IF;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - END
1100:
1101: --Get the new MO Header ID for this serial

Line 1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1103:
1104: END LOOP; -- Loop ends
1105:
1106: --Remove all header values back on error
1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1108: x_mo_lines_tbl.DELETE;
1109: --Populate MO Header ID
1110: ELSE
1111: x_mo_hdr_id := l_to_hdr_rec.header_id;

Line 1115: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1111: x_mo_hdr_id := l_to_hdr_rec.header_id;
1112: END IF;
1113:
1114: --Standard check for commit
1115: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1116: COMMIT;
1117: END IF;
1118:
1119: -- Count and Get messages

Line 1120: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1116: COMMIT;
1117: END IF;
1118:
1119: -- Count and Get messages
1120: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data);
1123:
1124: IF (l_log_procedure >= l_log_current_level) THEN

Line 1130: WHEN FND_API.G_EXC_ERROR THEN

1126: 'At the End of the PLSQL procedure CREATE_MOVE_ORDER');
1127: END IF;
1128:
1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,

Line 1132: x_return_status := FND_API.G_RET_STS_ERROR;

1128:
1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: ROLLBACK TO CREATE_MOVE_ORDER_SP;

Line 1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
1142: WHEN OTHERS THEN

Line 1139: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1135: p_data => x_msg_data);
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO CREATE_MOVE_ORDER_SP;

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
1142: WHEN OTHERS THEN
1143: ROLLBACK TO CREATE_MOVE_ORDER_SP;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1146: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
1147: END IF;
1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

Line 1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1146: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
1147: END IF;
1148: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data);
1151:
1152: END CREATE_MOVE_ORDER;

Line 1228: RAISE FND_API.G_EXC_ERROR;

1224:
1225: --If Planning window is not defined, or if its null
1226: IF(l_planning_window IS NULL) THEN
1227: FND_FILE.put_line(FND_FILE.log, 'Planning Window is not defined');
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: --Revert ATP_FLAG for demands falling outside planning window due to change in required date
1232: UPDATE ahl_schedule_materials

Line 1271: , p_init_msg_list => FND_API.G_FALSE

1267: --Call API to schedule material requirement for the same
1268: FND_FILE.put_line(FND_FILE.log, 'Calling schedule_material API for a set of ' || l_bucket_size || ' demands');
1269:
1270: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1271: , p_init_msg_list => FND_API.G_FALSE
1272: , p_commit => FND_API.G_FALSE
1273: , p_module_type => NULL
1274: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1275: , p_schedule_material_id_tbl => l_p_sch_mtl_id_tbl

Line 1272: , p_commit => FND_API.G_FALSE

1268: FND_FILE.put_line(FND_FILE.log, 'Calling schedule_material API for a set of ' || l_bucket_size || ' demands');
1269:
1270: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1271: , p_init_msg_list => FND_API.G_FALSE
1272: , p_commit => FND_API.G_FALSE
1273: , p_module_type => NULL
1274: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1275: , p_schedule_material_id_tbl => l_p_sch_mtl_id_tbl
1276: , x_mtl_avl_schld_tbl => l_x_mtl_avl_schld_tbl

Line 1274: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1270: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1271: , p_init_msg_list => FND_API.G_FALSE
1272: , p_commit => FND_API.G_FALSE
1273: , p_module_type => NULL
1274: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1275: , p_schedule_material_id_tbl => l_p_sch_mtl_id_tbl
1276: , x_mtl_avl_schld_tbl => l_x_mtl_avl_schld_tbl
1277: , x_return_status => l_return_status
1278: , x_msg_count => l_msg_count

Line 1281: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1277: , x_return_status => l_return_status
1278: , x_msg_count => l_msg_count
1279: , x_msg_data => l_msg_data
1280: );
1281: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1282: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSE

Line 1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1279: , x_msg_data => l_msg_data
1280: );
1281: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1282: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSE
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;

Line 1284: RAISE FND_API.G_EXC_ERROR;

1280: );
1281: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1282: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSE
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSE
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;
1289:
1290: FOR j in l_x_mtl_avl_schld_tbl.FIRST..l_x_mtl_avl_schld_tbl.LAST

Line 1313: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1309: i := 1;
1310: k := 1;
1311:
1312: --Standard check before commit, committing every call to SCHEDULE_MATERIALS
1313: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1314: --Commit all changes and replace the old savepoint
1315: COMMIT;
1316: SAVEPOINT FLAG_REQUIREMENTS_SP;
1317: ELSE

Line 1332: , p_init_msg_list => FND_API.G_FALSE

1328: --Call API to schedule material requirement for the same
1329: FND_FILE.put_line(FND_FILE.log, 'Calling schedule_material API for last set of demands');
1330:
1331: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1332: , p_init_msg_list => FND_API.G_FALSE
1333: , p_commit => FND_API.G_FALSE
1334: , p_module_type => NULL
1335: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1336: , p_schedule_material_id_tbl => l_p_sch_mtl_id_tbl

Line 1333: , p_commit => FND_API.G_FALSE

1329: FND_FILE.put_line(FND_FILE.log, 'Calling schedule_material API for last set of demands');
1330:
1331: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1332: , p_init_msg_list => FND_API.G_FALSE
1333: , p_commit => FND_API.G_FALSE
1334: , p_module_type => NULL
1335: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1336: , p_schedule_material_id_tbl => l_p_sch_mtl_id_tbl
1337: , x_mtl_avl_schld_tbl => l_x_mtl_avl_schld_tbl

Line 1335: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1331: AHL_MM_MTL_MGT_PVT.SCHEDULE_MATERIALS(p_api_version => 1.0
1332: , p_init_msg_list => FND_API.G_FALSE
1333: , p_commit => FND_API.G_FALSE
1334: , p_module_type => NULL
1335: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1336: , p_schedule_material_id_tbl => l_p_sch_mtl_id_tbl
1337: , x_mtl_avl_schld_tbl => l_x_mtl_avl_schld_tbl
1338: , x_return_status => l_return_status
1339: , x_msg_count => l_msg_count

Line 1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1339: , x_msg_count => l_msg_count
1340: , x_msg_data => l_msg_data
1341: );
1342:
1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1344: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1345: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: ELSE

Line 1345: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1341: );
1342:
1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1344: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1345: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: ELSE
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;

Line 1346: RAISE FND_API.G_EXC_ERROR;

1342:
1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1344: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1345: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: ELSE
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;
1350: END IF;

Line 1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1344: fnd_file.put_line(fnd_file.log, 'Error after calling schedule_material API');
1345: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1346: RAISE FND_API.G_EXC_ERROR;
1347: ELSE
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;
1350: END IF;
1351:
1352: FOR j in l_x_mtl_avl_schld_tbl.FIRST..l_x_mtl_avl_schld_tbl.LAST

Line 1368: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1364:
1365: END IF; -- l_p_sch_mtl_id_tbl IS NOT NULL
1366:
1367: --Standard check before commit
1368: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1369: COMMIT;
1370: ELSE
1371: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1372: END IF;

Line 1377: WHEN FND_API.G_EXC_ERROR THEN

1373:
1374: fnd_file.put_line(fnd_file.log, 'At the end of PL SQL procedure UPDATE_REQUIREMENTS_FOR_GOP');
1375:
1376: EXCEPTION
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1379: retcode := 2;
1380: l_msg_count := Fnd_Msg_Pub.count_msg;
1381:

Line 1386: p_encoded => FND_API.G_FALSE,

1382: IF (l_msg_count > 0) THEN
1383: FOR i IN 1..l_msg_count
1384: LOOP
1385: fnd_msg_pub.get( p_msg_index => i,
1386: p_encoded => FND_API.G_FALSE,
1387: p_data => l_err_msg,
1388: p_msg_index_out => l_msg_index_out);
1389:
1390: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1390: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);
1391: END LOOP;
1392: END IF;
1393:
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395: ROLLBACK TO FLAG_REQUIREMENTS_SP;
1396: retcode := 2;
1397: l_msg_count := Fnd_Msg_Pub.count_msg;
1398:

Line 1403: p_encoded => FND_API.G_FALSE,

1399: IF (l_msg_count > 0) THEN
1400: FOR i IN 1..l_msg_count
1401: LOOP
1402: fnd_msg_pub.get( p_msg_index => i,
1403: p_encoded => FND_API.G_FALSE,
1404: p_data => l_err_msg,
1405: p_msg_index_out => l_msg_index_out);
1406:
1407: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 1425: p_encoded => FND_API.G_FALSE,

1421: IF (l_msg_count > 0) THEN
1422: FOR i IN 1..l_msg_count
1423: LOOP
1424: fnd_msg_pub.get( p_msg_index => i,
1425: p_encoded => FND_API.G_FALSE,
1426: p_data => l_err_msg,
1427: p_msg_index_out => l_msg_index_out);
1428:
1429: fnd_file.put_line(FND_FILE.LOG, 'Error message-'||l_msg_index_out||':' || l_err_msg);

Line 1444: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1440: -- Usage : This procedure is called from variour places where AOG flag gets updated. It is used to
1441: -- send workflow notifications upon updation of AOG flag.
1442: -- IN Parameters :
1443: -- p_api_version IN NUMBER Required
1444: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1445: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1446: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1447: -- p_asm_id IN NUMBER Required.
1448: --

Line 1445: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1441: -- send workflow notifications upon updation of AOG flag.
1442: -- IN Parameters :
1443: -- p_api_version IN NUMBER Required
1444: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1445: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1446: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1447: -- p_asm_id IN NUMBER Required.
1448: --
1449: -- OUT Parameters :

Line 1446: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1442: -- IN Parameters :
1443: -- p_api_version IN NUMBER Required
1444: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1445: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1446: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1447: -- p_asm_id IN NUMBER Required.
1448: --
1449: -- OUT Parameters :
1450: -- x_return_status OUT VARCHAR2 Required

Line 1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1452: -- x_msg_data OUT VARCHAR2 Required
1453: --
1454: PROCEDURE Invoke_AOG_Upd_Notification(
1455: p_api_version IN NUMBER := 1.0,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
1460: x_return_status OUT NOCOPY VARCHAR2,

Line 1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1453: --
1454: PROCEDURE Invoke_AOG_Upd_Notification(
1455: p_api_version IN NUMBER := 1.0,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
1460: x_return_status OUT NOCOPY VARCHAR2,
1461: x_msg_count OUT NOCOPY NUMBER,

Line 1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1454: PROCEDURE Invoke_AOG_Upd_Notification(
1455: p_api_version IN NUMBER := 1.0,
1456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1459: p_asm_id_tab IN AHL_MM_MTL_MGT_PVT.number_table_type,
1460: x_return_status OUT NOCOPY VARCHAR2,
1461: x_msg_count OUT NOCOPY NUMBER,
1462: x_msg_data OUT NOCOPY VARCHAR2

Line 1491: IF FND_API.to_boolean(p_init_msg_list)

1487: --------------------Initialize ----------------------------------
1488: -- Standard Start of API savepoint
1489: SAVEPOINT Invoke_AOG_Upd_Notification;
1490: -- Initialize message list if p_init_msg_list is set to TRUE.
1491: IF FND_API.to_boolean(p_init_msg_list)
1492: THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495: -- Initialize API return status to success

Line 1496: x_return_status := FND_API.G_RET_STS_SUCCESS;

1492: THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: p_api_version,
1500: l_api_name,G_PKG_NAME)

Line 1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: p_api_version,
1500: l_api_name,G_PKG_NAME)
1501: THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: p_api_version,
1500: l_api_name,G_PKG_NAME)
1501: THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504: --------------------Start of Main Logic ----------------------------------
1505: IF (p_asm_id_tab.count = 0) THEN
1506: RETURN;

Line 1539: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1535: 'After calling Ahl_Utility_Pvt.Get_Wf_Process_Name, Return Status : '|| l_return_status
1536: );
1537: END IF;
1538: -- if returned with error, don't proceed any further
1539: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1540: x_return_status := l_return_status;
1541: RETURN;
1542: END IF;
1543: -- if the mapping is not active then return normal.

Line 1553: x_return_status := FND_API.G_RET_STS_SUCCESS;

1549: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1550: 'Returning to caller as Workflow is not active, Return Status : S'
1551: );
1552: END IF;
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;
1554: RETURN;
1555: END IF;
1556: --End of Get Workflow attributes.
1557:

Line 1632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1628: 'l_item_key ' || l_item_key
1629: );
1630: END IF;
1631: -- if returned with error, don't proceed any further
1632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1633: x_return_status := l_return_status;
1634: RETURN;
1635: END IF;
1636: END LOOP;

Line 1642: x_return_status := FND_API.G_RET_STS_ERROR;

1638: l_msg_count := Fnd_Msg_Pub.count_msg;
1639: -- Check the return status of API call.
1640: IF (l_return_status <> 'S' OR l_msg_count > 0) THEN
1641: x_msg_count := l_msg_count;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: RAISE Fnd_Api.G_EXC_ERROR;
1644: END IF;
1645: -- Standard check of p_commit
1646: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1643: RAISE Fnd_Api.G_EXC_ERROR;

1639: -- Check the return status of API call.
1640: IF (l_return_status <> 'S' OR l_msg_count > 0) THEN
1641: x_msg_count := l_msg_count;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: RAISE Fnd_Api.G_EXC_ERROR;
1644: END IF;
1645: -- Standard check of p_commit
1646: IF FND_API.TO_BOOLEAN(p_commit) THEN
1647: COMMIT;

Line 1646: IF FND_API.TO_BOOLEAN(p_commit) THEN

1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: RAISE Fnd_Api.G_EXC_ERROR;
1644: END IF;
1645: -- Standard check of p_commit
1646: IF FND_API.TO_BOOLEAN(p_commit) THEN
1647: COMMIT;
1648: END IF;
1649: EXCEPTION
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1646: IF FND_API.TO_BOOLEAN(p_commit) THEN
1647: COMMIT;
1648: END IF;
1649: EXCEPTION
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1651: ROLLBACK TO Invoke_AOG_Upd_Notification;
1652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,

Line 1652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1648: END IF;
1649: EXCEPTION
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1651: ROLLBACK TO Invoke_AOG_Upd_Notification;
1652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN

Line 1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1649: EXCEPTION
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1651: ROLLBACK TO Invoke_AOG_Upd_Notification;
1652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Invoke_AOG_Upd_Notification;

Line 1656: WHEN FND_API.G_EXC_ERROR THEN

1652: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1653: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Invoke_AOG_Upd_Notification;
1658: X_return_status := FND_API.G_RET_STS_ERROR;
1659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,

Line 1658: X_return_status := FND_API.G_RET_STS_ERROR;

1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Invoke_AOG_Upd_Notification;
1658: X_return_status := FND_API.G_RET_STS_ERROR;
1659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => X_msg_data);
1662: WHEN OTHERS THEN

Line 1659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1655: p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Invoke_AOG_Upd_Notification;
1658: X_return_status := FND_API.G_RET_STS_ERROR;
1659: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => X_msg_data);
1662: WHEN OTHERS THEN
1663: ROLLBACK TO Invoke_AOG_Upd_Notification;

Line 1664: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1660: p_count => x_msg_count,
1661: p_data => X_msg_data);
1662: WHEN OTHERS THEN
1663: ROLLBACK TO Invoke_AOG_Upd_Notification;
1664: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1666: THEN
1667: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1668: p_procedure_name => 'Invoke_AOG_Upd_Notification',

Line 1671: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1667: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1668: p_procedure_name => 'Invoke_AOG_Upd_Notification',
1669: p_error_text => SUBSTR(SQLERRM,1,240));
1670: END IF;
1671: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1672: p_count => x_msg_count,
1673: p_data => X_msg_data);
1674: END Invoke_AOG_Upd_Notification;
1675:

Line 1696: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

1692: -- Pre-reqs :
1693: --
1694: -- Standard IN Parameters :
1695: -- p_api_version NUMBER := 1.0
1696: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1697: -- p_commit VARCHAR2 := FND_API.G_FALSE
1698: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1699: --
1700: -- Standard OUT Parameters :

Line 1697: -- p_commit VARCHAR2 := FND_API.G_FALSE

1693: --
1694: -- Standard IN Parameters :
1695: -- p_api_version NUMBER := 1.0
1696: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1697: -- p_commit VARCHAR2 := FND_API.G_FALSE
1698: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1699: --
1700: -- Standard OUT Parameters :
1701: -- x_return_status VARCHAR2 Required

Line 1698: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

1694: -- Standard IN Parameters :
1695: -- p_api_version NUMBER := 1.0
1696: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1697: -- p_commit VARCHAR2 := FND_API.G_FALSE
1698: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1699: --
1700: -- Standard OUT Parameters :
1701: -- x_return_status VARCHAR2 Required
1702: -- x_msg_count NUMBER Required

Line 1724: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1720: -- End of Comments --
1721: PROCEDURE CREATE_INTERNAL_SALES_ORDER(
1722: -- Standard IN params
1723: P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1725: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1726: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1727: -- Standard OUT params
1728: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1725: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1721: PROCEDURE CREATE_INTERNAL_SALES_ORDER(
1722: -- Standard IN params
1723: P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1725: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1726: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1727: -- Standard OUT params
1728: X_MSG_COUNT OUT NOCOPY NUMBER,
1729: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 1726: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1722: -- Standard IN params
1723: P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1725: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1726: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1727: -- Standard OUT params
1728: X_MSG_COUNT OUT NOCOPY NUMBER,
1729: X_MSG_DATA OUT NOCOPY VARCHAR2,
1730: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1915: p_encoded => fnd_api.g_false);

1911: fnd_message.set_token('ITEM_NAME',L_INVENTORY_ITEM );
1912: FND_MSG_PUB.ADD;
1913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1914: P_DATA => X_MSG_DATA,
1915: p_encoded => fnd_api.g_false);
1916: X_RETURN_STATUS := G_RET_STS_ERROR;
1917: WHEN OTHERS THEN
1918: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
1919: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME , ' OTHERS exception.');

Line 1942: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

1938: -- Pre-reqs :
1939: --
1940: -- Standard IN Parameters :
1941: -- p_api_version NUMBER := 1.0
1942: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1943: -- p_commit VARCHAR2 := FND_API.G_FALSE
1944: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1945: --
1946: -- Standard OUT Parameters :

Line 1943: -- p_commit VARCHAR2 := FND_API.G_FALSE

1939: --
1940: -- Standard IN Parameters :
1941: -- p_api_version NUMBER := 1.0
1942: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1943: -- p_commit VARCHAR2 := FND_API.G_FALSE
1944: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1945: --
1946: -- Standard OUT Parameters :
1947: -- x_return_status VARCHAR2 Required

Line 1944: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

1940: -- Standard IN Parameters :
1941: -- p_api_version NUMBER := 1.0
1942: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1943: -- p_commit VARCHAR2 := FND_API.G_FALSE
1944: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1945: --
1946: -- Standard OUT Parameters :
1947: -- x_return_status VARCHAR2 Required
1948: -- x_msg_count NUMBER Required

Line 1969: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1965: --
1966: -- End of Comments --
1967: PROCEDURE CREATE_INTERNAL_ORDER(
1968: P_API_VERSION IN NUMBER,
1969: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1970: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1971: P_SCH_MTL_ID IN NUMBER,
1972: P_SOURCE_ORG IN NUMBER,
1973: P_SOURCE_SUB_INV_TBL IN OAF_VARCHAR2_TABLE_100,

Line 1970: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1966: -- End of Comments --
1967: PROCEDURE CREATE_INTERNAL_ORDER(
1968: P_API_VERSION IN NUMBER,
1969: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1970: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1971: P_SCH_MTL_ID IN NUMBER,
1972: P_SOURCE_ORG IN NUMBER,
1973: P_SOURCE_SUB_INV_TBL IN OAF_VARCHAR2_TABLE_100,
1974: P_SOURCE_LOCATOR_TBL IN OAF_NUMBER_TABLE,

Line 2049: IF NOT Fnd_Api.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2045: Fnd_Log.STRING(G_LEVEL_PROCEDURE, l_api_name,'Begin API');
2046: END IF;
2047:
2048: -- standard check for API compatibility.
2049: IF NOT Fnd_Api.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2050: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2051: END IF;
2052: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
2053: Fnd_Msg_Pub.initialize;

Line 2050: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

2046: END IF;
2047:
2048: -- standard check for API compatibility.
2049: IF NOT Fnd_Api.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2050: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2051: END IF;
2052: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
2053: Fnd_Msg_Pub.initialize;
2054: END IF;

Line 2052: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN

2048: -- standard check for API compatibility.
2049: IF NOT Fnd_Api.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2050: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2051: END IF;
2052: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
2053: Fnd_Msg_Pub.initialize;
2054: END IF;
2055: x_return_status := G_RET_STS_SUCCESS;
2056:

Line 2487: P_COMMIT => FND_API.G_FALSE,

2483: --savepoint PERFORM_PICK_RELEASE;
2484:
2485: PICK_RELEASE(
2486: P_API_VERSION => 1.0,
2487: P_COMMIT => FND_API.G_FALSE,
2488: P_INIT_MSG_LIST => FND_API.G_TRUE,
2489: P_ORDER_HEADER_ID => X_INT_ORDER_HDR_ID,
2490: P_ORDER_LINE_ID => X_INT_ORDER_LINE_ID,
2491: P_FM_SERIAL_NUM_TBL => P_FM_SERIAL_NUM_TBL,

Line 2488: P_INIT_MSG_LIST => FND_API.G_TRUE,

2484:
2485: PICK_RELEASE(
2486: P_API_VERSION => 1.0,
2487: P_COMMIT => FND_API.G_FALSE,
2488: P_INIT_MSG_LIST => FND_API.G_TRUE,
2489: P_ORDER_HEADER_ID => X_INT_ORDER_HDR_ID,
2490: P_ORDER_LINE_ID => X_INT_ORDER_LINE_ID,
2491: P_FM_SERIAL_NUM_TBL => P_FM_SERIAL_NUM_TBL,
2492: P_TO_SERIAL_NUM_TBL => P_TO_SERIAL_NUM_TBL,

Line 2538: IF fnd_api.to_boolean(p_commit)

2534: RAISE PICK_REL_EXC;
2535: END IF;
2536:
2537:
2538: IF fnd_api.to_boolean(p_commit)
2539: THEN
2540: COMMIT;
2541: END IF;
2542:

Line 2554: P_ENCODED => FND_API.G_FALSE);

2550: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_NO_CUST_ASSOC');
2551: FND_MSG_PUB.ADD;
2552: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2553: P_DATA => X_MSG_DATA,
2554: P_ENCODED => FND_API.G_FALSE);
2555: X_RETURN_STATUS := G_RET_STS_ERROR;
2556:
2557: WHEN NO_SHIPPING_NETWORK THEN
2558: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 2565: P_ENCODED => FND_API.G_FALSE);

2561: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_SHIPPING_NETWORK');
2562: FND_MSG_PUB.ADD;
2563: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2564: P_DATA => X_MSG_DATA,
2565: P_ENCODED => FND_API.G_FALSE);
2566: X_RETURN_STATUS := G_RET_STS_ERROR;
2567:
2568: WHEN NO_ISO_ENABLED_NETWORK THEN
2569: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 2576: P_ENCODED => FND_API.G_FALSE);

2572: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_NO_ISO_ENABLED_NETWORK');
2573: FND_MSG_PUB.ADD;
2574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2575: P_DATA => X_MSG_DATA,
2576: P_ENCODED => FND_API.G_FALSE);
2577: X_RETURN_STATUS := G_RET_STS_ERROR;
2578:
2579: WHEN CREATE_IR_EXC THEN
2580: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 2587: p_encoded => fnd_api.g_false);

2583: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_IR_CREATION_ERR');
2584: FND_MSG_PUB.ADD;
2585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2586: P_DATA => X_MSG_DATA,
2587: p_encoded => fnd_api.g_false);
2588: X_RETURN_STATUS := G_RET_STS_ERROR;
2589: --rollback to RELEASE_SALESORDER;
2590:
2591: WHEN CREATE_ISO_EXC THEN

Line 2599: p_encoded => fnd_api.g_false);

2595: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_ISO_CREATION_ERR');
2596: FND_MSG_PUB.ADD;
2597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2598: P_DATA => X_MSG_DATA,
2599: p_encoded => fnd_api.g_false);
2600: X_RETURN_STATUS := G_RET_STS_ERROR;
2601: --rollback to RELEASE_SALESORDER;
2602:
2603: when CREATE_IR_RSRV_EXC then

Line 2614: p_encoded => fnd_api.g_false);

2610: FND_MESSAGE.SET_TOKEN('ISO_NUM',X_INT_ORDER_NUM );
2611: FND_MSG_PUB.ADD;
2612: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2613: P_DATA => X_MSG_DATA,
2614: p_encoded => fnd_api.g_false);
2615: X_RETURN_STATUS := G_RET_STS_ERROR;
2616: --rollback to CREATE_IR_RESERVATION;
2617:
2618: WHEN PICK_REL_EXC THEN

Line 2630: p_encoded => fnd_api.g_false);

2626: FND_MESSAGE.SET_TOKEN('RSRV_ID',X_RESERVATION_ID );
2627: FND_MSG_PUB.ADD;
2628: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2629: P_DATA => X_MSG_DATA,
2630: p_encoded => fnd_api.g_false);
2631: X_RETURN_STATUS := G_RET_STS_ERROR;
2632: --rollback to PERFORM_PICK_RELEASE;
2633:
2634: when OTHERS then

Line 2640: p_encoded => fnd_api.g_false);

2636: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2637: X_RETURN_STATUS := G_RET_STS_ERROR;
2638: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2639: P_DATA => X_MSG_DATA,
2640: p_encoded => fnd_api.g_false);
2641: --rollback to PERFORM_PICK_RELEASE;
2642: --rollback to CREATE_IR_RESERVATION;
2643:
2644:

Line 2709: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

2705: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION(
2706: p_api_version => 1.0,
2707: p_init_msg_list => 'F',
2708: p_commit => 'T',
2709: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level
2710: p_module_type => 'OAF',
2711: x_return_status => X_RETURN_STATUS,
2712: x_msg_count => X_MSG_COUNT,
2713: X_MSG_DATA => X_MSG_DATA,

Line 2723: RAISE fnd_api.g_exc_error;

2719: THEN
2720: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2721: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'create reservation failed as: '|| X_MSG_DATA);
2722: END IF;
2723: RAISE fnd_api.g_exc_error;
2724: end if;
2725:
2726:
2727:

Line 2729: WHEN fnd_api.g_exc_error

2725:
2726:
2727:
2728: EXCEPTION
2729: WHEN fnd_api.g_exc_error
2730: THEN
2731: x_return_status := G_RET_STS_ERROR;
2732: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
2733: p_data => x_msg_data);

Line 2755: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

2751: -- Pre-reqs :
2752: --
2753: -- Standard IN Parameters :
2754: -- p_api_version NUMBER := 1.0
2755: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2756: -- p_commit VARCHAR2 := FND_API.G_FALSE
2757: --
2758: -- Standard OUT Parameters :
2759: -- x_return_status VARCHAR2 Required

Line 2756: -- p_commit VARCHAR2 := FND_API.G_FALSE

2752: --
2753: -- Standard IN Parameters :
2754: -- p_api_version NUMBER := 1.0
2755: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2756: -- p_commit VARCHAR2 := FND_API.G_FALSE
2757: --
2758: -- Standard OUT Parameters :
2759: -- x_return_status VARCHAR2 Required
2760: -- x_msg_count NUMBER Required

Line 2780: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2776: --
2777: -- End of Comments --
2778: PROCEDURE PICK_RELEASE(
2779: P_API_VERSION IN NUMBER,
2780: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2781: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2782: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
2783: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
2784: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 2781: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2777: -- End of Comments --
2778: PROCEDURE PICK_RELEASE(
2779: P_API_VERSION IN NUMBER,
2780: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2781: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2782: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
2783: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
2784: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,
2785: P_TO_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 2886: P_COMMIT => FND_API.G_FALSE,

2882: END LOOP;
2883:
2884: PICK_RELEASE_CONFIRM(
2885: P_API_VERSION => 1.0,
2886: P_COMMIT => FND_API.G_FALSE,
2887: P_INIT_MSG_LIST => FND_API.G_TRUE,
2888: P_ORDER_HEADER_ID => P_ORDER_HEADER_ID,
2889: P_ORDER_LINE_ID => P_ORDER_LINE_ID,
2890: P_FM_SERIAL_NUM_TBL => L_FM_SERIAL_NUM_TBL,

Line 2887: P_INIT_MSG_LIST => FND_API.G_TRUE,

2883:
2884: PICK_RELEASE_CONFIRM(
2885: P_API_VERSION => 1.0,
2886: P_COMMIT => FND_API.G_FALSE,
2887: P_INIT_MSG_LIST => FND_API.G_TRUE,
2888: P_ORDER_HEADER_ID => P_ORDER_HEADER_ID,
2889: P_ORDER_LINE_ID => P_ORDER_LINE_ID,
2890: P_FM_SERIAL_NUM_TBL => L_FM_SERIAL_NUM_TBL,
2891: P_TO_SERIAL_NUM_TBL => L_TO_SERIAL_NUM_TBL,

Line 2939: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

2935: -- Pre-reqs :
2936: --
2937: -- Standard IN Parameters :
2938: -- p_api_version NUMBER := 1.0
2939: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2940: -- p_commit VARCHAR2 := FND_API.G_FALSE
2941: --
2942: -- Standard OUT Parameters :
2943: -- x_return_status VARCHAR2 Required

Line 2940: -- p_commit VARCHAR2 := FND_API.G_FALSE

2936: --
2937: -- Standard IN Parameters :
2938: -- p_api_version NUMBER := 1.0
2939: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2940: -- p_commit VARCHAR2 := FND_API.G_FALSE
2941: --
2942: -- Standard OUT Parameters :
2943: -- x_return_status VARCHAR2 Required
2944: -- x_msg_count NUMBER Required

Line 2965: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2961: --
2962: -- End of Comments --
2963: PROCEDURE PICK_RELEASE_CONFIRM(
2964: P_API_VERSION IN NUMBER,
2965: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2966: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2967: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
2968: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
2969: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 2966: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2962: -- End of Comments --
2963: PROCEDURE PICK_RELEASE_CONFIRM(
2964: P_API_VERSION IN NUMBER,
2965: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2966: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2967: P_ORDER_HEADER_ID IN NUMBER, -- the ISO header is
2968: P_ORDER_LINE_ID IN NUMBER, -- the iso line id
2969: P_FM_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,
2970: P_TO_SERIAL_NUM_TBL IN OAF_VARCHAR2_TABLE_100,

Line 3047: IF NOT Fnd_Api.Compatible_API_Call

3043: fnd_log.string(G_LEVEL_PROCEDURE, l_api_name,'Begin API');
3044: END IF;
3045:
3046: -- standard check for API compatibility.
3047: IF NOT Fnd_Api.Compatible_API_Call
3048: (l_api_version,
3049: p_api_version,
3050: l_api_name,
3051: G_PKG_NAME)

Line 3053: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

3049: p_api_version,
3050: l_api_name,
3051: G_PKG_NAME)
3052: THEN
3053: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3054: END IF;
3055:
3056: IF fnd_api.to_boolean(p_init_msg_list)
3057: THEN

Line 3056: IF fnd_api.to_boolean(p_init_msg_list)

3052: THEN
3053: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3054: END IF;
3055:
3056: IF fnd_api.to_boolean(p_init_msg_list)
3057: THEN
3058: fnd_msg_pub.initialize;
3059: END IF;
3060:

Line 3212: p_init_msg_list => fnd_api.g_false,

3208: END IF;
3209:
3210: WSH_PICKING_BATCHES_GRP.Create_Batch(
3211: p_api_version_number => 1.0,
3212: p_init_msg_list => fnd_api.g_false,
3213: p_commit => fnd_api.g_false,
3214: x_return_status => x_return_status,
3215: x_msg_count => x_msg_count,
3216: x_msg_data => x_msg_data,

Line 3213: p_commit => fnd_api.g_false,

3209:
3210: WSH_PICKING_BATCHES_GRP.Create_Batch(
3211: p_api_version_number => 1.0,
3212: p_init_msg_list => fnd_api.g_false,
3213: p_commit => fnd_api.g_false,
3214: x_return_status => x_return_status,
3215: x_msg_count => x_msg_count,
3216: x_msg_data => x_msg_data,
3217: p_rule_id => p_picking_rule_id,

Line 3242: p_init_msg_list => fnd_api.g_false,

3238: END IF;
3239:
3240: wsh_picking_batches_pub.Release_Batch(
3241: p_api_version => 1.0,
3242: p_init_msg_list => fnd_api.g_false,
3243: p_commit => fnd_api.g_false,
3244: x_return_status => x_return_status,
3245: x_msg_count => x_msg_count,
3246: x_msg_data => x_msg_data,

Line 3243: p_commit => fnd_api.g_false,

3239:
3240: wsh_picking_batches_pub.Release_Batch(
3241: p_api_version => 1.0,
3242: p_init_msg_list => fnd_api.g_false,
3243: p_commit => fnd_api.g_false,
3244: x_return_status => x_return_status,
3245: x_msg_count => x_msg_count,
3246: x_msg_data => x_msg_data,
3247: p_batch_id => x_batch_id,

Line 3476: p_update_reservation => fnd_api.g_true,

3472: hdr_id => l_mmtt_temp_id,
3473: temp_id => l_mmtt_temp_id,
3474: lot_temp_id => l_mmtt_temp_id,
3475: p_reservation_id => l_reservation_id,
3476: p_update_reservation => fnd_api.g_true,
3477: success => x_success
3478: );
3479:
3480: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then

Line 3628: IF fnd_api.to_boolean(p_commit)

3624: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3625: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,' p_commit value - ' || p_commit);
3626: END IF;
3627:
3628: IF fnd_api.to_boolean(p_commit)
3629: THEN
3630: COMMIT;
3631: END IF;
3632:

Line 3643: p_encoded => fnd_api.g_false);

3639: fnd_message.set_token('PICKING_RULE_ID',l_picking_rule_id );
3640: FND_MSG_PUB.ADD;
3641: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3642: p_data => x_msg_data,
3643: p_encoded => fnd_api.g_false);
3644: X_RETURN_STATUS := G_RET_STS_ERROR;
3645: rollback to RELEASE_SALESORDER;
3646: WHEN INVALID_DELIVERY_DETAIL THEN
3647: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then

Line 3654: p_encoded => fnd_api.g_false);

3650: FND_MESSAGE.SET_NAME('AHL', 'AHL_INVLD_DELIVERY_DETAILS');
3651: FND_MSG_PUB.ADD;
3652: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3653: p_data => x_msg_data,
3654: p_encoded => fnd_api.g_false);
3655: X_RETURN_STATUS := G_RET_STS_ERROR;
3656: ROLLBACK TO RELEASE_SALESORDER;
3657: WHEN CREATE_BATCH THEN
3658: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then

Line 3665: p_encoded => fnd_api.g_false);

3661: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_CRT_BTCH_FAIL');
3662: FND_MSG_PUB.ADD;
3663: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3664: p_data => x_msg_data,
3665: p_encoded => fnd_api.g_false);
3666: x_return_status := G_RET_STS_ERROR;
3667: ROLLBACK TO RELEASE_SALESORDER;
3668: WHEN RELEASE_BATCH THEN
3669: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then

Line 3676: p_encoded => fnd_api.g_false);

3672: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_REL_BTCH_FAIL');
3673: fnd_msg_pub.add;
3674: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3675: P_DATA => X_MSG_DATA,
3676: p_encoded => fnd_api.g_false);
3677: x_return_status := G_RET_STS_ERROR;
3678: ROLLBACK TO RELEASE_SALESORDER;
3679: WHEN ALLOCATION_ERROR THEN
3680: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 3687: p_encoded => fnd_api.g_false);

3683: FND_MESSAGE.SET_NAME('AHL', 'AHL_MM_PICK_REL_ALOC_FAIL');
3684: fnd_msg_pub.add;
3685: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3686: P_DATA => X_MSG_DATA,
3687: p_encoded => fnd_api.g_false);
3688: x_return_status := G_RET_STS_ERROR;
3689: ROLLBACK TO RELEASE_SALESORDER;
3690: WHEN NO_DATA_FOUND THEN
3691: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 3696: p_encoded => fnd_api.g_false);

3692: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In NO_DATA_FOUND exception');
3693: END IF;
3694: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3695: P_DATA => X_MSG_DATA,
3696: p_encoded => fnd_api.g_false);
3697: X_RETURN_STATUS := G_RET_STS_ERROR;
3698: ROLLBACK TO RELEASE_SALESORDER;
3699: WHEN OTHERS THEN
3700: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN

Line 3705: p_encoded => fnd_api.g_false);

3701: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'In OTHERS exception');
3702: END IF;
3703: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3704: P_DATA => X_MSG_DATA,
3705: p_encoded => fnd_api.g_false);
3706: X_RETURN_STATUS := G_RET_STS_ERROR;
3707: ROLLBACK TO RELEASE_SALESORDER;
3708:
3709:

Line 3724: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

3720: -- Invokes Invoke_AOG_Upd_Notification to send notification and AhlPrdWorkorderPvt.updateWoAogStatus
3721: -- to update workorder status to AOG
3722: -- IN Parameters :
3723: -- p_api_version IN NUMBER Required
3724: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3725: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3726: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3727: -- p_asm_id IN NUMBER Required.
3728: --

Line 3725: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

3721: -- to update workorder status to AOG
3722: -- IN Parameters :
3723: -- p_api_version IN NUMBER Required
3724: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3725: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3726: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3727: -- p_asm_id IN NUMBER Required.
3728: --
3729: -- OUT Parameters :

Line 3726: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

3722: -- IN Parameters :
3723: -- p_api_version IN NUMBER Required
3724: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3725: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3726: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3727: -- p_asm_id IN NUMBER Required.
3728: --
3729: -- OUT Parameters :
3730: -- x_return_status OUT VARCHAR2 Required

Line 3737: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

3733: --
3734:
3735: PROCEDURE AOG_UPD_NOTIFICATION(
3736: P_API_VERSION IN NUMBER := 1.0,
3737: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3738: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3739: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3740: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
3741: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 3738: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

3734:
3735: PROCEDURE AOG_UPD_NOTIFICATION(
3736: P_API_VERSION IN NUMBER := 1.0,
3737: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3738: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3739: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3740: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
3741: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3742: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3739: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3735: PROCEDURE AOG_UPD_NOTIFICATION(
3736: P_API_VERSION IN NUMBER := 1.0,
3737: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3738: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3739: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3740: P_SCHEDULE_MATERIAL_ID_TBL IN NUMBER_TABLE_TYPE,
3741: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3742: X_MSG_COUNT OUT NOCOPY NUMBER,
3743: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 3767: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3763: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure AOG_UPD_NOTIFICATION');
3764: END IF;
3765:
3766: -- Initialize API return status to success
3767: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3768:
3769: -- Standard call to check for call compatibility.
3770: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3770: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

3766: -- Initialize API return status to success
3767: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3768:
3769: -- Standard call to check for call compatibility.
3770: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3772: END IF;
3773:
3774: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN

Line 3771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3767: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3768:
3769: -- Standard call to check for call compatibility.
3770: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3772: END IF;
3773:
3774: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
3775: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG, 'ASM ID Count : ' || TO_CHAR(P_SCHEDULE_MATERIAL_ID_TBL.COUNT) );

Line 3827: WHEN FND_API.G_EXC_ERROR THEN

3823: X_MSG_COUNT => X_MSG_COUNT,
3824: X_MSG_DATA => X_MSG_DATA);
3825:
3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3831: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 3829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3825:
3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3831: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3826: EXCEPTION
3827: WHEN FND_API.G_EXC_ERROR THEN
3828: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3831: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3834: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;

Line 3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3830: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3831: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3834: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3835: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3836: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3837: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 3835: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

3831: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3834: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3835: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3836: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3837: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3838:
3839: WHEN OTHERS THEN

Line 3836: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3832:
3833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3834: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3835: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3836: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3837: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3838:
3839: WHEN OTHERS THEN
3840: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;

Line 3841: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

3837: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3838:
3839: WHEN OTHERS THEN
3840: ROLLBACK TO MM_AOG_UPD_NOTIFICATION_SP;
3841: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3842: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3843: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3844: END IF;
3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

Line 3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3841: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3842: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3843: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3844: END IF;
3845: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3846: P_COUNT => X_MSG_COUNT,
3847: P_DATA => X_MSG_DATA);
3848:
3849: END AOG_UPD_NOTIFICATION;

Line 3860: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

3856: -- Type : Public
3857: -- Usage : This procedure is called to update AOG flag
3858: -- IN Parameters :
3859: -- p_api_version IN NUMBER Required
3860: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3861: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3862: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3863: -- P_AOG_TBL IN AOG_TBL_TYPE Required.
3864: --

Line 3861: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

3857: -- Usage : This procedure is called to update AOG flag
3858: -- IN Parameters :
3859: -- p_api_version IN NUMBER Required
3860: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3861: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3862: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3863: -- P_AOG_TBL IN AOG_TBL_TYPE Required.
3864: --
3865: -- OUT Parameters :

Line 3862: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

3858: -- IN Parameters :
3859: -- p_api_version IN NUMBER Required
3860: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3861: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3862: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3863: -- P_AOG_TBL IN AOG_TBL_TYPE Required.
3864: --
3865: -- OUT Parameters :
3866: -- x_return_status OUT VARCHAR2 Required

Line 3873: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

3869: --
3870:
3871: PROCEDURE UPDATE_AOG(
3872: P_API_VERSION IN NUMBER := 1.0,
3873: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3874: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3875: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3876: P_AOG_TBL IN AOG_TBL_TYPE,
3877: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 3874: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

3870:
3871: PROCEDURE UPDATE_AOG(
3872: P_API_VERSION IN NUMBER := 1.0,
3873: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3874: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3875: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3876: P_AOG_TBL IN AOG_TBL_TYPE,
3877: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3878: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 3875: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3871: PROCEDURE UPDATE_AOG(
3872: P_API_VERSION IN NUMBER := 1.0,
3873: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
3874: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
3875: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3876: P_AOG_TBL IN AOG_TBL_TYPE,
3877: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3878: X_MSG_COUNT OUT NOCOPY NUMBER,
3879: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 3899: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3895: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure UPDATE_AOG');
3896: END IF;
3897:
3898: -- Initialize API return status to success
3899: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3900:
3901: -- Standard call to check for call compatibility.
3902: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3902: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

3898: -- Initialize API return status to success
3899: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3900:
3901: -- Standard call to check for call compatibility.
3902: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3904: END IF;
3905:
3906: FOR I IN 1 .. P_AOG_TBL.COUNT

Line 3903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3899: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3900:
3901: -- Standard call to check for call compatibility.
3902: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3904: END IF;
3905:
3906: FOR I IN 1 .. P_AOG_TBL.COUNT
3907: LOOP

Line 3930: RAISE FND_API.G_EXC_ERROR;

3926: WHERE SCHEDULED_MATERIAL_ID = P_AOG_TBL(I).SCHEDULE_MATERIAL_ID AND OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER;
3927: IF SQL%ROWCOUNT=0 THEN
3928: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3929: FND_MSG_PUB.ADD;
3930: RAISE FND_API.G_EXC_ERROR;
3931: END IF;
3932: END IF;
3933: END IF;
3934: END LOOP;

Line 3950: IF FND_API.TO_BOOLEAN(P_COMMIT)

3946: X_MSG_DATA => X_MSG_DATA
3947: );
3948: END IF;
3949:
3950: IF FND_API.TO_BOOLEAN(P_COMMIT)
3951: THEN
3952: COMMIT;
3953: END IF;
3954:

Line 3956: WHEN FND_API.G_EXC_ERROR THEN

3952: COMMIT;
3953: END IF;
3954:
3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: ROLLBACK TO MM_UPDATE_AOG_SP;
3958: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3960: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 3958: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3954:
3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: ROLLBACK TO MM_UPDATE_AOG_SP;
3958: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3960: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3955: EXCEPTION
3956: WHEN FND_API.G_EXC_ERROR THEN
3957: ROLLBACK TO MM_UPDATE_AOG_SP;
3958: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3960: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: ROLLBACK TO MM_UPDATE_AOG_SP;

Line 3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3958: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3959: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3960: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: ROLLBACK TO MM_UPDATE_AOG_SP;
3964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3965: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3966: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 3964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

3960: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: ROLLBACK TO MM_UPDATE_AOG_SP;
3964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3965: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3966: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3967:
3968: WHEN OTHERS THEN

Line 3965: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3961:
3962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3963: ROLLBACK TO MM_UPDATE_AOG_SP;
3964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3965: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3966: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3967:
3968: WHEN OTHERS THEN
3969: ROLLBACK TO MM_UPDATE_AOG_SP;

Line 3970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

3966: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
3967:
3968: WHEN OTHERS THEN
3969: ROLLBACK TO MM_UPDATE_AOG_SP;
3970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3971: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3972: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3973: END IF;
3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

Line 3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

3970: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
3971: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3972: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
3973: END IF;
3974: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
3975: P_COUNT => X_MSG_COUNT,
3976: P_DATA => X_MSG_DATA);
3977:
3978: END UPDATE_AOG;

Line 4050: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

4046: -- in the source/destination organization.
4047: --
4048: -- Standard IN Parameters :
4049: -- p_api_version NUMBER := 1.0
4050: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4051: -- p_commit VARCHAR2 := FND_API.G_FALSE
4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4053: -- p_default VARCHAR2 := FND_API.G_FALSE
4054: -- p_module_type VARCHAR2 := NULL

Line 4051: -- p_commit VARCHAR2 := FND_API.G_FALSE

4047: --
4048: -- Standard IN Parameters :
4049: -- p_api_version NUMBER := 1.0
4050: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4051: -- p_commit VARCHAR2 := FND_API.G_FALSE
4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4053: -- p_default VARCHAR2 := FND_API.G_FALSE
4054: -- p_module_type VARCHAR2 := NULL
4055: --

Line 4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

4048: -- Standard IN Parameters :
4049: -- p_api_version NUMBER := 1.0
4050: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4051: -- p_commit VARCHAR2 := FND_API.G_FALSE
4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4053: -- p_default VARCHAR2 := FND_API.G_FALSE
4054: -- p_module_type VARCHAR2 := NULL
4055: --
4056: -- Standard OUT Parameters :

Line 4053: -- p_default VARCHAR2 := FND_API.G_FALSE

4049: -- p_api_version NUMBER := 1.0
4050: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4051: -- p_commit VARCHAR2 := FND_API.G_FALSE
4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4053: -- p_default VARCHAR2 := FND_API.G_FALSE
4054: -- p_module_type VARCHAR2 := NULL
4055: --
4056: -- Standard OUT Parameters :
4057: -- p_x_return_status VARCHAR2 Required

Line 4079: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4075: PROCEDURE Perform_Inter_Org_Transfer
4076: (
4077: -- Standard IN params
4078: p_api_version IN NUMBER := 1.0,
4079: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4082: p_default IN VARCHAR2 := FND_API.G_FALSE,
4083: p_module_type IN VARCHAR2 := NULL,

Line 4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4076: (
4077: -- Standard IN params
4078: p_api_version IN NUMBER := 1.0,
4079: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4082: p_default IN VARCHAR2 := FND_API.G_FALSE,
4083: p_module_type IN VARCHAR2 := NULL,
4084: -- Standard OUT params

Line 4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4077: -- Standard IN params
4078: p_api_version IN NUMBER := 1.0,
4079: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4082: p_default IN VARCHAR2 := FND_API.G_FALSE,
4083: p_module_type IN VARCHAR2 := NULL,
4084: -- Standard OUT params
4085: x_return_status OUT NOCOPY VARCHAR2,

Line 4082: p_default IN VARCHAR2 := FND_API.G_FALSE,

4078: p_api_version IN NUMBER := 1.0,
4079: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4082: p_default IN VARCHAR2 := FND_API.G_FALSE,
4083: p_module_type IN VARCHAR2 := NULL,
4084: -- Standard OUT params
4085: x_return_status OUT NOCOPY VARCHAR2,
4086: x_msg_count OUT NOCOPY NUMBER,

Line 4111: l_commit VARCHAR2(1) := FND_API.G_FALSE;

4107: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;
4108: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;
4109:
4110: -- for commit
4111: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4112: l_count NUMBER;
4113:
4114: BEGIN
4115: G_DEBUG_LINE_NUM := 10;

Line 4124: x_return_status := FND_API.G_RET_STS_SUCCESS;

4120: END IF;
4121: END IF;
4122:
4123: -- Initialize return status to success
4124: x_return_status := FND_API.G_RET_STS_SUCCESS;
4125:
4126: -- Initialize message list if p_init_msg_list is set to TRUE
4127: IF FND_API.To_Boolean(p_init_msg_list) THEN
4128: FND_MSG_PUB.Initialize;

Line 4127: IF FND_API.To_Boolean(p_init_msg_list) THEN

4123: -- Initialize return status to success
4124: x_return_status := FND_API.G_RET_STS_SUCCESS;
4125:
4126: -- Initialize message list if p_init_msg_list is set to TRUE
4127: IF FND_API.To_Boolean(p_init_msg_list) THEN
4128: FND_MSG_PUB.Initialize;
4129: END IF;
4130:
4131: -- Standard start of API savepoint

Line 4139: x_return_status := FND_API.G_RET_STS_ERROR;

4135: -- Check whether the input table type is valid
4136: IF (p_x_mtltfr_tbl IS NULL)
4137: THEN
4138: G_DEBUG_LINE_NUM := 17;
4139: x_return_status := FND_API.G_RET_STS_ERROR;
4140: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_ERROR;
4143: ELSIF (p_x_mtltfr_tbl.COUNT = 0)

Line 4142: RAISE FND_API.G_EXC_ERROR;

4138: G_DEBUG_LINE_NUM := 17;
4139: x_return_status := FND_API.G_RET_STS_ERROR;
4140: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_ERROR;
4143: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4144: THEN
4145: G_DEBUG_LINE_NUM := 19;
4146: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4146: x_return_status := FND_API.G_RET_STS_ERROR;

4142: RAISE FND_API.G_EXC_ERROR;
4143: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4144: THEN
4145: G_DEBUG_LINE_NUM := 19;
4146: x_return_status := FND_API.G_RET_STS_ERROR;
4147: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4148: FND_MSG_PUB.ADD;
4149: RAISE FND_API.G_EXC_ERROR;
4150: END IF;

Line 4149: RAISE FND_API.G_EXC_ERROR;

4145: G_DEBUG_LINE_NUM := 19;
4146: x_return_status := FND_API.G_RET_STS_ERROR;
4147: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4148: FND_MSG_PUB.ADD;
4149: RAISE FND_API.G_EXC_ERROR;
4150: END IF;
4151:
4152: G_DEBUG_LINE_NUM := 20;
4153: -- Call API to process transfer

Line 4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4175: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned exception');
4176: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM -'|| SQLERRM);
4177: END IF;
4178: -- Raise Exception
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: END;
4181: G_DEBUG_LINE_NUM := 30;
4182: IF (x_return_status = FND_API.G_RET_STS_ERROR)
4183: THEN

Line 4182: IF (x_return_status = FND_API.G_RET_STS_ERROR)

4178: -- Raise Exception
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: END;
4181: G_DEBUG_LINE_NUM := 30;
4182: IF (x_return_status = FND_API.G_RET_STS_ERROR)
4183: THEN
4184: IF (l_log_error >= l_log_current_level) THEN
4185: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned error.');
4186: END IF;

Line 4188: RAISE FND_API.G_EXC_ERROR;

4184: IF (l_log_error >= l_log_current_level) THEN
4185: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned error.');
4186: END IF;
4187: -- Raise exception
4188: RAISE FND_API.G_EXC_ERROR;
4189: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
4190: THEN
4191: IF (l_log_error >= l_log_current_level) THEN
4192: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned unexpected error.');

Line 4189: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

4185: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned error.');
4186: END IF;
4187: -- Raise exception
4188: RAISE FND_API.G_EXC_ERROR;
4189: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
4190: THEN
4191: IF (l_log_error >= l_log_current_level) THEN
4192: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned unexpected error.');
4193: END IF;

Line 4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4191: IF (l_log_error >= l_log_current_level) THEN
4192: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned unexpected error.');
4193: END IF;
4194: -- Raise exception
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4196: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS)
4197: THEN
4198:
4199: -- Loop through all records and reserve if applicable

Line 4196: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS)

4192: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer_Inv returned unexpected error.');
4193: END IF;
4194: -- Raise exception
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4196: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS)
4197: THEN
4198:
4199: -- Loop through all records and reserve if applicable
4200: FOR i IN p_x_mtltfr_tbl.FIRST.. p_x_mtltfr_tbl.LAST

Line 4284: p_init_msg_list => FND_API.G_TRUE,

4280: x_msg_count := NULL;
4281: x_msg_data := NULL;
4282: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION(
4283: p_api_version => 1.0,
4284: p_init_msg_list => FND_API.G_TRUE,
4285: p_commit => FND_API.G_FALSE,
4286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4287: p_module_type => p_module_type,
4288: x_return_status => x_return_status,

Line 4285: p_commit => FND_API.G_FALSE,

4281: x_msg_data := NULL;
4282: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION(
4283: p_api_version => 1.0,
4284: p_init_msg_list => FND_API.G_TRUE,
4285: p_commit => FND_API.G_FALSE,
4286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4287: p_module_type => p_module_type,
4288: x_return_status => x_return_status,
4289: x_msg_count => x_msg_count,

Line 4286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4282: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION(
4283: p_api_version => 1.0,
4284: p_init_msg_list => FND_API.G_TRUE,
4285: p_commit => FND_API.G_FALSE,
4286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4287: p_module_type => p_module_type,
4288: x_return_status => x_return_status,
4289: x_msg_count => x_msg_count,
4290: x_msg_data => x_msg_data,

Line 4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4297: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned exception');
4298: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4299: END IF;
4300: -- Raise Exception
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: END;
4303: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4304: IF (l_log_error >= l_log_current_level) THEN
4305: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned error. x_msg_count ='||x_msg_count);

Line 4303: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4299: END IF;
4300: -- Raise Exception
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: END;
4303: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4304: IF (l_log_error >= l_log_current_level) THEN
4305: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned error. x_msg_count ='||x_msg_count);
4306: END IF;
4307: -- Raise exception

Line 4308: RAISE FND_API.G_EXC_ERROR;

4304: IF (l_log_error >= l_log_current_level) THEN
4305: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned error. x_msg_count ='||x_msg_count);
4306: END IF;
4307: -- Raise exception
4308: RAISE FND_API.G_EXC_ERROR;
4309: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4310: IF (l_log_error >= l_log_current_level) THEN
4311: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned unexpected error.');
4312: END IF;

Line 4309: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4305: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned error. x_msg_count ='||x_msg_count);
4306: END IF;
4307: -- Raise exception
4308: RAISE FND_API.G_EXC_ERROR;
4309: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4310: IF (l_log_error >= l_log_current_level) THEN
4311: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned unexpected error.');
4312: END IF;
4313: -- Raise exception

Line 4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4310: IF (l_log_error >= l_log_current_level) THEN
4311: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned unexpected error.');
4312: END IF;
4313: -- Raise exception
4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4315: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4316: IF (l_log_statement >= l_log_current_level) THEN
4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');
4318: END IF;

Line 4315: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4311: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned unexpected error.');
4312: END IF;
4313: -- Raise exception
4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4315: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4316: IF (l_log_statement >= l_log_current_level) THEN
4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');
4318: END IF;
4319: --FND_MESSAGE.Set_Name('AHL','AHL_MM_RES_MSG');

Line 4338: IF FND_API.To_Boolean(p_commit) THEN

4334: END IF;
4335: G_DEBUG_LINE_NUM := 90;
4336: -- Perform Commit
4337: -- Standard check of p_commit
4338: IF FND_API.To_Boolean(p_commit) THEN
4339: COMMIT ;
4340: END IF;
4341: IF (l_log_statement >= l_log_current_level) THEN
4342: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer completed sucessfully');

Line 4345: WHEN FND_API.G_EXC_ERROR THEN

4341: IF (l_log_statement >= l_log_current_level) THEN
4342: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer completed sucessfully');
4343: END IF;
4344: EXCEPTION
4345: WHEN FND_API.G_EXC_ERROR THEN
4346: x_return_status := FND_API.G_RET_STS_ERROR;
4347: IF (l_log_error >= l_log_current_level) THEN
4348: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4349:

Line 4346: x_return_status := FND_API.G_RET_STS_ERROR;

4342: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API Perform_Inter_Org_Transfer completed sucessfully');
4343: END IF;
4344: EXCEPTION
4345: WHEN FND_API.G_EXC_ERROR THEN
4346: x_return_status := FND_API.G_RET_STS_ERROR;
4347: IF (l_log_error >= l_log_current_level) THEN
4348: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4349:
4350: END IF;

Line 4352: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4348: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4349:
4350: END IF;
4351: ROLLBACK TO Perform_Inter_Org_Transfer;
4352: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4355: IF (l_log_error >= l_log_current_level) THEN
4356: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);

Line 4353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4349:
4350: END IF;
4351: ROLLBACK TO Perform_Inter_Org_Transfer;
4352: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4355: IF (l_log_error >= l_log_current_level) THEN
4356: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4357: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);

Line 4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4350: END IF;
4351: ROLLBACK TO Perform_Inter_Org_Transfer;
4352: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4355: IF (l_log_error >= l_log_current_level) THEN
4356: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4357: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4358: END IF;

Line 4360: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4356: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4357: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4358: END IF;
4359: ROLLBACK TO Perform_Inter_Org_Transfer;
4360: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4361: WHEN OTHERS THEN
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: IF (l_log_exception >= l_log_current_level) THEN
4364: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);

Line 4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4358: END IF;
4359: ROLLBACK TO Perform_Inter_Org_Transfer;
4360: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4361: WHEN OTHERS THEN
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: IF (l_log_exception >= l_log_current_level) THEN
4364: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Error in processing. x_return_status ='||x_return_status);
4365: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4366: END IF;

Line 4369: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4365: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4366: END IF;
4367: ROLLBACK TO Perform_Inter_Org_Transfer;
4368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer', p_error_text => SQLERRM);
4369: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4370: END;
4371: ------------------------------------------------------------------------------------------------------
4372: --------------------------------------------------------------------------------------------------------------------------------------
4373: -- Define Private APIs --

Line 4385: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

4381: -- Pre-reqs :
4382: --
4383: -- Standard IN Parameters :
4384: -- p_api_version NUMBER := 1.0
4385: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4386: -- p_commit VARCHAR2 := FND_API.G_FALSE
4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4388: -- p_default VARCHAR2 := FND_API.G_FALSE
4389: -- p_module_type VARCHAR2 := NULL

Line 4386: -- p_commit VARCHAR2 := FND_API.G_FALSE

4382: --
4383: -- Standard IN Parameters :
4384: -- p_api_version NUMBER := 1.0
4385: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4386: -- p_commit VARCHAR2 := FND_API.G_FALSE
4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4388: -- p_default VARCHAR2 := FND_API.G_FALSE
4389: -- p_module_type VARCHAR2 := NULL
4390: --

Line 4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

4383: -- Standard IN Parameters :
4384: -- p_api_version NUMBER := 1.0
4385: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4386: -- p_commit VARCHAR2 := FND_API.G_FALSE
4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4388: -- p_default VARCHAR2 := FND_API.G_FALSE
4389: -- p_module_type VARCHAR2 := NULL
4390: --
4391: -- Standard OUT Parameters :

Line 4388: -- p_default VARCHAR2 := FND_API.G_FALSE

4384: -- p_api_version NUMBER := 1.0
4385: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4386: -- p_commit VARCHAR2 := FND_API.G_FALSE
4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4388: -- p_default VARCHAR2 := FND_API.G_FALSE
4389: -- p_module_type VARCHAR2 := NULL
4390: --
4391: -- Standard OUT Parameters :
4392: -- x_return_status VARCHAR2 Required

Line 4410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4406: PROCEDURE Perform_Inter_Org_Transfer_Inv
4407: (
4408: -- Standard IN params
4409: p_api_version IN NUMBER := 1.0,
4410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4413: p_default IN VARCHAR2 := FND_API.G_FALSE,
4414: p_module_type IN VARCHAR2 := NULL,

Line 4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4407: (
4408: -- Standard IN params
4409: p_api_version IN NUMBER := 1.0,
4410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4413: p_default IN VARCHAR2 := FND_API.G_FALSE,
4414: p_module_type IN VARCHAR2 := NULL,
4415: -- Standard OUT params

Line 4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4408: -- Standard IN params
4409: p_api_version IN NUMBER := 1.0,
4410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4413: p_default IN VARCHAR2 := FND_API.G_FALSE,
4414: p_module_type IN VARCHAR2 := NULL,
4415: -- Standard OUT params
4416: x_return_status OUT NOCOPY VARCHAR2,

Line 4413: p_default IN VARCHAR2 := FND_API.G_FALSE,

4409: p_api_version IN NUMBER := 1.0,
4410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4413: p_default IN VARCHAR2 := FND_API.G_FALSE,
4414: p_module_type IN VARCHAR2 := NULL,
4415: -- Standard OUT params
4416: x_return_status OUT NOCOPY VARCHAR2,
4417: x_msg_count OUT NOCOPY NUMBER,

Line 4477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

4473: END IF;
4474: -- Standard start of API savepoint
4475: SAVEPOINT Perform_Inter_Org_Transfer_Inv;
4476: -- Standard call to check for call compatibility
4477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: END IF;
4480: -- Initialize message list if p_init_msg_list is set to TRUE
4481: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4474: -- Standard start of API savepoint
4475: SAVEPOINT Perform_Inter_Org_Transfer_Inv;
4476: -- Standard call to check for call compatibility
4477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: END IF;
4480: -- Initialize message list if p_init_msg_list is set to TRUE
4481: IF FND_API.To_Boolean(p_init_msg_list) THEN
4482: FND_MSG_PUB.Initialize;

Line 4481: IF FND_API.To_Boolean(p_init_msg_list) THEN

4477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: END IF;
4480: -- Initialize message list if p_init_msg_list is set to TRUE
4481: IF FND_API.To_Boolean(p_init_msg_list) THEN
4482: FND_MSG_PUB.Initialize;
4483: END IF;
4484: -- Initialize API return status to success
4485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4485: x_return_status := FND_API.G_RET_STS_SUCCESS;

4481: IF FND_API.To_Boolean(p_init_msg_list) THEN
4482: FND_MSG_PUB.Initialize;
4483: END IF;
4484: -- Initialize API return status to success
4485: x_return_status := FND_API.G_RET_STS_SUCCESS;
4486: -- Initialize shipping id table to null
4487: ship_id_tbl := NULL;
4488: -- Check whether the input table type is valid
4489: IF (p_x_mtltfr_tbl IS NULL)

Line 4492: x_return_status := FND_API.G_RET_STS_ERROR;

4488: -- Check whether the input table type is valid
4489: IF (p_x_mtltfr_tbl IS NULL)
4490: THEN
4491: G_DEBUG_LINE_NUM := 107;
4492: x_return_status := FND_API.G_RET_STS_ERROR;
4493: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: ELSIF (p_x_mtltfr_tbl.COUNT = 0)

Line 4495: RAISE FND_API.G_EXC_ERROR;

4491: G_DEBUG_LINE_NUM := 107;
4492: x_return_status := FND_API.G_RET_STS_ERROR;
4493: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4497: THEN
4498: G_DEBUG_LINE_NUM := 109;
4499: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4499: x_return_status := FND_API.G_RET_STS_ERROR;

4495: RAISE FND_API.G_EXC_ERROR;
4496: ELSIF (p_x_mtltfr_tbl.COUNT = 0)
4497: THEN
4498: G_DEBUG_LINE_NUM := 109;
4499: x_return_status := FND_API.G_RET_STS_ERROR;
4500: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: END IF;

Line 4502: RAISE FND_API.G_EXC_ERROR;

4498: G_DEBUG_LINE_NUM := 109;
4499: x_return_status := FND_API.G_RET_STS_ERROR;
4500: FND_MESSAGE.Set_Name('AHL','AHL_MM_MTRL_REC_NULL');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: END IF;
4504:
4505: IF (p_x_mtltfr_tbl.COUNT > 0) THEN
4506: -- Validate each record

Line 4525: IF (x_return_status = FND_API.G_RET_STS_ERROR)

4521: IF (l_log_statement >= l_log_current_level) THEN
4522: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':After calling Validate_Record for i=['||i||']');
4523: END IF;
4524:
4525: IF (x_return_status = FND_API.G_RET_STS_ERROR)
4526: THEN
4527: l_error := true;
4528: IF (l_log_statement >= l_log_current_level)
4529: THEN

Line 4532: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

4528: IF (l_log_statement >= l_log_current_level)
4529: THEN
4530: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Error in Validation for record no'||i);
4531: END IF;
4532: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
4533: THEN
4534: IF (l_log_statement >= l_log_current_level) THEN
4535: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Unexpected error in Validation. No further processing');
4536: END IF;

Line 4537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4533: THEN
4534: IF (l_log_statement >= l_log_current_level) THEN
4535: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Unexpected error in Validation. No further processing');
4536: END IF;
4537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4538: END IF;
4539:
4540: END LOOP;
4541: G_DEBUG_LINE_NUM := 130;

Line 4554: RAISE FND_API.G_EXC_ERROR;

4550: --log
4551: IF (l_log_statement >= l_log_current_level) THEN
4552: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Validation Errors are there. Raise Error');
4553: END IF;
4554: RAISE FND_API.G_EXC_ERROR;
4555: END IF;
4556: -- No errors. Insert in interface table.
4557: l_error := false;
4558: --log

Line 4622: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4618: -- Store the transaction ids generated during each insertion
4619: l_transaction_id_tbl(i) := l_transaction_id;
4620: G_DEBUG_LINE_NUM := 170;
4621:
4622: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4623: l_error := true;
4624: IF (l_log_error >= l_log_current_level) THEN
4625: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in Insert_Material Procedure for record '||i);
4626: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Continuing...');

Line 4628: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4624: IF (l_log_error >= l_log_current_level) THEN
4625: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in Insert_Material Procedure for record '||i);
4626: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Continuing...');
4627: END IF;
4628: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4629: l_error := true;
4630: IF (l_log_error >= l_log_current_level) THEN
4631: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Unexpected Error in Insert_Material Procedure for record '||i);
4632: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Raising Error');

Line 4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4630: IF (l_log_error >= l_log_current_level) THEN
4631: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Unexpected Error in Insert_Material Procedure for record '||i);
4632: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Raising Error');
4633: END IF;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4635: END IF;
4636: END LOOP;
4637: IF(l_error ) THEN
4638: G_DEBUG_LINE_NUM := 180;

Line 4644: RAISE FND_API.G_EXC_ERROR;

4640: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Error in Insert_Material Procedure');
4641: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':Raising Error');
4642: END IF;
4643: -- Processing stops
4644: RAISE FND_API.G_EXC_ERROR;
4645: END IF;
4646: -- Now process the interface records
4647: --log
4648: IF (l_log_statement >= l_log_current_level) THEN

Line 4654: p_init_msg_list => fnd_api.g_false,

4650: END IF;
4651: BEGIN
4652: G_DEBUG_LINE_NUM := 185;
4653: l_result := INV_TXN_MANAGER_PUB.process_Transactions( p_api_version => NULL ,
4654: p_init_msg_list => fnd_api.g_false,
4655: p_commit => fnd_api.g_false ,
4656: p_validation_level => fnd_api.g_valid_level_full ,
4657: x_return_status => x_return_status,
4658: x_msg_count => x_msg_count,

Line 4655: p_commit => fnd_api.g_false ,

4651: BEGIN
4652: G_DEBUG_LINE_NUM := 185;
4653: l_result := INV_TXN_MANAGER_PUB.process_Transactions( p_api_version => NULL ,
4654: p_init_msg_list => fnd_api.g_false,
4655: p_commit => fnd_api.g_false ,
4656: p_validation_level => fnd_api.g_valid_level_full ,
4657: x_return_status => x_return_status,
4658: x_msg_count => x_msg_count,
4659: x_msg_data => x_msg_data,

Line 4656: p_validation_level => fnd_api.g_valid_level_full ,

4652: G_DEBUG_LINE_NUM := 185;
4653: l_result := INV_TXN_MANAGER_PUB.process_Transactions( p_api_version => NULL ,
4654: p_init_msg_list => fnd_api.g_false,
4655: p_commit => fnd_api.g_false ,
4656: p_validation_level => fnd_api.g_valid_level_full ,
4657: x_return_status => x_return_status,
4658: x_msg_count => x_msg_count,
4659: x_msg_data => x_msg_data,
4660: x_trans_count => l_trans_count,

Line 4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4667: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':API INV_TXN_MANAGER_PUB.process_Transactions returned exception');
4668: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM -'|| SQLERRM);
4669: END IF;
4670: -- Raise Exception
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: END;
4673: mo_global.init('AHL');
4674: IF( l_result = -1 OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4675: G_DEBUG_LINE_NUM := 188;

Line 4674: IF( l_result = -1 OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4670: -- Raise Exception
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: END;
4673: mo_global.init('AHL');
4674: IF( l_result = -1 OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4675: G_DEBUG_LINE_NUM := 188;
4676: IF (l_log_statement >= l_log_current_level) THEN
4677: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':INV_TXN_MANAGER_PUB.process_Transactions returned error.x_msg_data = '||x_msg_data);
4678: END IF;

Line 4711: RAISE FND_API.G_EXC_ERROR;

4707: END IF;
4708: CLOSE Transaction_Error_Cur;
4709: END LOOP;
4710: IF(l_error ) THEN
4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713: END IF;
4714: -- END of if which checks the count of transactions created
4715: -- Standard check of p_commit

Line 4716: IF FND_API.To_Boolean(p_commit) THEN

4712: END IF;
4713: END IF;
4714: -- END of if which checks the count of transactions created
4715: -- Standard check of p_commit
4716: IF FND_API.To_Boolean(p_commit) THEN
4717: COMMIT ;
4718: END IF;
4719: EXCEPTION
4720: WHEN FND_API.G_EXC_ERROR THEN

Line 4720: WHEN FND_API.G_EXC_ERROR THEN

4716: IF FND_API.To_Boolean(p_commit) THEN
4717: COMMIT ;
4718: END IF;
4719: EXCEPTION
4720: WHEN FND_API.G_EXC_ERROR THEN
4721: x_return_status := FND_API.G_RET_STS_ERROR;
4722: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4721: x_return_status := FND_API.G_RET_STS_ERROR;

4717: COMMIT ;
4718: END IF;
4719: EXCEPTION
4720: WHEN FND_API.G_EXC_ERROR THEN
4721: x_return_status := FND_API.G_RET_STS_ERROR;
4722: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4719: EXCEPTION
4720: WHEN FND_API.G_EXC_ERROR THEN
4721: x_return_status := FND_API.G_RET_STS_ERROR;
4722: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4720: WHEN FND_API.G_EXC_ERROR THEN
4721: x_return_status := FND_API.G_RET_STS_ERROR;
4722: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4728: WHEN OTHERS THEN

Line 4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4721: x_return_status := FND_API.G_RET_STS_ERROR;
4722: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4723: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);

Line 4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4726: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4727: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);
4732: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4733: END Perform_Inter_Org_Transfer_Inv;

Line 4732: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: ROLLBACK TO Perform_Inter_Org_Transfer_Inv;
4731: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME, p_procedure_name => 'Perform_Inter_Org_Transfer_Inv', p_error_text => SQLERRM);
4732: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4733: END Perform_Inter_Org_Transfer_Inv;
4734: ------------------------------------------------------------------------------------------------------------
4735: PROCEDURE Insert_Material
4736: (

Line 4828: x_return_status := FND_API.G_RET_STS_SUCCESS;

4824: --Log
4825: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Insert_Material';
4826: BEGIN
4827: l_process_flag := '1';
4828: x_return_status := FND_API.G_RET_STS_SUCCESS;
4829: --log
4830: G_DEBUG_LINE_NUM := 200;
4831: IF (l_log_statement >= l_log_current_level) THEN
4832: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':In Insert_Material Procedure with shipping network type '||p_shipping_type||

Line 5124: x_return_status := FND_API.G_RET_STS_ERROR;

5120: p_x_mtltfr_rec.shipment_number := l_shipment_number;
5121: EXCEPTION
5122: WHEN OTHERS
5123: THEN
5124: x_return_status := FND_API.G_RET_STS_ERROR;
5125: IF (l_log_exception >= l_log_current_level) THEN
5126: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':Exception in Insert_Material');
5127: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM -'||SQLERRM);
5128: END IF;

Line 5134: RAISE FND_API.G_EXC_ERROR;

5130: FND_MESSAGE.Set_Token('MSG',SQLERRM);
5131: FND_MESSAGE.Set_Token('ITEM',p_x_mtltfr_rec.inventory_item_id);
5132: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5133: FND_MSG_PUB.ADD;
5134: RAISE FND_API.G_EXC_ERROR;
5135: END Insert_Material;
5136: ------------------------------------------------------------------------------------------------------------
5137: PROCEDURE Validate_Record
5138: (

Line 5228: x_return_status := FND_API.G_RET_STS_SUCCESS;

5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;
5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;
5227: BEGIN
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;
5229: --log
5230: G_DEBUG_LINE_NUM := 300;
5231: IF (l_log_statement >= l_log_current_level) THEN
5232: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':In Validate_Record procedure');

Line 5280: x_return_status := FND_API.G_RET_STS_ERROR;

5276: IF(NVL(p_x_mtltfr_rec.quantity,0) <= 0) THEN
5277: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');
5278: FND_MESSAGE.Set_Token('QUANTITY',p_x_mtltfr_rec.quantity);
5279: FND_MSG_PUB.ADD;
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: END IF;
5282: G_DEBUG_LINE_NUM := 320;
5283: IF (l_log_statement >= l_log_current_level) THEN
5284: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Validating item '||p_x_mtltfr_rec.inventory_item_id||' and org id '||p_x_mtltfr_rec.source_org_id);

Line 5305: x_return_status := FND_API.G_RET_STS_ERROR;

5301: END IF;
5302: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_ITEM');
5303: FND_MESSAGE.Set_Token('FIELD',NVL(l_concatenated_segments, p_x_mtltfr_rec.Inventory_Item_Id));
5304: FND_MSG_PUB.ADD;
5305: x_return_status := FND_API.G_RET_STS_ERROR;
5306: END IF;
5307: CLOSE ITEM_VALID_CUR_DEST;
5308: ELSE
5309: G_DEBUG_LINE_NUM := 340;

Line 5320: x_return_status := FND_API.G_RET_STS_ERROR;

5316: END IF;
5317: FND_MESSAGE.Set_Name('AHL','AHL_MM_SOURCE_ORG_NULL');
5318: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5319: FND_MSG_PUB.ADD;
5320: x_return_status := FND_API.G_RET_STS_ERROR;
5321: END IF;
5322: IF p_x_mtltfr_rec.dest_org_id IS NULL THEN
5323: G_DEBUG_LINE_NUM := 350;
5324: IF (l_log_statement >= l_log_current_level) THEN

Line 5330: x_return_status := FND_API.G_RET_STS_ERROR;

5326: END IF;
5327: FND_MESSAGE.Set_Name('AHL','AHL_MM_DEST_ORG_NULL');
5328: FND_MESSAGE.Set_Token('SER', p_x_mtltfr_rec.serial_number);
5329: FND_MSG_PUB.ADD;
5330: x_return_status := FND_API.G_RET_STS_ERROR;
5331: END IF;
5332: END IF;
5333: G_DEBUG_LINE_NUM := 352;
5334: IF (l_log_statement >= l_log_current_level) THEN

Line 5344: x_return_status := FND_API.G_RET_STS_ERROR;

5340: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is null');
5341: END IF;
5342: FND_MESSAGE.Set_Name('AHL','AHL_CMP_ITEM_NULL');
5343: FND_MSG_PUB.ADD;
5344: x_return_status := FND_API.G_RET_STS_ERROR;
5345: END IF;
5346:
5347: IF (l_log_statement >= l_log_current_level) THEN
5348: G_DEBUG_LINE_NUM := 370;

Line 5351: IF(p_x_mtltfr_rec.Serial_Number IS NULL OR p_x_mtltfr_rec.Serial_Number = FND_API.G_MISS_CHAR)

5347: IF (l_log_statement >= l_log_current_level) THEN
5348: G_DEBUG_LINE_NUM := 370;
5349: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Validating Serial '||p_x_mtltfr_rec.Serial_Number);
5350: END IF;
5351: IF(p_x_mtltfr_rec.Serial_Number IS NULL OR p_x_mtltfr_rec.Serial_Number = FND_API.G_MISS_CHAR)
5352: THEN
5353: G_DEBUG_LINE_NUM := 380;
5354: IF (l_log_statement >= l_log_current_level) THEN
5355: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item serial is NULL. Can not be transfered');

Line 5359: x_return_status := FND_API.G_RET_STS_ERROR;

5355: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item serial is NULL. Can not be transfered');
5356: END IF;
5357: FND_MESSAGE.Set_Name('AHL','AHL_MM_SERIAL_NULL');
5358: FND_MSG_PUB.ADD;
5359: x_return_status := FND_API.G_RET_STS_ERROR;
5360: ELSE
5361: IF (p_x_mtltfr_rec.Serial_Number IS NOT NULL AND l_serial_Control_dest = 1) THEN
5362: G_DEBUG_LINE_NUM := 390;
5363: IF (l_log_statement >= l_log_current_level) THEN

Line 5370: x_return_status := FND_API.G_RET_STS_ERROR;

5366: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SRLNUM_NOTMAND');
5367: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.Serial_Number);
5368: FND_MESSAGE.Set_Token('ITEM',l_concatenated_segments);
5369: FND_MSG_PUB.ADD;
5370: x_return_status := FND_API.G_RET_STS_ERROR;
5371: END IF;
5372: END IF;
5373: IF (l_log_statement >= l_log_current_level) THEN
5374: G_DEBUG_LINE_NUM := 392;

Line 5384: x_return_status := FND_API.G_RET_STS_ERROR;

5380: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Item is lot controlled in destination org. Can not be transfered');
5381: END IF;
5382: FND_MESSAGE.Set_Name('AHL','AHL_MM_LOT_BASED_ITEM');
5383: FND_MSG_PUB.ADD;
5384: x_return_status := FND_API.G_RET_STS_ERROR;
5385: END IF;
5386: -- Visit Locator validation
5387: IF (l_log_statement >= l_log_current_level) THEN
5388: G_DEBUG_LINE_NUM := 402;

Line 5397: x_return_status := FND_API.G_RET_STS_ERROR;

5393: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Visit locator is null');
5394: END IF;
5395: FND_MESSAGE.Set_Name('AHL','AHL_MM_NULL_VISIT_LOCATOR');
5396: FND_MSG_PUB.ADD;
5397: x_return_status := FND_API.G_RET_STS_ERROR;
5398: ELSE
5399: --Locator Validation for destination
5400: OPEN LOCATOR_VALID_CUR(p_x_mtltfr_rec.dest_org_id, p_x_mtltfr_rec.dest_locator_id);
5401: FETCH LOCATOR_VALID_CUR INTO l_temp_number;

Line 5410: x_return_status := FND_API.G_RET_STS_ERROR;

5406: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5407: FND_MESSAGE.Set_Token('ORG',NVL(l_dest_organization_name, p_x_mtltfr_rec.dest_org_id));
5408: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5409: FND_MSG_PUB.ADD;
5410: x_return_status := FND_API.G_RET_STS_ERROR;
5411: END IF;
5412: CLOSE LOCATOR_VALID_CUR;
5413: END IF;
5414: --Locator Validation for source

Line 5425: x_return_status := FND_API.G_RET_STS_ERROR;

5421: FND_MESSAGE.Set_Name('AHL','AHL_MM_INVALID_LOCATOR');
5422: FND_MESSAGE.Set_Token('ORG',NVL(l_src_organization_name,p_x_mtltfr_rec.source_org_id));
5423: FND_MESSAGE.Set_Token('LOC',p_x_mtltfr_rec.dest_locator_id);
5424: FND_MSG_PUB.ADD;
5425: x_return_status := FND_API.G_RET_STS_ERROR;
5426: END IF;
5427: CLOSE LOCATOR_VALID_CUR;
5428: -- Check if already reserved
5429: IF (l_log_statement >= l_log_current_level) THEN

Line 5442: x_return_status := FND_API.G_RET_STS_ERROR;

5438: END IF;
5439: FND_MESSAGE.Set_Name('AHL','AHL_MM_EXIST_RES');
5440: FND_MESSAGE.Set_Token('SER',p_x_mtltfr_rec.serial_number);
5441: FND_MSG_PUB.ADD;
5442: x_return_status := FND_API.G_RET_STS_ERROR;
5443: END IF;
5444: CLOSE RESERVATION_VALID_CUR;
5445: -- Shipping network validation
5446: IF (l_log_statement >= l_log_current_level) THEN

Line 5458: x_return_status := FND_API.G_RET_STS_ERROR;

5454: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'No shipping network between the organizations');
5455: END IF;
5456: FND_MESSAGE.Set_Name('AHL','AHL_MM_NO_SHIP_NETWORK');
5457: FND_MSG_PUB.ADD;
5458: x_return_status := FND_API.G_RET_STS_ERROR;
5459: END IF;
5460: CLOSE SHIPPING_NETWORK_CUR;
5461:
5462: -- Validate if internal order is reqd fro transfer

Line 5471: x_return_status := FND_API.G_RET_STS_ERROR;

5467: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||'Internal Order required to transfer between the organizations');
5468: END IF;
5469: FND_MESSAGE.Set_Name('AHL','AHL_MM_INTERNAL_ORD_REQD');
5470: FND_MSG_PUB.ADD;
5471: x_return_status := FND_API.G_RET_STS_ERROR;
5472: END IF;
5473: CLOSE SHIPPING_ATTRIB_CUR;
5474: --This should be the last print
5475: G_DEBUG_LINE_NUM := 410;

Line 5499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5495: -- p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec
5496: --
5497: PROCEDURE FILTER_INSTANCES_MATCHING_BG(
5498: p_api_version IN NUMBER,
5499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5500: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5501: p_module_type IN VARCHAR2,
5502: p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec,
5503: x_return_status OUT NOCOPY VARCHAR2,

Line 5500: p_commit IN VARCHAR2 := FND_API.G_FALSE,

5496: --
5497: PROCEDURE FILTER_INSTANCES_MATCHING_BG(
5498: p_api_version IN NUMBER,
5499: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5500: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5501: p_module_type IN VARCHAR2,
5502: p_demand_Record IN AHL_MM_MTL_MGT_PVT.BG_Demand_Rec,
5503: x_return_status OUT NOCOPY VARCHAR2,
5504: x_msg_count OUT NOCOPY NUMBER,

Line 5675: IF FND_API.to_boolean( p_init_msg_list ) THEN

5671: FND_LOG.string(l_log_procedure, l_debug || '.begin','At the start of PLSQL procedure');
5672: END IF;
5673:
5674: -- Initialize message list if p_init_msg_list is set to TRUE.
5675: IF FND_API.to_boolean( p_init_msg_list ) THEN
5676: FND_MSG_PUB.initialize;
5677: END IF;
5678:
5679: -- Initialize API return status to success

Line 5680: x_return_status := FND_API.G_RET_STS_SUCCESS;

5676: FND_MSG_PUB.initialize;
5677: END IF;
5678:
5679: -- Initialize API return status to success
5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681:
5682: IF (l_log_statement >= l_log_current_level) THEN
5683: FND_LOG.string(l_log_statement, l_debug, 'Scheduled_Material_ID :' || p_demand_Record.Scheduled_Material_ID);
5684: FND_LOG.string(l_log_statement, l_debug, 'Include_HardLimit_MRs :' || p_demand_Record.Include_HardLimit_MRs);

Line 5727: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5723: FND_LOG.string(l_log_statement, l_debug, 'Requirement is not position based, returning back');
5724: END IF;
5725:
5726: --Standard check for commit
5727: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5728: COMMIT;
5729: END IF;
5730:
5731: RETURN;

Line 5750: p_init_msg_list => FND_API.G_FALSE,

5746: --Call API to populate AHL_APPLICABLE_INSTANCES
5747: --SB rules are applied by this API itself
5748: AHL_UC_INSTANCE_PVT.get_instances_for_req
5749: (p_api_version => 1.0,
5750: p_init_msg_list => FND_API.G_FALSE,
5751: x_return_status => x_return_status,
5752: x_msg_count => x_msg_count,
5753: x_msg_data => x_msg_data,
5754: p_schedule_material_id => p_demand_Record.Scheduled_Material_ID,

Line 5761: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)

5757: p_organization_name => p_demand_Record.Organization_Name,
5758: p_serial_number => p_demand_Record.Serial_Number);
5759:
5760: --Write in Log and exit when return status is not success
5761: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)
5762: THEN
5763: IF (l_log_statement >= l_log_current_level) THEN
5764: FND_LOG.string(l_log_statement, l_debug,
5765: 'After calling get_instances_for_req, Return Status is :' || x_return_status);

Line 5767: RAISE FND_API.G_EXC_ERROR;

5763: IF (l_log_statement >= l_log_current_level) THEN
5764: FND_LOG.string(l_log_statement, l_debug,
5765: 'After calling get_instances_for_req, Return Status is :' || x_return_status);
5766: END IF;
5767: RAISE FND_API.G_EXC_ERROR;
5768: END IF;
5769:
5770: --Other 3 supplies
5771: ELSIF (p_module_type = 'ER' OR p_module_type = 'WO' OR p_module_type = 'CNB') THEN

Line 5778: p_init_msg_list => FND_API.G_FALSE,

5774: THEN
5775: --Primary and alterante items filter
5776: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items
5777: (p_api_version => 1.0,
5778: p_init_msg_list => FND_API.G_FALSE,
5779: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5780: p_schedule_material_id => p_demand_Record.Scheduled_Material_ID,
5781: p_curr_item_flag => FND_API.G_TRUE,
5782: x_alt_items => l_alt_items_tbl,

Line 5779: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

5775: --Primary and alterante items filter
5776: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items
5777: (p_api_version => 1.0,
5778: p_init_msg_list => FND_API.G_FALSE,
5779: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5780: p_schedule_material_id => p_demand_Record.Scheduled_Material_ID,
5781: p_curr_item_flag => FND_API.G_TRUE,
5782: x_alt_items => l_alt_items_tbl,
5783: x_return_status => x_return_status,

Line 5781: p_curr_item_flag => FND_API.G_TRUE,

5777: (p_api_version => 1.0,
5778: p_init_msg_list => FND_API.G_FALSE,
5779: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5780: p_schedule_material_id => p_demand_Record.Scheduled_Material_ID,
5781: p_curr_item_flag => FND_API.G_TRUE,
5782: x_alt_items => l_alt_items_tbl,
5783: x_return_status => x_return_status,
5784: x_msg_count => x_msg_count,
5785: x_msg_data => x_msg_data);

Line 5787: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)

5783: x_return_status => x_return_status,
5784: x_msg_count => x_msg_count,
5785: x_msg_data => x_msg_data);
5786:
5787: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)
5788: THEN
5789: IF (l_log_statement >= l_log_current_level) THEN
5790: FND_LOG.string(l_log_statement, l_debug,
5791: 'After calling Get_Alternate_Items, Return Status is :' || x_return_status

Line 5794: RAISE FND_API.G_EXC_ERROR;

5790: FND_LOG.string(l_log_statement, l_debug,
5791: 'After calling Get_Alternate_Items, Return Status is :' || x_return_status
5792: || ', l_alt_items_tbl.COUNT :' || l_alt_items_tbl.COUNT);
5793: END IF;
5794: RAISE FND_API.G_EXC_ERROR;
5795: END IF;
5796:
5797: IF(l_alt_items_tbl.COUNT > 0) THEN
5798: l_base_query := l_base_query || ' AND ITEMS.inventory_item_id IN (NULL ';

Line 5815: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5811: 'No items match SB rules, returning without populating temp table');
5812: END IF;
5813:
5814: --Standard check for commit
5815: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5816: COMMIT;
5817: END IF;
5818:
5819: RETURN;

Line 5837: p_encoded => FND_API.G_FALSE,

5833: IF (l_msg_count > 0) THEN
5834: FOR i IN 1..l_msg_count
5835: LOOP
5836: fnd_msg_pub.get( p_msg_index => i,
5837: p_encoded => FND_API.G_FALSE,
5838: p_data => l_err_msg,
5839: p_msg_index_out => l_msg_index_out);
5840:
5841: IF (l_log_statement >= l_log_current_level) THEN

Line 5854: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5850: || ' Returning back without temp table population.');
5851: END IF;
5852:
5853: --Standard check for commit
5854: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5855: COMMIT;
5856: END IF;
5857:
5858: RETURN;

Line 6106: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6102: IF (p_demand_Record.Include_HardLimit_MRs <> 'Y'
6103: AND p_demand_Record.Include_SoftLimit_MRs <> 'Y') THEN
6104:
6105: --Standard check for commit
6106: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6107: COMMIT;
6108: END IF;
6109:
6110: RETURN;

Line 6214: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6210: END LOOP; -- END l_appl_inst_tbl LOOP
6211: END IF;
6212:
6213: --Standard check for commit
6214: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6215: COMMIT;
6216: END IF;
6217:
6218: -- Count and Get messages

Line 6219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6215: COMMIT;
6216: END IF;
6217:
6218: -- Count and Get messages
6219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6220: p_count => x_msg_count,
6221: p_data => x_msg_data);
6222:
6223: IF (l_log_procedure >= l_log_current_level) THEN

Line 6228: WHEN FND_API.G_EXC_ERROR THEN

6224: FND_LOG.string(l_log_procedure, l_debug || '.end','At the end of PLSQL procedure');
6225: END IF;
6226:
6227: EXCEPTION
6228: WHEN FND_API.G_EXC_ERROR THEN
6229: ROLLBACK TO FILTER_INSTANCES_SP;
6230: x_return_status := FND_API.G_RET_STS_ERROR;
6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6232: p_count => x_msg_count,

Line 6230: x_return_status := FND_API.G_RET_STS_ERROR;

6226:
6227: EXCEPTION
6228: WHEN FND_API.G_EXC_ERROR THEN
6229: ROLLBACK TO FILTER_INSTANCES_SP;
6230: x_return_status := FND_API.G_RET_STS_ERROR;
6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6232: p_count => x_msg_count,
6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6227: EXCEPTION
6228: WHEN FND_API.G_EXC_ERROR THEN
6229: ROLLBACK TO FILTER_INSTANCES_SP;
6230: x_return_status := FND_API.G_RET_STS_ERROR;
6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6232: p_count => x_msg_count,
6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6235: ROLLBACK TO FILTER_INSTANCES_SP;

Line 6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6230: x_return_status := FND_API.G_RET_STS_ERROR;
6231: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6232: p_count => x_msg_count,
6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6235: ROLLBACK TO FILTER_INSTANCES_SP;
6236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6237: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6238: p_count => x_msg_count,

Line 6236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6232: p_count => x_msg_count,
6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6235: ROLLBACK TO FILTER_INSTANCES_SP;
6236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6237: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6238: p_count => x_msg_count,
6239: p_data => x_msg_data);
6240: WHEN OTHERS THEN

Line 6237: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6233: p_data => x_msg_data);
6234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6235: ROLLBACK TO FILTER_INSTANCES_SP;
6236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6237: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6238: p_count => x_msg_count,
6239: p_data => x_msg_data);
6240: WHEN OTHERS THEN
6241: ROLLBACK TO FILTER_INSTANCES_SP;

Line 6242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6238: p_count => x_msg_count,
6239: p_data => x_msg_data);
6240: WHEN OTHERS THEN
6241: ROLLBACK TO FILTER_INSTANCES_SP;
6242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6243: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6244: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
6245: END IF;
6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

Line 6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

6242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6243: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6244: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
6245: END IF;
6246: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
6247: p_count => x_msg_count,
6248: p_data => x_msg_data);
6249:
6250: END FILTER_INSTANCES_MATCHING_BG;

Line 6269: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

6265: -- X_Inv_Mtl_Avl_Tbl AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl
6266: --
6267: PROCEDURE GET_AVAILABLE_QUANTITY(
6268: P_API_VERSION IN NUMBER,
6269: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6270: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6271: P_MODULE_TYPE IN VARCHAR2 := NULL,
6272: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6273: P_ORG_ID NUMBER,

Line 6270: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

6266: --
6267: PROCEDURE GET_AVAILABLE_QUANTITY(
6268: P_API_VERSION IN NUMBER,
6269: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6270: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6271: P_MODULE_TYPE IN VARCHAR2 := NULL,
6272: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6273: P_ORG_ID NUMBER,
6274: P_INV_ITEM_ID NUMBER,

Line 6272: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6268: P_API_VERSION IN NUMBER,
6269: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6270: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6271: P_MODULE_TYPE IN VARCHAR2 := NULL,
6272: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6273: P_ORG_ID NUMBER,
6274: P_INV_ITEM_ID NUMBER,
6275: X_Inv_Mtl_Avl_Tbl OUT NOCOPY AHL_MM_MTL_MGT_PVT.Inv_Mtl_Avl_Tbl,
6276: x_return_status OUT NOCOPY VARCHAR2,

Line 6315: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6311: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
6312: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure GET_AVAILABLE_QUANTITY');
6313: END IF;
6314: -- Initialize API return status to success
6315: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6316: -- Standard call to check for call compatibility.
6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;

Line 6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

6313: END IF;
6314: -- Initialize API return status to success
6315: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6316: -- Standard call to check for call compatibility.
6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;
6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6314: -- Initialize API return status to success
6315: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6316: -- Standard call to check for call compatibility.
6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;
6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
6322: FND_MSG_PUB.INITIALIZE;

Line 6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

6316: -- Standard call to check for call compatibility.
6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;
6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
6322: FND_MSG_PUB.INITIALIZE;
6323: END IF;
6324: SELECT mrp_atp_schedule_temp_s.nextval INTO l_session_id FROM dual;

Line 6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;
6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE
6321: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
6322: FND_MSG_PUB.INITIALIZE;
6323: END IF;
6324: SELECT mrp_atp_schedule_temp_s.nextval INTO l_session_id FROM dual;
6325: -- Get Session ID

Line 6335: RAISE FND_API.G_EXC_ERROR;

6331: IF instance_id_cur%notfound THEN
6332: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
6333: FND_MSG_PUB.add;
6334: CLOSE Instance_Id_Cur;
6335: RAISE FND_API.G_EXC_ERROR;
6336: END IF;
6337: CLOSE instance_id_cur;
6338: OPEN item_details_cur(P_INV_ITEM_ID,P_ORG_ID);
6339: FETCH item_details_cur INTO item_details;

Line 6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6364: FND_MESSAGE.SET_TOKEN('ATP_MSG', l_error_msg);
6365: X_Inv_Mtl_Avl_Tbl(1).ERROR_MESSAGE := FND_MESSAGE.GET();
6366: END IF;
6367: -- Standard call to get message count and if count is 1, get message info
6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6369: -- Log API exit point
6370: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
6371: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.end', 'At the end of PLSQL procedure');
6372: END IF;

Line 6374: WHEN FND_API.G_EXC_ERROR THEN

6370: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
6371: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.end', 'At the end of PLSQL procedure');
6372: END IF;
6373: EXCEPTION
6374: WHEN FND_API.G_EXC_ERROR THEN
6375: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6376: x_return_status := FND_API.G_RET_STS_ERROR;

6372: END IF;
6373: EXCEPTION
6374: WHEN FND_API.G_EXC_ERROR THEN
6375: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6373: EXCEPTION
6374: WHEN FND_API.G_EXC_ERROR THEN
6375: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

Line 6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6374: WHEN FND_API.G_EXC_ERROR THEN
6375: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6382: WHEN OTHERS THEN

Line 6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6382: WHEN OTHERS THEN
6383: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6377: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6379: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6382: WHEN OTHERS THEN
6383: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6382: WHEN OTHERS THEN
6383: ROLLBACK TO GET_AVAILABLE_QUANTITY;
6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6386: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME, p_procedure_name => 'create_reservation', p_error_text => SUBSTR(SQLERRM,1,240) );
6387: END IF;
6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

Line 6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );

6384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6386: FND_MSG_PUB.add_exc_msg ( p_pkg_name => G_PKG_NAME, p_procedure_name => 'create_reservation', p_error_text => SUBSTR(SQLERRM,1,240) );
6387: END IF;
6388: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6389: END GET_AVAILABLE_QUANTITY;
6390:
6391: -- Kasridha: Changes for Marshalling Phase II Begins
6392:

Line 6406: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

6402: -- Parameters :
6403: --
6404: -- Standard IN Parameters :
6405: -- p_api_version IN NUMBER Required
6406: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6407: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6408: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6409: -- Based on this flag, the API will set the default attributes.
6410: -- p_module_type In VARCHAR2 Default NULL

Line 6407: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

6403: --
6404: -- Standard IN Parameters :
6405: -- p_api_version IN NUMBER Required
6406: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6407: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6408: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6409: -- Based on this flag, the API will set the default attributes.
6410: -- p_module_type In VARCHAR2 Default NULL
6411: -- This will be null.

Line 6408: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

6404: -- Standard IN Parameters :
6405: -- p_api_version IN NUMBER Required
6406: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6407: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6408: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6409: -- Based on this flag, the API will set the default attributes.
6410: -- p_module_type In VARCHAR2 Default NULL
6411: -- This will be null.
6412: -- Standard OUT Parameters :

Line 6423: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

6419: -- x_mtl_avl_schld_tbl OUT : Table containing output against schedule material req id
6420: --
6421: PROCEDURE SCHED_ALL_VST_MTLS(
6422: P_API_VERSION IN NUMBER,
6423: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6424: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6425: P_MODULE_TYPE IN VARCHAR2 := NULL,
6426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6427: P_VISIT_IDS AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,

Line 6424: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

6420: --
6421: PROCEDURE SCHED_ALL_VST_MTLS(
6422: P_API_VERSION IN NUMBER,
6423: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6424: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6425: P_MODULE_TYPE IN VARCHAR2 := NULL,
6426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6427: P_VISIT_IDS AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,
6428: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,

Line 6426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6422: P_API_VERSION IN NUMBER,
6423: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
6424: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
6425: P_MODULE_TYPE IN VARCHAR2 := NULL,
6426: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6427: P_VISIT_IDS AHL_MM_MTL_MGT_PVT.visit_ids_Tbl,
6428: X_MTL_AVL_SCHLD_TBL OUT NOCOPY AHL_MM_MTL_MGT_PVT.MTL_AVL_SCHLD_TBL,
6429: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6430: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 6453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6449: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure SCHEDULE_MATERIALS');
6450: END IF;
6451:
6452: -- Initialize API return status to success
6453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6454:
6455: -- Standard call to check for call compatibility.
6456: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6456: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN

6452: -- Initialize API return status to success
6453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6454:
6455: -- Standard call to check for call compatibility.
6456: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6458: END IF;
6459:
6460: L_LOOP_COUNTER := 1;

Line 6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6454:
6455: -- Standard call to check for call compatibility.
6456: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6458: END IF;
6459:
6460: L_LOOP_COUNTER := 1;
6461: FOR l_visit_id IN P_VISIT_IDS.FIRST..P_VISIT_IDS.LAST

Line 6483: WHEN FND_API.G_EXC_ERROR THEN

6479: X_MSG_COUNT => X_MSG_COUNT,
6480: X_MSG_DATA => X_MSG_DATA);
6481:
6482: EXCEPTION
6483: WHEN FND_API.G_EXC_ERROR THEN
6484: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6487: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 6485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

6481:
6482: EXCEPTION
6483: WHEN FND_API.G_EXC_ERROR THEN
6484: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6487: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

6482: EXCEPTION
6483: WHEN FND_API.G_EXC_ERROR THEN
6484: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6487: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6490: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;

Line 6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6485: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6486: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6487: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6490: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6491: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6492: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6493: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 6491: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

6487: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6490: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6491: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6492: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6493: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6494:
6495: WHEN OTHERS THEN

Line 6492: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

6488:
6489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6490: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6491: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6492: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6493: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6494:
6495: WHEN OTHERS THEN
6496: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;

Line 6497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

6493: P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
6494:
6495: WHEN OTHERS THEN
6496: ROLLBACK TO MM_SCH_ALL_VISIT_MTLS;
6497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6498: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6499: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
6500: END IF;
6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

Line 6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,

6497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
6498: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6499: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
6500: END IF;
6501: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE,
6502: P_COUNT => X_MSG_COUNT,
6503: P_DATA => X_MSG_DATA);
6504: END SCHED_ALL_VST_MTLS;
6505: -- Kasridha: Changes for Marshalling Phase II Ends