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.ENG_CHANGE_LIFECYCLE_UTIL dependencies on STANDARD

Line 364: -- Standard Start of API savepoint

360: l_last_imp_flag VARCHAR2(1) := 'N';
361:
362:
363: BEGIN
364: -- Standard Start of API savepoint
365: --SAVEPOINT Is_CO_On_Last_Imp_Phase;
366:
367: -- Default return value
368: x_is_co_last_phase := 'F';

Line 441: -- Standard ending code ------------------------------------------------

437:
438: END IF;
439:
440:
441: -- Standard ending code ------------------------------------------------
442: IF g_debug_flag THEN
443: Write_Debug('x_is_co_last_phase : ' || x_is_co_last_phase );
444: --Write_Debug('x_curr_status_code : ' || x_curr_status_code );
445: --Write_Debug('x_last_status_code : ' || x_last_status_code );

Line 468: -- Standard Start of API savepoint

464: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
465: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
466: l_start_date eng_lifecycle_statuses.start_date%TYPE;
467: BEGIN
468: -- Standard Start of API savepoint
469: --SAVEPOINT Is_CO_Last_Imp_Phase_Used;
470:
471: -- Default return value
472: x_is_used := 'F';

Line 529: -- Standard ending code ------------------------------------------------

525:
526: END IF;
527:
528:
529: -- Standard ending code ------------------------------------------------
530: IF g_debug_flag THEN
531: Write_Debug('x_is_used : ' || x_is_used );
532: Write_Debug('x_last_status_type : ' || x_last_status_type );
533: Write_Debug('x_last_status_code : ' || x_last_status_code );

Line 626: -- Standard Start of API savepoint

622: l_doc_lc_object_flag BOOLEAN := FALSE ;
623: l_message_list Error_Handler.Error_Tbl_Type; --added for bug 10128347
624:
625: BEGIN
626: -- Standard Start of API savepoint
627: --SAVEPOINT Update_Header_Appr_Status;
628: Error_Handler.Initialize; --added for bug 10128347
629: -- Standard call to check for call compatibility
630: IF NOT FND_API.Compatible_API_Call ( l_api_version

Line 629: -- Standard call to check for call compatibility

625: BEGIN
626: -- Standard Start of API savepoint
627: --SAVEPOINT Update_Header_Appr_Status;
628: Error_Handler.Initialize; --added for bug 10128347
629: -- Standard call to check for call compatibility
630: IF NOT FND_API.Compatible_API_Call ( l_api_version
631: ,p_api_version
632: ,l_api_name
633: ,G_PKG_NAME )

Line 1132: -- Standard ending code ------------------------------------------------

1128: END IF; -- if (p_status_code's phase type is APPROVAL
1129:
1130:
1131:
1132: -- Standard ending code ------------------------------------------------
1133: IF FND_API.To_Boolean ( p_commit ) THEN
1134: COMMIT WORK;
1135: END IF;
1136:

Line 1330: -- Standard Start of API savepoint

1326: AND cur_status.status_code = c_cur_status_code
1327: AND cur_status.active_flag = 'Y' ;
1328:
1329: BEGIN
1330: -- Standard Start of API savepoint
1331: --SAVEPOINT Start_Line_Workflow;
1332: -- Standard call to check for call compatibility
1333: IF NOT FND_API.Compatible_API_Call ( l_api_version
1334: ,p_api_version

Line 1332: -- Standard call to check for call compatibility

1328:
1329: BEGIN
1330: -- Standard Start of API savepoint
1331: --SAVEPOINT Start_Line_Workflow;
1332: -- Standard call to check for call compatibility
1333: IF NOT FND_API.Compatible_API_Call ( l_api_version
1334: ,p_api_version
1335: ,l_api_name
1336: ,G_PKG_NAME )

Line 1453: -- Standard ending code ------------------------------------------------

1449: END LOOP ; -- c_line_wf loop
1450:
1451: END IF; -- if (action = PROMOTE)
1452:
1453: -- Standard ending code ------------------------------------------------
1454: IF FND_API.To_Boolean ( p_commit ) THEN
1455: COMMIT WORK;
1456: END IF;
1457:

Line 1569: -- Standard Start of API savepoint

1565: l_doc_lc_object_flag BOOLEAN := FALSE ;
1566:
1567:
1568: BEGIN
1569: -- Standard Start of API savepoint
1570: --SAVEPOINT Start_WF_OnlyIf_Necessary;
1571: -- Standard call to check for call compatibility
1572: IF NOT FND_API.Compatible_API_Call ( l_api_version
1573: ,p_api_version

Line 1571: -- Standard call to check for call compatibility

1567:
1568: BEGIN
1569: -- Standard Start of API savepoint
1570: --SAVEPOINT Start_WF_OnlyIf_Necessary;
1571: -- Standard call to check for call compatibility
1572: IF NOT FND_API.Compatible_API_Call ( l_api_version
1573: ,p_api_version
1574: ,l_api_name
1575: ,G_PKG_NAME )

Line 1706: -- launch the standard action workflow for new action if needed

1702: IF FND_API.To_Boolean ( p_commit ) THEN -- fix by 14018580, in PIP session, using XA Datsource and hard commits will cause this subordination session error.
1703: COMMIT WORK;
1704: END IF;
1705:
1706: -- launch the standard action workflow for new action if needed
1707: IF g_debug_flag THEN
1708: Write_Debug('Before: calling status change workflow API');
1709: END IF;
1710:

Line 1888: -- Standard ending code ------------------------------------------------

1884: END IF; -- if (phase workflow instance id and workflow template id)
1885:
1886: END IF; -- if (action = PROMOTE)
1887:
1888: -- Standard ending code ------------------------------------------------
1889: IF FND_API.To_Boolean ( p_commit ) THEN
1890: COMMIT WORK;
1891: END IF;
1892:

Line 2117: -- Standard Start of API savepoint

2113:
2114:
2115: BEGIN
2116:
2117: -- Standard Start of API savepoint
2118: SAVEPOINT Promote_Header;
2119: -- Standard call to check for call compatibility
2120: IF NOT FND_API.Compatible_API_Call ( l_api_version
2121: ,p_api_version

Line 2119: -- Standard call to check for call compatibility

2115: BEGIN
2116:
2117: -- Standard Start of API savepoint
2118: SAVEPOINT Promote_Header;
2119: -- Standard call to check for call compatibility
2120: IF NOT FND_API.Compatible_API_Call ( l_api_version
2121: ,p_api_version
2122: ,l_api_name
2123: ,G_PKG_NAME )

Line 3052: -- Standard ending code ------------------------------------------------

3048:
3049: END IF; -- if (p_skip_promotion='Y')
3050:
3051:
3052: -- Standard ending code ------------------------------------------------
3053: IF FND_API.To_Boolean ( p_commit ) THEN
3054: COMMIT WORK;
3055: END IF;
3056:

Line 3226: -- Standard Start of API savepoint

3222: -- Bug 6695079 End
3223:
3224: BEGIN
3225: select status_type, status_code into l_old_status_code, l_old_status_type from eng_engineering_changes where change_id = p_change_id;
3226: -- Standard Start of API savepoint
3227: SAVEPOINT Demote_Header;
3228: -- Standard call to check for call compatibility
3229: IF NOT FND_API.Compatible_API_Call ( l_api_version
3230: ,p_api_version

Line 3228: -- Standard call to check for call compatibility

3224: BEGIN
3225: select status_type, status_code into l_old_status_code, l_old_status_type from eng_engineering_changes where change_id = p_change_id;
3226: -- Standard Start of API savepoint
3227: SAVEPOINT Demote_Header;
3228: -- Standard call to check for call compatibility
3229: IF NOT FND_API.Compatible_API_Call ( l_api_version
3230: ,p_api_version
3231: ,l_api_name
3232: ,G_PKG_NAME )

Line 3775: -- Standard ending code ------------------------------------------------

3771: --#FND_MSG_PUB.Add;
3772: RAISE FND_API.G_EXC_ERROR;
3773: END IF;
3774:
3775: -- Standard ending code ------------------------------------------------
3776: IF FND_API.To_Boolean ( p_commit ) THEN
3777: COMMIT WORK;
3778: END IF;
3779:

Line 3920: -- Standard Start of API savepoint

3916: l_request_id NUMBER;
3917:
3918: l_row_cnt NUMBER := 0;
3919: BEGIN
3920: -- Standard Start of API savepoint
3921: SAVEPOINT Promote_Revised_Item;
3922: -- Standard call to check for call compatibility
3923: IF NOT FND_API.Compatible_API_Call ( l_api_version
3924: ,p_api_version

Line 3922: -- Standard call to check for call compatibility

3918: l_row_cnt NUMBER := 0;
3919: BEGIN
3920: -- Standard Start of API savepoint
3921: SAVEPOINT Promote_Revised_Item;
3922: -- Standard call to check for call compatibility
3923: IF NOT FND_API.Compatible_API_Call ( l_api_version
3924: ,p_api_version
3925: ,l_api_name
3926: ,G_PKG_NAME )

Line 4189: -- Standard ending code ------------------------------------------------

4185: Write_Debug('Done: Updating revised items to the new phase');
4186: END IF;
4187:
4188:
4189: -- Standard ending code ------------------------------------------------
4190: IF FND_API.To_Boolean ( p_commit ) THEN
4191: COMMIT WORK;
4192: END IF;
4193:

Line 4293: -- Standard Start of API savepoint

4289:
4290: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4291:
4292: BEGIN
4293: -- Standard Start of API savepoint
4294: SAVEPOINT Demote_Revised_Item;
4295: -- Standard call to check for call compatibility
4296: IF NOT FND_API.Compatible_API_Call ( l_api_version
4297: ,p_api_version

Line 4295: -- Standard call to check for call compatibility

4291:
4292: BEGIN
4293: -- Standard Start of API savepoint
4294: SAVEPOINT Demote_Revised_Item;
4295: -- Standard call to check for call compatibility
4296: IF NOT FND_API.Compatible_API_Call ( l_api_version
4297: ,p_api_version
4298: ,l_api_name
4299: ,G_PKG_NAME )

Line 4498: -- Standard ending code ------------------------------------------------

4494: IF g_debug_flag THEN
4495: Write_Debug('Done: Updating revised items to the new phase');
4496: END IF;
4497:
4498: -- Standard ending code ------------------------------------------------
4499: IF FND_API.To_Boolean ( p_commit ) THEN
4500: COMMIT WORK;
4501: END IF;
4502:

Line 4596: -- Standard Start of API savepoint

4592: l_curr_status_type eng_engineering_changes.status_type%TYPE;
4593: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4594: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
4595: BEGIN
4596: -- Standard Start of API savepoint
4597: SAVEPOINT Change_Phase;
4598: -- Standard call to check for call compatibility
4599: IF NOT FND_API.Compatible_API_Call ( l_api_version
4600: ,p_api_version

Line 4598: -- Standard call to check for call compatibility

4594: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
4595: BEGIN
4596: -- Standard Start of API savepoint
4597: SAVEPOINT Change_Phase;
4598: -- Standard call to check for call compatibility
4599: IF NOT FND_API.Compatible_API_Call ( l_api_version
4600: ,p_api_version
4601: ,l_api_name
4602: ,G_PKG_NAME )

Line 4821: -- Standard ending code ------------------------------------------------

4817: Write_Debug('Error: p_object_name is neither ENG_CHANGE nor ENG_REVISED_ITEM') ;
4818: END IF;
4819: END IF;
4820:
4821: -- Standard ending code ------------------------------------------------
4822: IF FND_API.To_Boolean ( p_commit ) THEN
4823: COMMIT WORK;
4824: END IF;
4825:

Line 5012: -- Standard Start of API savepoint

5008: l_flag_imp_failed VARCHAR2(1) := 'N';
5009:
5010: BEGIN
5011:
5012: -- Standard Start of API savepoint
5013: SAVEPOINT Update_Lifecycle_States;
5014: -- Standard call to check for call compatibility
5015: IF NOT FND_API.Compatible_API_Call ( l_api_version
5016: ,p_api_version

Line 5014: -- Standard call to check for call compatibility

5010: BEGIN
5011:
5012: -- Standard Start of API savepoint
5013: SAVEPOINT Update_Lifecycle_States;
5014: -- Standard call to check for call compatibility
5015: IF NOT FND_API.Compatible_API_Call ( l_api_version
5016: ,p_api_version
5017: ,l_api_name
5018: ,G_PKG_NAME )

Line 6350: -- Standard ending code ------------------------------------------------

6346: ,p_wf_route_status => p_route_status -- workflow routing status (for document types)
6347: ,p_api_caller => p_api_caller -- Optionnal for future use
6348: );
6349: END IF;
6350: -- Standard ending code ------------------------------------------------
6351: IF FND_API.To_Boolean ( p_commit ) THEN
6352: COMMIT WORK;
6353: END IF;
6354:

Line 6456: -- Standard Start of API savepoint

6452: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;
6453: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
6454:
6455: BEGIN
6456: -- Standard Start of API savepoint
6457: SAVEPOINT Refresh_WF_Route;
6458: -- Standard call to check for call compatibility
6459: IF NOT FND_API.Compatible_API_Call ( l_api_version
6460: ,p_api_version

Line 6458: -- Standard call to check for call compatibility

6454:
6455: BEGIN
6456: -- Standard Start of API savepoint
6457: SAVEPOINT Refresh_WF_Route;
6458: -- Standard call to check for call compatibility
6459: IF NOT FND_API.Compatible_API_Call ( l_api_version
6460: ,p_api_version
6461: ,l_api_name
6462: ,G_PKG_NAME )

Line 6586: -- Standard ending code ------------------------------------------------

6582: FND_MSG_PUB.Add;
6583: RAISE FND_API.G_EXC_ERROR;
6584: END IF;
6585:
6586: -- Standard ending code ------------------------------------------------
6587: IF FND_API.To_Boolean ( p_commit ) THEN
6588: COMMIT WORK;
6589: END IF;
6590:

Line 6735: -- Standard Start of API savepoint

6731: l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
6732: l_wf_only_flag BOOLEAN ;
6733:
6734: BEGIN
6735: -- Standard Start of API savepoint
6736: SAVEPOINT Init_Lifecycle;
6737: --Error_Handler.Initialize; --Bug 11825003
6738: -- Standard call to check for call compatibility
6739: IF NOT FND_API.Compatible_API_Call ( l_api_version

Line 6738: -- Standard call to check for call compatibility

6734: BEGIN
6735: -- Standard Start of API savepoint
6736: SAVEPOINT Init_Lifecycle;
6737: --Error_Handler.Initialize; --Bug 11825003
6738: -- Standard call to check for call compatibility
6739: IF NOT FND_API.Compatible_API_Call ( l_api_version
6740: ,p_api_version
6741: ,l_api_name
6742: ,G_PKG_NAME )

Line 7291: -- Standard ending code ------------------------------------------------

7287: --#FND_MSG_PUB.Add;
7288: RAISE FND_API.G_EXC_ERROR;
7289: END IF;
7290:
7291: -- Standard ending code ------------------------------------------------
7292: IF FND_API.To_Boolean ( p_commit ) THEN
7293: COMMIT WORK;
7294: END IF;
7295:

Line 7399: -- Standard Start of API savepoint

7395: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7396: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7397:
7398: BEGIN
7399: -- Standard Start of API savepoint
7400: --SAVEPOINT Update_RevItem_Lifecycle;
7401: -- Standard call to check for call compatibility
7402: IF NOT FND_API.Compatible_API_Call ( l_api_version
7403: ,p_api_version

Line 7401: -- Standard call to check for call compatibility

7397:
7398: BEGIN
7399: -- Standard Start of API savepoint
7400: --SAVEPOINT Update_RevItem_Lifecycle;
7401: -- Standard call to check for call compatibility
7402: IF NOT FND_API.Compatible_API_Call ( l_api_version
7403: ,p_api_version
7404: ,l_api_name
7405: ,G_PKG_NAME )

Line 7455: -- Standard ending code ------------------------------------------------

7451: last_update_login = l_fnd_login_id
7452: WHERE revised_item_sequence_id = p_rev_item_seq_id;
7453:
7454:
7455: -- Standard ending code ------------------------------------------------
7456: IF FND_API.To_Boolean ( p_commit ) THEN
7457: COMMIT WORK;
7458: END IF;
7459:

Line 7585: -- Standard Start of API savepoint

7581:
7582:
7583: BEGIN
7584:
7585: -- Standard Start of API savepoint
7586: SAVEPOINT Reset_Phase ;
7587: -- Standard call to check for call compatibility
7588: IF NOT FND_API.Compatible_API_Call ( l_api_version
7589: ,p_api_version

Line 7587: -- Standard call to check for call compatibility

7583: BEGIN
7584:
7585: -- Standard Start of API savepoint
7586: SAVEPOINT Reset_Phase ;
7587: -- Standard call to check for call compatibility
7588: IF NOT FND_API.Compatible_API_Call ( l_api_version
7589: ,p_api_version
7590: ,l_api_name
7591: ,G_PKG_NAME )

Line 7850: -- Standard ending code ------------------------------------------------

7846:
7847: END IF ; -- if ( Change Object is Documet LC Object)
7848:
7849:
7850: -- Standard ending code ------------------------------------------------
7851: IF FND_API.To_Boolean ( p_commit ) THEN
7852: COMMIT WORK;
7853: END IF;
7854:

Line 7869: -- Standard check of p_commit.

7865: END IF;
7866:
7867: EXCEPTION
7868: WHEN FND_API.G_EXC_ERROR THEN
7869: -- Standard check of p_commit.
7870: IF FND_API.To_Boolean( p_commit ) THEN
7871: IF g_debug_flag THEN
7872: Write_Debug('Rollback . . .') ;
7873: END IF ;

Line 7893: -- Standard check of p_commit.

7889: END IF;
7890:
7891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7892:
7893: -- Standard check of p_commit.
7894: IF FND_API.To_Boolean( p_commit ) THEN
7895: IF g_debug_flag THEN
7896: Write_Debug('Rollback . . .') ;
7897: END IF ;

Line 7919: -- Standard check of p_commit.

7915:
7916:
7917: WHEN OTHERS THEN
7918:
7919: -- Standard check of p_commit.
7920: IF FND_API.To_Boolean( p_commit ) THEN
7921: IF g_debug_flag THEN
7922: Write_Debug('Rollback . . .') ;
7923: END IF ;

Line 8020: -- Standard Start of API savepoint

8016:
8017:
8018: BEGIN
8019:
8020: -- Standard Start of API savepoint
8021: SAVEPOINT Sync_LC_Phase_Setup ;
8022: -- Standard call to check for call compatibility
8023: IF NOT FND_API.Compatible_API_Call ( l_api_version
8024: ,p_api_version

Line 8022: -- Standard call to check for call compatibility

8018: BEGIN
8019:
8020: -- Standard Start of API savepoint
8021: SAVEPOINT Sync_LC_Phase_Setup ;
8022: -- Standard call to check for call compatibility
8023: IF NOT FND_API.Compatible_API_Call ( l_api_version
8024: ,p_api_version
8025: ,l_api_name
8026: ,G_PKG_NAME )

Line 8386: -- Standard ending code ------------------------------------------------

8382: END IF ;
8383:
8384:
8385:
8386: -- Standard ending code ------------------------------------------------
8387: IF FND_API.To_Boolean ( p_commit ) THEN
8388: COMMIT WORK;
8389: END IF;
8390:

Line 8405: -- Standard check of p_commit.

8401: END IF;
8402:
8403: EXCEPTION
8404: WHEN FND_API.G_EXC_ERROR THEN
8405: -- Standard check of p_commit.
8406: IF FND_API.To_Boolean( p_commit ) THEN
8407: IF g_debug_flag THEN
8408: Write_Debug('Rollback . . .') ;
8409: END IF ;

Line 8429: -- Standard check of p_commit.

8425: END IF;
8426:
8427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8428:
8429: -- Standard check of p_commit.
8430: IF FND_API.To_Boolean( p_commit ) THEN
8431: IF g_debug_flag THEN
8432: Write_Debug('Rollback . . .') ;
8433: END IF ;

Line 8455: -- Standard check of p_commit.

8451:
8452:
8453: WHEN OTHERS THEN
8454:
8455: -- Standard check of p_commit.
8456: IF FND_API.To_Boolean( p_commit ) THEN
8457: IF g_debug_flag THEN
8458: Write_Debug('Rollback . . .') ;
8459: END IF ;