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

Line 127: l_product_exists := FND_API.G_RET_STS_SUCCESS;

123: INTO l_count
124: FROM eng_change_mgmt_types_vl
125: WHERE disable_flag = 'N';
126: IF l_count <> 0 THEN
127: l_product_exists := FND_API.G_RET_STS_SUCCESS;
128: END IF;
129: END IF;
130: RETURN (l_product_exists);
131: EXCEPTION

Line 140: RETURN FND_API.G_RET_STS_SUCCESS;

136: RETURN (l_product_exists);*/
137:
138: l_product_exists := EGO_COMMON_PVT.Is_EGO_Installed(1.0, '');
139: IF (l_product_exists = 'T') THEN
140: RETURN FND_API.G_RET_STS_SUCCESS;
141: ELSE
142: RETURN FND_API.G_RET_STS_ERROR;
143: END IF;
144: EXCEPTION

Line 142: RETURN FND_API.G_RET_STS_ERROR;

138: l_product_exists := EGO_COMMON_PVT.Is_EGO_Installed(1.0, '');
139: IF (l_product_exists = 'T') THEN
140: RETURN FND_API.G_RET_STS_SUCCESS;
141: ELSE
142: RETURN FND_API.G_RET_STS_ERROR;
143: END IF;
144: EXCEPTION
145: WHEN OTHERS THEN
146: RETURN FND_API.G_RET_STS_ERROR;

Line 146: RETURN FND_API.G_RET_STS_ERROR;

142: RETURN FND_API.G_RET_STS_ERROR;
143: END IF;
144: EXCEPTION
145: WHEN OTHERS THEN
146: RETURN FND_API.G_RET_STS_ERROR;
147:
148: END Check_CM_Existance;
149:
150: ----------------------------------------------------------------------

Line 161: IF (Check_CM_Existance() = FND_API.G_RET_STS_SUCCESS) THEN

157: l_dynamic_sql VARCHAR2(2000);
158:
159: BEGIN
160: l_change_notice := NULL;
161: IF (Check_CM_Existance() = FND_API.G_RET_STS_SUCCESS) THEN
162: IF (p_change_id IS NULL) THEN
163: l_change_notice := NULL;
164: ELSE
165: --Bug#5043988 : Literal Fix

Line 183: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

179: PROCEDURE Check_Delete_Project_OK
180: (
181: p_api_version IN NUMBER
182: , p_project_id IN NUMBER
183: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
184: , x_delete_ok OUT NOCOPY VARCHAR2
185: , x_return_status OUT NOCOPY VARCHAR2
186: , x_errorcode OUT NOCOPY NUMBER
187: , x_msg_count OUT NOCOPY NUMBER

Line 202: IF NOT FND_API.Compatible_API_Call (l_api_version

198:
199: l_api_version := 1.0;
200: l_api_name := 'Check_Delete_Project_OK';
201: --Standard checks
202: IF NOT FND_API.Compatible_API_Call (l_api_version
203: ,p_api_version
204: ,l_api_name
205: ,g_pkg_name)
206: THEN

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: ,p_api_version
204: ,l_api_name
205: ,g_pkg_name)
206: THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: -- Initialize message list if p_init_msg_list is set to TRUE
211: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 211: IF FND_API.To_Boolean(p_init_msg_list) THEN

207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: -- Initialize message list if p_init_msg_list is set to TRUE
211: IF FND_API.To_Boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.Initialize;
213: END IF;
214:
215: --Check if there are any entries for it in EGO_ITEM_PROJECTS

Line 225: x_delete_ok := FND_API.G_FALSE;

221: PROJECT_ID = p_project_id;
222:
223: IF (l_count > 0)
224: THEN
225: x_delete_ok := FND_API.G_FALSE;
226: l_message := 'EGO_ITEM_ASSOCIATED_PR';
227: END IF;
228:
229: IF (l_message IS NOT NULL)

Line 234: p_encoded => FND_API.G_FALSE,

230: THEN
231: FND_MESSAGE.Set_Name(g_app_name, l_message);
232: FND_MSG_PUB.Add;
233: FND_MSG_PUB.Count_And_Get(
234: p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: x_return_status := FND_API.G_RET_STS_ERROR;

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234: p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: ELSE
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: END IF;
242:

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: p_data => x_msg_data
237: );
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: ELSE
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: END IF;
242:
243: EXCEPTION
244: WHEN OTHERS THEN

Line 245: x_delete_ok := FND_API.G_FALSE;

241: END IF;
242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: x_delete_ok := FND_API.G_FALSE;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: x_delete_ok := FND_API.G_FALSE;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 253: p_encoded => FND_API.G_FALSE,

249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
251: FND_MSG_PUB.Add;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data
256: );
257:

Line 371: IF NOT FND_API.Compatible_API_Call (l_api_version

367: l_attribute_code := 'PROMOTE_DEMOTE';
368: code_debug (l_api_name ||' started project id '|| p_project_id ||' item id '||p_inventory_item_id||' organization id '||p_organization_id||' curr phase id '||p_curr_phase_id ||' future phase id '||p_future_phase_id);
369:
370: --Standard checks
371: IF NOT FND_API.Compatible_API_Call (l_api_version
372: ,p_api_version
373: ,l_api_name
374: ,g_pkg_name)
375: THEN

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

372: ,p_api_version
373: ,l_api_name
374: ,g_pkg_name)
375: THEN
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: END IF;
378:
379: -- First we need to determine the phase change code if it isn't passed in
380: IF (p_phase_change_code IS NULL)

Line 462: IF (Check_CM_Existance() = FND_API.G_RET_STS_SUCCESS) THEN

458: ELSIF (l_phase_change_code = g_promote) THEN
459: l_attr_num := 1;
460: END IF;
461:
462: IF (Check_CM_Existance() = FND_API.G_RET_STS_SUCCESS) THEN
463: /*ENG_CHANGE_POLICY_PKG.GetChangePolicy
464: ( p_policy_object_name => l_policy_object_name
465: , p_policy_code => l_policy_code
466: , p_policy_pk1_value => l_catalog_category_id

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: WHEN OTHERS THEN
525: IF c_get_assoc_category_id%ISOPEN THEN
526: CLOSE c_get_assoc_category_id;
527: END IF;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
530: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 535: p_encoded => FND_API.G_FALSE,

531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
533: FND_MSG_PUB.Add;
534: FND_MSG_PUB.Count_And_Get(
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539:

Line 610: IF NOT FND_API.Compatible_API_Call (l_api_version

606:
607: l_api_version := 1.0;
608: l_api_name := 'Check_Lc_Tracking_Project';
609: --Standard checks
610: IF NOT FND_API.Compatible_API_Call (l_api_version
611: ,p_api_version
612: ,l_api_name
613: ,g_pkg_name)
614: THEN

Line 615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

611: ,p_api_version
612: ,l_api_name
613: ,g_pkg_name)
614: THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;
617:
618: -- This procedure returns TRUE if and only if the project ID
619: -- passed in belongs to a project that is:

Line 631: x_is_lifecycle_tracking := FND_API.G_TRUE;

627: AND ASSOCIATION_CODE = g_lifecycle_tracking_code
628: AND ROWNUM = 1;
629:
630: IF (l_count > 0) THEN
631: x_is_lifecycle_tracking := FND_API.G_TRUE;
632: ELSE
633: x_is_lifecycle_tracking := FND_API.G_FALSE;
634: END IF;
635:

Line 633: x_is_lifecycle_tracking := FND_API.G_FALSE;

629:
630: IF (l_count > 0) THEN
631: x_is_lifecycle_tracking := FND_API.G_TRUE;
632: ELSE
633: x_is_lifecycle_tracking := FND_API.G_FALSE;
634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
640: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 645: p_encoded => FND_API.G_FALSE,

641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
643: FND_MSG_PUB.Add;
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649:

Line 658: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

654: PROCEDURE Delete_All_Item_Assocs
655: (
656: p_api_version IN NUMBER
657: , p_project_id IN NUMBER
658: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
659: , x_return_status OUT NOCOPY VARCHAR2
660: , x_errorcode OUT NOCOPY NUMBER
661: , x_msg_count OUT NOCOPY NUMBER
662: , x_msg_data OUT NOCOPY VARCHAR2

Line 678: IF NOT FND_API.Compatible_API_Call (l_api_version

674:
675: l_api_version := 1.0;
676: l_api_name := 'Delete_All_Item_Assocs';
677: --Standard checks
678: IF NOT FND_API.Compatible_API_Call (l_api_version
679: ,p_api_version
680: ,l_api_name
681: ,g_pkg_name)
682: THEN

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

679: ,p_api_version
680: ,l_api_name
681: ,g_pkg_name)
682: THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF;
685:
686: -- 4052565 perform security check
687: FOR l_item_projs IN c_item_project(cp_project_id => p_project_id) LOOP

Line 696: ,p_set_message => FND_API.G_TRUE

692: ,p_organization_id => l_item_projs.organization_id
693: ,p_organization_name => NULL
694: ,p_user_id => NULL
695: ,p_party_id => NULL
696: ,p_set_message => FND_API.G_TRUE
697: ) THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MSG_PUB.Count_And_Get(
700: p_encoded => FND_API.G_FALSE,

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: ,p_user_id => NULL
695: ,p_party_id => NULL
696: ,p_set_message => FND_API.G_TRUE
697: ) THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MSG_PUB.Count_And_Get(
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data

Line 700: p_encoded => FND_API.G_FALSE,

696: ,p_set_message => FND_API.G_TRUE
697: ) THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MSG_PUB.Count_And_Get(
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704: RETURN;

Line 712: IF FND_API.To_Boolean(p_commit)

708: FROM EGO_ITEM_PROJECTS
709: WHERE PROJECT_ID = p_project_id;
710:
711: -- Standard check of p_commit.
712: IF FND_API.To_Boolean(p_commit)
713: THEN
714: COMMIT WORK;
715: END IF;
716:

Line 717: x_return_status := FND_API.G_RET_STS_SUCCESS;

713: THEN
714: COMMIT WORK;
715: END IF;
716:
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: EXCEPTION
720: WHEN NO_DATA_FOUND THEN
721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 721: x_return_status := FND_API.G_RET_STS_SUCCESS;

717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: EXCEPTION
720: WHEN NO_DATA_FOUND THEN
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: WHEN OTHERS THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: EXCEPTION
720: WHEN NO_DATA_FOUND THEN
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: WHEN OTHERS THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 730: p_encoded => FND_API.G_FALSE,

726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
728: FND_MSG_PUB.Add;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
733: );
734:

Line 746: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

742: , p_project_id IN NUMBER
743: , p_lifecycle_id IN NUMBER
744: , p_phase_id IN NUMBER
745: , p_effective_date IN DATE
746: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
747: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
748: , x_return_status OUT NOCOPY VARCHAR2
749: , x_errorcode OUT NOCOPY NUMBER
750: , x_msg_count OUT NOCOPY NUMBER

Line 747: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

743: , p_lifecycle_id IN NUMBER
744: , p_phase_id IN NUMBER
745: , p_effective_date IN DATE
746: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
747: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
748: , x_return_status OUT NOCOPY VARCHAR2
749: , x_errorcode OUT NOCOPY NUMBER
750: , x_msg_count OUT NOCOPY NUMBER
751: , x_msg_data OUT NOCOPY VARCHAR2

Line 816: IF NOT FND_API.Compatible_API_Call (l_api_version

812: code_debug (l_api_name ||' started p_project_id '||p_project_id||' lc id '||p_lifecycle_id ||' phase id '||p_phase_id);
813: code_debug (l_api_name ||' p_effective_date '||to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS'));
814:
815: --Standard checks
816: IF NOT FND_API.Compatible_API_Call (l_api_version
817: ,p_api_version
818: ,l_api_name
819: ,g_pkg_name)
820: THEN

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

817: ,p_api_version
818: ,l_api_name
819: ,g_pkg_name)
820: THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:
824: IF FND_API.To_Boolean(p_commit) THEN
825: SAVEPOINT Sync_Phase_Change_PUB;

Line 824: IF FND_API.To_Boolean(p_commit) THEN

820: THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:
824: IF FND_API.To_Boolean(p_commit) THEN
825: SAVEPOINT Sync_Phase_Change_PUB;
826: END IF;
827:
828: -- Initialize message list if p_init_msg_list is set to TRUE

Line 829: IF FND_API.To_Boolean(p_init_msg_list) THEN

825: SAVEPOINT Sync_Phase_Change_PUB;
826: END IF;
827:
828: -- Initialize message list if p_init_msg_list is set to TRUE
829: IF FND_API.To_Boolean(p_init_msg_list) THEN
830: FND_MSG_PUB.Initialize;
831: END IF;
832:
833: l_revision_master_controlled := FND_API.g_false;

Line 833: l_revision_master_controlled := FND_API.g_false;

829: IF FND_API.To_Boolean(p_init_msg_list) THEN
830: FND_MSG_PUB.Initialize;
831: END IF;
832:
833: l_revision_master_controlled := FND_API.g_false;
834: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
835:
836: FOR l_item_record IN l_item_revisions LOOP
837: code_debug (l_api_name ||' creating pending phase change for item '||l_item_record.INVENTORY_ITEM_ID||'in org '||l_item_record.organization_id||' revision id '||l_item_record.REVISION_id);

Line 863: ,p_commit => FND_API.G_FALSE

859: END;
860:
861: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
862: (p_api_version => p_api_version
863: ,p_commit => FND_API.G_FALSE
864: ,p_inventory_item_id => l_item_record.INVENTORY_ITEM_ID
865: ,p_organization_id => l_item_record.ORGANIZATION_ID
866: ,p_effective_date => p_effective_date
867: ,p_pending_flag => NULL

Line 875: ,p_perform_security_check => FND_API.G_TRUE

871: ,p_phase_id => p_phase_id
872: ,p_status_code => l_status_code
873: ,p_change_id => NULL
874: ,p_change_line_id => NULL
875: ,p_perform_security_check => FND_API.G_TRUE
876: ,x_return_status => x_return_status
877: ,x_errorcode => x_errorcode
878: ,x_msg_count => x_msg_count
879: ,x_msg_data => x_msg_data

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

878: ,x_msg_count => x_msg_count
879: ,x_msg_data => x_msg_data
880: );
881: code_debug (l_api_name ||' creating pending phase change for item returned with status '||x_return_status);
882: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
883:
884: l_is_master_org :=
885: EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(l_item_record.ORGANIZATION_ID);
886: -- l_revision_id :=

Line 902: ,p_perform_security_check => FND_API.G_FALSE

898: ,p_revision_id => l_item_record.REVISION_ID
899: ,p_revision_master_controlled => l_revision_master_controlled
900: ,p_status_master_controlled => l_status_master_controlled
901: ,p_is_master_org => l_is_master_org
902: ,p_perform_security_check => FND_API.G_FALSE
903: ,x_return_status => x_return_status
904: ,x_errorcode => x_errorcode
905: ,x_msg_count => x_msg_count
906: ,x_msg_data => x_msg_data

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

905: ,x_msg_count => x_msg_count
906: ,x_msg_data => x_msg_data
907: );
908: code_debug (l_api_name ||' returning implement pending phase change with status '||x_return_status||' msg count'||x_msg_count||' errorcode '||x_errorcode);
909: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
910: --
911: -- Commented as a part of fix for 3371749
912: --
913: -- Sync_Phase_Change

Line 932: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

928: -- );
929: --
930: END LOOP;
931:
932: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
933: -- Standard check of p_commit.
934: IF FND_API.To_Boolean(p_commit) THEN
935: COMMIT WORK;
936: END IF;

Line 934: IF FND_API.To_Boolean(p_commit) THEN

930: END LOOP;
931:
932: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
933: -- Standard check of p_commit.
934: IF FND_API.To_Boolean(p_commit) THEN
935: COMMIT WORK;
936: END IF;
937: ELSE
938: IF FND_API.To_Boolean(p_commit) THEN

Line 938: IF FND_API.To_Boolean(p_commit) THEN

934: IF FND_API.To_Boolean(p_commit) THEN
935: COMMIT WORK;
936: END IF;
937: ELSE
938: IF FND_API.To_Boolean(p_commit) THEN
939: ROLLBACK TO Sync_Phase_Change_PUB;
940: END IF;
941: code_debug (l_api_name ||' returning with msg count'||x_msg_count);
942: IF NOT x_msg_count = 1 THEN

Line 944: p_encoded => FND_API.G_FALSE,

940: END IF;
941: code_debug (l_api_name ||' returning with msg count'||x_msg_count);
942: IF NOT x_msg_count = 1 THEN
943: FND_MSG_PUB.Count_And_Get(
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => x_msg_data
947: );
948: END IF;

Line 953: WHEN FND_API.G_EXC_ERROR THEN

949: END IF;
950:
951:
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: IF FND_API.To_Boolean(p_commit) THEN
955: ROLLBACK TO Sync_Phase_Change_PUB;
956: END IF;
957: x_return_status := FND_API.G_RET_STS_ERROR;

Line 954: IF FND_API.To_Boolean(p_commit) THEN

950:
951:
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: IF FND_API.To_Boolean(p_commit) THEN
955: ROLLBACK TO Sync_Phase_Change_PUB;
956: END IF;
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: IF NOT x_msg_count = 1 THEN

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953: WHEN FND_API.G_EXC_ERROR THEN
954: IF FND_API.To_Boolean(p_commit) THEN
955: ROLLBACK TO Sync_Phase_Change_PUB;
956: END IF;
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: IF NOT x_msg_count = 1 THEN
959: FND_MSG_PUB.Count_And_Get(
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,

Line 960: p_encoded => FND_API.G_FALSE,

956: END IF;
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: IF NOT x_msg_count = 1 THEN
959: FND_MSG_PUB.Count_And_Get(
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data
963: );
964: END IF;

Line 966: IF FND_API.To_Boolean(p_commit) THEN

962: p_data => x_msg_data
963: );
964: END IF;
965: WHEN OTHERS THEN
966: IF FND_API.To_Boolean(p_commit) THEN
967: ROLLBACK TO Sync_Phase_Change_PUB;
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

965: WHEN OTHERS THEN
966: IF FND_API.To_Boolean(p_commit) THEN
967: ROLLBACK TO Sync_Phase_Change_PUB;
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
971: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 976: p_encoded => FND_API.G_FALSE,

972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
974: FND_MSG_PUB.Add;
975: FND_MSG_PUB.Count_And_Get(
976: p_encoded => FND_API.G_FALSE,
977: p_count => x_msg_count,
978: p_data => x_msg_data
979: );
980:

Line 994: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

990: , p_revision IN VARCHAR2 DEFAULT null
991: , p_lifecycle_id IN NUMBER
992: , p_phase_id IN NUMBER
993: , p_effective_date IN DATE
994: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
995: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
996: , x_return_status OUT NOCOPY VARCHAR2
997: , x_errorcode OUT NOCOPY NUMBER
998: , x_msg_count OUT NOCOPY NUMBER

Line 995: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

991: , p_lifecycle_id IN NUMBER
992: , p_phase_id IN NUMBER
993: , p_effective_date IN DATE
994: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
995: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
996: , x_return_status OUT NOCOPY VARCHAR2
997: , x_errorcode OUT NOCOPY NUMBER
998: , x_msg_count OUT NOCOPY NUMBER
999: , x_msg_data OUT NOCOPY VARCHAR2

Line 1026: IF NOT FND_API.Compatible_API_Call (l_api_version

1022: code_debug (l_api_name ||' started p_inventory_item_id '||p_inventory_item_id||' revision '|| p_revision ||' lc id '||p_lifecycle_id ||' phase id '||p_phase_id);
1023: code_debug (l_api_name ||' p_effective_date '||to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS'));
1024:
1025: --Standard checks
1026: IF NOT FND_API.Compatible_API_Call (l_api_version
1027: ,p_api_version
1028: ,l_api_name
1029: ,g_pkg_name)
1030: THEN

Line 1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1027: ,p_api_version
1028: ,l_api_name
1029: ,g_pkg_name)
1030: THEN
1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1032: END IF;
1033:
1034:
1035: IF FND_API.To_Boolean(p_commit) THEN

Line 1035: IF FND_API.To_Boolean(p_commit) THEN

1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1032: END IF;
1033:
1034:
1035: IF FND_API.To_Boolean(p_commit) THEN
1036: SAVEPOINT Implement_All_Pending_Changes;
1037: END IF;
1038:
1039: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1040: IF FND_API.To_Boolean(p_init_msg_list) THEN

1036: SAVEPOINT Implement_All_Pending_Changes;
1037: END IF;
1038:
1039: -- Initialize message list if p_init_msg_list is set to TRUE
1040: IF FND_API.To_Boolean(p_init_msg_list) THEN
1041: FND_MSG_PUB.Initialize;
1042: END IF;
1043: code_debug (l_api_name ||' creating pending phase change for item ');
1044:

Line 1047: ,p_commit => FND_API.G_FALSE

1043: code_debug (l_api_name ||' creating pending phase change for item ');
1044:
1045: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
1046: (p_api_version => p_api_version
1047: ,p_commit => FND_API.G_FALSE
1048: ,p_inventory_item_id => p_inventory_item_id
1049: ,p_organization_id => p_organization_id
1050: ,p_effective_date => p_effective_date
1051: ,p_pending_flag => NULL

Line 1058: ,p_perform_security_check => FND_API.G_TRUE

1054: ,p_lifecycle_id => p_lifecycle_id
1055: ,p_phase_id => p_phase_id
1056: ,p_change_id => NULL
1057: ,p_change_line_id => NULL
1058: ,p_perform_security_check => FND_API.G_TRUE
1059: ,x_return_status => x_return_status
1060: ,x_errorcode => x_errorcode
1061: ,x_msg_count => x_msg_count
1062: ,x_msg_data => x_msg_data

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

1061: ,x_msg_count => x_msg_count
1062: ,x_msg_data => x_msg_data
1063: );
1064: code_debug (l_api_name ||' returning pending phase change for item with status '||x_return_status);
1065: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1066: RETURN;
1067: END IF;
1068: l_revision_master_controlled := FND_API.g_false;
1069: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();

Line 1068: l_revision_master_controlled := FND_API.g_false;

1064: code_debug (l_api_name ||' returning pending phase change for item with status '||x_return_status);
1065: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1066: RETURN;
1067: END IF;
1068: l_revision_master_controlled := FND_API.g_false;
1069: l_status_master_controlled := EGO_ITEM_LC_IMP_PC_PUB.get_master_controlled_status();
1070: l_is_master_org :=
1071: EGO_ITEM_LC_IMP_PC_PUB.get_master_org_status(p_organization_id);
1072: l_revision_id :=

Line 1088: ,p_perform_security_check => FND_API.G_FALSE

1084: ,p_revision_id => l_revision_id
1085: ,p_revision_master_controlled => l_revision_master_controlled
1086: ,p_status_master_controlled => l_status_master_controlled
1087: ,p_is_master_org => l_is_master_org
1088: ,p_perform_security_check => FND_API.G_FALSE
1089: ,x_return_status => x_return_status
1090: ,x_errorcode => x_errorcode
1091: ,x_msg_count => x_msg_count
1092: ,x_msg_data => x_msg_data

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

1091: ,x_msg_count => x_msg_count
1092: ,x_msg_data => x_msg_data
1093: );
1094: code_debug (l_api_name ||' returning implement pending phase change for item with status '||x_return_status);
1095: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1096: RETURN;
1097: END IF;
1098: --
1099: -- commented for fixing 3371749

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

1187: );
1188:
1189: --Now call an api to implement all of the pendings we just added
1190:
1191: SELECT DECODE(LOOKUP_CODE2, 1, FND_API.G_TRUE, 2, FND_API.G_FALSE, FND_API.G_FALSE) INTO l_status_master_controlled
1192: FROM MTL_ITEM_ATTRIBUTES_V
1193: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
1194:
1195: l_revision_master_controlled := FND_API.G_FALSE;

Line 1195: l_revision_master_controlled := FND_API.G_FALSE;

1191: SELECT DECODE(LOOKUP_CODE2, 1, FND_API.G_TRUE, 2, FND_API.G_FALSE, FND_API.G_FALSE) INTO l_status_master_controlled
1192: FROM MTL_ITEM_ATTRIBUTES_V
1193: WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
1194:
1195: l_revision_master_controlled := FND_API.G_FALSE;
1196:
1197: SELECT
1198: DECODE(MP.ORGANIZATION_ID,MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE, FND_API.G_FALSE) INTO l_is_master_org
1199: FROM MTL_PARAMETERS MP

Line 1198: DECODE(MP.ORGANIZATION_ID,MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE, FND_API.G_FALSE) INTO l_is_master_org

1194:
1195: l_revision_master_controlled := FND_API.G_FALSE;
1196:
1197: SELECT
1198: DECODE(MP.ORGANIZATION_ID,MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE, FND_API.G_FALSE) INTO l_is_master_org
1199: FROM MTL_PARAMETERS MP
1200: WHERE MP.ORGANIZATION_ID = p_organization_id;
1201:
1202: EGO_ITEM_LC_IMP_PC_PUB.Implement_Pending_Changes(1.0

Line 1220: IF FND_API.To_Boolean(p_commit) THEN

1216:
1217: END IF;--Bug: 2871650 ended If condition
1218: ***/
1219: -- Standard check of p_commit.
1220: IF FND_API.To_Boolean(p_commit) THEN
1221: COMMIT WORK;
1222: END IF;
1223:
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1224: x_return_status := FND_API.G_RET_STS_SUCCESS;

1220: IF FND_API.To_Boolean(p_commit) THEN
1221: COMMIT WORK;
1222: END IF;
1223:
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225:
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: IF FND_API.To_Boolean(p_commit) THEN

Line 1227: WHEN FND_API.G_EXC_ERROR THEN

1223:
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225:
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: IF FND_API.To_Boolean(p_commit) THEN
1229: ROLLBACK TO Sync_Phase_Change_PUB;
1230: END IF;
1231: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1228: IF FND_API.To_Boolean(p_commit) THEN

1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225:
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: IF FND_API.To_Boolean(p_commit) THEN
1229: ROLLBACK TO Sync_Phase_Change_PUB;
1230: END IF;
1231: x_return_status := FND_API.G_RET_STS_ERROR;
1232: IF NOT x_msg_count = 1 THEN

Line 1231: x_return_status := FND_API.G_RET_STS_ERROR;

1227: WHEN FND_API.G_EXC_ERROR THEN
1228: IF FND_API.To_Boolean(p_commit) THEN
1229: ROLLBACK TO Sync_Phase_Change_PUB;
1230: END IF;
1231: x_return_status := FND_API.G_RET_STS_ERROR;
1232: IF NOT x_msg_count = 1 THEN
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_msg_count,

Line 1234: p_encoded => FND_API.G_FALSE,

1230: END IF;
1231: x_return_status := FND_API.G_RET_STS_ERROR;
1232: IF NOT x_msg_count = 1 THEN
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_msg_count,
1236: p_data => x_msg_data
1237: );
1238: END IF;

Line 1240: IF FND_API.To_Boolean(p_commit) THEN

1236: p_data => x_msg_data
1237: );
1238: END IF;
1239: WHEN OTHERS THEN
1240: IF FND_API.To_Boolean(p_commit) THEN
1241: ROLLBACK TO Sync_Phase_Change_PUB;
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1239: WHEN OTHERS THEN
1240: IF FND_API.To_Boolean(p_commit) THEN
1241: ROLLBACK TO Sync_Phase_Change_PUB;
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1245: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1250: p_encoded => FND_API.G_FALSE,

1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1248: FND_MSG_PUB.Add;
1249: FND_MSG_PUB.Count_And_Get(
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data
1253: );
1254:

Line 1271: , p_organization_specific IN VARCHAR2 DEFAULT FND_API.G_FALSE

1267: , p_revision_id IN NUMBER DEFAULT NULL
1268: , p_task_id IN NUMBER DEFAULT NULL
1269: , p_association_type IN VARCHAR2
1270: , p_association_code IN VARCHAR2
1271: , p_organization_specific IN VARCHAR2 DEFAULT FND_API.G_FALSE
1272: -- Currently not used
1273: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_TRUE
1274: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1275: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 1273: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_TRUE

1269: , p_association_type IN VARCHAR2
1270: , p_association_code IN VARCHAR2
1271: , p_organization_specific IN VARCHAR2 DEFAULT FND_API.G_FALSE
1272: -- Currently not used
1273: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_TRUE
1274: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1275: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1276: , x_return_status OUT NOCOPY VARCHAR2
1277: , x_errorcode OUT NOCOPY NUMBER

Line 1274: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1270: , p_association_code IN VARCHAR2
1271: , p_organization_specific IN VARCHAR2 DEFAULT FND_API.G_FALSE
1272: -- Currently not used
1273: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_TRUE
1274: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1275: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1276: , x_return_status OUT NOCOPY VARCHAR2
1277: , x_errorcode OUT NOCOPY NUMBER
1278: , x_msg_count OUT NOCOPY NUMBER

Line 1275: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1271: , p_organization_specific IN VARCHAR2 DEFAULT FND_API.G_FALSE
1272: -- Currently not used
1273: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_TRUE
1274: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1275: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1276: , x_return_status OUT NOCOPY VARCHAR2
1277: , x_errorcode OUT NOCOPY NUMBER
1278: , x_msg_count OUT NOCOPY NUMBER
1279: , x_msg_data OUT NOCOPY VARCHAR2

Line 1306: IF NOT FND_API.Compatible_API_Call (l_api_version

1302: -- Validity Checking --
1303: --------------------------------------------------------------------------
1304:
1305: --Standard checks
1306: IF NOT FND_API.Compatible_API_Call (l_api_version
1307: ,p_api_version
1308: ,l_api_name
1309: ,g_pkg_name)
1310: THEN

Line 1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1307: ,p_api_version
1308: ,l_api_name
1309: ,g_pkg_name)
1310: THEN
1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END IF;
1313:
1314: IF (FND_API.To_Boolean(p_commit)) THEN
1315: SAVEPOINT Create_Proj_Item_Assoc_PUB;

Line 1314: IF (FND_API.To_Boolean(p_commit)) THEN

1310: THEN
1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END IF;
1313:
1314: IF (FND_API.To_Boolean(p_commit)) THEN
1315: SAVEPOINT Create_Proj_Item_Assoc_PUB;
1316: END IF;
1317:
1318: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1319: IF FND_API.To_Boolean(p_init_msg_list) THEN

1315: SAVEPOINT Create_Proj_Item_Assoc_PUB;
1316: END IF;
1317:
1318: -- Initialize message list if p_init_msg_list is set to TRUE
1319: IF FND_API.To_Boolean(p_init_msg_list) THEN
1320: FND_MSG_PUB.Initialize;
1321: END IF;
1322:
1323: -- Since this is an API intended for use by Projects, it

Line 1333: IF (FND_API.To_Boolean(p_check_privileges)) THEN

1329: IF (p_association_type = G_PROJECT_ASSOC_TYPE AND
1330: p_association_code = g_lifecycle_tracking_code) THEN
1331:
1332:
1333: IF (FND_API.To_Boolean(p_check_privileges)) THEN
1334:
1335: -- 4052565 perform security check
1336: code_debug (l_api_name ||' performing security checks ');
1337: IF NOT EGO_ITEM_PVT.has_role_on_item

Line 1345: ,p_set_message => FND_API.G_TRUE

1341: ,p_organization_id => p_organization_id
1342: ,p_organization_name => NULL
1343: ,p_user_id => NULL
1344: ,p_party_id => NULL
1345: ,p_set_message => FND_API.G_TRUE
1346: ) THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349: ELSE

Line 1347: RAISE FND_API.G_EXC_ERROR;

1343: ,p_user_id => NULL
1344: ,p_party_id => NULL
1345: ,p_set_message => FND_API.G_TRUE
1346: ) THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349: ELSE
1350: code_debug (l_api_name ||' security checks bypassed');
1351: END IF;

Line 1436: IF FND_API.To_Boolean(p_commit)

1432: -- Commit --
1433: --------------------------------------------------------------------------
1434:
1435: -- Standard check of p_commit.
1436: IF FND_API.To_Boolean(p_commit)
1437: THEN
1438: COMMIT WORK;
1439: END IF;
1440:

Line 1441: x_return_status := FND_API.G_RET_STS_SUCCESS;

1437: THEN
1438: COMMIT WORK;
1439: END IF;
1440:
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: EXCEPTION
1444: WHEN DUP_VAL_ON_INDEX THEN
1445: IF (FND_API.To_Boolean(p_commit)) THEN

Line 1445: IF (FND_API.To_Boolean(p_commit)) THEN

1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: EXCEPTION
1444: WHEN DUP_VAL_ON_INDEX THEN
1445: IF (FND_API.To_Boolean(p_commit)) THEN
1446: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1447: END IF;
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_DUP_ERR');

Line 1448: x_return_status := FND_API.G_RET_STS_ERROR;

1444: WHEN DUP_VAL_ON_INDEX THEN
1445: IF (FND_API.To_Boolean(p_commit)) THEN
1446: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1447: END IF;
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_DUP_ERR');
1450: FND_MSG_PUB.Add;
1451: FND_MSG_PUB.Count_And_Get(
1452: p_encoded => FND_API.G_FALSE,

Line 1452: p_encoded => FND_API.G_FALSE,

1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_DUP_ERR');
1450: FND_MSG_PUB.Add;
1451: FND_MSG_PUB.Count_And_Get(
1452: p_encoded => FND_API.G_FALSE,
1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );
1456: WHEN G_VALIDATION_ERROR THEN

Line 1457: IF (FND_API.To_Boolean(p_commit)) THEN

1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );
1456: WHEN G_VALIDATION_ERROR THEN
1457: IF (FND_API.To_Boolean(p_commit)) THEN
1458: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1459: END IF;
1460: x_return_status := FND_API.G_RET_STS_ERROR;
1461: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_TRACK_EXISTS');

Line 1460: x_return_status := FND_API.G_RET_STS_ERROR;

1456: WHEN G_VALIDATION_ERROR THEN
1457: IF (FND_API.To_Boolean(p_commit)) THEN
1458: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1459: END IF;
1460: x_return_status := FND_API.G_RET_STS_ERROR;
1461: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_TRACK_EXISTS');
1462: FND_MSG_PUB.Add;
1463: FND_MSG_PUB.Count_And_Get(
1464: p_encoded => FND_API.G_FALSE,

Line 1464: p_encoded => FND_API.G_FALSE,

1460: x_return_status := FND_API.G_RET_STS_ERROR;
1461: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_TRACK_EXISTS');
1462: FND_MSG_PUB.Add;
1463: FND_MSG_PUB.Count_And_Get(
1464: p_encoded => FND_API.G_FALSE,
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468: WHEN FND_API.G_EXC_ERROR THEN

Line 1468: WHEN FND_API.G_EXC_ERROR THEN

1464: p_encoded => FND_API.G_FALSE,
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: IF FND_API.To_Boolean( p_commit ) THEN
1470: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1471: END IF;
1472: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1469: IF FND_API.To_Boolean( p_commit ) THEN

1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: IF FND_API.To_Boolean( p_commit ) THEN
1470: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1471: END IF;
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: IF NOT x_msg_count = 1 THEN

Line 1472: x_return_status := FND_API.G_RET_STS_ERROR;

1468: WHEN FND_API.G_EXC_ERROR THEN
1469: IF FND_API.To_Boolean( p_commit ) THEN
1470: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1471: END IF;
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: IF NOT x_msg_count = 1 THEN
1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,

Line 1475: p_encoded => FND_API.G_FALSE,

1471: END IF;
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: IF NOT x_msg_count = 1 THEN
1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data
1478: );
1479: END IF;

Line 1481: IF (FND_API.To_Boolean(p_commit)) THEN

1477: p_data => x_msg_data
1478: );
1479: END IF;
1480: WHEN OTHERS THEN
1481: IF (FND_API.To_Boolean(p_commit)) THEN
1482: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1483: END IF;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1480: WHEN OTHERS THEN
1481: IF (FND_API.To_Boolean(p_commit)) THEN
1482: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1483: END IF;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1486: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1491: p_encoded => FND_API.G_FALSE,

1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1489: FND_MSG_PUB.Add;
1490: FND_MSG_PUB.Count_And_Get(
1491: p_encoded => FND_API.G_FALSE,
1492: p_count => x_msg_count,
1493: p_data => x_msg_data
1494: );
1495:

Line 1516: (-) NULL value for p_init_msg_list means fnd_api.G_FALSE

1512:
1513: PARAMETERS
1514: (-) Association code is NOT functionally dependent on association type
1515: (-) We support all types of association code, not just LIFECYCLE_TRACKING
1516: (-) NULL value for p_init_msg_list means fnd_api.G_FALSE
1517: (-) NULL value for p_commit means fnd_api.G_FALSE
1518:
1519: PRECONDITIONS
1520: These must be respected by the caller and are not enforced here.

Line 1517: (-) NULL value for p_commit means fnd_api.G_FALSE

1513: PARAMETERS
1514: (-) Association code is NOT functionally dependent on association type
1515: (-) We support all types of association code, not just LIFECYCLE_TRACKING
1516: (-) NULL value for p_init_msg_list means fnd_api.G_FALSE
1517: (-) NULL value for p_commit means fnd_api.G_FALSE
1518:
1519: PRECONDITIONS
1520: These must be respected by the caller and are not enforced here.
1521: (-) The source and destination items already exist

Line 1535: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1531: */
1532: PROCEDURE Copy_Project
1533: (
1534: p_api_version IN NUMBER
1535: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1536: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1537: , p_source_item_id IN NUMBER
1538: , p_source_org_id IN NUMBER
1539: , p_source_rev_id IN NUMBER

Line 1536: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1532: PROCEDURE Copy_Project
1533: (
1534: p_api_version IN NUMBER
1535: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1536: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1537: , p_source_item_id IN NUMBER
1538: , p_source_org_id IN NUMBER
1539: , p_source_rev_id IN NUMBER
1540: , p_association_type IN VARCHAR2

Line 1545: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_FALSE

1541: , p_association_code IN VARCHAR2
1542: , p_dest_item_id IN NUMBER
1543: , p_dest_org_id IN NUMBER
1544: , p_dest_rev_id IN NUMBER
1545: , p_check_privileges IN VARCHAR2 DEFAULT FND_API.G_FALSE
1546: , x_return_status OUT NOCOPY VARCHAR2
1547: , x_error_code OUT NOCOPY NUMBER
1548: , x_msg_count OUT NOCOPY NUMBER
1549: , x_msg_data OUT NOCOPY VARCHAR2

Line 1593: IF NOT FND_API.Compatible_API_Call (l_api_version

1589: code_debug (' p_dest_org_id: ' || p_dest_org_id);
1590: code_debug (' p_dest_rev_id: ' || p_dest_rev_id);
1591:
1592: --Standard checks
1593: IF NOT FND_API.Compatible_API_Call (l_api_version
1594: ,p_api_version
1595: ,l_api_name
1596: ,g_pkg_name)
1597: THEN

Line 1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1594: ,p_api_version
1595: ,l_api_name
1596: ,g_pkg_name)
1597: THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: END IF;
1600:
1601: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
1602: FND_MSG_PUB.Initialize;

Line 1601: IF (FND_API.To_Boolean(p_init_msg_list)) THEN

1597: THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: END IF;
1600:
1601: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
1602: FND_MSG_PUB.Initialize;
1603: END IF;
1604:
1605: IF FND_API.To_Boolean(p_commit) THEN

Line 1605: IF FND_API.To_Boolean(p_commit) THEN

1601: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
1602: FND_MSG_PUB.Initialize;
1603: END IF;
1604:
1605: IF FND_API.To_Boolean(p_commit) THEN
1606: SAVEPOINT Copy_Project_PUB;
1607: END IF;
1608:
1609: IF (p_source_item_id IS NULL OR

Line 1619: RAISE FND_API.G_EXC_ERROR;

1615: ) THEN
1616: FND_MESSAGE.Set_Name(g_app_name, 'EGO_IPI_INSUFFICIENT_PARAMS');
1617: FND_MESSAGE.Set_Token('PROG_NAME', g_pkg_name||'.'||l_api_name);
1618: FND_MSG_PUB.Add;
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;
1621:
1622: ----------------------------------------------------------------------------
1623: -- Obtain the data to be inserted --

Line 1658: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

1654: --------------------------------------------------------------------------
1655: -- Error Handling --
1656: --------------------------------------------------------------------------
1657:
1658: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
1659: l_has_errors := TRUE;
1660: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_UNEXP_ERROR THEN
1661: x_return_status := l_return_status;
1662: END IF;

Line 1660: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_UNEXP_ERROR THEN

1656: --------------------------------------------------------------------------
1657:
1658: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
1659: l_has_errors := TRUE;
1660: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_UNEXP_ERROR THEN
1661: x_return_status := l_return_status;
1662: END IF;
1663: IF l_msg_count = 1 THEN
1664: -- add the fetched message into error stack

Line 1674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1670: END LOOP;
1671:
1672: -- raise an error if anything was unsuccessful
1673: IF l_has_errors THEN
1674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: END IF;
1677: RAISE FND_API.G_EXC_ERROR;
1678: ELSE

Line 1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1671:
1672: -- raise an error if anything was unsuccessful
1673: IF l_has_errors THEN
1674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: END IF;
1677: RAISE FND_API.G_EXC_ERROR;
1678: ELSE
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1677: RAISE FND_API.G_EXC_ERROR;

1673: IF l_has_errors THEN
1674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: END IF;
1677: RAISE FND_API.G_EXC_ERROR;
1678: ELSE
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680: END IF;
1681:

Line 1679: x_return_status := FND_API.G_RET_STS_SUCCESS;

1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: END IF;
1677: RAISE FND_API.G_EXC_ERROR;
1678: ELSE
1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680: END IF;
1681:
1682: -- Standard check of p_commit.
1683: IF FND_API.To_Boolean(p_commit) THEN

Line 1683: IF FND_API.To_Boolean(p_commit) THEN

1679: x_return_status := FND_API.G_RET_STS_SUCCESS;
1680: END IF;
1681:
1682: -- Standard check of p_commit.
1683: IF FND_API.To_Boolean(p_commit) THEN
1684: COMMIT WORK;
1685: END IF;
1686:
1687: EXCEPTION

Line 1688: WHEN FND_API.G_EXC_ERROR THEN

1684: COMMIT WORK;
1685: END IF;
1686:
1687: EXCEPTION
1688: WHEN FND_API.G_EXC_ERROR THEN
1689: IF FND_API.To_Boolean(p_commit) THEN
1690: ROLLBACK TO Copy_Project_PUB;
1691: END IF;
1692: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1689: IF FND_API.To_Boolean(p_commit) THEN

1685: END IF;
1686:
1687: EXCEPTION
1688: WHEN FND_API.G_EXC_ERROR THEN
1689: IF FND_API.To_Boolean(p_commit) THEN
1690: ROLLBACK TO Copy_Project_PUB;
1691: END IF;
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: FND_MSG_PUB.Count_And_Get(

Line 1692: x_return_status := FND_API.G_RET_STS_ERROR;

1688: WHEN FND_API.G_EXC_ERROR THEN
1689: IF FND_API.To_Boolean(p_commit) THEN
1690: ROLLBACK TO Copy_Project_PUB;
1691: END IF;
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: FND_MSG_PUB.Count_And_Get(
1694: p_encoded => FND_API.G_FALSE,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data

Line 1694: p_encoded => FND_API.G_FALSE,

1690: ROLLBACK TO Copy_Project_PUB;
1691: END IF;
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: FND_MSG_PUB.Count_And_Get(
1694: p_encoded => FND_API.G_FALSE,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );
1698: WHEN OTHERS THEN

Line 1699: IF FND_API.To_Boolean(p_commit) THEN

1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );
1698: WHEN OTHERS THEN
1699: IF FND_API.To_Boolean(p_commit) THEN
1700: ROLLBACK TO Copy_Project_PUB;
1701: END IF;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1698: WHEN OTHERS THEN
1699: IF FND_API.To_Boolean(p_commit) THEN
1700: ROLLBACK TO Copy_Project_PUB;
1701: END IF;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1704: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1709: p_encoded => FND_API.G_FALSE,

1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1707: FND_MSG_PUB.Add;
1708: FND_MSG_PUB.Count_And_Get(
1709: p_encoded => FND_API.G_FALSE,
1710: p_count => x_msg_count,
1711: p_data => x_msg_data
1712: );
1713:

Line 1723: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

1719: (
1720: p_api_version IN NUMBER
1721: ,p_project_id_from IN NUMBER
1722: ,p_project_id_to IN NUMBER
1723: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
1724: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
1725: ,x_return_status OUT NOCOPY VARCHAR2
1726: ,x_errorcode OUT NOCOPY NUMBER
1727: ,x_msg_count OUT NOCOPY NUMBER

Line 1724: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

1720: p_api_version IN NUMBER
1721: ,p_project_id_from IN NUMBER
1722: ,p_project_id_to IN NUMBER
1723: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
1724: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
1725: ,x_return_status OUT NOCOPY VARCHAR2
1726: ,x_errorcode OUT NOCOPY NUMBER
1727: ,x_msg_count OUT NOCOPY NUMBER
1728: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1754: IF NOT FND_API.Compatible_API_Call (l_api_version

1750: l_api_version := 1.0;
1751: l_api_name := 'Copy_Item_Assocs';
1752:
1753: --Standard checks
1754: IF NOT FND_API.Compatible_API_Call (l_api_version
1755: ,p_api_version
1756: ,l_api_name
1757: ,g_pkg_name)
1758: THEN

Line 1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1755: ,p_api_version
1756: ,l_api_name
1757: ,g_pkg_name)
1758: THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761:
1762: IF FND_API.To_Boolean(p_commit) THEN
1763: SAVEPOINT Copy_Item_Assocs_PUB;

Line 1762: IF FND_API.To_Boolean(p_commit) THEN

1758: THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761:
1762: IF FND_API.To_Boolean(p_commit) THEN
1763: SAVEPOINT Copy_Item_Assocs_PUB;
1764: END IF;
1765:
1766: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1767: IF FND_API.To_Boolean(p_init_msg_list) THEN

1763: SAVEPOINT Copy_Item_Assocs_PUB;
1764: END IF;
1765:
1766: -- Initialize message list if p_init_msg_list is set to TRUE
1767: IF FND_API.To_Boolean(p_init_msg_list) THEN
1768: FND_MSG_PUB.Initialize;
1769: END IF;
1770:
1771: FOR assoc_rec IN project_assocs_cursor(p_project_id_from)

Line 1775: l_is_org_specific := FND_API.G_FALSE;

1771: FOR assoc_rec IN project_assocs_cursor(p_project_id_from)
1772: LOOP
1773:
1774: IF (assoc_rec.ORGANIZATION_ID IS NULL) THEN
1775: l_is_org_specific := FND_API.G_FALSE;
1776: ELSE
1777: l_is_org_specific := FND_API.G_TRUE;
1778: END IF;
1779:

Line 1777: l_is_org_specific := FND_API.G_TRUE;

1773:
1774: IF (assoc_rec.ORGANIZATION_ID IS NULL) THEN
1775: l_is_org_specific := FND_API.G_FALSE;
1776: ELSE
1777: l_is_org_specific := FND_API.G_TRUE;
1778: END IF;
1779:
1780: IF (assoc_rec.ASSOCIATION_TYPE = g_project_assoc_type
1781: AND assoc_rec.ASSOCIATION_CODE <> g_lifecycle_tracking_code) THEN

Line 1801: x_return_status = FND_API.G_RET_STS_SUCCESS OR

1797: );
1798:
1799: -- Keep track of and report the status of our worst failure
1800: IF (x_return_status IS NULL OR
1801: x_return_status = FND_API.G_RET_STS_SUCCESS OR
1802: (x_return_status = FND_API.G_RET_STS_ERROR AND
1803: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
1804:
1805: x_return_status := l_return_status;

Line 1802: (x_return_status = FND_API.G_RET_STS_ERROR AND

1798:
1799: -- Keep track of and report the status of our worst failure
1800: IF (x_return_status IS NULL OR
1801: x_return_status = FND_API.G_RET_STS_SUCCESS OR
1802: (x_return_status = FND_API.G_RET_STS_ERROR AND
1803: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
1804:
1805: x_return_status := l_return_status;
1806: END IF;

Line 1803: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN

1799: -- Keep track of and report the status of our worst failure
1800: IF (x_return_status IS NULL OR
1801: x_return_status = FND_API.G_RET_STS_SUCCESS OR
1802: (x_return_status = FND_API.G_RET_STS_ERROR AND
1803: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
1804:
1805: x_return_status := l_return_status;
1806: END IF;
1807:

Line 1813: x_return_status := FND_API.G_RET_STS_SUCCESS;

1809: END LOOP;
1810:
1811: -- (keep this code before the commit check or it may behave incorrectly)
1812: IF (x_return_status IS NULL) THEN
1813: x_return_status := FND_API.G_RET_STS_SUCCESS;
1814: END IF;
1815:
1816: -- If we got no errors and the commit check passes, we commit
1817: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 1817: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

1813: x_return_status := FND_API.G_RET_STS_SUCCESS;
1814: END IF;
1815:
1816: -- If we got no errors and the commit check passes, we commit
1817: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
1818: FND_API.To_Boolean(p_commit)) THEN
1819: COMMIT WORK;
1820: END IF;
1821:

Line 1818: FND_API.To_Boolean(p_commit)) THEN

1814: END IF;
1815:
1816: -- If we got no errors and the commit check passes, we commit
1817: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
1818: FND_API.To_Boolean(p_commit)) THEN
1819: COMMIT WORK;
1820: END IF;
1821:
1822: EXCEPTION

Line 1824: IF (FND_API.To_Boolean(p_commit)) THEN

1820: END IF;
1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: IF (FND_API.To_Boolean(p_commit)) THEN
1825: ROLLBACK TO Copy_Item_Assocs_PUB;
1826: END IF;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

Line 1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1823: WHEN OTHERS THEN
1824: IF (FND_API.To_Boolean(p_commit)) THEN
1825: ROLLBACK TO Copy_Item_Assocs_PUB;
1826: END IF;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1829: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

Line 1834: p_encoded => FND_API.G_FALSE,

1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1832: FND_MSG_PUB.Add;
1833: FND_MSG_PUB.Count_And_Get(
1834: p_encoded => FND_API.G_FALSE,
1835: p_count => x_msg_count,
1836: p_data => x_msg_data
1837: );
1838: