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 ENG_WORKFLOW_UTIL

Line 856: Eng_Workflow_Util.StartWorkflow

852: IF g_debug_flag THEN
853: Write_Debug('Before: Launch header approval status change workflow');
854: END IF;
855:
856: Eng_Workflow_Util.StartWorkflow
857: ( p_api_version => 1.0
858: , p_init_msg_list => FND_API.G_FALSE
859: , p_commit => FND_API.G_FALSE
860: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 864: , p_item_type => Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE

860: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
861: , x_return_status => l_return_status
862: , x_msg_count => l_msg_count
863: , x_msg_data => l_msg_data
864: , p_item_type => Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE
865: , x_item_key => l_wf_item_key
866: , p_process_name => Eng_Workflow_Util.G_APPROVAL_STATUS_CHANGE_PROC
867: , p_change_id => p_change_id
868: , p_wf_user_id => l_fnd_user_id

Line 866: , p_process_name => Eng_Workflow_Util.G_APPROVAL_STATUS_CHANGE_PROC

862: , x_msg_count => l_msg_count
863: , x_msg_data => l_msg_data
864: , p_item_type => Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE
865: , x_item_key => l_wf_item_key
866: , p_process_name => Eng_Workflow_Util.G_APPROVAL_STATUS_CHANGE_PROC
867: , p_change_id => p_change_id
868: , p_wf_user_id => l_fnd_user_id
869: , p_route_id => 0 --l_wf_route_id
870: , p_debug => p_debug --FND_API.G_FALSE

Line 1306: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED

1302: eng_change_lines line,
1303: eng_lifecycle_statuses line_start_after,
1304: eng_lifecycle_statuses new_status,
1305: eng_lifecycle_statuses cur_status
1306: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
1307: AND route.route_id = line.route_id
1308: AND s.status_type <> G_ENG_COMPLETED
1309: AND s.status_type <> G_ENG_IMPLEMENTED
1310: AND s.status_type <> G_ENG_CANCELLED

Line 1407: Write_Debug('calling Eng_Workflow_Util.StartWorkflow API for Line') ;

1403: l_line_wf_route_id := l_rec.wf_route_id ;
1404: l_line_wf_item_key := NULL;
1405:
1406: IF g_debug_flag THEN
1407: Write_Debug('calling Eng_Workflow_Util.StartWorkflow API for Line') ;
1408: Write_Debug('l_change_line_id: ' || TO_CHAR(l_change_line_id) ) ;
1409: Write_Debug('l_line_wf_route_id: ' || TO_CHAR(l_line_wf_route_id) ) ;
1410: END IF;
1411:

Line 1413: Eng_Workflow_Util.StartWorkflow

1409: Write_Debug('l_line_wf_route_id: ' || TO_CHAR(l_line_wf_route_id) ) ;
1410: END IF;
1411:
1412: -- start phase-level workflow
1413: Eng_Workflow_Util.StartWorkflow
1414: ( p_api_version => 1.0
1415: , p_init_msg_list => FND_API.G_FALSE
1416: , p_commit => FND_API.G_FALSE
1417: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1421: , p_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE

1417: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1418: , x_return_status => l_return_status
1419: , x_msg_count => l_msg_count
1420: , x_msg_data => l_msg_data
1421: , p_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
1422: , x_item_key => l_line_wf_item_key
1423: , p_process_name => Eng_Workflow_Util.G_ROUTE_AGENT_PROC
1424: , p_change_id => p_change_id
1425: , p_change_line_id => l_change_line_id

Line 1423: , p_process_name => Eng_Workflow_Util.G_ROUTE_AGENT_PROC

1419: , x_msg_count => l_msg_count
1420: , x_msg_data => l_msg_data
1421: , p_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
1422: , x_item_key => l_line_wf_item_key
1423: , p_process_name => Eng_Workflow_Util.G_ROUTE_AGENT_PROC
1424: , p_change_id => p_change_id
1425: , p_change_line_id => l_change_line_id
1426: , p_wf_user_id => l_fnd_user_id
1427: , p_route_id => l_line_wf_route_id

Line 1434: Write_Debug('After: calling Eng_Workflow_Util.StartWorkflow API for ' || TO_CHAR(l_change_line_id) || l_return_status) ;

1430: , p_debug_filename => NULL
1431: ) ;
1432:
1433: IF g_debug_flag THEN
1434: Write_Debug('After: calling Eng_Workflow_Util.StartWorkflow API for ' || TO_CHAR(l_change_line_id) || l_return_status) ;
1435: Write_Debug('l_line_wf_item_key: ' || l_line_wf_item_key) ;
1436: END IF;
1437:
1438: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

Line 1711: Eng_Workflow_Util.StartWorkflow

1707: IF g_debug_flag THEN
1708: Write_Debug('Before: calling status change workflow API');
1709: END IF;
1710:
1711: Eng_Workflow_Util.StartWorkflow
1712: ( p_api_version => 1.0
1713: , p_init_msg_list => FND_API.G_FALSE
1714: , p_commit => FND_API.G_FALSE
1715: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1719: , p_item_type => Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE

1715: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1716: , x_return_status => l_return_status
1717: , x_msg_count => l_msg_count
1718: , x_msg_data => l_msg_data
1719: , p_item_type => Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE
1720: , x_item_key => l_wf_item_key
1721: , p_process_name => Eng_Workflow_Util.G_STATUS_CHANGE_PROC
1722: , p_change_id => p_change_id
1723: , p_action_id => l_action_id

Line 1721: , p_process_name => Eng_Workflow_Util.G_STATUS_CHANGE_PROC

1717: , x_msg_count => l_msg_count
1718: , x_msg_data => l_msg_data
1719: , p_item_type => Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE
1720: , x_item_key => l_wf_item_key
1721: , p_process_name => Eng_Workflow_Util.G_STATUS_CHANGE_PROC
1722: , p_change_id => p_change_id
1723: , p_action_id => l_action_id
1724: , p_wf_user_id => l_fnd_user_id
1725: , p_route_id => 0 --l_wf_route_id

Line 1788: Eng_Workflow_Util.StartWorkflow

1784: Write_Debug('Auto-starting workflow is needed, calling workflow routing agent');
1785: END IF;
1786:
1787: -- start phase-level workflow
1788: Eng_Workflow_Util.StartWorkflow
1789: ( p_api_version => 1.0
1790: , p_init_msg_list => FND_API.G_FALSE
1791: , p_commit => FND_API.G_FALSE
1792: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1796: , p_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE

1792: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1793: , x_return_status => l_return_status
1794: , x_msg_count => l_msg_count
1795: , x_msg_data => l_msg_data
1796: , p_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
1797: , x_item_key => l_wf_item_key
1798: , p_process_name => Eng_Workflow_Util.G_ROUTE_AGENT_PROC
1799: , p_change_id => p_change_id
1800: , p_wf_user_id => l_fnd_user_id

Line 1798: , p_process_name => Eng_Workflow_Util.G_ROUTE_AGENT_PROC

1794: , x_msg_count => l_msg_count
1795: , x_msg_data => l_msg_data
1796: , p_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_ITEM_TYPE
1797: , x_item_key => l_wf_item_key
1798: , p_process_name => Eng_Workflow_Util.G_ROUTE_AGENT_PROC
1799: , p_change_id => p_change_id
1800: , p_wf_user_id => l_fnd_user_id
1801: , p_route_id => l_wf_route_id
1802: , p_debug => p_debug --FND_API.G_FALSE

Line 1808: Write_Debug('After: calling Eng_Workflow_Util.StartWorkflow API: ' || l_return_status) ;

1804: , p_debug_filename => NULL
1805: ) ;
1806:
1807: IF g_debug_flag THEN
1808: Write_Debug('After: calling Eng_Workflow_Util.StartWorkflow API: ' || l_return_status) ;
1809: END IF;
1810:
1811:
1812: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

Line 2285: and l_new_wf_status = Eng_Workflow_Util.G_RT_COMPLETED)THEN

2281:
2282: -- Sanity check to make sure the new phase is after the current phase
2283: -- bug 9577905, if the new phase is not be completed
2284: IF (l_new_phase_sn <= l_curr_phase_sn
2285: and l_new_wf_status = Eng_Workflow_Util.G_RT_COMPLETED)THEN
2286: FND_MESSAGE.Set_Name('ENG','ENG_OBJ_STATE_CHANGED');
2287: FND_MSG_PUB.Add;
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;

Line 2490: AND l_eco_approval_status = Eng_Workflow_Util.G_REJECTED

2486: -- Fix for bug 4767315 - end
2487: -- Fix for Bug 3769329
2488: IF (l_base_cm_type_code = G_ENG_ECO
2489: AND l_last_imp_flag = 'Y'
2490: AND l_eco_approval_status = Eng_Workflow_Util.G_REJECTED
2491: )
2492: THEN
2493: -- Do not promote CO to implement phase in order to comply with the ERP approval status validation
2494: l_skip_promotion := 'Y';

Line 2563: IF (l_wf_route_id IS NOT NULL AND l_wf_status <> Eng_Workflow_Util.G_RT_NOT_STARTED)

2559: AND active_flag = 'Y'
2560: AND rownum = 1;
2561:
2562:
2563: IF (l_wf_route_id IS NOT NULL AND l_wf_status <> Eng_Workflow_Util.G_RT_NOT_STARTED)
2564: THEN
2565:
2566: -- Get a new workflow route_id
2567: Eng_Change_Route_Util.REFRESH_ROUTE

Line 2577: workflow_status = Eng_Workflow_Util.G_RT_NOT_STARTED,

2573:
2574: -- refresh imp phase row
2575: UPDATE eng_lifecycle_statuses
2576: SET change_wf_route_id = l_new_route_id,
2577: workflow_status = Eng_Workflow_Util.G_RT_NOT_STARTED,
2578: last_update_date = sysdate,
2579: last_updated_by = l_fnd_user_id,
2580: last_update_login = l_fnd_login_id
2581: WHERE entity_name = G_ENG_CHANGE

Line 2957: or l_new_wf_status <> Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN

2953:
2954: -- Bug 13810488 Start
2955: -- Note: If new workflow status is already IN_PROGRESS, do not start WF
2956: IF (l_new_phase_sn > l_curr_phase_sn
2957: or l_new_wf_status <> Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN
2958: -- Start workflow for new phase if necessary
2959: Start_WF_OnlyIf_Necessary
2960: ( p_api_version => 1.0
2961: ,p_init_msg_list => FND_API.G_FALSE

Line 3447: l_lcStatuses_row.workflow_status := Eng_Workflow_Util.G_RT_NOT_STARTED;

3443: -- populate wf_status based upon wf availibility of the phase
3444: IF ( l_lcStatuses_row.change_wf_route_id IS NULL ) THEN
3445: l_lcStatuses_row.workflow_status := null;
3446: ELSE
3447: l_lcStatuses_row.workflow_status := Eng_Workflow_Util.G_RT_NOT_STARTED;
3448: END IF;
3449: -- populate start_date only if it is the newly demoted phase
3450: IF ( l_lcStatuses_row.status_code = p_status_code ) THEN
3451: l_lcStatuses_row.start_date := sysdate;

Line 4660: AND l_wf_status = Eng_Workflow_Util.G_RT_IN_PROGRESS)

4656: -- workflow is available on the current phase but it is still running,
4657: -- raise error message.
4658: IF (--l_curr_status_type = G_ENG_APPROVED AND
4659: l_wf_route_id IS NOT NULL
4660: AND l_wf_status = Eng_Workflow_Util.G_RT_IN_PROGRESS)
4661: THEN
4662: FND_MESSAGE.Set_Name('ENG','ENG_OBJ_STATE_CHANGED');
4663: FND_MSG_PUB.Add;
4664: RAISE FND_API.G_EXC_ERROR;

Line 5068: IF ( p_route_status = Eng_Workflow_Util.G_RT_APPROVED

5064:
5065: -- Real code starts here -----------------------------------------------
5066:
5067: -- Translate workflow route statuses to change workflow status types
5068: IF ( p_route_status = Eng_Workflow_Util.G_RT_APPROVED
5069: OR p_route_status = Eng_Workflow_Util.G_RT_COMPLETED
5070: OR p_route_status = Eng_Workflow_Util.G_RT_REPLIED)
5071: THEN
5072: l_chg_appr_status := G_ENG_APPR_APPROVED;

Line 5069: OR p_route_status = Eng_Workflow_Util.G_RT_COMPLETED

5065: -- Real code starts here -----------------------------------------------
5066:
5067: -- Translate workflow route statuses to change workflow status types
5068: IF ( p_route_status = Eng_Workflow_Util.G_RT_APPROVED
5069: OR p_route_status = Eng_Workflow_Util.G_RT_COMPLETED
5070: OR p_route_status = Eng_Workflow_Util.G_RT_REPLIED)
5071: THEN
5072: l_chg_appr_status := G_ENG_APPR_APPROVED;
5073: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_REJECTED)

Line 5070: OR p_route_status = Eng_Workflow_Util.G_RT_REPLIED)

5066:
5067: -- Translate workflow route statuses to change workflow status types
5068: IF ( p_route_status = Eng_Workflow_Util.G_RT_APPROVED
5069: OR p_route_status = Eng_Workflow_Util.G_RT_COMPLETED
5070: OR p_route_status = Eng_Workflow_Util.G_RT_REPLIED)
5071: THEN
5072: l_chg_appr_status := G_ENG_APPR_APPROVED;
5073: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_REJECTED)
5074: THEN

Line 5073: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_REJECTED)

5069: OR p_route_status = Eng_Workflow_Util.G_RT_COMPLETED
5070: OR p_route_status = Eng_Workflow_Util.G_RT_REPLIED)
5071: THEN
5072: l_chg_appr_status := G_ENG_APPR_APPROVED;
5073: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_REJECTED)
5074: THEN
5075: l_chg_appr_status := G_ENG_APPR_REJECTED;
5076: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT)
5077: THEN

Line 5076: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT)

5072: l_chg_appr_status := G_ENG_APPR_APPROVED;
5073: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_REJECTED)
5074: THEN
5075: l_chg_appr_status := G_ENG_APPR_REJECTED;
5076: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT)
5077: THEN
5078: l_chg_appr_status := G_ENG_APPR_TIME_OUT;
5079: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5080: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED)

Line 5079: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED

5075: l_chg_appr_status := G_ENG_APPR_REJECTED;
5076: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT)
5077: THEN
5078: l_chg_appr_status := G_ENG_APPR_TIME_OUT;
5079: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5080: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED)
5081: THEN
5082: l_chg_appr_status := G_ENG_NOT_SUBMITTED;
5083: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_IN_PROGRESS)

Line 5080: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED)

5076: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT)
5077: THEN
5078: l_chg_appr_status := G_ENG_APPR_TIME_OUT;
5079: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5080: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED)
5081: THEN
5082: l_chg_appr_status := G_ENG_NOT_SUBMITTED;
5083: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_IN_PROGRESS)
5084: THEN

Line 5083: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_IN_PROGRESS)

5079: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5080: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED)
5081: THEN
5082: l_chg_appr_status := G_ENG_NOT_SUBMITTED;
5083: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_IN_PROGRESS)
5084: THEN
5085: l_chg_appr_status := G_ENG_APPR_REQUESTED;
5086: END IF;
5087: IF g_debug_flag THEN

Line 5790: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_REJECTED )

5786: END IF;
5787:
5788:
5789: -- Case 2: workflow is rejected
5790: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_REJECTED )
5791: THEN
5792: IF g_debug_flag THEN
5793: Write_Debug('Case 2: workflow is rejected');
5794: END IF;

Line 5951: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED

5947: END IF; -- if (next status_code is null)
5948:
5949:
5950: -- Case 3: workflow fails due to unexpected problems
5951: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5952: OR p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT
5953: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED )
5954: THEN
5955: IF g_debug_flag THEN

Line 5952: OR p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT

5948:
5949:
5950: -- Case 3: workflow fails due to unexpected problems
5951: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5952: OR p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT
5953: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED )
5954: THEN
5955: IF g_debug_flag THEN
5956: Write_Debug('Case 3: workflow ends with unexpected status');

Line 5953: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED )

5949:
5950: -- Case 3: workflow fails due to unexpected problems
5951: ELSIF ( p_route_status = Eng_Workflow_Util.G_RT_ABORTED
5952: OR p_route_status = Eng_Workflow_Util.G_RT_TIME_OUT
5953: OR p_route_status = Eng_Workflow_Util.G_RT_NOT_STARTED )
5954: THEN
5955: IF g_debug_flag THEN
5956: Write_Debug('Case 3: workflow ends with unexpected status');
5957: END IF;

Line 6036: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN

6032:
6033: -- Case 4: workflow calls to update phase of p_status_code
6034: -- (may not be current header status_code in case of last ECO implement phase)
6035: -- to IN_PROGRESS
6036: ELSIF (p_route_status = Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN
6037: -- sanity check: workflow must pass p_status_code for the workflow p_route_id
6038: IF (p_status_code IS NULL) THEN
6039: FND_MESSAGE.Set_Name('ENG','ENG_OBJECT_CANT_BE_NULL');
6040: FND_MESSAGE.Set_Token('OBJECT_NAME', 'p_status_code passed by workflow');

Line 6549: workflow_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED,

6545: );
6546: -- Replace the old id with the new id
6547: UPDATE eng_lifecycle_statuses
6548: SET change_wf_route_id = l_wf_route_id_new,
6549: workflow_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED,
6550: last_update_date = sysdate,
6551: last_updated_by = l_fnd_user_id,
6552: last_update_login = l_fnd_login_id
6553: WHERE CURRENT OF c_currPhase;

Line 6566: workflow_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED,

6562: Write_Debug('Branch: p_route_id is not null') ;
6563: END IF;
6564: UPDATE eng_lifecycle_statuses
6565: SET change_wf_route_id = p_wf_route_id,
6566: workflow_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED,
6567: last_update_date = sysdate,
6568: last_updated_by = l_fnd_user_id,
6569: last_update_login = l_fnd_login_id
6570: WHERE CURRENT OF c_currPhase;

Line 6808: AND (NVL(lcs.workflow_status, 'xxx') <> Eng_Workflow_Util.G_RT_COMPLETED -- for 9036674

6804: AND lcs.entity_id1 = p_change_id
6805: AND lcs.active_flag = 'Y'
6806: AND lcs.sequence_number = l_initial_phase_sn
6807: AND ecs.status_code = lcs.status_code
6808: AND (NVL(lcs.workflow_status, 'xxx') <> Eng_Workflow_Util.G_RT_COMPLETED -- for 9036674
6809: OR lcs.auto_promote_status is not null) -- bug 9577905
6810: AND rownum = 1;
6811: exception
6812: when NO_DATA_FOUND then

Line 6830: IF ( (l_workflow_status = Eng_Workflow_Util.G_RT_COMPLETED

6826:
6827: -- bug 9577905, branch for first phase be completed and and Auto Promote enabled
6828:
6829: --Bug 13810488 For Approval type (status_type: 8), if it is finished, status is APPROVED instead of COMPLETED
6830: IF ( (l_workflow_status = Eng_Workflow_Util.G_RT_COMPLETED
6831: or ( l_status_type = 8 and l_workflow_status = Eng_Workflow_Util.G_RT_APPROVED) )
6832: and l_next_status_code is not null) THEN
6833: IF g_debug_flag THEN
6834: Write_Debug('The initial status is completed or approved, the second phase not started.');

Line 6831: or ( l_status_type = 8 and l_workflow_status = Eng_Workflow_Util.G_RT_APPROVED) )

6827: -- bug 9577905, branch for first phase be completed and and Auto Promote enabled
6828:
6829: --Bug 13810488 For Approval type (status_type: 8), if it is finished, status is APPROVED instead of COMPLETED
6830: IF ( (l_workflow_status = Eng_Workflow_Util.G_RT_COMPLETED
6831: or ( l_status_type = 8 and l_workflow_status = Eng_Workflow_Util.G_RT_APPROVED) )
6832: and l_next_status_code is not null) THEN
6833: IF g_debug_flag THEN
6834: Write_Debug('The initial status is completed or approved, the second phase not started.');
6835: Write_Debug('start second phase, l_workflow_status : ' || l_workflow_status);

Line 6847: IF (NVL(l_next_status, 'xxx') <> Eng_Workflow_Util.G_RT_COMPLETED) THEN

6843: AND lcs.entity_id1 = p_change_id
6844: AND lcs.active_flag = 'Y'
6845: AND lcs.status_code = l_next_status_code;
6846:
6847: IF (NVL(l_next_status, 'xxx') <> Eng_Workflow_Util.G_RT_COMPLETED) THEN
6848:
6849: IF g_debug_flag THEN
6850: Write_Debug('In Init_Lifecyle, l_next_status_code IS NOT NULL AND first phase be completed, call PROMOTE_HEADER');
6851: END IF;

Line 6894: IF (l_workflow_status = Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN

6890: END IF;
6891: -- bug 9577905, end of branch for first phase be completed and and Auto Promote enabled
6892:
6893: -- bug 12875329
6894: IF (l_workflow_status = Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN
6895: IF g_debug_flag THEN
6896: Write_Debug('The status is started, exit...');
6897: END IF;
6898: return ; -- return to avoid the exception in Eng_Workflow_Util.CheckRouteStatus

Line 6898: return ; -- return to avoid the exception in Eng_Workflow_Util.CheckRouteStatus

6894: IF (l_workflow_status = Eng_Workflow_Util.G_RT_IN_PROGRESS) THEN
6895: IF g_debug_flag THEN
6896: Write_Debug('The status is started, exit...');
6897: END IF;
6898: return ; -- return to avoid the exception in Eng_Workflow_Util.CheckRouteStatus
6899: END IF;
6900:
6901: IF g_debug_flag THEN
6902: Write_Debug('After: getting first phase from lifecycle definitions');

Line 6962: SET workflow_status = Eng_Workflow_Util.G_RT_NOT_STARTED,

6958: END IF;
6959:
6960: -- Initialize workflow_status for all phases that have workflows
6961: UPDATE eng_lifecycle_statuses
6962: SET workflow_status = Eng_Workflow_Util.G_RT_NOT_STARTED,
6963: last_update_date = sysdate,
6964: last_updated_by = l_fnd_user_id,
6965: last_update_login = l_fnd_login_id
6966: WHERE entity_name = G_ENG_CHANGE

Line 7078: Eng_Workflow_Util.G_REQUESTED,

7074:
7075: -- for nir set all included item approval status to submitted for approval
7076: IF (l_base_cm_type_code = 'NEW_ITEM_REQUEST') THEN
7077: ENG_NIR_UTIL_PKG.set_nir_item_approval_status (p_change_id,
7078: Eng_Workflow_Util.G_REQUESTED,
7079: x_return_status => l_return_status,
7080: x_msg_count => l_msg_count,
7081: x_msg_data => l_msg_data);
7082: END IF;

Line 7720: ,p_route_status => Eng_Workflow_Util.G_RT_NOT_STARTED

7716: ,x_msg_data => l_msg_data
7717: ,p_change_id => p_change_id
7718: ,p_status_code => l_reset_status_code
7719: ,p_appr_status => G_ENG_APPR_REQUESTED
7720: ,p_route_status => Eng_Workflow_Util.G_RT_NOT_STARTED
7721: ,p_api_caller => p_api_caller
7722: ,p_bypass => 'N'
7723: );
7724: /* ELSE

Line 7740: ,p_wf_route_status => Eng_Workflow_Util.G_RT_NOT_STARTED -- workflow routing status (for document types)

7736: ,x_msg_count => l_msg_count --
7737: ,x_msg_data => l_msg_data --
7738: ,p_change_id => p_change_id -- header's change_id
7739: ,p_approval_status => G_ENG_APPR_REQUESTED-- header approval status
7740: ,p_wf_route_status => Eng_Workflow_Util.G_RT_NOT_STARTED -- workflow routing status (for document types)
7741: ,p_api_caller => p_api_caller -- Optionnal for future use
7742: );
7743: END IF;*/
7744: