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 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: --AMSRINIV. Bug 5470730. Removing message initialization.
279: -- FND_MSG_PUB.Initialize;
280:
281: -- Initialize API return status to success
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: -- Begin Processing
285:
286: --Getting all the required values from the user hook record

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

309: --Validating the Request
310: --******************************
311:
312: --Raising an error if the request id null
313: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
316: FND_MSG_PUB.add;
317: RAISE FND_API.G_EXC_ERROR;

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: --******************************
311:
312: --Raising an error if the request id null
313: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
316: FND_MSG_PUB.add;
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;

Line 317: RAISE FND_API.G_EXC_ERROR;

313: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
316: FND_MSG_PUB.add;
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319:
320: --Opening cursor to validate incident id
321: OPEN validate_incident_id ( l_request_id );

Line 330: RAISE FND_API.G_EXC_ERROR;

326: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
327: fnd_message.set_token('INCIDENT_ID', l_request_id, false);
328: FND_MSG_PUB.add;
329: CLOSE validate_instance;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: CLOSE validate_incident_id;
334:

Line 337: x_return_status := FND_API.G_RET_STS_SUCCESS;

333: CLOSE validate_incident_id;
334:
335: --Validating CMRO Type. If not CMRO type, return without processing.
336: IF (nvl(l_new_type_cmro_flag, 'N') <> 'Y') THEN
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338: RETURN;
339: END IF;
340:
341: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

357: END IF;
358:
359:
360: --Set the return status to an error and raise an error message if the return status is an error.
361: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
364: FND_MSG_PUB.add;
365: RAISE FND_API.G_EXC_ERROR;

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358:
359:
360: --Set the return status to an error and raise an error message if the return status is an error.
361: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
364: FND_MSG_PUB.add;
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;

Line 365: RAISE FND_API.G_EXC_ERROR;

361: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
364: FND_MSG_PUB.add;
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:
368: --Set the return status to an error and raise an error message if the application code returned is not AHL
369: IF (l_appln_code <> 'AHL') THEN

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366: END IF;
367:
368: --Set the return status to an error and raise an error message if the application code returned is not AHL
369: IF (l_appln_code <> 'AHL') THEN
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
372: FND_MESSAGE.set_token('TASK', l_name, false);
373: FND_MSG_PUB.add;
374: RAISE FND_API.G_EXC_ERROR;

Line 374: RAISE FND_API.G_EXC_ERROR;

370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
372: FND_MESSAGE.set_token('TASK', l_name, false);
373: FND_MSG_PUB.add;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376:
377: --******************************
378: --Validating the status

Line 385: RAISE FND_API.G_EXC_ERROR;

381: -- Raise an error if the status is PLANNED.
382: IF (l_status_id = G_SR_PLANNED_STATUS_ID) THEN
383: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_STATUS_CODE');
384: FND_MSG_PUB.add;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: --******************************
389: --Validating the item instance

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

388: --******************************
389: --Validating the item instance
390: --******************************
391: --Raise an error if the item instance id null
392: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
395: FND_MSG_PUB.add;
396: RAISE FND_API.G_EXC_ERROR;

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389: --Validating the item instance
390: --******************************
391: --Raise an error if the item instance id null
392: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
395: FND_MSG_PUB.add;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;

Line 396: RAISE FND_API.G_EXC_ERROR;

392: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
395: FND_MSG_PUB.add;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398:
399: --Ensuring that the instance exists in csi_item_instances.
400: OPEN validate_instance(l_customer_product_id);

Line 408: RAISE FND_API.G_EXC_ERROR;

404: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');
405: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);
406: FND_MSG_PUB.add;
407: CLOSE validate_instance;
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410:
411: --Raise an error if the instance is inactive.
412: IF ( l_active_end_date IS NOT NULL AND l_active_end_date <= SYSDATE ) THEN

Line 417: RAISE FND_API.G_EXC_ERROR;

413: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');
414: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);
415: FND_MSG_PUB.add;
416: CLOSE validate_instance;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: CLOSE validate_instance;
421:

Line 442: RAISE FND_API.G_EXC_ERROR;

438: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
439: THEN
440: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');
441: FND_MSG_PUB.ADD;
442: RAISE FND_API.G_EXC_ERROR;
443: ELSIF (l_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE'))
444: THEN
445: l_uc_hdr_id := null;
446: END IF;

Line 547: WHEN FND_API.G_EXC_ERROR THEN

543: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Create_SR_Unit_Effectivity Procedure');
544: END IF;
545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);
552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Msg Count:' || fnd_msg_pub.count_msg);
553: END IF;

Line 555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);
552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Msg Count:' || fnd_msg_pub.count_msg);
553: END IF;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Return Status:' || x_return_status);

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: END IF;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Return Status:' || x_return_status);
560: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Msg Count:' || fnd_msg_pub.count_msg);
561: END IF;

Line 565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

561: END IF;
562:
563: WHEN OTHERS THEN
564: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
567: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
568: p_procedure_name => 'Create_SR_Unit_Effectivity',
569: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 625: x_return_status := FND_API.G_RET_STS_SUCCESS;

621: ', exp_resolution_date = ' || CS_SERVICEREQUEST_PVT.user_hooks_rec.exp_resolution_date);
622: END IF;
623:
624: -- Initialize API return status to success
625: x_return_status := FND_API.G_RET_STS_SUCCESS;
626:
627: -- Initialize message list
628: --AMSRINIV. Bug 5470730. Removing message initialization.
629: --FND_MSG_PUB.Initialize;

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

649: -- Since this is a CMRO type SR, ensure that the Application Usage profile option has been set to AHL
650: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
651: x_return_status => x_return_status);
652:
653: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
654: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
655: FND_MSG_PUB.ADD;
656: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

655: FND_MSG_PUB.ADD;
656: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
658: END IF;
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
661: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
662: FND_MSG_PUB.ADD;
663: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: FND_MSG_PUB.ADD;
663: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
664: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
665: END IF;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: ELSE
668: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Application Usage Profile Option Validated');
670: END IF;

Line 696: WHEN FND_API.G_EXC_ERROR THEN

692: END IF;
693:
694: EXCEPTION
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO Process_SR_Updates_Pvt;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: EXCEPTION
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO Process_SR_Updates_Pvt;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO Process_SR_Updates_Pvt;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO Process_SR_Updates_Pvt;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO Process_SR_Updates_Pvt;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703:
704: WHEN OTHERS THEN

Line 702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

698: x_return_status := FND_API.G_RET_STS_ERROR;
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO Process_SR_Updates_Pvt;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703:
704: WHEN OTHERS THEN
705: ROLLBACK TO Process_SR_Updates_Pvt;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703:
704: WHEN OTHERS THEN
705: ROLLBACK TO Process_SR_Updates_Pvt;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
708: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
709: p_procedure_name => 'Process_SR_Updates',
710: p_error_text => SUBSTRB(SQLERRM,1,240));

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

724: -- Parameters :
725: --
726: -- Standard IN Parameters :
727: -- p_api_version IN NUMBER Required
728: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
729: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
730: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
731: --
732: -- Standard OUT Parameters :

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

725: --
726: -- Standard IN Parameters :
727: -- p_api_version IN NUMBER Required
728: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
729: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
730: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
731: --
732: -- Standard OUT Parameters :
733: -- x_return_status OUT VARCHAR2 Required

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

726: -- Standard IN Parameters :
727: -- p_api_version IN NUMBER Required
728: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
729: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
730: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
731: --
732: -- Standard OUT Parameters :
733: -- x_return_status OUT VARCHAR2 Required
734: -- x_msg_count OUT NUMBER Required

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

755:
756: PROCEDURE Process_SR_MR_Associations
757: (
758: p_api_version IN NUMBER,
759: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
760: p_commit IN VARCHAR2 := FND_API.G_FALSE,
761: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
762: x_return_status OUT NOCOPY VARCHAR2,
763: x_msg_count OUT NOCOPY NUMBER,

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

756: PROCEDURE Process_SR_MR_Associations
757: (
758: p_api_version IN NUMBER,
759: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
760: p_commit IN VARCHAR2 := FND_API.G_FALSE,
761: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
762: x_return_status OUT NOCOPY VARCHAR2,
763: x_msg_count OUT NOCOPY NUMBER,
764: x_msg_data OUT NOCOPY VARCHAR2,

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

757: (
758: p_api_version IN NUMBER,
759: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
760: p_commit IN VARCHAR2 := FND_API.G_FALSE,
761: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
762: x_return_status OUT NOCOPY VARCHAR2,
763: x_msg_count OUT NOCOPY NUMBER,
764: x_msg_data OUT NOCOPY VARCHAR2,
765: p_user_id IN NUMBER,

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

787: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
788: END IF;
789:
790: -- Standard call to check for call compatibility
791: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: -- Initialize message list if p_init_msg_list is set to TRUE

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: END IF;
789:
790: -- Standard call to check for call compatibility
791: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: -- Initialize message list if p_init_msg_list is set to TRUE
796: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 796: IF FND_API.To_Boolean(p_init_msg_list) THEN

792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: -- Initialize message list if p_init_msg_list is set to TRUE
796: IF FND_API.To_Boolean(p_init_msg_list) THEN
797: FND_MSG_PUB.Initialize;
798: END IF;
799:
800: -- Initialize API return status to success

Line 801: x_return_status := FND_API.G_RET_STS_SUCCESS;

797: FND_MSG_PUB.Initialize;
798: END IF;
799:
800: -- Initialize API return status to success
801: x_return_status := FND_API.G_RET_STS_SUCCESS;
802:
803: -- Begin Processing
804: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Beginning Processing with p_request_id = ' || p_request_id ||

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

809: -- Check if the Application Usage profile option has been set
810: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
811: x_return_status => x_return_status);
812:
813: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
814: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
815: FND_MSG_PUB.ADD;
816: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

815: FND_MSG_PUB.ADD;
816: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
818: END IF;
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
821: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
822: FND_MSG_PUB.ADD;
823: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: FND_MSG_PUB.ADD;
823: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
825: END IF;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
829: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Application Usage Profile Option Validated');
830: END IF;

Line 850: RAISE FND_API.G_EXC_ERROR;

846: FND_MSG_PUB.ADD;
847: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
849: END IF;
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: -- Validate the SR-MR Association records
854: Validate_Association_Records(p_request_id => l_request_id,

Line 861: RAISE FND_API.G_EXC_ERROR;

857: p_x_sr_mr_association_tbl => p_x_sr_mr_association_tbl);
858:
859: IF (FND_MSG_PUB.Count_Msg > 0) THEN
860: -- There are validation errors: No need to process further
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;
863:
864:
865: -- Process all Disassociations First

Line 879: RAISE FND_API.G_EXC_ERROR;

875: p_x_sr_mr_association_tbl => p_x_sr_mr_association_tbl);
876:
877: IF (FND_MSG_PUB.Count_Msg > 0) THEN
878: -- There are validation errors from Process_New_Associations: Raise error
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882: -- Standard check of p_commit
883: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 883: IF FND_API.TO_BOOLEAN(p_commit) THEN

879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882: -- Standard check of p_commit
883: IF FND_API.TO_BOOLEAN(p_commit) THEN
884: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
885: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Commit.');
886: END IF;
887: COMMIT WORK;

Line 894: p_encoded => fnd_api.g_false

890: -- Standard call to get message count and if count is 1, get message info
891: FND_MSG_PUB.Count_And_Get
892: ( p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => fnd_api.g_false
895: );
896:
897: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 902: WHEN FND_API.G_EXC_ERROR THEN

898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
899: END IF;
900:
901: EXCEPTION
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO Process_SR_MR_Associations_pvt;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
906: p_data => x_msg_data,

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900:
901: EXCEPTION
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO Process_SR_MR_Associations_pvt;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
906: p_data => x_msg_data,
907: p_encoded => fnd_api.g_false);
908: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

Line 907: p_encoded => fnd_api.g_false);

903: ROLLBACK TO Process_SR_MR_Associations_pvt;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
906: p_data => x_msg_data,
907: p_encoded => fnd_api.g_false);
908: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Process_SR_MR_Associations_pvt;

Line 910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

906: p_data => x_msg_data,
907: p_encoded => fnd_api.g_false);
908: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Process_SR_MR_Associations_pvt;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
914: p_data => x_msg_data,

Line 912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

908: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Process_SR_MR_Associations_pvt;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
914: p_data => x_msg_data,
915: p_encoded => fnd_api.g_false);
916: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

Line 915: p_encoded => fnd_api.g_false);

911: ROLLBACK TO Process_SR_MR_Associations_pvt;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
914: p_data => x_msg_data,
915: p_encoded => fnd_api.g_false);
916: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
917:
918: WHEN OTHERS THEN
919: ROLLBACK TO Process_SR_MR_Associations_pvt;

Line 920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
917:
918: WHEN OTHERS THEN
919: ROLLBACK TO Process_SR_MR_Associations_pvt;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
922: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
923: p_procedure_name => 'Process_SR_MR_Associations',
924: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 928: p_encoded => fnd_api.g_false);

924: p_error_text => SUBSTRB(SQLERRM,1,240));
925: END IF;
926: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
927: p_data => x_msg_data,
928: p_encoded => fnd_api.g_false);
929: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
930:
931: END Process_SR_MR_Associations;
932:

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: FND_MSG_PUB.ADD;
993: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
995: END IF;
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (p_object_version_number IS NULL) THEN
998: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_NULL');
999: FND_MSG_PUB.ADD;
1000: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

999: FND_MSG_PUB.ADD;
1000: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1002: END IF;
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: ELSE
1005: OPEN get_request_dtls_csr(p_request_id => p_x_request_id,
1006: p_request_number => p_request_number,
1007: p_object_version_number => p_object_version_number);

Line 1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1018: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1020: END IF;
1021: CLOSE get_request_dtls_csr;
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: CLOSE get_request_dtls_csr;
1025: END IF;
1026:

Line 1033: RAISE FND_API.G_EXC_ERROR;

1029: FND_MSG_PUB.ADD;
1030: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1031: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1032: END IF;
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035: /*
1036: Balaji commented out this cursor validation for OGMA ER : Adding MRs to Non-Routines
1037: Since as per this ER requirements, we are going to allow SR UEs to be modified and plan

Line 1048: RAISE FND_API.G_EXC_ERROR;

1044: FND_MSG_PUB.ADD;
1045: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1047: END IF;
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;
1050: */
1051: OPEN get_ue_dtls_csr(p_request_id => p_x_request_id);
1052: FETCH get_ue_dtls_csr INTO x_sr_ue_id; -- OUT Parameter

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1059: END IF;
1060: CLOSE get_ue_dtls_csr;
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: CLOSE get_ue_dtls_csr;
1064:
1065: /*

Line 1079: RAISE FND_API.G_EXC_ERROR;

1075: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1077: END IF;
1078: CLOSE get_tasks_for_ue_csr;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: CLOSE get_tasks_for_ue_csr;
1082: */
1083: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1292: x_msg_data => l_temp_msg_data,
1293: p_item_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID,
1294: p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID,
1295: x_applicable_mr_tbl => l_applicable_mr_tbl);
1296: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1297: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');
1298: FND_MESSAGE.Set_Token('INDEX', i);
1299: FND_MSG_PUB.ADD;
1300: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2048: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,
2049: x_return_status => l_temp_return_status,
2050: x_msg_count => l_temp_msg_count,
2051: x_msg_data => l_temp_msg_data);
2052: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2053: p_x_valid_flag := false;
2054: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2055: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');
2056: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);

Line 2565: RAISE FND_API.G_EXC_UNEXPECTED_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_UNEXPECTED_ERROR;
2566: END IF;
2567:
2568: -- Ensure that the request id is valid
2569: OPEN check_request_exists_csr;

Line 2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2575: FND_MSG_PUB.ADD;
2576: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: END IF;
2581: CLOSE check_request_exists_csr;
2582:
2583: -- If already a CMRO SR, ensure that an unit effectivity exists for the SR

Line 2599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2595: END IF;
2596: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2597: 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);
2598: END IF;
2599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2600: END IF; -- UE Not Found
2601: CLOSE get_ue_dtls_csr;
2602: END IF; -- CMRO Type SR
2603:

Line 2646: RAISE FND_API.G_EXC_ERROR;

2642: FND_MSG_PUB.ADD;
2643: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2644: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2645: END IF;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;
2648:
2649: IF (NVL(CS_SERVICEREQUEST_PVT.user_hooks_rec.new_type_cmro_flag, G_NO_FLAG) = G_NO_FLAG) THEN
2650: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2661: RAISE FND_API.G_EXC_ERROR;

2657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'UE was deferred.');
2658: END IF;
2659: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_DEFERRED');
2660: FND_MSG_PUB.ADD;
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;
2663: -- apattark end changes for bug #9166304
2664: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
2665: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN

Line 2684: RAISE FND_API.G_EXC_ERROR;

2680: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
2681: FND_MSG_PUB.ADD;
2682: END IF; -- tasks found
2683: CLOSE get_tasks_for_ue_csr;
2684: RAISE FND_API.G_EXC_ERROR;
2685: ELSE
2686: -- Not yet Planned, but open
2687: -- Delete all the dependent UEs and UE relationships
2688: FOR rel_and_ue_id_rec in get_all_ue_and_rel_ids_csr LOOP

Line 2718: RAISE FND_API.G_EXC_ERROR;

2714: FND_MSG_PUB.ADD;
2715: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2716: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2717: END IF;
2718: RAISE FND_API.G_EXC_ERROR;
2719: ELSE
2720: -- Not yet Planned, but open: Call Create_SR_Init_Effectivity
2721: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2722: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call Create_SR_Unit_Effectivity.');

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

2724: Create_SR_Unit_Effectivity(x_return_status => l_temp_return_status);
2725: /* For Testing
2726: UMP_SR_TEST.Create_SR_Unit_Effectivity(x_return_status => l_temp_return_status);
2727: */
2728: IF (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2729: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2730: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Success.');
2731: END IF;
2732: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2728: IF (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2729: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2730: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Success.');
2731: END IF;
2732: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN
2733: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned User Error.');
2735: END IF;
2736: RAISE FND_API.G_EXC_ERROR;

Line 2736: RAISE FND_API.G_EXC_ERROR;

2732: ELSIF (l_temp_return_status = FND_API.G_RET_STS_ERROR) THEN
2733: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned User Error.');
2735: END IF;
2736: RAISE FND_API.G_EXC_ERROR;
2737: ELSE
2738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2739: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Unexpected Error.');
2740: END IF;

Line 2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2737: ELSE
2738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2739: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Create_SR_Unit_Effectivity Returned Unexpected Error.');
2740: END IF;
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: END IF;
2743: END IF; -- Planned or not
2744: END IF; -- CMRO to Non-CMRO or vice-versa
2745:

Line 2820: p_init_msg_list => FND_API.G_FALSE,

2816: AHL_UMP_PROCESSUNIT_PVT.Calculate_Init_DueDate(
2817: x_return_status => l_return_status,
2818: x_msg_data => l_msg_data,
2819: x_msg_count => l_msg_count,
2820: p_init_msg_list => FND_API.G_FALSE,
2821: p_unit_effectivity_id => p_sr_ue_id,
2822: x_due_date => l_calc_due_date);
2823: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2824: l_new_due_date := l_calc_due_date;

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

2819: x_msg_count => l_msg_count,
2820: p_init_msg_list => FND_API.G_FALSE,
2821: p_unit_effectivity_id => p_sr_ue_id,
2822: x_due_date => l_calc_due_date);
2823: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2824: l_new_due_date := l_calc_due_date;
2825: END IF;
2826: END IF;
2827:

Line 2844: RAISE FND_API.G_EXC_ERROR;

2840: END IF;
2841:
2842: IF (l_valid_flag = false) THEN
2843: -- At least one Validation has failed: No need to do any further processing
2844: RAISE FND_API.G_EXC_ERROR;
2845: END IF;
2846:
2847: IF (l_instance_changed = true OR l_status_changed = true OR l_due_date_changed = true) THEN
2848: -- Apply changes to the SR Unit Effectivity

Line 3262: p_init_msg_list => FND_API.G_FALSE,

3258: -- Update the workorders
3259: AHL_PRD_WORKORDER_PVT.Process_Jobs
3260: (
3261: p_api_version => 1.0,
3262: p_init_msg_list => FND_API.G_FALSE,
3263: p_commit => FND_API.G_FALSE,
3264: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3265: p_default => FND_API.G_TRUE,
3266: p_module_type => 'API',

Line 3263: p_commit => FND_API.G_FALSE,

3259: AHL_PRD_WORKORDER_PVT.Process_Jobs
3260: (
3261: p_api_version => 1.0,
3262: p_init_msg_list => FND_API.G_FALSE,
3263: p_commit => FND_API.G_FALSE,
3264: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3265: p_default => FND_API.G_TRUE,
3266: p_module_type => 'API',
3267: x_return_status => l_return_status,

Line 3264: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3260: (
3261: p_api_version => 1.0,
3262: p_init_msg_list => FND_API.G_FALSE,
3263: p_commit => FND_API.G_FALSE,
3264: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3265: p_default => FND_API.G_TRUE,
3266: p_module_type => 'API',
3267: x_return_status => l_return_status,
3268: x_msg_count => l_msg_count,

Line 3265: p_default => FND_API.G_TRUE,

3261: p_api_version => 1.0,
3262: p_init_msg_list => FND_API.G_FALSE,
3263: p_commit => FND_API.G_FALSE,
3264: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3265: p_default => FND_API.G_TRUE,
3266: p_module_type => 'API',
3267: x_return_status => l_return_status,
3268: x_msg_count => l_msg_count,
3269: x_msg_data => l_msg_data,

Line 3274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3270: p_x_prd_workorder_tbl => l_prd_workorder_tbl,
3271: p_prd_workorder_rel_tbl=> l_prd_workorder_rel_tbl
3272: );
3273:
3274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3275: THEN
3276: RAISE FND_API.G_EXC_ERROR;
3277: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 3276: RAISE FND_API.G_EXC_ERROR;

3272: );
3273:
3274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3275: THEN
3276: RAISE FND_API.G_EXC_ERROR;
3277: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3279: END IF;
3280: END IF;