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

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: --AMSRINIV. Bug 5470730. Removing message initialization.
262: -- FND_MSG_PUB.Initialize;
263:
264: -- Initialize API return status to success
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266:
267: -- Begin Processing
268:
269: --Getting all the required values from the user hook record

Line 295: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN

291: --Validating the Request
292: --******************************
293:
294: --Raising an error if the request id null
295: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
298: FND_MSG_PUB.add;
299: RAISE FND_API.G_EXC_ERROR;

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: --******************************
293:
294: --Raising an error if the request id null
295: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
298: FND_MSG_PUB.add;
299: RAISE FND_API.G_EXC_ERROR;
300: END IF;

Line 299: RAISE FND_API.G_EXC_ERROR;

295: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
298: FND_MSG_PUB.add;
299: RAISE FND_API.G_EXC_ERROR;
300: END IF;
301:
302: --Opening cursor to validate incident id
303: OPEN validate_incident_id ( l_request_id );

Line 312: RAISE FND_API.G_EXC_ERROR;

308: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
309: fnd_message.set_token('INCIDENT_ID', l_request_id, false);
310: FND_MSG_PUB.add;
311: CLOSE validate_instance;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: CLOSE validate_incident_id;
316:

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: CLOSE validate_incident_id;
316:
317: --Validating CMRO Type. If not CMRO type, return without processing.
318: IF (nvl(l_new_type_cmro_flag, 'N') <> 'Y') THEN
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320: RETURN;
321: END IF;
322:
323: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

339: END IF;
340:
341:
342: --Set the return status to an error and raise an error message if the return status is an error.
343: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
346: FND_MSG_PUB.add;
347: RAISE FND_API.G_EXC_ERROR;

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340:
341:
342: --Set the return status to an error and raise an error message if the return status is an error.
343: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
346: FND_MSG_PUB.add;
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;

Line 347: RAISE FND_API.G_EXC_ERROR;

343: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
346: FND_MSG_PUB.add;
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;
349:
350: --Set the return status to an error and raise an error message if the application code returned is not AHL
351: IF (l_appln_code <> 'AHL') THEN

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348: END IF;
349:
350: --Set the return status to an error and raise an error message if the application code returned is not AHL
351: IF (l_appln_code <> 'AHL') THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
354: FND_MESSAGE.set_token('TASK', l_name, false);
355: FND_MSG_PUB.add;
356: RAISE FND_API.G_EXC_ERROR;

Line 356: RAISE FND_API.G_EXC_ERROR;

352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
354: FND_MESSAGE.set_token('TASK', l_name, false);
355: FND_MSG_PUB.add;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:
359: --******************************
360: --Validating the status

Line 367: RAISE FND_API.G_EXC_ERROR;

363: -- Raise an error if the status is PLANNED.
364: IF (l_status_id = G_SR_PLANNED_STATUS_ID) THEN
365: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_STATUS_CODE');
366: FND_MSG_PUB.add;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370: --******************************
371: --Validating the item instance

Line 374: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN

370: --******************************
371: --Validating the item instance
372: --******************************
373: --Raise an error if the item instance id null
374: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
377: FND_MSG_PUB.add;
378: RAISE FND_API.G_EXC_ERROR;

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: --Validating the item instance
372: --******************************
373: --Raise an error if the item instance id null
374: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
377: FND_MSG_PUB.add;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;

Line 378: RAISE FND_API.G_EXC_ERROR;

374: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
377: FND_MSG_PUB.add;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380:
381: --Ensuring that the instance exists in csi_item_instances.
382: OPEN validate_instance(l_customer_product_id);

Line 390: RAISE FND_API.G_EXC_ERROR;

386: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');
387: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);
388: FND_MSG_PUB.add;
389: CLOSE validate_instance;
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;
392:
393: --Raise an error if the instance is inactive.
394: IF ( l_active_end_date IS NOT NULL AND l_active_end_date <= SYSDATE ) THEN

Line 399: RAISE FND_API.G_EXC_ERROR;

395: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');
396: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);
397: FND_MSG_PUB.add;
398: CLOSE validate_instance;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: CLOSE validate_instance;
403:

Line 424: RAISE FND_API.G_EXC_ERROR;

420: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
421: THEN
422: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');
423: FND_MSG_PUB.ADD;
424: RAISE FND_API.G_EXC_ERROR;
425: ELSIF (l_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE'))
426: THEN
427: l_uc_hdr_id := null;
428: END IF;

Line 516: WHEN FND_API.G_EXC_ERROR THEN

512: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Create_SR_Unit_Effectivity Procedure');
513: END IF;
514:
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514:
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Msg Count:' || fnd_msg_pub.count_msg);
522: END IF;

Line 524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Msg Count:' || fnd_msg_pub.count_msg);
522: END IF;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Return Status:' || x_return_status);

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: END IF;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Return Status:' || x_return_status);
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Msg Count:' || fnd_msg_pub.count_msg);
530: END IF;

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: END IF;
531:
532: WHEN OTHERS THEN
533: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
536: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
537: p_procedure_name => 'Create_SR_Unit_Effectivity',
538: p_error_text => SUBSTR(SQLERRM,1,240));

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
590: END IF;
591:
592: -- Initialize API return status to success
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: -- Initialize message list
596: --AMSRINIV. Bug 5470730. Removing message initialization.
597: --FND_MSG_PUB.Initialize;

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

617: -- Since this is a CMRO type SR, ensure that the Application Usage profile option has been set to AHL
618: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
619: x_return_status => x_return_status);
620:
621: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
622: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
623: FND_MSG_PUB.ADD;
624: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

623: FND_MSG_PUB.ADD;
624: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
626: END IF;
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
629: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
630: FND_MSG_PUB.ADD;
631: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: FND_MSG_PUB.ADD;
631: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
632: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
633: END IF;
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSE
636: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
637: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Application Usage Profile Option Validated');
638: END IF;

Line 662: WHEN FND_API.G_EXC_ERROR THEN

658: END IF;
659:
660: EXCEPTION
661:
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO Process_SR_Updates_Pvt;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660: EXCEPTION
661:
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO Process_SR_Updates_Pvt;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO Process_SR_Updates_Pvt;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO Process_SR_Updates_Pvt;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO Process_SR_Updates_Pvt;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: WHEN OTHERS THEN

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664: x_return_status := FND_API.G_RET_STS_ERROR;
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO Process_SR_Updates_Pvt;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: WHEN OTHERS THEN
671: ROLLBACK TO Process_SR_Updates_Pvt;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: WHEN OTHERS THEN
671: ROLLBACK TO Process_SR_Updates_Pvt;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
674: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
675: p_procedure_name => 'Process_SR_Updates',
676: p_error_text => SUBSTR(SQLERRM,1,240));

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

690: -- Parameters :
691: --
692: -- Standard IN Parameters :
693: -- p_api_version IN NUMBER Required
694: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
695: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
696: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
697: --
698: -- Standard OUT Parameters :

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

691: --
692: -- Standard IN Parameters :
693: -- p_api_version IN NUMBER Required
694: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
695: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
696: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
697: --
698: -- Standard OUT Parameters :
699: -- x_return_status OUT VARCHAR2 Required

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

692: -- Standard IN Parameters :
693: -- p_api_version IN NUMBER Required
694: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
695: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
696: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
697: --
698: -- Standard OUT Parameters :
699: -- x_return_status OUT VARCHAR2 Required
700: -- x_msg_count OUT NUMBER Required

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

721:
722: PROCEDURE Process_SR_MR_Associations
723: (
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,

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

722: PROCEDURE Process_SR_MR_Associations
723: (
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,
730: x_msg_data OUT NOCOPY VARCHAR2,

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

723: (
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,
730: x_msg_data OUT NOCOPY VARCHAR2,
731: p_user_id IN NUMBER,

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

753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
754: END IF;
755:
756: -- Standard call to check for call compatibility
757: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: -- Initialize message list if p_init_msg_list is set to TRUE

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: END IF;
755:
756: -- Standard call to check for call compatibility
757: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: -- Initialize message list if p_init_msg_list is set to TRUE
762: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 762: IF FND_API.To_Boolean(p_init_msg_list) THEN

758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: -- Initialize message list if p_init_msg_list is set to TRUE
762: IF FND_API.To_Boolean(p_init_msg_list) THEN
763: FND_MSG_PUB.Initialize;
764: END IF;
765:
766: -- Initialize API return status to success

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

763: FND_MSG_PUB.Initialize;
764: END IF;
765:
766: -- Initialize API return status to success
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769: -- Begin Processing
770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Beginning Processing with p_request_id = ' || p_request_id ||

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

775: -- Check if the Application Usage profile option has been set
776: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
777: x_return_status => x_return_status);
778:
779: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
780: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
781: FND_MSG_PUB.ADD;
782: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: FND_MSG_PUB.ADD;
782: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
784: END IF;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
787: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
788: FND_MSG_PUB.ADD;
789: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: FND_MSG_PUB.ADD;
789: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
790: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
791: END IF;
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Application Usage Profile Option Validated');
796: END IF;

Line 816: RAISE FND_API.G_EXC_ERROR;

812: FND_MSG_PUB.ADD;
813: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
814: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
815: END IF;
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819: -- Validate the SR-MR Association records
820: Validate_Association_Records(p_request_id => l_request_id,

Line 827: RAISE FND_API.G_EXC_ERROR;

823: p_x_sr_mr_association_tbl => p_x_sr_mr_association_tbl);
824:
825: IF (FND_MSG_PUB.Count_Msg > 0) THEN
826: -- There are validation errors: No need to process further
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:
830:
831: -- Process all Disassociations First

Line 845: RAISE FND_API.G_EXC_ERROR;

841: p_x_sr_mr_association_tbl => p_x_sr_mr_association_tbl);
842:
843: IF (FND_MSG_PUB.Count_Msg > 0) THEN
844: -- There are validation errors from Process_New_Associations: Raise error
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847:
848: -- Standard check of p_commit
849: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 849: IF FND_API.TO_BOOLEAN(p_commit) THEN

845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847:
848: -- Standard check of p_commit
849: IF FND_API.TO_BOOLEAN(p_commit) THEN
850: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
851: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Commit.');
852: END IF;
853: COMMIT WORK;

Line 860: p_encoded => fnd_api.g_false

856: -- Standard call to get message count and if count is 1, get message info
857: FND_MSG_PUB.Count_And_Get
858: ( p_count => x_msg_count,
859: p_data => x_msg_data,
860: p_encoded => fnd_api.g_false
861: );
862:
863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 868: WHEN FND_API.G_EXC_ERROR THEN

864: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
865: END IF;
866:
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO Process_SR_MR_Associations_pvt;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
872: p_data => x_msg_data,

Line 870: x_return_status := FND_API.G_RET_STS_ERROR;

866:
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO Process_SR_MR_Associations_pvt;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
872: p_data => x_msg_data,
873: p_encoded => fnd_api.g_false);
874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

Line 873: p_encoded => fnd_api.g_false);

869: ROLLBACK TO Process_SR_MR_Associations_pvt;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
872: p_data => x_msg_data,
873: p_encoded => fnd_api.g_false);
874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
875:
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: ROLLBACK TO Process_SR_MR_Associations_pvt;

Line 876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

872: p_data => x_msg_data,
873: p_encoded => fnd_api.g_false);
874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
875:
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: ROLLBACK TO Process_SR_MR_Associations_pvt;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
880: p_data => x_msg_data,

Line 878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
875:
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: ROLLBACK TO Process_SR_MR_Associations_pvt;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
880: p_data => x_msg_data,
881: p_encoded => fnd_api.g_false);
882: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

Line 881: p_encoded => fnd_api.g_false);

877: ROLLBACK TO Process_SR_MR_Associations_pvt;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
880: p_data => x_msg_data,
881: p_encoded => fnd_api.g_false);
882: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
883:
884: WHEN OTHERS THEN
885: ROLLBACK TO Process_SR_MR_Associations_pvt;

Line 886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

882: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
883:
884: WHEN OTHERS THEN
885: ROLLBACK TO Process_SR_MR_Associations_pvt;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
888: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
889: p_procedure_name => 'Process_SR_MR_Associations',
890: p_error_text => SUBSTR(SQLERRM,1,240));

Line 894: p_encoded => fnd_api.g_false);

890: p_error_text => SUBSTR(SQLERRM,1,240));
891: END IF;
892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => fnd_api.g_false);
895: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
896:
897: END Process_SR_MR_Associations;
898:

Line 962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

958: FND_MSG_PUB.ADD;
959: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
961: END IF;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: ELSIF (p_object_version_number IS NULL) THEN
964: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_NULL');
965: FND_MSG_PUB.ADD;
966: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

965: FND_MSG_PUB.ADD;
966: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
968: END IF;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: ELSE
971: OPEN get_request_dtls_csr(p_request_id => p_x_request_id,
972: p_request_number => p_request_number,
973: p_object_version_number => p_object_version_number);

Line 988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

984: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
986: END IF;
987: CLOSE get_request_dtls_csr;
988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
989: END IF;
990: CLOSE get_request_dtls_csr;
991: END IF;
992:

Line 999: RAISE FND_API.G_EXC_ERROR;

995: FND_MSG_PUB.ADD;
996: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
998: END IF;
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001: /*
1002: Balaji commented out this cursor validation for OGMA ER : Adding MRs to Non-Routines
1003: Since as per this ER requirements, we are going to allow SR UEs to be modified and plan

Line 1014: RAISE FND_API.G_EXC_ERROR;

1010: FND_MSG_PUB.ADD;
1011: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1012: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1013: END IF;
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016: */
1017: OPEN get_ue_dtls_csr(p_request_id => p_x_request_id);
1018: FETCH get_ue_dtls_csr INTO x_sr_ue_id; -- OUT Parameter

Line 1027: RAISE FND_API.G_EXC_ERROR;

1023: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1025: END IF;
1026: CLOSE get_ue_dtls_csr;
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029: CLOSE get_ue_dtls_csr;
1030:
1031: /*

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1042: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1043: END IF;
1044: CLOSE get_tasks_for_ue_csr;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047: CLOSE get_tasks_for_ue_csr;
1048: */
1049: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1262: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1258: x_msg_data => l_temp_msg_data,
1259: p_item_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID,
1260: p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID,
1261: x_applicable_mr_tbl => l_applicable_mr_tbl);
1262: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1263: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');
1264: FND_MESSAGE.Set_Token('INDEX', i);
1265: FND_MSG_PUB.ADD;
1266: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1956: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1952: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,
1953: x_return_status => l_temp_return_status,
1954: x_msg_count => l_temp_msg_count,
1955: x_msg_data => l_temp_msg_data);
1956: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1957: p_x_valid_flag := false;
1958: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
1959: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');
1960: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);

Line 2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2420: FND_MSG_PUB.ADD;
2421: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2422: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: END IF;
2426:
2427: -- Ensure that the request id is valid
2428: OPEN check_request_exists_csr;

Line 2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2434: FND_MSG_PUB.ADD;
2435: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2436: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2437: END IF;
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2439: END IF;
2440: CLOSE check_request_exists_csr;
2441:
2442: -- If already a CMRO SR, ensure that an unit effectivity exists for the SR

Line 2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2453: END IF;
2454: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not find any valid Unit Effectivity for this CS_INCIDENT_ID: ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2456: END IF;
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF; -- UE Not Found
2459: CLOSE get_ue_dtls_csr;
2460: END IF; -- CMRO Type SR
2461:

Line 2503: RAISE FND_API.G_EXC_ERROR;

2499: FND_MSG_PUB.ADD;
2500: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2502: END IF;
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;
2505:
2506: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.new_type_cmro_flag, G_NO_FLAG) = G_NO_FLAG) THEN
2507: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2531: RAISE FND_API.G_EXC_ERROR;

2527: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
2528: FND_MSG_PUB.ADD;
2529: END IF; -- tasks found
2530: CLOSE get_tasks_for_ue_csr;
2531: RAISE FND_API.G_EXC_ERROR;
2532: ELSE
2533: -- Not yet Planned, but open
2534: -- Delete all the dependent UEs and UE relationships
2535: FOR rel_and_ue_id_rec in get_all_ue_and_rel_ids_csr LOOP

Line 2565: RAISE FND_API.G_EXC_ERROR;

2561: FND_MSG_PUB.ADD;
2562: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2564: END IF;
2565: RAISE FND_API.G_EXC_ERROR;
2566: ELSE
2567: -- Not yet Planned, but open: Call Create_SR_Init_Effectivity
2568: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call Create_SR_Unit_Effectivity.');

Line 2575: IF (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2571: Create_SR_Unit_Effectivity(x_return_status => l_temp_return_status);
2572: /* For Testing
2573: UMP_SR_TEST.Create_SR_Unit_Effectivity(x_return_status => l_temp_return_status);
2574: */
2575: IF (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2576: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Success.');
2578: END IF;
2579: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2579: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

2575: IF (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2576: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Success.');
2578: END IF;
2579: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN
2580: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned User Error.');
2582: END IF;
2583: RAISE FND_API.G_EXC_ERROR;

Line 2583: RAISE FND_API.G_EXC_ERROR;

2579: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN
2580: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned User Error.');
2582: END IF;
2583: RAISE FND_API.G_EXC_ERROR;
2584: ELSE
2585: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Unexpected Error.');
2587: END IF;

Line 2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2584: ELSE
2585: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Unexpected Error.');
2587: END IF;
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: END IF;
2590: END IF; -- Planned or not
2591: END IF; -- CMRO to Non-CMRO or vice-versa
2592:

Line 2664: RAISE FND_API.G_EXC_ERROR;

2660: END IF;
2661:
2662: IF (l_valid_flag = false) THEN
2663: -- At least one Validation has failed: No need to do any further processing
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666:
2667: IF (l_instance_changed = true OR l_status_changed = true OR l_due_date_changed = true) THEN
2668: -- Apply changes to the SR Unit Effectivity

Line 3070: p_init_msg_list => FND_API.G_FALSE,

3066: -- Update the workorders
3067: AHL_PRD_WORKORDER_PVT.Process_Jobs
3068: (
3069: p_api_version => 1.0,
3070: p_init_msg_list => FND_API.G_FALSE,
3071: p_commit => FND_API.G_FALSE,
3072: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3073: p_default => FND_API.G_TRUE,
3074: p_module_type => 'API',

Line 3071: p_commit => FND_API.G_FALSE,

3067: AHL_PRD_WORKORDER_PVT.Process_Jobs
3068: (
3069: p_api_version => 1.0,
3070: p_init_msg_list => FND_API.G_FALSE,
3071: p_commit => FND_API.G_FALSE,
3072: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3073: p_default => FND_API.G_TRUE,
3074: p_module_type => 'API',
3075: x_return_status => l_return_status,

Line 3072: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3068: (
3069: p_api_version => 1.0,
3070: p_init_msg_list => FND_API.G_FALSE,
3071: p_commit => FND_API.G_FALSE,
3072: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3073: p_default => FND_API.G_TRUE,
3074: p_module_type => 'API',
3075: x_return_status => l_return_status,
3076: x_msg_count => l_msg_count,

Line 3073: p_default => FND_API.G_TRUE,

3069: p_api_version => 1.0,
3070: p_init_msg_list => FND_API.G_FALSE,
3071: p_commit => FND_API.G_FALSE,
3072: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3073: p_default => FND_API.G_TRUE,
3074: p_module_type => 'API',
3075: x_return_status => l_return_status,
3076: x_msg_count => l_msg_count,
3077: x_msg_data => l_msg_data,

Line 3082: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3078: p_x_prd_workorder_tbl => l_prd_workorder_tbl,
3079: p_prd_workorder_rel_tbl=> l_prd_workorder_rel_tbl
3080: );
3081:
3082: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3083: THEN
3084: RAISE FND_API.G_EXC_ERROR;
3085: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 3084: RAISE FND_API.G_EXC_ERROR;

3080: );
3081:
3082: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3083: THEN
3084: RAISE FND_API.G_EXC_ERROR;
3085: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3087: END IF;
3088: END IF;