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_CANNIBALIZATION_PVT dependencies on FND_API

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

11: -- Parameters :
12: --
13: -- Standard IN Parameters :
14: -- p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
18: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
19: -- p_module_type IN VARCHAR2 Default NULL.

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

12: --
13: -- Standard IN Parameters :
14: -- p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
18: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
19: -- p_module_type IN VARCHAR2 Default NULL.
20: --

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

13: -- Standard IN Parameters :
14: -- p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
18: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
19: -- p_module_type IN VARCHAR2 Default NULL.
20: --
21: -- Standard OUT Parameters :

Line 18: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

14: -- p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
18: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
19: -- p_module_type IN VARCHAR2 Default NULL.
20: --
21: -- Standard OUT Parameters :
22: -- x_return_status OUT VARCHAR2 Required

Line 45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

41:
42: PROCEDURE process_cannibalization
43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_module_type IN VARCHAR2,
49: x_return_status OUT NOCOPY VARCHAR2,

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

42: PROCEDURE process_cannibalization
43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_module_type IN VARCHAR2,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,

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

43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48: p_module_type IN VARCHAR2,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144:
145: SAVEPOINT sp_process_cannibalization;
146:
147: -- Initialize API return status to success
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: -- Enable Debug.
151: IF (G_DEBUG = 'Y') THEN
152: AHL_DEBUG_PUB.enable_debug;

Line 155: IF FND_API.to_boolean(p_init_msg_list)

151: IF (G_DEBUG = 'Y') THEN
152: AHL_DEBUG_PUB.enable_debug;
153: END IF;
154: -- Initilaize message list
155: IF FND_API.to_boolean(p_init_msg_list)
156: THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159:

Line 165: RAISE FND_API.G_EXC_ERROR;

161: IF (NOT FND_FUNCTION.TEST('AHL_MM_CANNIBALIZATION_USER'))
162: THEN
163: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CAN_NOT_AUTH_USER' );
164: FND_MSG_PUB.ADD;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:
168: -- Print the All the input parameters
169: IF G_DEBUG = 'Y' THEN

Line 264: RAISE FND_API.G_EXC_ERROR;

260:
261: -- Raise an Exception if any of the input is Invalid
262: IF(l_input_valid)
263: THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: -- Nonroutine --- ONE
268: -- Intialize the input paramaters for NR WO Creation

Line 288: p_init_msg_list => Fnd_Api.g_false,

284: -- Call Create Non-routine Workorder for Supply WO
285: create_nr_workorder
286: (
287: p_api_version => 1.0,
288: p_init_msg_list => Fnd_Api.g_false,
289: p_commit => Fnd_Api.g_false,
290: p_validation_level => p_validation_level,
291: p_module_type => 'API',
292: x_return_status => l_return_status,

Line 289: p_commit => Fnd_Api.g_false,

285: create_nr_workorder
286: (
287: p_api_version => 1.0,
288: p_init_msg_list => Fnd_Api.g_false,
289: p_commit => Fnd_Api.g_false,
290: p_validation_level => p_validation_level,
291: p_module_type => 'API',
292: x_return_status => l_return_status,
293: x_msg_count => l_msg_count,

Line 306: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

302: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::l_return_status::'||l_return_status );
303: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_cannibalization_sr_rec.incident_id );
304: END IF;
305:
306: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: x_msg_count := l_msg_count;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: END IF;
305:
306: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: x_msg_count := l_msg_count;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: -- Call the Workflow notification Non-routine created for cannibalization

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305:
306: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: x_msg_count := l_msg_count;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: -- Call the Workflow notification Non-routine created for cannibalization
313: Launch_NR_Notification (

Line 316: p_commit => FND_API.G_FALSE,

312: -- Call the Workflow notification Non-routine created for cannibalization
313: Launch_NR_Notification (
314: p_sr_incident_id => l_cannibalization_sr_rec.incident_id,
315: p_sr_profile_name => 'CANN',
316: p_commit => FND_API.G_FALSE,
317: p_wf_sr_obj => 'MCAN',
318: p_wf_sr_sbj => 'AHL_MM_CN_NR_CRT' ,
319: x_item_key => l_item_key,
320: x_return_status => l_return_status

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: THEN
334: IF (G_DEBUG = 'Y' ) THEN
335: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Supply Non-routine Workorder is not created' );
336: END IF;
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: CLOSE get_wo_det;
340:
341: -- CALL WO to WO Reservation API

Line 363: p_init_msg_list => Fnd_Api.g_false,

359:
360: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION
361: (
362: p_api_version => 1.0,
363: p_init_msg_list => Fnd_Api.g_false,
364: p_commit => Fnd_Api.g_false,
365: p_validation_level => p_validation_level, -- the validation level
366: p_module_type => 'OAF',
367: x_return_status => l_return_status,

Line 364: p_commit => Fnd_Api.g_false,

360: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION
361: (
362: p_api_version => 1.0,
363: p_init_msg_list => Fnd_Api.g_false,
364: p_commit => Fnd_Api.g_false,
365: p_validation_level => p_validation_level, -- the validation level
366: p_module_type => 'OAF',
367: x_return_status => l_return_status,
368: x_msg_count => l_msg_count,

Line 380: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

376: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling ahl_mm_reservations_pvt.create_reservation::l_return_status::'||l_return_status );
377: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.Reservation ID::'||l_reservation_id );
378: END IF;
379:
380: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
381: x_msg_count := l_msg_count;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

378: END IF;
379:
380: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
381: x_msg_count := l_msg_count;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:
386: p_cannibalization_rec.reservation_id := l_reservation_id;

Line 383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

379:
380: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
381: x_msg_count := l_msg_count;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:
386: p_cannibalization_rec.reservation_id := l_reservation_id;
387:

Line 407: p_init_msg_list => Fnd_Api.g_false,

403:
404: create_nr_workorder
405: (
406: p_api_version => 1.0,
407: p_init_msg_list => Fnd_Api.g_false,
408: p_commit => Fnd_Api.g_false,
409: p_validation_level => p_validation_level,
410: p_module_type => 'API',
411: x_return_status => l_return_status,

Line 408: p_commit => Fnd_Api.g_false,

404: create_nr_workorder
405: (
406: p_api_version => 1.0,
407: p_init_msg_list => Fnd_Api.g_false,
408: p_commit => Fnd_Api.g_false,
409: p_validation_level => p_validation_level,
410: p_module_type => 'API',
411: x_return_status => l_return_status,
412: x_msg_count => l_msg_count,

Line 425: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

421: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for Replace cannibalization::l_return_status::'||l_return_status );
422: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling create_nr_workorder for cannibalization::SR_ID::'||l_rep_cannibalization_sr_rec.incident_id );
423: END IF;
424:
425: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
426: x_msg_count := l_msg_count;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: END IF;

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: END IF;
424:
425: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
426: x_msg_count := l_msg_count;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: END IF;
430:
431: -- Call the Workflow notification Non-routine created for Replace cannibalization

Line 428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

424:
425: IF l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
426: x_msg_count := l_msg_count;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: END IF;
430:
431: -- Call the Workflow notification Non-routine created for Replace cannibalization
432: Launch_NR_Notification (

Line 435: p_commit => FND_API.G_FALSE,

431: -- Call the Workflow notification Non-routine created for Replace cannibalization
432: Launch_NR_Notification (
433: p_sr_incident_id => l_rep_cannibalization_sr_rec.incident_id,
434: p_sr_profile_name => 'REP_CAN',
435: p_commit => FND_API.G_FALSE,
436: p_wf_sr_obj => 'MRCAN' ,
437: p_wf_sr_sbj => 'AHL_MM_CN_NR_CRT_REP',
438: x_item_key => l_item_key,
439: x_return_status => l_return_status

Line 455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

451: THEN
452: IF (G_DEBUG = 'Y' ) THEN
453: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Replacement Non-routine Workorder is not created' );
454: END IF;
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457: CLOSE get_wo_det;
458:
459: IF G_DEBUG = 'Y' THEN

Line 503: p_init_msg_list => Fnd_Api.g_false,

499:
500: AHL_PP_MATERIALS_PVT.Process_Material_Request
501: (
502: p_api_version => 1.0,
503: p_init_msg_list => Fnd_Api.g_false,
504: p_commit => Fnd_Api.g_false,
505: p_validation_level => p_validation_level,
506: p_module_type => 'API',
507: p_x_req_material_tbl => l_rep_can_mat_req_tab,

Line 504: p_commit => Fnd_Api.g_false,

500: AHL_PP_MATERIALS_PVT.Process_Material_Request
501: (
502: p_api_version => 1.0,
503: p_init_msg_list => Fnd_Api.g_false,
504: p_commit => Fnd_Api.g_false,
505: p_validation_level => p_validation_level,
506: p_module_type => 'API',
507: p_x_req_material_tbl => l_rep_can_mat_req_tab,
508: x_return_status => l_return_status,

Line 517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

513: IF G_DEBUG = 'Y' THEN
514: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After Calling AHL_PP_MATERIALS_PVT.Process_Material_Request for Replace cannibalization' );
515: END IF;
516:
517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
518: x_msg_count := l_msg_count;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: END IF;
516:
517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
518: x_msg_count := l_msg_count;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: -- Commit if p_commit = FND_API.G_TRUE

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516:
517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
518: x_msg_count := l_msg_count;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: -- Commit if p_commit = FND_API.G_TRUE
524: IF FND_API.TO_BOOLEAN(p_commit)

Line 523: -- Commit if p_commit = FND_API.G_TRUE

519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: -- Commit if p_commit = FND_API.G_TRUE
524: IF FND_API.TO_BOOLEAN(p_commit)
525: THEN
526: COMMIT WORK;
527: IF G_DEBUG = 'Y' THEN

Line 524: IF FND_API.TO_BOOLEAN(p_commit)

520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: -- Commit if p_commit = FND_API.G_TRUE
524: IF FND_API.TO_BOOLEAN(p_commit)
525: THEN
526: COMMIT WORK;
527: IF G_DEBUG = 'Y' THEN
528: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Commited all the work' );

Line 534: WHEN FND_API.G_EXC_ERROR THEN

530: END IF;
531:
532:
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: Rollback to sp_process_cannibalization;
537: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
538: p_data => x_msg_data,

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531:
532:
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: Rollback to sp_process_cannibalization;
537: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);

Line 539: p_encoded => fnd_api.g_false);

535: x_return_status := FND_API.G_RET_STS_ERROR;
536: Rollback to sp_process_cannibalization;
537: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: Rollback to sp_process_cannibalization;

Line 541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

537: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: Rollback to sp_process_cannibalization;
544: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
545: p_data => x_msg_data,

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: Rollback to sp_process_cannibalization;
544: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => fnd_api.g_false);

Line 546: p_encoded => fnd_api.g_false);

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: Rollback to sp_process_cannibalization;
544: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => fnd_api.g_false);
547:
548: WHEN OTHERS THEN
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: Rollback to sp_process_cannibalization;

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: p_data => x_msg_data,
546: p_encoded => fnd_api.g_false);
547:
548: WHEN OTHERS THEN
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: Rollback to sp_process_cannibalization;
551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
553: p_procedure_name => 'process_cannibalization',

Line 558: p_encoded => fnd_api.g_false);

554: p_error_text => SUBSTR(SQLERRM,1,240));
555: END IF;
556: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
557: p_data => x_msg_data,
558: p_encoded => fnd_api.g_false);
559:
560: END process_cannibalization;
561:
562:

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

567: -- Parameters :
568: --
569: -- Standard IN Parameters :
570: -- p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
572: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
573: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
574: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
575: -- p_module_type IN VARCHAR2 Default NULL.

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

568: --
569: -- Standard IN Parameters :
570: -- p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
572: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
573: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
574: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
575: -- p_module_type IN VARCHAR2 Default NULL.
576: --

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

569: -- Standard IN Parameters :
570: -- p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
572: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
573: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
574: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
575: -- p_module_type IN VARCHAR2 Default NULL.
576: --
577: -- Standard OUT Parameters :

Line 574: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

570: -- p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
572: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
573: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
574: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
575: -- p_module_type IN VARCHAR2 Default NULL.
576: --
577: -- Standard OUT Parameters :
578: -- x_return_status OUT VARCHAR2 Required

Line 597: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

593: -------------------------------------------------------------------
594:
595: PROCEDURE create_nr_workorder (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
598: p_commit IN VARCHAR2 := Fnd_Api.g_false,
599: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
600: p_module_type IN VARCHAR2 := 'API',
601: x_return_status OUT NOCOPY VARCHAR2,

Line 598: p_commit IN VARCHAR2 := Fnd_Api.g_false,

594:
595: PROCEDURE create_nr_workorder (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
598: p_commit IN VARCHAR2 := Fnd_Api.g_false,
599: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
600: p_module_type IN VARCHAR2 := 'API',
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,

Line 599: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

595: PROCEDURE create_nr_workorder (
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
598: p_commit IN VARCHAR2 := Fnd_Api.g_false,
599: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
600: p_module_type IN VARCHAR2 := 'API',
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2,

Line 675: x_return_status := FND_API.G_RET_STS_SUCCESS;

671:
672: SAVEPOINT sp_create_nr_workorder;
673:
674: -- Initialize API return status to success
675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676:
677: IF G_DEBUG = 'Y' THEN
678: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
679: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || p_x_sr_task_rec.instance_id ||'::severity_id::'|| p_x_sr_task_rec.severity_id);

Line 685: IF FND_API.to_boolean(p_init_msg_list)

681: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Type_id::'||p_x_sr_task_rec.Type_id);
682: END IF;
683:
684: -- Initilaize message list
685: IF FND_API.to_boolean(p_init_msg_list)
686: THEN
687: FND_MSG_PUB.initialize;
688: END IF;
689:

Line 694: p_init_msg_list => FND_API.G_FALSE,

690: -- STEP 1: Call SR API to create Non-routine.
691: AHL_UMP_NONROUTINES_PVT.Create_SR
692: (
693: p_api_version => 1.0,
694: p_init_msg_list => FND_API.G_FALSE,
695: p_commit => FND_API.G_FALSE,
696: p_validation_level => p_validation_level,
697: p_module_type => p_module_type,
698: p_default => FND_API.G_FALSE,

Line 695: p_commit => FND_API.G_FALSE,

691: AHL_UMP_NONROUTINES_PVT.Create_SR
692: (
693: p_api_version => 1.0,
694: p_init_msg_list => FND_API.G_FALSE,
695: p_commit => FND_API.G_FALSE,
696: p_validation_level => p_validation_level,
697: p_module_type => p_module_type,
698: p_default => FND_API.G_FALSE,
699: x_return_status => l_return_status,

Line 698: p_default => FND_API.G_FALSE,

694: p_init_msg_list => FND_API.G_FALSE,
695: p_commit => FND_API.G_FALSE,
696: p_validation_level => p_validation_level,
697: p_module_type => p_module_type,
698: p_default => FND_API.G_FALSE,
699: x_return_status => l_return_status,
700: x_msg_count => l_msg_count,
701: x_msg_data => l_msg_data,
702: p_x_nonroutine_rec => p_x_sr_task_rec

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

701: x_msg_data => l_msg_data,
702: p_x_nonroutine_rec => p_x_sr_task_rec
703: ) ;
704:
705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
706: x_msg_count := l_msg_count;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:

Line 707: RAISE FND_API.G_EXC_ERROR;

703: ) ;
704:
705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
706: x_msg_count := l_msg_count;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710: IF G_DEBUG = 'Y' THEN
711: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After calling AHL_UMP_NONROUTINES_PVT.Create_SR::l_return_status:: '||l_return_status);

Line 723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

719: THEN
720: IF G_DEBUG = 'Y' THEN
721: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request is not created');
722: END IF;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725: CLOSE c_get_ue_id;
726:
727: l_create_task_tbl(1).originating_task_id := p_orig_task_id;

Line 744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

740: THEN
741: IF G_DEBUG = 'Y' THEN
742: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Request is not created');
743: END IF;
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746: CLOSE C_VISIT_START_DATE;
747: IF(SYSDATE < L_VISIT_DATE) THEN
748: L_CREATE_TASK_TBL(1).TASK_START_DATE := L_VISIT_DATE;

Line 769: p_init_msg_list => FND_API.G_FALSE,

765:
766: -- STEP 2: Call VWP API to create tasks for Non-routine.
767: AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS(
768: p_api_version => 1.0,
769: p_init_msg_list => FND_API.G_FALSE,
770: p_module_type => 'SR',
771: p_x_task_tbl => l_create_task_tbl,
772: x_return_status => l_return_status,
773: x_msg_count => l_msg_count,

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

777: IF G_DEBUG = 'Y' THEN
778: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS::Return Status::'||l_return_status );
779: END IF;
780:
781: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
782: x_msg_count := l_msg_count;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:

Line 783: RAISE FND_API.G_EXC_ERROR;

779: END IF;
780:
781: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
782: x_msg_count := l_msg_count;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:
786: IF G_DEBUG = 'Y' THEN
787: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply...' );

Line 817: p_init_msg_list => FND_API.G_FALSE,

813:
814: AHL_VWP_RULES_PVT.Add_Return_To_Supply
815: (
816: p_api_version => 1.0,
817: p_init_msg_list => FND_API.G_FALSE,
818: p_commit => FND_API.G_FALSE,
819: p_validation_level => p_validation_level,
820: p_task_tbl_type =>l_upd_rts_task_tbl,
821: x_return_status => l_return_status,

Line 818: p_commit => FND_API.G_FALSE,

814: AHL_VWP_RULES_PVT.Add_Return_To_Supply
815: (
816: p_api_version => 1.0,
817: p_init_msg_list => FND_API.G_FALSE,
818: p_commit => FND_API.G_FALSE,
819: p_validation_level => p_validation_level,
820: p_task_tbl_type =>l_upd_rts_task_tbl,
821: x_return_status => l_return_status,
822: x_msg_count => l_msg_count,

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

826: IF G_DEBUG = 'Y' THEN
827: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.After calling AHL_VWP_TASKS_PVT.Add_Return_To_Supply::Return Status::'||l_return_status );
828: END IF;
829:
830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
831: x_msg_count := l_msg_count;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: END IF;

Line 832: RAISE FND_API.G_EXC_ERROR;

828: END IF;
829:
830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
831: x_msg_count := l_msg_count;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: END IF;
835:
836:

Line 845: p_init_msg_list => FND_API.G_FALSE,

841: END IF;
842:
843: AHL_VWP_PROJ_PROD_PVT.Release_MR(
844: p_api_version => 1.0,
845: p_init_msg_list => FND_API.G_FALSE,
846: p_commit => FND_API.G_FALSE,
847: p_validation_level => p_validation_level,
848: p_module_type => 'SR',
849: p_visit_id => p_visit_id,

Line 846: p_commit => FND_API.G_FALSE,

842:
843: AHL_VWP_PROJ_PROD_PVT.Release_MR(
844: p_api_version => 1.0,
845: p_init_msg_list => FND_API.G_FALSE,
846: p_commit => FND_API.G_FALSE,
847: p_validation_level => p_validation_level,
848: p_module_type => 'SR',
849: p_visit_id => p_visit_id,
850: p_unit_effectivity_id => l_unit_effectivity_id,

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

860: IF G_DEBUG = 'Y' THEN
861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ::'||l_return_status);
862: END IF;
863:
864: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
865: x_msg_count := l_msg_count;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:

Line 866: RAISE FND_API.G_EXC_ERROR;

862: END IF;
863:
864: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
865: x_msg_count := l_msg_count;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:
869: -- STEP 4: Call the AHL_PRD_WORKORDER_PVT.update_job API to mark WO as AOG
870:

Line 901: p_init_msg_list => FND_API.G_FALSE,

897:
898: AHL_PRD_WORKORDER_PVT.update_job
899: (
900: p_api_version => 1.0,
901: p_init_msg_list => FND_API.G_FALSE,
902: p_commit => FND_API.G_FALSE,
903: p_validation_level => p_validation_level,
904: p_default => FND_API.G_FALSE,
905: p_module_type => 'SR',

Line 902: p_commit => FND_API.G_FALSE,

898: AHL_PRD_WORKORDER_PVT.update_job
899: (
900: p_api_version => 1.0,
901: p_init_msg_list => FND_API.G_FALSE,
902: p_commit => FND_API.G_FALSE,
903: p_validation_level => p_validation_level,
904: p_default => FND_API.G_FALSE,
905: p_module_type => 'SR',
906: x_return_status => l_return_status,

Line 904: p_default => FND_API.G_FALSE,

900: p_api_version => 1.0,
901: p_init_msg_list => FND_API.G_FALSE,
902: p_commit => FND_API.G_FALSE,
903: p_validation_level => p_validation_level,
904: p_default => FND_API.G_FALSE,
905: p_module_type => 'SR',
906: x_return_status => l_return_status,
907: x_msg_count => l_msg_count,
908: x_msg_data => l_msg_data,

Line 918: -- Commit if p_commit = FND_API.G_TRUE

914: IF G_DEBUG = 'Y' THEN
915: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );
916: END IF;
917:
918: -- Commit if p_commit = FND_API.G_TRUE
919: IF FND_API.TO_BOOLEAN(p_commit)
920: THEN
921: COMMIT WORK;
922: END IF;

Line 919: IF FND_API.TO_BOOLEAN(p_commit)

915: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );
916: END IF;
917:
918: -- Commit if p_commit = FND_API.G_TRUE
919: IF FND_API.TO_BOOLEAN(p_commit)
920: THEN
921: COMMIT WORK;
922: END IF;
923:

Line 925: WHEN FND_API.G_EXC_ERROR THEN

921: COMMIT WORK;
922: END IF;
923:
924: EXCEPTION
925: WHEN FND_API.G_EXC_ERROR THEN
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: Rollback to sp_create_nr_workorder;
928: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
929: p_data => x_msg_data,

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922: END IF;
923:
924: EXCEPTION
925: WHEN FND_API.G_EXC_ERROR THEN
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: Rollback to sp_create_nr_workorder;
928: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
929: p_data => x_msg_data,
930: p_encoded => fnd_api.g_false);

Line 930: p_encoded => fnd_api.g_false);

926: x_return_status := FND_API.G_RET_STS_ERROR;
927: Rollback to sp_create_nr_workorder;
928: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
929: p_data => x_msg_data,
930: p_encoded => fnd_api.g_false);
931:
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

929: p_data => x_msg_data,
930: p_encoded => fnd_api.g_false);
931:
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: Rollback to sp_create_nr_workorder;
936: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
937: p_data => x_msg_data,

Line 934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

930: p_encoded => fnd_api.g_false);
931:
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: Rollback to sp_create_nr_workorder;
936: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
937: p_data => x_msg_data,
938: p_encoded => fnd_api.g_false);

Line 938: p_encoded => fnd_api.g_false);

934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: Rollback to sp_create_nr_workorder;
936: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
937: p_data => x_msg_data,
938: p_encoded => fnd_api.g_false);
939:
940: WHEN OTHERS THEN
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
942: Rollback to sp_create_nr_workorder;

Line 941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

937: p_data => x_msg_data,
938: p_encoded => fnd_api.g_false);
939:
940: WHEN OTHERS THEN
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
942: Rollback to sp_create_nr_workorder;
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
944: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
945: p_procedure_name => 'create_nr_workorder',

Line 950: p_encoded => fnd_api.g_false);

946: p_error_text => SUBSTR(SQLERRM,1,240));
947: END IF;
948: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
949: p_data => x_msg_data,
950: p_encoded => fnd_api.g_false);
951:
952: END create_nr_workorder;
953:
954:

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

961: ------------------------------------------------------------------------------------
962: PROCEDURE Launch_NR_Notification (
963: p_sr_incident_id IN NUMBER,
964: p_sr_profile_name IN VARCHAR2,
965: p_commit IN VARCHAR2 := FND_API.G_FALSE,
966: p_wf_sr_obj IN VARCHAR2 ,
967: p_wf_sr_sbj IN VARCHAR2 ,
968: x_item_key OUT NOCOPY VARCHAR2,
969: x_return_status OUT NOCOPY VARCHAR2

Line 995: x_return_status := FND_API.G_RET_STS_SUCCESS;

991: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::.Begin of the API');
992: END IF;
993:
994: -- initialize procedure return status to success
995: x_return_status := FND_API.G_RET_STS_SUCCESS;
996:
997: IF (G_DEBUG = 'Y') THEN
998: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':arguments: '||
999: ' p_sr_incident_id > '||p_sr_incident_id||

Line 1008: x_return_status := FND_API.G_RET_STS_ERROR;

1004: END IF;
1005:
1006: -- check for the entitlement id
1007: IF (p_sr_incident_id IS NULL) THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MM_CN_SR_ID_NULL');
1010: FND_MSG_PUB.ADD;
1011: RETURN;
1012: END IF;

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

1029: ', x_return_status > '||x_return_status);
1030: END IF;
1031:
1032: -- if returned with error, don't proceed any further
1033: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1034: RETURN;
1035: END IF;
1036:
1037: -- if the mapping is active, call the notification API

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

1073: ', x_return_status > '||x_return_status);
1074: END IF;
1075:
1076: -- if returned with error, don't proceed any further
1077: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1078: RETURN;
1079: END IF;
1080: END IF;
1081:

Line 1083: IF FND_API.TO_BOOLEAN(p_commit) THEN

1079: END IF;
1080: END IF;
1081:
1082: -- Standard check of p_commit
1083: IF FND_API.TO_BOOLEAN(p_commit) THEN
1084: COMMIT WORK;
1085: END IF;
1086:
1087: IF (G_DEBUG = 'Y') THEN