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

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121: IF (p_inventory_item_id IS NULL
122: OR
123: p_organization_id is NULL) THEN
124: code_debug(' invalid params ');
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: RETURN;
127: END IF;
128: l_pending_change_found := FND_API.G_FALSE;
129: l_is_master_org := get_master_org_status(p_organization_id => p_organization_id);

Line 128: l_pending_change_found := FND_API.G_FALSE;

124: code_debug(' invalid params ');
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: RETURN;
127: END IF;
128: l_pending_change_found := FND_API.G_FALSE;
129: l_is_master_org := get_master_org_status(p_organization_id => p_organization_id);
130: l_status_master_controlled := get_master_controlled_status();
131: IF p_revision_id IS NULL THEN
132: IF (FND_API.TO_BOOLEAN(l_status_master_controlled)) THEN

Line 132: IF (FND_API.TO_BOOLEAN(l_status_master_controlled)) THEN

128: l_pending_change_found := FND_API.G_FALSE;
129: l_is_master_org := get_master_org_status(p_organization_id => p_organization_id);
130: l_status_master_controlled := get_master_controlled_status();
131: IF p_revision_id IS NULL THEN
132: IF (FND_API.TO_BOOLEAN(l_status_master_controlled)) THEN
133: IF (FND_API.TO_BOOLEAN(l_is_master_org)) THEN
134: OPEN c_pending_changes(cp_item_id => p_inventory_item_id
135: ,cp_org_id => p_organization_id
136: ,cp_rev_id => p_revision_id

Line 133: IF (FND_API.TO_BOOLEAN(l_is_master_org)) THEN

129: l_is_master_org := get_master_org_status(p_organization_id => p_organization_id);
130: l_status_master_controlled := get_master_controlled_status();
131: IF p_revision_id IS NULL THEN
132: IF (FND_API.TO_BOOLEAN(l_status_master_controlled)) THEN
133: IF (FND_API.TO_BOOLEAN(l_is_master_org)) THEN
134: OPEN c_pending_changes(cp_item_id => p_inventory_item_id
135: ,cp_org_id => p_organization_id
136: ,cp_rev_id => p_revision_id
137: );

Line 140: l_pending_change_found := FND_API.G_TRUE;

136: ,cp_rev_id => p_revision_id
137: );
138: FETCH c_pending_changes INTO l_organization_id;
139: IF c_pending_changes%FOUND THEN
140: l_pending_change_found := FND_API.G_TRUE;
141: END IF;
142: CLOSE c_pending_changes;
143: ELSE
144: --

Line 153: l_pending_change_found := FND_API.G_TRUE;

149: ,cp_rev_id => p_revision_id
150: );
151: FETCH c_pending_org_changes INTO l_organization_id;
152: IF c_pending_org_changes%FOUND THEN
153: l_pending_change_found := FND_API.G_TRUE;
154: END IF;
155: CLOSE c_pending_org_changes;
156: END IF; -- in master org
157: ELSE

Line 165: l_pending_change_found := FND_API.G_TRUE;

161: ,cp_rev_id => p_revision_id
162: );
163: FETCH c_pending_changes INTO l_organization_id;
164: IF c_pending_changes%FOUND THEN
165: l_pending_change_found := FND_API.G_TRUE;
166: END IF;
167: CLOSE c_pending_changes;
168: END IF; -- status is master controlled
169: ELSE

Line 180: l_pending_change_found := FND_API.G_TRUE;

176: ,cp_rev_id => p_revision_id
177: );
178: FETCH c_pending_changes INTO l_organization_id;
179: IF c_pending_changes%FOUND THEN
180: l_pending_change_found := FND_API.G_TRUE;
181: END IF;
182: CLOSE c_pending_changes;
183: END IF; -- p_revision_id IS NULL
184:

Line 185: IF (FND_API.TO_BOOLEAN(l_pending_change_found)) THEN

181: END IF;
182: CLOSE c_pending_changes;
183: END IF; -- p_revision_id IS NULL
184:
185: IF (FND_API.TO_BOOLEAN(l_pending_change_found)) THEN
186: code_debug(' pending changes exist ');
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: --
189: -- get item name

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183: END IF; -- p_revision_id IS NULL
184:
185: IF (FND_API.TO_BOOLEAN(l_pending_change_found)) THEN
186: code_debug(' pending changes exist ');
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: --
189: -- get item name
190: --
191: SELECT concatenated_segments

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

206: x_msg_data := fnd_message.get();
207: code_debug(' error msg '|| x_msg_data);
208: ELSE
209: code_debug(' no pending changes ');
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: END IF;
212:
213: EXCEPTION
214: WHEN OTHERS THEN

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212:
213: EXCEPTION
214: WHEN OTHERS THEN
215: code_debug(' EXCEPTION in Check_Pending_Change_Orders ');
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF c_pending_changes%ISOPEN THEN
218: CLOSE c_pending_changes;
219: END IF;
220: IF c_pending_org_changes%ISOPEN THEN

Line 484: --IF FND_API.To_Boolean(p_commit) THEN

480: code_debug(' p_status_master_controlled : '||p_status_master_controlled||' p_is_master_org: '||p_is_master_org);
481:
482:
483: -- Bug 13495593
484: --IF FND_API.To_Boolean(p_commit) THEN
485: SAVEPOINT Implement_All_Pending_Changes;
486: --END IF;
487:
488: --Standard checks

Line 489: IF NOT FND_API.Compatible_API_Call (l_api_version

485: SAVEPOINT Implement_All_Pending_Changes;
486: --END IF;
487:
488: --Standard checks
489: IF NOT FND_API.Compatible_API_Call (l_api_version
490: ,p_api_version
491: ,l_api_name
492: ,g_pkg_name)
493: THEN

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: ,p_api_version
491: ,l_api_name
492: ,g_pkg_name)
493: THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
498: THEN

Line 535: ,p_lifecycle_changed => FND_API.G_FALSE

531: EGO_INV_ITEM_CATALOG_PVT.Check_pending_Change_Orders (
532: p_inventory_item_id => p_inventory_item_id
533: ,p_organization_id => p_organization_id
534: ,p_revision_id => p_revision_id
535: ,p_lifecycle_changed => FND_API.G_FALSE
536: ,p_lifecycle_phase_changed => FND_API.G_TRUE
537: ,p_change_id => p_change_id
538: ,p_change_line_id => p_change_line_id
539: ,x_return_status => x_return_status

Line 536: ,p_lifecycle_phase_changed => FND_API.G_TRUE

532: p_inventory_item_id => p_inventory_item_id
533: ,p_organization_id => p_organization_id
534: ,p_revision_id => p_revision_id
535: ,p_lifecycle_changed => FND_API.G_FALSE
536: ,p_lifecycle_phase_changed => FND_API.G_TRUE
537: ,p_change_id => p_change_id
538: ,p_change_line_id => p_change_line_id
539: ,x_return_status => x_return_status
540: ,x_msg_count => x_msg_count

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

539: ,x_return_status => x_return_status
540: ,x_msg_count => x_msg_count
541: ,x_msg_data => x_msg_data
542: );
543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
544: code_debug (' pending co exist '|| x_msg_data);
545: IF FND_API.To_Boolean(p_commit) THEN
546: ROLLBACK TO Implement_All_Pending_Changes;
547: END IF;

Line 545: IF FND_API.To_Boolean(p_commit) THEN

541: ,x_msg_data => x_msg_data
542: );
543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
544: code_debug (' pending co exist '|| x_msg_data);
545: IF FND_API.To_Boolean(p_commit) THEN
546: ROLLBACK TO Implement_All_Pending_Changes;
547: END IF;
548: RETURN;
549: END IF;

Line 554: IF FND_API.TO_BOOLEAN(p_is_master_org) THEN

550: END IF;
551:
552: code_debug (' no pending change orders exist ');
553:
554: IF FND_API.TO_BOOLEAN(p_is_master_org) THEN
555: code_debug (' in context of master org ');
556: ELSE
557: code_debug (' in context of child org ');
558: END IF;

Line 560: IF FND_API.TO_BOOLEAN(p_status_master_controlled) THEN

556: ELSE
557: code_debug (' in context of child org ');
558: END IF;
559:
560: IF FND_API.TO_BOOLEAN(p_status_master_controlled) THEN
561: code_debug (' status is master controlled ');
562: ELSE
563: code_debug (' status is controlled at org level ');
564: END IF;

Line 569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

565:
566: --
567: -- to be removed after bug 3874132 is resoloved.
568: --
569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: IF FND_API.To_Boolean( p_commit ) THEN
571: ROLLBACK TO Implement_All_Pending_Changes;
572: END IF;
573: RETURN;

Line 570: IF FND_API.To_Boolean( p_commit ) THEN

566: --
567: -- to be removed after bug 3874132 is resoloved.
568: --
569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: IF FND_API.To_Boolean( p_commit ) THEN
571: ROLLBACK TO Implement_All_Pending_Changes;
572: END IF;
573: RETURN;
574: END IF;

Line 585: IF (FND_API.TO_BOOLEAN(p_is_master_org)

581: --
582: -- If it's at the master and status is master controlled,
583: -- then do it for all assigned orgs
584: --
585: IF (FND_API.TO_BOOLEAN(p_is_master_org)
586: OR
587: FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE
588: ) THEN
589: IF (FND_API.TO_BOOLEAN(p_is_master_org)

Line 587: FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE

583: -- then do it for all assigned orgs
584: --
585: IF (FND_API.TO_BOOLEAN(p_is_master_org)
586: OR
587: FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE
588: ) THEN
589: IF (FND_API.TO_BOOLEAN(p_is_master_org)
590: AND
591: FND_API.TO_BOOLEAN(p_status_master_controlled) = TRUE

Line 589: IF (FND_API.TO_BOOLEAN(p_is_master_org)

585: IF (FND_API.TO_BOOLEAN(p_is_master_org)
586: OR
587: FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE
588: ) THEN
589: IF (FND_API.TO_BOOLEAN(p_is_master_org)
590: AND
591: FND_API.TO_BOOLEAN(p_status_master_controlled) = TRUE
592: ) THEN
593: -- Get the most recent phase id

Line 591: FND_API.TO_BOOLEAN(p_status_master_controlled) = TRUE

587: FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE
588: ) THEN
589: IF (FND_API.TO_BOOLEAN(p_is_master_org)
590: AND
591: FND_API.TO_BOOLEAN(p_status_master_controlled) = TRUE
592: ) THEN
593: -- Get the most recent phase id
594: code_debug(' before the loop' );
595:

Line 597: IF FND_API.To_boolean(p_perform_security_check) THEN

593: -- Get the most recent phase id
594: code_debug(' before the loop' );
595:
596: FOR l_phase_id IN l_phase_ids LOOP
597: IF FND_API.To_boolean(p_perform_security_check) THEN
598: -- 4052565 perform security check
599: l_priv_name_to_check := get_privlige_name_for_action
600: (p_curr_item_id => p_inventory_item_id
601: ,p_curr_org_id => p_organization_id

Line 619: ,p_set_message => FND_API.G_TRUE

615: ,p_organization_id => p_organization_id
616: ,p_organization_name => NULL
617: ,p_user_id => G_CURRENT_USER_ID
618: ,p_party_id => NULL
619: ,p_set_message => FND_API.G_TRUE
620: ) THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END IF;

Line 621: RAISE FND_API.G_EXC_ERROR;

617: ,p_user_id => G_CURRENT_USER_ID
618: ,p_party_id => NULL
619: ,p_set_message => FND_API.G_TRUE
620: ) THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END IF;
624: END IF;
625:

Line 637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

633: ,x_msg_count => x_msg_count
634: ,x_msg_data => x_msg_data );
635:
636: code_debug(' after check_floating_attachments 1 ' || x_return_status);
637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
638: IF FND_API.To_Boolean( p_commit ) THEN
639: ROLLBACK TO Implement_All_Pending_Changes;
640: END IF;
641: RETURN;

Line 638: IF FND_API.To_Boolean( p_commit ) THEN

634: ,x_msg_data => x_msg_data );
635:
636: code_debug(' after check_floating_attachments 1 ' || x_return_status);
637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
638: IF FND_API.To_Boolean( p_commit ) THEN
639: ROLLBACK TO Implement_All_Pending_Changes;
640: END IF;
641: RETURN;
642: END IF;

Line 659: ELSIF (FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE) THEN

655: --
656: -- Otherwise, either we are not at master or not master controlled.
657: -- So if not master controlled, do it for the current org
658: --
659: ELSIF (FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE) THEN
660: --
661: -- Get the most recent phase id
662: --
663: FOR l_phase_id IN l_phase_ids LOOP

Line 665: IF FND_API.To_boolean(p_perform_security_check) THEN

661: -- Get the most recent phase id
662: --
663: FOR l_phase_id IN l_phase_ids LOOP
664:
665: IF FND_API.To_boolean(p_perform_security_check) THEN
666: -- 4052565 perform security check
667: l_priv_name_to_check := get_privlige_name_for_action
668: (p_curr_item_id => p_inventory_item_id
669: ,p_curr_org_id => p_organization_id

Line 687: ,p_set_message => FND_API.G_TRUE

683: ,p_organization_id => p_organization_id
684: ,p_organization_name => NULL
685: ,p_user_id => G_CURRENT_USER_ID
686: ,p_party_id => NULL
687: ,p_set_message => FND_API.G_TRUE
688: ) THEN
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691: END IF;

Line 689: RAISE FND_API.G_EXC_ERROR;

685: ,p_user_id => G_CURRENT_USER_ID
686: ,p_party_id => NULL
687: ,p_set_message => FND_API.G_TRUE
688: ) THEN
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691: END IF;
692: END IF;
693:

Line 705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

701: ,x_msg_count => x_msg_count
702: ,x_msg_data => x_msg_data );
703:
704: code_debug(' after check_floating_attachments 2 ' || x_return_status);
705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
706: IF FND_API.To_Boolean( p_commit ) THEN
707: ROLLBACK TO Implement_All_Pending_Changes;
708: END IF;
709: RETURN;

Line 706: IF FND_API.To_Boolean( p_commit ) THEN

702: ,x_msg_data => x_msg_data );
703:
704: code_debug(' after check_floating_attachments 2 ' || x_return_status);
705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
706: IF FND_API.To_Boolean( p_commit ) THEN
707: ROLLBACK TO Implement_All_Pending_Changes;
708: END IF;
709: RETURN;
710: END IF;

Line 741: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

737: ,x_msg_count
738: ,x_msg_data
739: );
740: --Added for bug 5230594
741: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: ROLLBACK TO Implement_All_Pending_Changes;
743: RETURN;
744: END IF;
745:

Line 796: IF NVL(p_perform_security_check,FND_API.G_FALSE) = FND_API.G_TRUE THEN

792: -- Get all of the pending records
793: --
794: FOR l_pending_record IN l_pending_revision_statuses LOOP
795: code_debug (' processing revision '||l_pending_record.REVISION_ID);
796: IF NVL(p_perform_security_check,FND_API.G_FALSE) = FND_API.G_TRUE THEN
797: -- 4052565 perform security check
798: l_priv_name_to_check := get_privlige_name_for_action
799: (p_curr_item_id => p_inventory_item_id
800: ,p_curr_org_id => p_organization_id

Line 818: ,p_set_message => FND_API.G_TRUE

814: ,p_organization_id => p_organization_id
815: ,p_organization_name => NULL
816: ,p_user_id => G_CURRENT_USER_ID
817: ,p_party_id => NULL
818: ,p_set_message => FND_API.G_TRUE
819: ) THEN
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822: END IF;

Line 820: RAISE FND_API.G_EXC_ERROR;

816: ,p_user_id => G_CURRENT_USER_ID
817: ,p_party_id => NULL
818: ,p_set_message => FND_API.G_TRUE
819: ) THEN
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822: END IF;
823: END IF;
824:

Line 829: IF (FND_API.TO_BOOLEAN(p_revision_master_controlled)

825: IF l_pending_record.PHASE_ID IS NOT NULL THEN
826: --
827: -- If master controlled and we are at master
828: --
829: IF (FND_API.TO_BOOLEAN(p_revision_master_controlled)
830: AND
831: FND_API.TO_BOOLEAN(p_is_master_org)
832: ) THEN
833: code_debug (' rev is master controlled and we are at master org ');

Line 831: FND_API.TO_BOOLEAN(p_is_master_org)

827: -- If master controlled and we are at master
828: --
829: IF (FND_API.TO_BOOLEAN(p_revision_master_controlled)
830: AND
831: FND_API.TO_BOOLEAN(p_is_master_org)
832: ) THEN
833: code_debug (' rev is master controlled and we are at master org ');
834: --
835: -- First get the revision code

Line 858: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

854: ,x_msg_count => x_msg_count
855: ,x_msg_data => x_msg_data );
856:
857: code_debug(' after check_floating_attachments 3 ' || x_return_status);
858: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
859: IF FND_API.To_Boolean( p_commit ) THEN
860: ROLLBACK TO Implement_All_Pending_Changes;
861: END IF;
862: RETURN;

Line 859: IF FND_API.To_Boolean( p_commit ) THEN

855: ,x_msg_data => x_msg_data );
856:
857: code_debug(' after check_floating_attachments 3 ' || x_return_status);
858: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
859: IF FND_API.To_Boolean( p_commit ) THEN
860: ROLLBACK TO Implement_All_Pending_Changes;
861: END IF;
862: RETURN;
863: END IF;

Line 877: ELSIF (FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE) THEN

873: MTL_PARAMETERS P2
874: WHERE P1.ORGANIZATION_ID = p_organization_id
875: AND P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID);
876:
877: ELSIF (FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE) THEN
878: code_debug (' rev is org controlled and we are at master org ');
879: --
880: -- Just update for the current one
881: --

Line 893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

889: ,x_msg_count => x_msg_count
890: ,x_msg_data => x_msg_data );
891:
892: code_debug(' after check_floating_attachments 4 ' || x_return_status);
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: IF FND_API.To_Boolean( p_commit ) THEN
895: ROLLBACK TO Implement_All_Pending_Changes;
896: END IF;
897: RETURN;

Line 894: IF FND_API.To_Boolean( p_commit ) THEN

890: ,x_msg_data => x_msg_data );
891:
892: code_debug(' after check_floating_attachments 4 ' || x_return_status);
893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
894: IF FND_API.To_Boolean( p_commit ) THEN
895: ROLLBACK TO Implement_All_Pending_Changes;
896: END IF;
897: RETURN;
898: END IF;

Line 909: IF (FND_API.TO_BOOLEAN(p_is_master_org)

905: AND ORGANIZATION_ID = l_pending_record.ORGANIZATION_ID;
906: END IF;
907:
908: code_debug (' modifying the pending status table now ');
909: IF (FND_API.TO_BOOLEAN(p_is_master_org)
910: OR
911: FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE
912: ) THEN
913: UPDATE MTL_PENDING_ITEM_STATUS

Line 911: FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE

907:
908: code_debug (' modifying the pending status table now ');
909: IF (FND_API.TO_BOOLEAN(p_is_master_org)
910: OR
911: FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE
912: ) THEN
913: UPDATE MTL_PENDING_ITEM_STATUS
914: SET
915: PENDING_FLAG = 'N'

Line 926: IF FND_API.To_Boolean(p_commit) THEN

922: END LOOP;
923:
924: END IF;
925:
926: IF FND_API.To_Boolean(p_commit) THEN
927: COMMIT WORK;
928: -- Call IP Intermedia Sync
929: INV_ITEM_EVENTS_PVT.Sync_IP_IM_Index;
930: END IF;

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927: COMMIT WORK;
928: -- Call IP Intermedia Sync
929: INV_ITEM_EVENTS_PVT.Sync_IP_IM_Index;
930: END IF;
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN
935: IF FND_API.To_Boolean( p_commit ) THEN

Line 934: WHEN FND_API.G_EXC_ERROR THEN

930: END IF;
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN
935: IF FND_API.To_Boolean( p_commit ) THEN
936: ROLLBACK TO Implement_All_Pending_Changes;
937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;

Line 935: IF FND_API.To_Boolean( p_commit ) THEN

931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN
935: IF FND_API.To_Boolean( p_commit ) THEN
936: ROLLBACK TO Implement_All_Pending_Changes;
937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MSG_PUB.Count_And_Get(

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: WHEN FND_API.G_EXC_ERROR THEN
935: IF FND_API.To_Boolean( p_commit ) THEN
936: ROLLBACK TO Implement_All_Pending_Changes;
937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data

Line 940: p_encoded => FND_API.G_FALSE,

936: ROLLBACK TO Implement_All_Pending_Changes;
937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data
943: );
944: WHEN OTHERS THEN

Line 945: IF FND_API.To_Boolean(p_commit) THEN

941: p_count => x_msg_count,
942: p_data => x_msg_data
943: );
944: WHEN OTHERS THEN
945: IF FND_API.To_Boolean(p_commit) THEN
946: ROLLBACK TO Implement_All_Pending_Changes;
947: END IF;
948: IF c_item_pending_phase_change%ISOPEN THEN
949: CLOSE c_item_pending_phase_change;

Line 954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

950: END IF;
951: IF c_rev_pending_phase_change%ISOPEN THEN
952: CLOSE c_rev_pending_phase_change;
953: END IF;
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: FND_MESSAGE.Set_Name(G_APP_NAME, G_PLSQL_ERR);
956: FND_MESSAGE.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
957: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
958: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);

Line 961: -- x_return_status := FND_API.G_RET_STS_ERROR;

957: FND_MESSAGE.Set_Token(G_API_NAME_TOKEN, 'IMPLEMENT_ALL_PENDING_CHANGES');
958: FND_MESSAGE.Set_Token(G_SQL_ERR_MSG_TOKEN, SQLERRM);
959: x_msg_count := 1;
960: x_msg_data := FND_MESSAGE.GET;
961: -- x_return_status := FND_API.G_RET_STS_ERROR;
962: -- x_msg_data := FND_MESSAGE.Get_String('EGO', 'EGO_EXT_EXCEPTION_OCCURED');
963:
964: END Implement_All_Pending_Changes;
965:

Line 975: l_status_master_controlled := FND_API.G_FALSE;

971:
972: FUNCTION get_master_controlled_status RETURN VARCHAR2 IS
973: l_status_master_controlled VARCHAR2(100);
974: BEGIN
975: l_status_master_controlled := FND_API.G_FALSE;
976: SELECT DECODE(LOOKUP_CODE2,
977: 1, FND_API.G_TRUE,
978: 2, FND_API.G_FALSE,
979: FND_API.G_FALSE)

Line 977: 1, FND_API.G_TRUE,

973: l_status_master_controlled VARCHAR2(100);
974: BEGIN
975: l_status_master_controlled := FND_API.G_FALSE;
976: SELECT DECODE(LOOKUP_CODE2,
977: 1, FND_API.G_TRUE,
978: 2, FND_API.G_FALSE,
979: FND_API.G_FALSE)
980: INTO l_status_master_controlled
981: FROM MTL_ITEM_ATTRIBUTES_V

Line 978: 2, FND_API.G_FALSE,

974: BEGIN
975: l_status_master_controlled := FND_API.G_FALSE;
976: SELECT DECODE(LOOKUP_CODE2,
977: 1, FND_API.G_TRUE,
978: 2, FND_API.G_FALSE,
979: FND_API.G_FALSE)
980: INTO l_status_master_controlled
981: FROM MTL_ITEM_ATTRIBUTES_V
982: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

Line 979: FND_API.G_FALSE)

975: l_status_master_controlled := FND_API.G_FALSE;
976: SELECT DECODE(LOOKUP_CODE2,
977: 1, FND_API.G_TRUE,
978: 2, FND_API.G_FALSE,
979: FND_API.G_FALSE)
980: INTO l_status_master_controlled
981: FROM MTL_ITEM_ATTRIBUTES_V
982: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
983:

Line 996: l_is_master_org := FND_API.G_FALSE;

992: FUNCTION get_master_org_status (p_organization_id IN NUMBER)
993: RETURN VARCHAR2 IS
994: l_is_master_org VARCHAR2(100);
995: BEGIN
996: l_is_master_org := FND_API.G_FALSE;
997: SELECT DECODE(MP.ORGANIZATION_ID,
998: MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,
999: FND_API.G_FALSE)
1000: INTO l_is_master_org

Line 998: MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,

994: l_is_master_org VARCHAR2(100);
995: BEGIN
996: l_is_master_org := FND_API.G_FALSE;
997: SELECT DECODE(MP.ORGANIZATION_ID,
998: MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,
999: FND_API.G_FALSE)
1000: INTO l_is_master_org
1001: FROM MTL_PARAMETERS MP
1002: WHERE MP.ORGANIZATION_ID = p_organization_id;

Line 999: FND_API.G_FALSE)

995: BEGIN
996: l_is_master_org := FND_API.G_FALSE;
997: SELECT DECODE(MP.ORGANIZATION_ID,
998: MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,
999: FND_API.G_FALSE)
1000: INTO l_is_master_org
1001: FROM MTL_PARAMETERS MP
1002: WHERE MP.ORGANIZATION_ID = p_organization_id;
1003:

Line 1129: IF FND_API.To_Boolean(p_commit) THEN

1125:
1126: l_api_version := 1.0;
1127: l_api_name := 'Create_Pending_Phase_Change';
1128:
1129: IF FND_API.To_Boolean(p_commit) THEN
1130: SAVEPOINT Create_Pending_Phase_Change_SP;
1131: END IF;
1132: code_debug( l_api_name ||' started with params');
1133: code_debug( l_api_name ||' p_inventory_item_id '|| p_inventory_item_id ||' p_organization_id '|| p_organization_id || ' p_revision '|| p_revision);

Line 1138: IF NOT FND_API.Compatible_API_Call (l_api_version

1134: code_debug( l_api_name ||' p_lifecycle_id '|| p_lifecycle_id ||' p_phase_id '|| p_phase_id ||' p_status_code '|| p_status_code);
1135: code_debug( l_api_name ||' p_pending_flag '|| p_pending_flag ||' p_change_id '|| p_change_id ||' p_change_line_id '|| p_change_line_id);
1136:
1137: --Standard checks
1138: IF NOT FND_API.Compatible_API_Call (l_api_version
1139: ,p_api_version
1140: ,l_api_name
1141: ,g_pkg_name)
1142: THEN

Line 1143: RAISE FND_API.G_EXC_ERROR;

1139: ,p_api_version
1140: ,l_api_name
1141: ,g_pkg_name)
1142: THEN
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:
1146: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1147: THEN

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1161: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1162: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:
1167: l_revision := p_revision;
1168: l_revision_id := p_revision_id;

Line 1213: RAISE FND_API.G_EXC_ERROR;

1209: FROM hr_all_organization_units_vl
1210: WHERE organization_id = p_organization_id;
1211: fnd_message.set_token('ORGANIZATION', l_dummy_char);
1212: fnd_msg_pub.Add;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:
1216: IF FND_API.To_Boolean(p_perform_security_check) THEN
1217: code_debug( l_api_name ||' need to perform security check ');

Line 1216: IF FND_API.To_Boolean(p_perform_security_check) THEN

1212: fnd_msg_pub.Add;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215:
1216: IF FND_API.To_Boolean(p_perform_security_check) THEN
1217: code_debug( l_api_name ||' need to perform security check ');
1218: -- 4052565 perform security check
1219: l_priv_name_to_check := get_privlige_name_for_action
1220: (p_curr_item_id => p_inventory_item_id

Line 1240: ,p_set_message => FND_API.G_TRUE

1236: ,p_organization_id => p_organization_id
1237: ,p_organization_name => NULL
1238: ,p_user_id => G_CURRENT_USER_ID
1239: ,p_party_id => NULL
1240: ,p_set_message => FND_API.G_TRUE
1241: ) THEN
1242: code_debug( l_api_name ||' user does not have privilege for '||l_priv_name_to_check);
1243: RAISE FND_API.G_EXC_ERROR;
1244: ELSE

Line 1243: RAISE FND_API.G_EXC_ERROR;

1239: ,p_party_id => NULL
1240: ,p_set_message => FND_API.G_TRUE
1241: ) THEN
1242: code_debug( l_api_name ||' user does not have privilege for '||l_priv_name_to_check);
1243: RAISE FND_API.G_EXC_ERROR;
1244: ELSE
1245: code_debug( l_api_name ||' user can perform the action '||l_priv_name_to_check);
1246: END IF;
1247: END IF;

Line 1271: RAISE FND_API.G_EXC_ERROR;

1267: WHERE proj_element_id = p_phase_id;
1268: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1269: fnd_message.Set_Token('PHASE', l_dummy_char);
1270: FND_MSG_PUB.Add;
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSE
1273: CLOSE c_get_def_status_code;
1274: END IF;
1275: ELSE

Line 1309: RAISE FND_API.G_EXC_ERROR;

1305: IF l_revision_id IS NULL THEN
1306: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');
1307: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: ELSE
1311: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1312: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1313: fnd_message.Set_Token('REVISION', l_revision);

Line 1315: RAISE FND_API.G_EXC_ERROR;

1311: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1312: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1313: fnd_message.Set_Token('REVISION', l_revision);
1314: FND_MSG_PUB.Add;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317: END IF; -- l_pending_rec_count
1318: END IF; -- NVL(l_phase_id_curr,-1) <> p_phase_id
1319: ELSE

Line 1355: RAISE FND_API.G_EXC_ERROR;

1351: FROM PA_EGO_PHASES_V
1352: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1353: fnd_message.Set_Token('PHASE', l_dummy_char);
1354: FND_MSG_PUB.Add;
1355: RAISE FND_API.G_EXC_ERROR;
1356: ELSE
1357: code_debug (l_api_name ||' checking for master controlled status ');
1358: l_is_master_org := get_master_org_status(p_organization_id);
1359: l_revision_master_controlled := FND_API.g_false;

Line 1359: l_revision_master_controlled := FND_API.g_false;

1355: RAISE FND_API.G_EXC_ERROR;
1356: ELSE
1357: code_debug (l_api_name ||' checking for master controlled status ');
1358: l_is_master_org := get_master_org_status(p_organization_id);
1359: l_revision_master_controlled := FND_API.g_false;
1360: l_status_master_controlled := get_master_controlled_status();
1361: IF ('T' = l_status_master_controlled) AND NOT ('T' = l_is_master_org) THEN
1362: IF l_status_code_itm <> l_status_code THEN
1363: code_debug (l_api_name ||' status changes controlled at master cannot change ');

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: IF l_status_code_itm <> l_status_code THEN
1363: code_debug (l_api_name ||' status changes controlled at master cannot change ');
1364: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');
1365: fnd_msg_pub.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: END IF; -- status is master controlled and we are in context of child org
1369: END IF; -- status is valid
1370: ELSE -- phase id null

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385: -- FROM PA_EGO_PHASES_V
1386: -- WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1387: -- fnd_message.Set_Token('PHASE', l_dummy_char);
1388: FND_MSG_PUB.Add;
1389: RAISE FND_API.G_EXC_ERROR;
1390: ELSE
1391: code_debug (l_api_name ||' checking for master controlled status ');
1392: l_is_master_org := get_master_org_status(p_organization_id);
1393: l_revision_master_controlled := FND_API.g_false;

Line 1393: l_revision_master_controlled := FND_API.g_false;

1389: RAISE FND_API.G_EXC_ERROR;
1390: ELSE
1391: code_debug (l_api_name ||' checking for master controlled status ');
1392: l_is_master_org := get_master_org_status(p_organization_id);
1393: l_revision_master_controlled := FND_API.g_false;
1394: l_status_master_controlled := get_master_controlled_status();
1395: IF ('T' = l_status_master_controlled) AND NOT ('T' = l_is_master_org) THEN
1396: IF l_status_code_itm <> l_status_code THEN
1397: code_debug (l_api_name ||' status changes controlled at master cannot change ');

Line 1400: RAISE FND_API.G_EXC_ERROR;

1396: IF l_status_code_itm <> l_status_code THEN
1397: code_debug (l_api_name ||' status changes controlled at master cannot change ');
1398: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');
1399: fnd_msg_pub.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF; -- status is master controlled and we are in context of child org
1403: END IF; -- status is valid
1404: /*Bug 14076356: swuppala:

Line 1461: IF FND_API.To_Boolean(p_commit) THEN

1457: ,p_change_id
1458: ,p_change_line_id
1459: );
1460:
1461: IF FND_API.To_Boolean(p_commit) THEN
1462: COMMIT WORK;
1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;
1465: EXCEPTION

Line 1464: x_return_status := FND_API.G_RET_STS_SUCCESS;

1460:
1461: IF FND_API.To_Boolean(p_commit) THEN
1462: COMMIT WORK;
1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;
1465: EXCEPTION
1466: WHEN FND_API.G_EXC_ERROR THEN
1467: IF FND_API.To_Boolean( p_commit ) THEN
1468: ROLLBACK TO Create_Pending_Phase_Change_SP;

Line 1466: WHEN FND_API.G_EXC_ERROR THEN

1462: COMMIT WORK;
1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;
1465: EXCEPTION
1466: WHEN FND_API.G_EXC_ERROR THEN
1467: IF FND_API.To_Boolean( p_commit ) THEN
1468: ROLLBACK TO Create_Pending_Phase_Change_SP;
1469: END IF;
1470: IF c_get_rev_details%ISOPEN THEN

Line 1467: IF FND_API.To_Boolean( p_commit ) THEN

1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;
1465: EXCEPTION
1466: WHEN FND_API.G_EXC_ERROR THEN
1467: IF FND_API.To_Boolean( p_commit ) THEN
1468: ROLLBACK TO Create_Pending_Phase_Change_SP;
1469: END IF;
1470: IF c_get_rev_details%ISOPEN THEN
1471: CLOSE c_get_rev_details;

Line 1482: x_return_status := FND_API.G_RET_STS_ERROR;

1478: END IF;
1479: IF c_validate_status_code%ISOPEN THEN
1480: CLOSE c_validate_status_code;
1481: END IF;
1482: x_return_status := FND_API.G_RET_STS_ERROR;
1483: WHEN OTHERS THEN
1484: IF FND_API.To_Boolean(p_commit) THEN
1485: ROLLBACK TO Create_Pending_Phase_Change_SP;
1486: END IF;

Line 1484: IF FND_API.To_Boolean(p_commit) THEN

1480: CLOSE c_validate_status_code;
1481: END IF;
1482: x_return_status := FND_API.G_RET_STS_ERROR;
1483: WHEN OTHERS THEN
1484: IF FND_API.To_Boolean(p_commit) THEN
1485: ROLLBACK TO Create_Pending_Phase_Change_SP;
1486: END IF;
1487: IF c_get_rev_details%ISOPEN THEN
1488: CLOSE c_get_rev_details;

Line 1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1495: END IF;
1496: IF c_validate_status_code%ISOPEN THEN
1497: CLOSE c_validate_status_code;
1498: END IF;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1501: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1502: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1503: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1540: l_miss_num := FND_API.G_MISS_NUM;

1536:
1537: BEGIN
1538: l_api_version := 1.0;
1539: l_api_name := 'Modify_Pending_Phase_Change';
1540: l_miss_num := FND_API.G_MISS_NUM;
1541: l_miss_char := FND_API.G_MISS_CHAR;
1542:
1543: IF FND_API.To_Boolean(p_commit) THEN
1544: SAVEPOINT Modify_Pending_Phase_Change_SP;

Line 1541: l_miss_char := FND_API.G_MISS_CHAR;

1537: BEGIN
1538: l_api_version := 1.0;
1539: l_api_name := 'Modify_Pending_Phase_Change';
1540: l_miss_num := FND_API.G_MISS_NUM;
1541: l_miss_char := FND_API.G_MISS_CHAR;
1542:
1543: IF FND_API.To_Boolean(p_commit) THEN
1544: SAVEPOINT Modify_Pending_Phase_Change_SP;
1545: END IF;

Line 1543: IF FND_API.To_Boolean(p_commit) THEN

1539: l_api_name := 'Modify_Pending_Phase_Change';
1540: l_miss_num := FND_API.G_MISS_NUM;
1541: l_miss_char := FND_API.G_MISS_CHAR;
1542:
1543: IF FND_API.To_Boolean(p_commit) THEN
1544: SAVEPOINT Modify_Pending_Phase_Change_SP;
1545: END IF;
1546:
1547: --Standard checks

Line 1548: IF NOT FND_API.Compatible_API_Call (l_api_version

1544: SAVEPOINT Modify_Pending_Phase_Change_SP;
1545: END IF;
1546:
1547: --Standard checks
1548: IF NOT FND_API.Compatible_API_Call (l_api_version
1549: ,p_api_version
1550: ,l_api_name
1551: ,g_pkg_name)
1552: THEN

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: ,p_api_version
1550: ,l_api_name
1551: ,g_pkg_name)
1552: THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1557: THEN

Line 1575: RAISE FND_API.G_EXC_ERROR;

1571: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1572: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1573: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1574: FND_MSG_PUB.Add;
1575: RAISE FND_API.G_EXC_ERROR;
1576: END IF;
1577:
1578: IF FND_API.To_Boolean(p_perform_security_check) THEN
1579: -- 4052565 perform security check

Line 1578: IF FND_API.To_Boolean(p_perform_security_check) THEN

1574: FND_MSG_PUB.Add;
1575: RAISE FND_API.G_EXC_ERROR;
1576: END IF;
1577:
1578: IF FND_API.To_Boolean(p_perform_security_check) THEN
1579: -- 4052565 perform security check
1580: l_priv_name_to_check := get_privlige_name_for_action
1581: (p_curr_item_id => p_inventory_item_id
1582: ,p_curr_org_id => p_organization_id

Line 1600: ,p_set_message => FND_API.G_TRUE

1596: ,p_organization_id => p_organization_id
1597: ,p_organization_name => NULL
1598: ,p_user_id => G_CURRENT_USER_ID
1599: ,p_party_id => NULL
1600: ,p_set_message => FND_API.G_TRUE
1601: ) THEN
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604: END IF;

Line 1602: RAISE FND_API.G_EXC_ERROR;

1598: ,p_user_id => G_CURRENT_USER_ID
1599: ,p_party_id => NULL
1600: ,p_set_message => FND_API.G_TRUE
1601: ) THEN
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604: END IF;
1605: END IF;
1606:

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: code_debug(l_api_name|| ' cannot update record!! ');
1630: -- no records found for update
1631: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_UPDATE');
1632: FND_MSG_PUB.Add;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN
1637: --

Line 1657: RAISE FND_API.G_EXC_ERROR;

1653: IF SQL%ROWCOUNT = 0 THEN
1654: -- no records found for delete
1655: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_DELETE');
1656: FND_MSG_PUB.Add;
1657: RAISE FND_API.G_EXC_ERROR;
1658: END IF;
1659:
1660: END IF;
1661:

Line 1663: WHEN FND_API.G_EXC_ERROR THEN

1659:
1660: END IF;
1661:
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_ERROR THEN
1664: IF FND_API.To_Boolean( p_commit ) THEN
1665: ROLLBACK TO Create_Pending_Phase_Change_SP;
1666: END IF;
1667: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1664: IF FND_API.To_Boolean( p_commit ) THEN

1660: END IF;
1661:
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_ERROR THEN
1664: IF FND_API.To_Boolean( p_commit ) THEN
1665: ROLLBACK TO Create_Pending_Phase_Change_SP;
1666: END IF;
1667: x_return_status := FND_API.G_RET_STS_ERROR;
1668:

Line 1667: x_return_status := FND_API.G_RET_STS_ERROR;

1663: WHEN FND_API.G_EXC_ERROR THEN
1664: IF FND_API.To_Boolean( p_commit ) THEN
1665: ROLLBACK TO Create_Pending_Phase_Change_SP;
1666: END IF;
1667: x_return_status := FND_API.G_RET_STS_ERROR;
1668:
1669: END Modify_Pending_Phase_change;
1670:
1671:

Line 1695: IF NOT FND_API.Compatible_API_Call (l_api_version

1691: BEGIN
1692: l_api_version := 1.0;
1693: l_api_name := 'Delete_Pending_Phase_Change';
1694: --Standard checks
1695: IF NOT FND_API.Compatible_API_Call (l_api_version
1696: ,p_api_version
1697: ,l_api_name
1698: ,g_pkg_name)
1699: THEN

Line 1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1696: ,p_api_version
1697: ,l_api_name
1698: ,g_pkg_name)
1699: THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702:
1703: IF ( (p_inventory_item_id IS NULL
1704: AND

Line 1712: x_return_status := FND_API.G_RET_STS_ERROR;

1708: )
1709: OR
1710: p_organization_id IS NULL
1711: ) THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: RETURN;
1714: END IF;
1715:
1716: IF FND_API.To_Boolean(p_commit) THEN

Line 1716: IF FND_API.To_Boolean(p_commit) THEN

1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713: RETURN;
1714: END IF;
1715:
1716: IF FND_API.To_Boolean(p_commit) THEN
1717: SAVEPOINT Delete_Pending_Phase_Change_SP;
1718: END IF;
1719:
1720: IF p_change_id IS NOT NULL THEN

Line 1805: IF FND_API.To_Boolean(p_commit) THEN

1801: END IF;
1802: END IF;
1803: END IF;
1804:
1805: IF FND_API.To_Boolean(p_commit) THEN
1806: COMMIT WORK;
1807: END IF;
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809:

Line 1808: x_return_status := FND_API.G_RET_STS_SUCCESS;

1804:
1805: IF FND_API.To_Boolean(p_commit) THEN
1806: COMMIT WORK;
1807: END IF;
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809:
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: IF FND_API.To_Boolean(p_commit) THEN

Line 1812: IF FND_API.To_Boolean(p_commit) THEN

1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809:
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: IF FND_API.To_Boolean(p_commit) THEN
1813: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1811: WHEN OTHERS THEN
1812: IF FND_API.To_Boolean(p_commit) THEN
1813: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1814: END IF;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1817: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1818: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1819: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1852: * l_commit := FND_API.G_TRUE;

1848: /* Fix for bug 11660573 - commenting the below code that hardcodes l_commit =
1849: * TRUE.
1850: * Hardcoding it to true was causing 'SAVEPOINT NEVER ESTABLISHED' exception
1851: * when any error was occuring in Implement_All_Pending_Changes() api.
1852: * l_commit := FND_API.G_TRUE;
1853: * */
1854: Implement_All_Pending_Changes
1855: (p_api_version => p_api_version
1856: ,p_commit => l_commit

Line 1913: IF NOT FND_API.Compatible_API_Call (l_api_version

1909: l_api_version := 1.0;
1910: l_api_name := 'Implement_Pending_Changes';
1911: code_debug(' Implement Pending Changes from Change area ');
1912: --Standard checks
1913: IF NOT FND_API.Compatible_API_Call (l_api_version
1914: ,p_api_version
1915: ,l_api_name
1916: ,g_pkg_name)
1917: THEN

Line 1918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1914: ,p_api_version
1915: ,l_api_name
1916: ,g_pkg_name)
1917: THEN
1918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1919: END IF;
1920:
1921: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1922: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

Line 1927: x_return_status := FND_API.G_RET_STS_ERROR;

1923: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1924: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1925: x_msg_data := FND_MESSAGE.get();
1926: x_msg_count := 1;
1927: x_return_status := FND_API.G_RET_STS_ERROR;
1928: RETURN;
1929: END IF;
1930:
1931: IF FND_API.To_Boolean(p_commit) THEN

Line 1931: IF FND_API.To_Boolean(p_commit) THEN

1927: x_return_status := FND_API.G_RET_STS_ERROR;
1928: RETURN;
1929: END IF;
1930:
1931: IF FND_API.To_Boolean(p_commit) THEN
1932: SAVEPOINT Implement_Pending_Changes_SP;
1933: END IF;
1934:
1935: l_revision_master_controlled := FND_API.g_false;

Line 1935: l_revision_master_controlled := FND_API.g_false;

1931: IF FND_API.To_Boolean(p_commit) THEN
1932: SAVEPOINT Implement_Pending_Changes_SP;
1933: END IF;
1934:
1935: l_revision_master_controlled := FND_API.g_false;
1936: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
1937:
1938: FOR l_item_record IN
1939: c_get_pending_items (cp_change_id => p_change_id

Line 1946: ,p_commit => FND_API.G_FALSE

1942:
1943: l_is_master_org := get_master_org_status(l_item_record.ORGANIZATION_ID);
1944: Implement_All_Pending_Changes
1945: (p_api_version => p_api_version
1946: ,p_commit => FND_API.G_FALSE
1947: ,p_inventory_item_id => l_item_record.INVENTORY_ITEM_ID
1948: ,p_organization_id => l_item_record.ORGANIZATION_ID
1949: ,p_revision_id => l_item_record.REVISION_ID
1950: ,p_change_id => p_change_id

Line 1961: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;

1957: ,x_errorcode => x_errorcode
1958: ,x_msg_count => x_msg_count
1959: ,x_msg_data => x_msg_data
1960: );
1961: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
1962: END LOOP;
1963:
1964: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1965: IF FND_API.To_Boolean(p_commit) THEN

Line 1964: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1960: );
1961: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
1962: END LOOP;
1963:
1964: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1965: IF FND_API.To_Boolean(p_commit) THEN
1966: COMMIT WORK;
1967: END IF;
1968: ELSE

Line 1965: IF FND_API.To_Boolean(p_commit) THEN

1961: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
1962: END LOOP;
1963:
1964: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1965: IF FND_API.To_Boolean(p_commit) THEN
1966: COMMIT WORK;
1967: END IF;
1968: ELSE
1969: IF x_msg_count <>1 THEN

Line 1971: p_encoded => FND_API.G_FALSE,

1967: END IF;
1968: ELSE
1969: IF x_msg_count <>1 THEN
1970: FND_MSG_PUB.Count_And_Get(
1971: p_encoded => FND_API.G_FALSE,
1972: p_count => x_msg_count,
1973: p_data => x_msg_data
1974: );
1975: END IF;

Line 1983: IF FND_API.To_Boolean(p_commit) THEN

1979: WHEN OTHERS THEN
1980: IF c_get_pending_items%ISOPEN THEN
1981: CLOSE c_get_pending_items;
1982: END IF;
1983: IF FND_API.To_Boolean(p_commit) THEN
1984: ROLLBACK TO Implement_Pending_Changes_SP;
1985: END IF;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1982: END IF;
1983: IF FND_API.To_Boolean(p_commit) THEN
1984: ROLLBACK TO Implement_Pending_Changes_SP;
1985: END IF;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1988: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1989: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1990: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1993: p_encoded => FND_API.G_FALSE,

1989: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1990: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1991: FND_MSG_PUB.Add;
1992: FND_MSG_PUB.Count_And_Get(
1993: p_encoded => FND_API.G_FALSE,
1994: p_count => x_msg_count,
1995: p_data => x_msg_data
1996: );
1997:

Line 2038: DECODE(LOOKUP_CODE2, 1, FND_API.G_TRUE, 2, FND_API.G_FALSE, FND_API.G_FALSE) INTO l_status_master_controlled

2034: BEGIN
2035:
2036: code_debug(' Implement Pending Changes from Concurrent Program ');
2037: SELECT
2038: DECODE(LOOKUP_CODE2, 1, FND_API.G_TRUE, 2, FND_API.G_FALSE, FND_API.G_FALSE) INTO l_status_master_controlled
2039: FROM
2040: MTL_ITEM_ATTRIBUTES_V
2041: WHERE
2042: ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

Line 2044: l_revision_master_controlled := FND_API.G_FALSE;

2040: MTL_ITEM_ATTRIBUTES_V
2041: WHERE
2042: ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
2043:
2044: l_revision_master_controlled := FND_API.G_FALSE;
2045:
2046: --If there is no organization id, then do everything
2047: IF p_organization_id IS NULL
2048: THEN

Line 2080: l_is_master_org := FND_API.G_FALSE;

2076: MTL_PARAMETERS MP
2077: WHERE
2078: MP.ORGANIZATION_ID = l_orgs(org_index);
2079:
2080: l_is_master_org := FND_API.G_FALSE;
2081:
2082: IF l_master_org = l_orgs(org_index)
2083: THEN
2084: l_is_master_org := FND_API.G_TRUE;

Line 2084: l_is_master_org := FND_API.G_TRUE;

2080: l_is_master_org := FND_API.G_FALSE;
2081:
2082: IF l_master_org = l_orgs(org_index)
2083: THEN
2084: l_is_master_org := FND_API.G_TRUE;
2085: END IF;
2086:
2087: --If item is null, then get them all
2088: IF p_inventory_item_id IS NULL

Line 2153: IF FND_API.To_Boolean(l_revision_master_controlled)

2149: IF l_revs(rev_index) IS NOT NULL
2150: THEN
2151:
2152: --Either the master or current
2153: IF FND_API.To_Boolean(l_revision_master_controlled)
2154: THEN
2155:
2156: SELECT
2157: REVISION_ID INTO l_revision_id

Line 2189: , p_perform_security_check => FND_API.G_FALSE

2185: , p_revision_id => l_revision_id
2186: , p_revision_master_controlled => l_revision_master_controlled
2187: , p_status_master_controlled => l_status_master_controlled
2188: , p_is_master_org => l_is_master_org
2189: , p_perform_security_check => FND_API.G_FALSE
2190: , x_return_status => l_return_status
2191: , x_errorcode => l_errorcode
2192: , x_msg_count => l_msg_count
2193: , x_msg_data => l_msg_data