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 625: -- Standard Start of API savepoint

621:
622: l_doc_lc_object_flag BOOLEAN := FALSE ;
623:
624: BEGIN
625: -- Standard Start of API savepoint
626: --SAVEPOINT Update_Header_Appr_Status;
627: -- Standard call to check for call compatibility
628: IF NOT FND_API.Compatible_API_Call ( l_api_version
629: ,p_api_version

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

623:
624: BEGIN
625: -- Standard Start of API savepoint
626: --SAVEPOINT Update_Header_Appr_Status;
627: -- Standard call to check for call compatibility
628: IF NOT FND_API.Compatible_API_Call ( l_api_version
629: ,p_api_version
630: ,l_api_name
631: ,G_PKG_NAME )

Line 1130: -- Standard ending code ------------------------------------------------

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

Line 1314: -- Standard Start of API savepoint

1310: AND cur_status.status_code = c_cur_status_code
1311: AND cur_status.active_flag = 'Y' ;
1312:
1313: BEGIN
1314: -- Standard Start of API savepoint
1315: --SAVEPOINT Start_Line_Workflow;
1316: -- Standard call to check for call compatibility
1317: IF NOT FND_API.Compatible_API_Call ( l_api_version
1318: ,p_api_version

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

1312:
1313: BEGIN
1314: -- Standard Start of API savepoint
1315: --SAVEPOINT Start_Line_Workflow;
1316: -- Standard call to check for call compatibility
1317: IF NOT FND_API.Compatible_API_Call ( l_api_version
1318: ,p_api_version
1319: ,l_api_name
1320: ,G_PKG_NAME )

Line 1437: -- Standard ending code ------------------------------------------------

1433: END LOOP ; -- c_line_wf loop
1434:
1435: END IF; -- if (action = PROMOTE)
1436:
1437: -- Standard ending code ------------------------------------------------
1438: IF FND_API.To_Boolean ( p_commit ) THEN
1439: COMMIT WORK;
1440: END IF;
1441:

Line 1553: -- Standard Start of API savepoint

1549: l_doc_lc_object_flag BOOLEAN := FALSE ;
1550:
1551:
1552: BEGIN
1553: -- Standard Start of API savepoint
1554: --SAVEPOINT Start_WF_OnlyIf_Necessary;
1555: -- Standard call to check for call compatibility
1556: IF NOT FND_API.Compatible_API_Call ( l_api_version
1557: ,p_api_version

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

1551:
1552: BEGIN
1553: -- Standard Start of API savepoint
1554: --SAVEPOINT Start_WF_OnlyIf_Necessary;
1555: -- Standard call to check for call compatibility
1556: IF NOT FND_API.Compatible_API_Call ( l_api_version
1557: ,p_api_version
1558: ,l_api_name
1559: ,G_PKG_NAME )

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

1679:
1680: -- Force commit to make sure workflow picks up the latest phase
1681: COMMIT WORK;
1682:
1683: -- launch the standard action workflow for new action if needed
1684: IF g_debug_flag THEN
1685: Write_Debug('Before: calling status change workflow API');
1686: END IF;
1687:

Line 1865: -- Standard ending code ------------------------------------------------

1861: END IF; -- if (phase workflow instance id and workflow template id)
1862:
1863: END IF; -- if (action = PROMOTE)
1864:
1865: -- Standard ending code ------------------------------------------------
1866: IF FND_API.To_Boolean ( p_commit ) THEN
1867: COMMIT WORK;
1868: END IF;
1869:

Line 2077: -- Standard Start of API savepoint

2073: l_eco_approval_status VARCHAR2(1); -- Bug 3769329
2074:
2075: BEGIN
2076:
2077: -- Standard Start of API savepoint
2078: SAVEPOINT Promote_Header;
2079: -- Standard call to check for call compatibility
2080: IF NOT FND_API.Compatible_API_Call ( l_api_version
2081: ,p_api_version

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

2075: BEGIN
2076:
2077: -- Standard Start of API savepoint
2078: SAVEPOINT Promote_Header;
2079: -- Standard call to check for call compatibility
2080: IF NOT FND_API.Compatible_API_Call ( l_api_version
2081: ,p_api_version
2082: ,l_api_name
2083: ,G_PKG_NAME )

Line 2961: -- Standard ending code ------------------------------------------------

2957:
2958: END IF; -- if (p_skip_promotion='Y')
2959:
2960:
2961: -- Standard ending code ------------------------------------------------
2962: IF FND_API.To_Boolean ( p_commit ) THEN
2963: COMMIT WORK;
2964: END IF;
2965:

Line 3122: -- Standard Start of API savepoint

3118: l_old_status_type NUMBER;
3119:
3120: BEGIN
3121: select status_type, status_code into l_old_status_code, l_old_status_type from eng_engineering_changes where change_id = p_change_id;
3122: -- Standard Start of API savepoint
3123: SAVEPOINT Demote_Header;
3124: -- Standard call to check for call compatibility
3125: IF NOT FND_API.Compatible_API_Call ( l_api_version
3126: ,p_api_version

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

3120: BEGIN
3121: select status_type, status_code into l_old_status_code, l_old_status_type from eng_engineering_changes where change_id = p_change_id;
3122: -- Standard Start of API savepoint
3123: SAVEPOINT Demote_Header;
3124: -- Standard call to check for call compatibility
3125: IF NOT FND_API.Compatible_API_Call ( l_api_version
3126: ,p_api_version
3127: ,l_api_name
3128: ,G_PKG_NAME )

Line 3657: -- Standard ending code ------------------------------------------------

3653: --#FND_MSG_PUB.Add;
3654: RAISE FND_API.G_EXC_ERROR;
3655: END IF;
3656:
3657: -- Standard ending code ------------------------------------------------
3658: IF FND_API.To_Boolean ( p_commit ) THEN
3659: COMMIT WORK;
3660: END IF;
3661:

Line 3802: -- Standard Start of API savepoint

3798: l_request_id NUMBER;
3799:
3800: l_row_cnt NUMBER := 0;
3801: BEGIN
3802: -- Standard Start of API savepoint
3803: SAVEPOINT Promote_Revised_Item;
3804: -- Standard call to check for call compatibility
3805: IF NOT FND_API.Compatible_API_Call ( l_api_version
3806: ,p_api_version

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

3800: l_row_cnt NUMBER := 0;
3801: BEGIN
3802: -- Standard Start of API savepoint
3803: SAVEPOINT Promote_Revised_Item;
3804: -- Standard call to check for call compatibility
3805: IF NOT FND_API.Compatible_API_Call ( l_api_version
3806: ,p_api_version
3807: ,l_api_name
3808: ,G_PKG_NAME )

Line 4071: -- Standard ending code ------------------------------------------------

4067: Write_Debug('Done: Updating revised items to the new phase');
4068: END IF;
4069:
4070:
4071: -- Standard ending code ------------------------------------------------
4072: IF FND_API.To_Boolean ( p_commit ) THEN
4073: COMMIT WORK;
4074: END IF;
4075:

Line 4175: -- Standard Start of API savepoint

4171:
4172: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4173:
4174: BEGIN
4175: -- Standard Start of API savepoint
4176: SAVEPOINT Demote_Revised_Item;
4177: -- Standard call to check for call compatibility
4178: IF NOT FND_API.Compatible_API_Call ( l_api_version
4179: ,p_api_version

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

4173:
4174: BEGIN
4175: -- Standard Start of API savepoint
4176: SAVEPOINT Demote_Revised_Item;
4177: -- Standard call to check for call compatibility
4178: IF NOT FND_API.Compatible_API_Call ( l_api_version
4179: ,p_api_version
4180: ,l_api_name
4181: ,G_PKG_NAME )

Line 4380: -- Standard ending code ------------------------------------------------

4376: IF g_debug_flag THEN
4377: Write_Debug('Done: Updating revised items to the new phase');
4378: END IF;
4379:
4380: -- Standard ending code ------------------------------------------------
4381: IF FND_API.To_Boolean ( p_commit ) THEN
4382: COMMIT WORK;
4383: END IF;
4384:

Line 4478: -- Standard Start of API savepoint

4474: l_curr_status_type eng_engineering_changes.status_type%TYPE;
4475: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4476: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
4477: BEGIN
4478: -- Standard Start of API savepoint
4479: SAVEPOINT Change_Phase;
4480: -- Standard call to check for call compatibility
4481: IF NOT FND_API.Compatible_API_Call ( l_api_version
4482: ,p_api_version

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

4476: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
4477: BEGIN
4478: -- Standard Start of API savepoint
4479: SAVEPOINT Change_Phase;
4480: -- Standard call to check for call compatibility
4481: IF NOT FND_API.Compatible_API_Call ( l_api_version
4482: ,p_api_version
4483: ,l_api_name
4484: ,G_PKG_NAME )

Line 4703: -- Standard ending code ------------------------------------------------

4699: Write_Debug('Error: p_object_name is neither ENG_CHANGE nor ENG_REVISED_ITEM') ;
4700: END IF;
4701: END IF;
4702:
4703: -- Standard ending code ------------------------------------------------
4704: IF FND_API.To_Boolean ( p_commit ) THEN
4705: COMMIT WORK;
4706: END IF;
4707:

Line 4894: -- Standard Start of API savepoint

4890: l_flag_imp_failed VARCHAR2(1) := 'N';
4891:
4892: BEGIN
4893:
4894: -- Standard Start of API savepoint
4895: SAVEPOINT Update_Lifecycle_States;
4896: -- Standard call to check for call compatibility
4897: IF NOT FND_API.Compatible_API_Call ( l_api_version
4898: ,p_api_version

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

4892: BEGIN
4893:
4894: -- Standard Start of API savepoint
4895: SAVEPOINT Update_Lifecycle_States;
4896: -- Standard call to check for call compatibility
4897: IF NOT FND_API.Compatible_API_Call ( l_api_version
4898: ,p_api_version
4899: ,l_api_name
4900: ,G_PKG_NAME )

Line 6186: -- Standard ending code ------------------------------------------------

6182: ,p_wf_route_status => p_route_status -- workflow routing status (for document types)
6183: ,p_api_caller => p_api_caller -- Optionnal for future use
6184: );
6185: END IF;
6186: -- Standard ending code ------------------------------------------------
6187: IF FND_API.To_Boolean ( p_commit ) THEN
6188: COMMIT WORK;
6189: END IF;
6190:

Line 6292: -- Standard Start of API savepoint

6288: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;
6289: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
6290:
6291: BEGIN
6292: -- Standard Start of API savepoint
6293: SAVEPOINT Refresh_WF_Route;
6294: -- Standard call to check for call compatibility
6295: IF NOT FND_API.Compatible_API_Call ( l_api_version
6296: ,p_api_version

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

6290:
6291: BEGIN
6292: -- Standard Start of API savepoint
6293: SAVEPOINT Refresh_WF_Route;
6294: -- Standard call to check for call compatibility
6295: IF NOT FND_API.Compatible_API_Call ( l_api_version
6296: ,p_api_version
6297: ,l_api_name
6298: ,G_PKG_NAME )

Line 6422: -- Standard ending code ------------------------------------------------

6418: FND_MSG_PUB.Add;
6419: RAISE FND_API.G_EXC_ERROR;
6420: END IF;
6421:
6422: -- Standard ending code ------------------------------------------------
6423: IF FND_API.To_Boolean ( p_commit ) THEN
6424: COMMIT WORK;
6425: END IF;
6426:

Line 6565: -- Standard Start of API savepoint

6561: l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
6562: l_wf_only_flag BOOLEAN ;
6563:
6564: BEGIN
6565: -- Standard Start of API savepoint
6566: SAVEPOINT Init_Lifecycle;
6567: -- Standard call to check for call compatibility
6568: IF NOT FND_API.Compatible_API_Call ( l_api_version
6569: ,p_api_version

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

6563:
6564: BEGIN
6565: -- Standard Start of API savepoint
6566: SAVEPOINT Init_Lifecycle;
6567: -- Standard call to check for call compatibility
6568: IF NOT FND_API.Compatible_API_Call ( l_api_version
6569: ,p_api_version
6570: ,l_api_name
6571: ,G_PKG_NAME )

Line 7014: -- Standard ending code ------------------------------------------------

7010: --#FND_MSG_PUB.Add;
7011: RAISE FND_API.G_EXC_ERROR;
7012: END IF;
7013:
7014: -- Standard ending code ------------------------------------------------
7015: IF FND_API.To_Boolean ( p_commit ) THEN
7016: COMMIT WORK;
7017: END IF;
7018:

Line 7108: -- Standard Start of API savepoint

7104: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7105: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7106:
7107: BEGIN
7108: -- Standard Start of API savepoint
7109: --SAVEPOINT Update_RevItem_Lifecycle;
7110: -- Standard call to check for call compatibility
7111: IF NOT FND_API.Compatible_API_Call ( l_api_version
7112: ,p_api_version

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

7106:
7107: BEGIN
7108: -- Standard Start of API savepoint
7109: --SAVEPOINT Update_RevItem_Lifecycle;
7110: -- Standard call to check for call compatibility
7111: IF NOT FND_API.Compatible_API_Call ( l_api_version
7112: ,p_api_version
7113: ,l_api_name
7114: ,G_PKG_NAME )

Line 7164: -- Standard ending code ------------------------------------------------

7160: last_update_login = l_fnd_login_id
7161: WHERE revised_item_sequence_id = p_rev_item_seq_id;
7162:
7163:
7164: -- Standard ending code ------------------------------------------------
7165: IF FND_API.To_Boolean ( p_commit ) THEN
7166: COMMIT WORK;
7167: END IF;
7168:

Line 7294: -- Standard Start of API savepoint

7290:
7291:
7292: BEGIN
7293:
7294: -- Standard Start of API savepoint
7295: SAVEPOINT Reset_Phase ;
7296: -- Standard call to check for call compatibility
7297: IF NOT FND_API.Compatible_API_Call ( l_api_version
7298: ,p_api_version

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

7292: BEGIN
7293:
7294: -- Standard Start of API savepoint
7295: SAVEPOINT Reset_Phase ;
7296: -- Standard call to check for call compatibility
7297: IF NOT FND_API.Compatible_API_Call ( l_api_version
7298: ,p_api_version
7299: ,l_api_name
7300: ,G_PKG_NAME )

Line 7559: -- Standard ending code ------------------------------------------------

7555:
7556: END IF ; -- if ( Change Object is Documet LC Object)
7557:
7558:
7559: -- Standard ending code ------------------------------------------------
7560: IF FND_API.To_Boolean ( p_commit ) THEN
7561: COMMIT WORK;
7562: END IF;
7563:

Line 7578: -- Standard check of p_commit.

7574: END IF;
7575:
7576: EXCEPTION
7577: WHEN FND_API.G_EXC_ERROR THEN
7578: -- Standard check of p_commit.
7579: IF FND_API.To_Boolean( p_commit ) THEN
7580: IF g_debug_flag THEN
7581: Write_Debug('Rollback . . .') ;
7582: END IF ;

Line 7602: -- Standard check of p_commit.

7598: END IF;
7599:
7600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7601:
7602: -- Standard check of p_commit.
7603: IF FND_API.To_Boolean( p_commit ) THEN
7604: IF g_debug_flag THEN
7605: Write_Debug('Rollback . . .') ;
7606: END IF ;

Line 7628: -- Standard check of p_commit.

7624:
7625:
7626: WHEN OTHERS THEN
7627:
7628: -- Standard check of p_commit.
7629: IF FND_API.To_Boolean( p_commit ) THEN
7630: IF g_debug_flag THEN
7631: Write_Debug('Rollback . . .') ;
7632: END IF ;

Line 7729: -- Standard Start of API savepoint

7725:
7726:
7727: BEGIN
7728:
7729: -- Standard Start of API savepoint
7730: SAVEPOINT Sync_LC_Phase_Setup ;
7731: -- Standard call to check for call compatibility
7732: IF NOT FND_API.Compatible_API_Call ( l_api_version
7733: ,p_api_version

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

7727: BEGIN
7728:
7729: -- Standard Start of API savepoint
7730: SAVEPOINT Sync_LC_Phase_Setup ;
7731: -- Standard call to check for call compatibility
7732: IF NOT FND_API.Compatible_API_Call ( l_api_version
7733: ,p_api_version
7734: ,l_api_name
7735: ,G_PKG_NAME )

Line 8095: -- Standard ending code ------------------------------------------------

8091: END IF ;
8092:
8093:
8094:
8095: -- Standard ending code ------------------------------------------------
8096: IF FND_API.To_Boolean ( p_commit ) THEN
8097: COMMIT WORK;
8098: END IF;
8099:

Line 8114: -- Standard check of p_commit.

8110: END IF;
8111:
8112: EXCEPTION
8113: WHEN FND_API.G_EXC_ERROR THEN
8114: -- Standard check of p_commit.
8115: IF FND_API.To_Boolean( p_commit ) THEN
8116: IF g_debug_flag THEN
8117: Write_Debug('Rollback . . .') ;
8118: END IF ;

Line 8138: -- Standard check of p_commit.

8134: END IF;
8135:
8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8137:
8138: -- Standard check of p_commit.
8139: IF FND_API.To_Boolean( p_commit ) THEN
8140: IF g_debug_flag THEN
8141: Write_Debug('Rollback . . .') ;
8142: END IF ;

Line 8164: -- Standard check of p_commit.

8160:
8161:
8162: WHEN OTHERS THEN
8163:
8164: -- Standard check of p_commit.
8165: IF FND_API.To_Boolean( p_commit ) THEN
8166: IF g_debug_flag THEN
8167: Write_Debug('Rollback . . .') ;
8168: END IF ;