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 482: IF FND_API.To_Boolean(p_commit) THEN

478: code_debug(' p_inventory_item_id :'||p_inventory_item_id||' p_organization_id : '||p_organization_id);
479: code_debug(' p_revision_id : '||p_revision_id||' p_revision_master_controlled: '||p_revision_master_controlled);
480: code_debug(' p_status_master_controlled : '||p_status_master_controlled||' p_is_master_org: '||p_is_master_org);
481:
482: IF FND_API.To_Boolean(p_commit) THEN
483: SAVEPOINT Implement_All_Pending_Changes;
484: END IF;
485:
486: --Standard checks

Line 487: IF NOT FND_API.Compatible_API_Call (l_api_version

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

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 533: ,p_lifecycle_changed => FND_API.G_FALSE

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

Line 534: ,p_lifecycle_phase_changed => FND_API.G_TRUE

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

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

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

Line 543: IF FND_API.To_Boolean(p_commit) THEN

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

Line 552: IF FND_API.TO_BOOLEAN(p_is_master_org) THEN

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

Line 558: IF FND_API.TO_BOOLEAN(p_status_master_controlled) THEN

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

Line 567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 568: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 583: IF (FND_API.TO_BOOLEAN(p_is_master_org)

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

Line 585: FND_API.TO_BOOLEAN(p_status_master_controlled) = FALSE

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

Line 587: IF (FND_API.TO_BOOLEAN(p_is_master_org)

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

Line 589: FND_API.TO_BOOLEAN(p_status_master_controlled) = TRUE

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

Line 595: IF FND_API.To_boolean(p_perform_security_check) THEN

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

Line 617: ,p_set_message => FND_API.G_TRUE

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

Line 619: RAISE FND_API.G_EXC_ERROR;

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

Line 635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 636: IF FND_API.To_Boolean( p_commit ) THEN

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

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

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

Line 663: IF FND_API.To_boolean(p_perform_security_check) THEN

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

Line 685: ,p_set_message => FND_API.G_TRUE

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

Line 687: RAISE FND_API.G_EXC_ERROR;

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

Line 703: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 704: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 739: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 816: ,p_set_message => FND_API.G_TRUE

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

Line 818: RAISE FND_API.G_EXC_ERROR;

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

Line 827: IF (FND_API.TO_BOOLEAN(p_revision_master_controlled)

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

Line 829: FND_API.TO_BOOLEAN(p_is_master_org)

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

Line 856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 857: IF FND_API.To_Boolean( p_commit ) THEN

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

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

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

Line 891: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 892: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 907: IF (FND_API.TO_BOOLEAN(p_is_master_org)

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

Line 909: FND_API.TO_BOOLEAN(p_revision_master_controlled) = FALSE

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

Line 924: IF FND_API.To_Boolean(p_commit) THEN

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

Line 929: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 932: WHEN FND_API.G_EXC_ERROR THEN

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

Line 933: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 936: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 938: p_encoded => FND_API.G_FALSE,

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

Line 943: IF FND_API.To_Boolean(p_commit) THEN

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

Line 952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 973: l_status_master_controlled := FND_API.G_FALSE;

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

Line 975: 1, FND_API.G_TRUE,

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

Line 976: 2, FND_API.G_FALSE,

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

Line 977: FND_API.G_FALSE)

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

Line 994: l_is_master_org := FND_API.G_FALSE;

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

Line 996: MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,

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

Line 997: FND_API.G_FALSE)

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

Line 1120: IF FND_API.To_Boolean(p_commit) THEN

1116:
1117: l_api_version := 1.0;
1118: l_api_name := 'Create_Pending_Phase_Change';
1119:
1120: IF FND_API.To_Boolean(p_commit) THEN
1121: SAVEPOINT Create_Pending_Phase_Change_SP;
1122: END IF;
1123: code_debug( l_api_name ||' started with params');
1124: code_debug( l_api_name ||' p_inventory_item_id '|| p_inventory_item_id ||' p_organization_id '|| p_organization_id || ' p_revision '|| p_revision);

Line 1129: IF NOT FND_API.Compatible_API_Call (l_api_version

1125: code_debug( l_api_name ||' p_lifecycle_id '|| p_lifecycle_id ||' p_phase_id '|| p_phase_id ||' p_status_code '|| p_status_code);
1126: 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);
1127:
1128: --Standard checks
1129: IF NOT FND_API.Compatible_API_Call (l_api_version
1130: ,p_api_version
1131: ,l_api_name
1132: ,g_pkg_name)
1133: THEN

Line 1134: RAISE FND_API.G_EXC_ERROR;

1130: ,p_api_version
1131: ,l_api_name
1132: ,g_pkg_name)
1133: THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:
1137: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1138: THEN

Line 1155: RAISE FND_API.G_EXC_ERROR;

1151: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1152: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1153: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:
1158: l_revision := p_revision;
1159: l_revision_id := p_revision_id;

Line 1204: RAISE FND_API.G_EXC_ERROR;

1200: FROM hr_all_organization_units_vl
1201: WHERE organization_id = p_organization_id;
1202: fnd_message.set_token('ORGANIZATION', l_dummy_char);
1203: fnd_msg_pub.Add;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206:
1207: IF FND_API.To_Boolean(p_perform_security_check) THEN
1208: code_debug( l_api_name ||' need to perform security check ');

Line 1207: IF FND_API.To_Boolean(p_perform_security_check) THEN

1203: fnd_msg_pub.Add;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206:
1207: IF FND_API.To_Boolean(p_perform_security_check) THEN
1208: code_debug( l_api_name ||' need to perform security check ');
1209: -- 4052565 perform security check
1210: l_priv_name_to_check := get_privlige_name_for_action
1211: (p_curr_item_id => p_inventory_item_id

Line 1231: ,p_set_message => FND_API.G_TRUE

1227: ,p_organization_id => p_organization_id
1228: ,p_organization_name => NULL
1229: ,p_user_id => G_CURRENT_USER_ID
1230: ,p_party_id => NULL
1231: ,p_set_message => FND_API.G_TRUE
1232: ) THEN
1233: code_debug( l_api_name ||' user does not have privilege for '||l_priv_name_to_check);
1234: RAISE FND_API.G_EXC_ERROR;
1235: ELSE

Line 1234: RAISE FND_API.G_EXC_ERROR;

1230: ,p_party_id => NULL
1231: ,p_set_message => FND_API.G_TRUE
1232: ) THEN
1233: code_debug( l_api_name ||' user does not have privilege for '||l_priv_name_to_check);
1234: RAISE FND_API.G_EXC_ERROR;
1235: ELSE
1236: code_debug( l_api_name ||' user can perform the action '||l_priv_name_to_check);
1237: END IF;
1238: END IF;

Line 1262: RAISE FND_API.G_EXC_ERROR;

1258: WHERE proj_element_id = p_phase_id;
1259: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1260: fnd_message.Set_Token('PHASE', l_dummy_char);
1261: FND_MSG_PUB.Add;
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSE
1264: CLOSE c_get_def_status_code;
1265: END IF;
1266: ELSE

Line 1300: RAISE FND_API.G_EXC_ERROR;

1296: IF l_revision_id IS NULL THEN
1297: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_PENDING_PHASE_CHANGE');
1298: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR;
1301: ELSE
1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1303: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1304: fnd_message.Set_Token('REVISION', l_revision);

Line 1306: RAISE FND_API.G_EXC_ERROR;

1302: fnd_message.Set_Name(G_APP_NAME, 'EGO_REV_PENDING_PHASE_CHANGE');
1303: fnd_message.Set_Token('ITEM_NUMBER', l_dummy_char);
1304: fnd_message.Set_Token('REVISION', l_revision);
1305: FND_MSG_PUB.Add;
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: END IF; -- l_pending_rec_count
1309: END IF; -- NVL(l_phase_id_curr,-1) <> p_phase_id
1310: ELSE

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328: FROM PA_EGO_PHASES_V
1329: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1330: fnd_message.Set_Token('PHASE', l_dummy_char);
1331: FND_MSG_PUB.Add;
1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSE
1334: code_debug (l_api_name ||' checking for master controlled status ');
1335: l_is_master_org := get_master_org_status(p_organization_id);
1336: l_revision_master_controlled := FND_API.g_false;

Line 1336: l_revision_master_controlled := FND_API.g_false;

1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSE
1334: code_debug (l_api_name ||' checking for master controlled status ');
1335: l_is_master_org := get_master_org_status(p_organization_id);
1336: l_revision_master_controlled := FND_API.g_false;
1337: l_status_master_controlled := get_master_controlled_status();
1338: IF ('T' = l_status_master_controlled) AND NOT ('T' = l_is_master_org) THEN
1339: IF l_status_code_itm <> l_status_code THEN
1340: code_debug (l_api_name ||' status changes controlled at master cannot change ');

Line 1343: RAISE FND_API.G_EXC_ERROR;

1339: IF l_status_code_itm <> l_status_code THEN
1340: code_debug (l_api_name ||' status changes controlled at master cannot change ');
1341: fnd_message.Set_Name(G_APP_NAME,'EGO_ITEM_STATUS_MC');
1342: fnd_msg_pub.Add;
1343: RAISE FND_API.G_EXC_ERROR;
1344: END IF;
1345: END IF; -- status is master controlled and we are in context of child org
1346: END IF; -- status is valid
1347: ELSE

Line 1399: IF FND_API.To_Boolean(p_commit) THEN

1395: ,p_change_id
1396: ,p_change_line_id
1397: );
1398:
1399: IF FND_API.To_Boolean(p_commit) THEN
1400: COMMIT WORK;
1401: END IF;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: EXCEPTION

Line 1402: x_return_status := FND_API.G_RET_STS_SUCCESS;

1398:
1399: IF FND_API.To_Boolean(p_commit) THEN
1400: COMMIT WORK;
1401: END IF;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: EXCEPTION
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: IF FND_API.To_Boolean( p_commit ) THEN
1406: ROLLBACK TO Create_Pending_Phase_Change_SP;

Line 1404: WHEN FND_API.G_EXC_ERROR THEN

1400: COMMIT WORK;
1401: END IF;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: EXCEPTION
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: IF FND_API.To_Boolean( p_commit ) THEN
1406: ROLLBACK TO Create_Pending_Phase_Change_SP;
1407: END IF;
1408: IF c_get_rev_details%ISOPEN THEN

Line 1405: IF FND_API.To_Boolean( p_commit ) THEN

1401: END IF;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: EXCEPTION
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: IF FND_API.To_Boolean( p_commit ) THEN
1406: ROLLBACK TO Create_Pending_Phase_Change_SP;
1407: END IF;
1408: IF c_get_rev_details%ISOPEN THEN
1409: CLOSE c_get_rev_details;

Line 1420: x_return_status := FND_API.G_RET_STS_ERROR;

1416: END IF;
1417: IF c_validate_status_code%ISOPEN THEN
1418: CLOSE c_validate_status_code;
1419: END IF;
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: WHEN OTHERS THEN
1422: IF FND_API.To_Boolean(p_commit) THEN
1423: ROLLBACK TO Create_Pending_Phase_Change_SP;
1424: END IF;

Line 1422: IF FND_API.To_Boolean(p_commit) THEN

1418: CLOSE c_validate_status_code;
1419: END IF;
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: WHEN OTHERS THEN
1422: IF FND_API.To_Boolean(p_commit) THEN
1423: ROLLBACK TO Create_Pending_Phase_Change_SP;
1424: END IF;
1425: IF c_get_rev_details%ISOPEN THEN
1426: CLOSE c_get_rev_details;

Line 1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1433: END IF;
1434: IF c_validate_status_code%ISOPEN THEN
1435: CLOSE c_validate_status_code;
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1439: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1440: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1441: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1478: l_miss_num := FND_API.G_MISS_NUM;

1474:
1475: BEGIN
1476: l_api_version := 1.0;
1477: l_api_name := 'Modify_Pending_Phase_Change';
1478: l_miss_num := FND_API.G_MISS_NUM;
1479: l_miss_char := FND_API.G_MISS_CHAR;
1480:
1481: IF FND_API.To_Boolean(p_commit) THEN
1482: SAVEPOINT Modify_Pending_Phase_Change_SP;

Line 1479: l_miss_char := FND_API.G_MISS_CHAR;

1475: BEGIN
1476: l_api_version := 1.0;
1477: l_api_name := 'Modify_Pending_Phase_Change';
1478: l_miss_num := FND_API.G_MISS_NUM;
1479: l_miss_char := FND_API.G_MISS_CHAR;
1480:
1481: IF FND_API.To_Boolean(p_commit) THEN
1482: SAVEPOINT Modify_Pending_Phase_Change_SP;
1483: END IF;

Line 1481: IF FND_API.To_Boolean(p_commit) THEN

1477: l_api_name := 'Modify_Pending_Phase_Change';
1478: l_miss_num := FND_API.G_MISS_NUM;
1479: l_miss_char := FND_API.G_MISS_CHAR;
1480:
1481: IF FND_API.To_Boolean(p_commit) THEN
1482: SAVEPOINT Modify_Pending_Phase_Change_SP;
1483: END IF;
1484:
1485: --Standard checks

Line 1486: IF NOT FND_API.Compatible_API_Call (l_api_version

1482: SAVEPOINT Modify_Pending_Phase_Change_SP;
1483: END IF;
1484:
1485: --Standard checks
1486: IF NOT FND_API.Compatible_API_Call (l_api_version
1487: ,p_api_version
1488: ,l_api_name
1489: ,g_pkg_name)
1490: THEN

Line 1491: RAISE FND_API.G_EXC_ERROR;

1487: ,p_api_version
1488: ,l_api_name
1489: ,g_pkg_name)
1490: THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1495: THEN

Line 1513: RAISE FND_API.G_EXC_ERROR;

1509: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
1510: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
1511: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:
1516: IF FND_API.To_Boolean(p_perform_security_check) THEN
1517: -- 4052565 perform security check

Line 1516: IF FND_API.To_Boolean(p_perform_security_check) THEN

1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:
1516: IF FND_API.To_Boolean(p_perform_security_check) THEN
1517: -- 4052565 perform security check
1518: l_priv_name_to_check := get_privlige_name_for_action
1519: (p_curr_item_id => p_inventory_item_id
1520: ,p_curr_org_id => p_organization_id

Line 1538: ,p_set_message => FND_API.G_TRUE

1534: ,p_organization_id => p_organization_id
1535: ,p_organization_name => NULL
1536: ,p_user_id => G_CURRENT_USER_ID
1537: ,p_party_id => NULL
1538: ,p_set_message => FND_API.G_TRUE
1539: ) THEN
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: END IF;

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: ,p_user_id => G_CURRENT_USER_ID
1537: ,p_party_id => NULL
1538: ,p_set_message => FND_API.G_TRUE
1539: ) THEN
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: END IF;
1543: END IF;
1544:

Line 1571: RAISE FND_API.G_EXC_ERROR;

1567: code_debug(l_api_name|| ' cannot update record!! ');
1568: -- no records found for update
1569: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_UPDATE');
1570: FND_MSG_PUB.Add;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN
1575: --

Line 1595: RAISE FND_API.G_EXC_ERROR;

1591: IF SQL%ROWCOUNT = 0 THEN
1592: -- no records found for delete
1593: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_DELETE');
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597:
1598: END IF;
1599:

Line 1601: WHEN FND_API.G_EXC_ERROR THEN

1597:
1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: IF FND_API.To_Boolean( p_commit ) THEN
1603: ROLLBACK TO Create_Pending_Phase_Change_SP;
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1602: IF FND_API.To_Boolean( p_commit ) THEN

1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: IF FND_API.To_Boolean( p_commit ) THEN
1603: ROLLBACK TO Create_Pending_Phase_Change_SP;
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606:

Line 1605: x_return_status := FND_API.G_RET_STS_ERROR;

1601: WHEN FND_API.G_EXC_ERROR THEN
1602: IF FND_API.To_Boolean( p_commit ) THEN
1603: ROLLBACK TO Create_Pending_Phase_Change_SP;
1604: END IF;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606:
1607: END Modify_Pending_Phase_change;
1608:
1609:

Line 1633: IF NOT FND_API.Compatible_API_Call (l_api_version

1629: BEGIN
1630: l_api_version := 1.0;
1631: l_api_name := 'Delete_Pending_Phase_Change';
1632: --Standard checks
1633: IF NOT FND_API.Compatible_API_Call (l_api_version
1634: ,p_api_version
1635: ,l_api_name
1636: ,g_pkg_name)
1637: THEN

Line 1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1634: ,p_api_version
1635: ,l_api_name
1636: ,g_pkg_name)
1637: THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: IF ( (p_inventory_item_id IS NULL
1642: AND

Line 1650: x_return_status := FND_API.G_RET_STS_ERROR;

1646: )
1647: OR
1648: p_organization_id IS NULL
1649: ) THEN
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: RETURN;
1652: END IF;
1653:
1654: IF FND_API.To_Boolean(p_commit) THEN

Line 1654: IF FND_API.To_Boolean(p_commit) THEN

1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: RETURN;
1652: END IF;
1653:
1654: IF FND_API.To_Boolean(p_commit) THEN
1655: SAVEPOINT Delete_Pending_Phase_Change_SP;
1656: END IF;
1657:
1658: IF p_change_id IS NOT NULL THEN

Line 1743: IF FND_API.To_Boolean(p_commit) THEN

1739: END IF;
1740: END IF;
1741: END IF;
1742:
1743: IF FND_API.To_Boolean(p_commit) THEN
1744: COMMIT WORK;
1745: END IF;
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:

Line 1746: x_return_status := FND_API.G_RET_STS_SUCCESS;

1742:
1743: IF FND_API.To_Boolean(p_commit) THEN
1744: COMMIT WORK;
1745: END IF;
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF FND_API.To_Boolean(p_commit) THEN

Line 1750: IF FND_API.To_Boolean(p_commit) THEN

1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF FND_API.To_Boolean(p_commit) THEN
1751: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1752: END IF;
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1749: WHEN OTHERS THEN
1750: IF FND_API.To_Boolean(p_commit) THEN
1751: ROLLBACK TO Delete_Pending_Phase_Change_SP;
1752: END IF;
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1755: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1756: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1757: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1786: l_commit := FND_API.G_TRUE;

1782: --
1783: -- existing functionality is doing a commit always
1784: --
1785: code_debug(' Implement Pending Changes from Projects area item id '||p_inventory_item_id||' org id '||p_organization_id||' rev id '||p_revision_id);
1786: l_commit := FND_API.G_TRUE;
1787: Implement_All_Pending_Changes
1788: (p_api_version => p_api_version
1789: ,p_commit => l_commit
1790: ,p_inventory_item_id => p_inventory_item_id

Line 1846: IF NOT FND_API.Compatible_API_Call (l_api_version

1842: l_api_version := 1.0;
1843: l_api_name := 'Implement_Pending_Changes';
1844: code_debug(' Implement Pending Changes from Change area ');
1845: --Standard checks
1846: IF NOT FND_API.Compatible_API_Call (l_api_version
1847: ,p_api_version
1848: ,l_api_name
1849: ,g_pkg_name)
1850: THEN

Line 1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1847: ,p_api_version
1848: ,l_api_name
1849: ,g_pkg_name)
1850: THEN
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1852: END IF;
1853:
1854: IF (p_change_id IS NULL AND p_change_line_id IS NULL) THEN
1855: FND_MESSAGE.Set_name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

Line 1860: x_return_status := FND_API.G_RET_STS_ERROR;

1856: FND_MESSAGE.Set_token('PKG_NAME', G_PKG_NAME);
1857: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
1858: x_msg_data := FND_MESSAGE.get();
1859: x_msg_count := 1;
1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: RETURN;
1862: END IF;
1863:
1864: IF FND_API.To_Boolean(p_commit) THEN

Line 1864: IF FND_API.To_Boolean(p_commit) THEN

1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: RETURN;
1862: END IF;
1863:
1864: IF FND_API.To_Boolean(p_commit) THEN
1865: SAVEPOINT Implement_Pending_Changes_SP;
1866: END IF;
1867:
1868: l_revision_master_controlled := FND_API.g_false;

Line 1868: l_revision_master_controlled := FND_API.g_false;

1864: IF FND_API.To_Boolean(p_commit) THEN
1865: SAVEPOINT Implement_Pending_Changes_SP;
1866: END IF;
1867:
1868: l_revision_master_controlled := FND_API.g_false;
1869: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
1870:
1871: FOR l_item_record IN
1872: c_get_pending_items (cp_change_id => p_change_id

Line 1879: ,p_commit => FND_API.G_FALSE

1875:
1876: l_is_master_org := get_master_org_status(l_item_record.ORGANIZATION_ID);
1877: Implement_All_Pending_Changes
1878: (p_api_version => p_api_version
1879: ,p_commit => FND_API.G_FALSE
1880: ,p_inventory_item_id => l_item_record.INVENTORY_ITEM_ID
1881: ,p_organization_id => l_item_record.ORGANIZATION_ID
1882: ,p_revision_id => l_item_record.REVISION_ID
1883: ,p_change_id => p_change_id

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

1890: ,x_errorcode => x_errorcode
1891: ,x_msg_count => x_msg_count
1892: ,x_msg_data => x_msg_data
1893: );
1894: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
1895: END LOOP;
1896:
1897: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1898: IF FND_API.To_Boolean(p_commit) THEN

Line 1897: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1893: );
1894: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
1895: END LOOP;
1896:
1897: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1898: IF FND_API.To_Boolean(p_commit) THEN
1899: COMMIT WORK;
1900: END IF;
1901: ELSE

Line 1898: IF FND_API.To_Boolean(p_commit) THEN

1894: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
1895: END LOOP;
1896:
1897: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1898: IF FND_API.To_Boolean(p_commit) THEN
1899: COMMIT WORK;
1900: END IF;
1901: ELSE
1902: IF x_msg_count <>1 THEN

Line 1904: p_encoded => FND_API.G_FALSE,

1900: END IF;
1901: ELSE
1902: IF x_msg_count <>1 THEN
1903: FND_MSG_PUB.Count_And_Get(
1904: p_encoded => FND_API.G_FALSE,
1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );
1908: END IF;

Line 1916: IF FND_API.To_Boolean(p_commit) THEN

1912: WHEN OTHERS THEN
1913: IF c_get_pending_items%ISOPEN THEN
1914: CLOSE c_get_pending_items;
1915: END IF;
1916: IF FND_API.To_Boolean(p_commit) THEN
1917: ROLLBACK TO Implement_Pending_Changes_SP;
1918: END IF;
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1915: END IF;
1916: IF FND_API.To_Boolean(p_commit) THEN
1917: ROLLBACK TO Implement_Pending_Changes_SP;
1918: END IF;
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1921: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1926: p_encoded => FND_API.G_FALSE,

1922: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1923: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1924: FND_MSG_PUB.Add;
1925: FND_MSG_PUB.Count_And_Get(
1926: p_encoded => FND_API.G_FALSE,
1927: p_count => x_msg_count,
1928: p_data => x_msg_data
1929: );
1930:

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

1967: BEGIN
1968:
1969: code_debug(' Implement Pending Changes from Concurrent Program ');
1970: SELECT
1971: DECODE(LOOKUP_CODE2, 1, FND_API.G_TRUE, 2, FND_API.G_FALSE, FND_API.G_FALSE) INTO l_status_master_controlled
1972: FROM
1973: MTL_ITEM_ATTRIBUTES_V
1974: WHERE
1975: ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

Line 1977: l_revision_master_controlled := FND_API.G_FALSE;

1973: MTL_ITEM_ATTRIBUTES_V
1974: WHERE
1975: ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
1976:
1977: l_revision_master_controlled := FND_API.G_FALSE;
1978:
1979: --If there is no organization id, then do everything
1980: IF p_organization_id IS NULL
1981: THEN

Line 2013: l_is_master_org := FND_API.G_FALSE;

2009: MTL_PARAMETERS MP
2010: WHERE
2011: MP.ORGANIZATION_ID = l_orgs(org_index);
2012:
2013: l_is_master_org := FND_API.G_FALSE;
2014:
2015: IF l_master_org = l_orgs(org_index)
2016: THEN
2017: l_is_master_org := FND_API.G_TRUE;

Line 2017: l_is_master_org := FND_API.G_TRUE;

2013: l_is_master_org := FND_API.G_FALSE;
2014:
2015: IF l_master_org = l_orgs(org_index)
2016: THEN
2017: l_is_master_org := FND_API.G_TRUE;
2018: END IF;
2019:
2020: --If item is null, then get them all
2021: IF p_inventory_item_id IS NULL

Line 2086: IF FND_API.To_Boolean(l_revision_master_controlled)

2082: IF l_revs(rev_index) IS NOT NULL
2083: THEN
2084:
2085: --Either the master or current
2086: IF FND_API.To_Boolean(l_revision_master_controlled)
2087: THEN
2088:
2089: SELECT
2090: REVISION_ID INTO l_revision_id

Line 2122: , p_perform_security_check => FND_API.G_FALSE

2118: , p_revision_id => l_revision_id
2119: , p_revision_master_controlled => l_revision_master_controlled
2120: , p_status_master_controlled => l_status_master_controlled
2121: , p_is_master_org => l_is_master_org
2122: , p_perform_security_check => FND_API.G_FALSE
2123: , x_return_status => l_return_status
2124: , x_errorcode => l_errorcode
2125: , x_msg_count => l_msg_count
2126: , x_msg_data => l_msg_data