DBA Data[Home] [Help]

APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_ACTIONS

Line 1554: l_action_id eng_change_actions.action_id%TYPE;

1550: l_api_caller VARCHAR2(2) := NULL;
1551: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1552: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1553:
1554: l_action_id eng_change_actions.action_id%TYPE;
1555:
1556: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
1557: l_wf_route_temp_id eng_lifecycle_statuses.change_wf_route_template_id%TYPE;
1558: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;

Line 1637: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

1633: Write_Debug('Before: saving action log');
1634: END IF;
1635: l_action_id := 0;
1636: -- create new action log
1637: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
1638: ( p_api_version => 1.0
1639: , p_init_msg_list => FND_API.G_FALSE --
1640: , p_commit => FND_API.G_FALSE --
1641: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1673: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

1669: x_return_status := l_return_status;
1670: x_msg_count := l_msg_count;
1671: x_msg_data := l_msg_data;
1672: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1673: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
1674: --#FND_MSG_PUB.Add;
1675: RAISE FND_API.G_EXC_ERROR;
1676: END IF;
1677: IF g_debug_flag THEN

Line 2087: l_action_id eng_change_actions.action_id%TYPE;

2083: );
2084:
2085: l_request_id NUMBER := 0;
2086:
2087: l_action_id eng_change_actions.action_id%TYPE;
2088:
2089: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
2090: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2091: l_new_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

Line 2835: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

2831: -- create new action log
2832: -- Bug Fix: 3547844
2833: -- In case of Auto-Propgation Action Log
2834: -- Who column is Workflow
2835: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
2836: ( p_api_version => 1.0
2837: , p_init_msg_list => FND_API.G_FALSE --
2838: , p_commit => FND_API.G_FALSE --
2839: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2846: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE

2842: , p_debug_filename => NULL
2843: , x_return_status => l_return_status
2844: , x_msg_count => l_msg_count
2845: , x_msg_data => l_msg_data
2846: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE
2847: , p_object_name => G_ENG_CHANGE
2848: , p_object_id1 => p_change_id
2849: , p_object_id2 => NULL
2850: , p_object_id3 => NULL

Line 2874: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

2870: x_return_status := l_return_status;
2871: x_msg_count := l_msg_count;
2872: x_msg_data := l_msg_data;
2873: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2874: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
2875: --#FND_MSG_PUB.Add;
2876: RAISE FND_API.G_EXC_ERROR;
2877: END IF;
2878:

Line 4967: l_action_id eng_change_actions.action_id%TYPE;

4963: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4964:
4965: l_api_caller VARCHAR2(2) := NULL;
4966:
4967: l_action_id eng_change_actions.action_id%TYPE;
4968:
4969: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4970: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4971:

Line 5273: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

5269: Write_Debug('Before: saving action log');
5270: END IF;
5271: l_action_id := 0;
5272: -- create new action log
5273: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
5274: ( p_api_version => 1.0
5275: , p_init_msg_list => FND_API.G_FALSE --
5276: , p_commit => FND_API.G_FALSE --
5277: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5284: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED

5280: , p_debug_filename => NULL
5281: , x_return_status => l_return_status
5282: , x_msg_count => l_msg_count
5283: , x_msg_data => l_msg_data
5284: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED
5285: , p_object_name => G_ENG_CHANGE
5286: , p_object_id1 => p_change_id
5287: , p_object_id2 => NULL
5288: , p_object_id3 => NULL

Line 5312: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

5308: x_return_status := l_return_status;
5309: x_msg_count := l_msg_count;
5310: x_msg_data := l_msg_data;
5311: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
5312: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
5313: --#FND_MSG_PUB.Add;
5314: RAISE FND_API.G_EXC_ERROR;
5315: END IF;
5316: IF g_debug_flag THEN

Line 5354: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

5350: Write_Debug('Before: saving action log');
5351: END IF;
5352: l_action_id := 0;
5353: -- create new action log
5354: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
5355: ( p_api_version => 1.0
5356: , p_init_msg_list => FND_API.G_FALSE --
5357: , p_commit => FND_API.G_FALSE --
5358: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5365: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_IN_PROGRESS

5361: , p_debug_filename => NULL
5362: , x_return_status => l_return_status
5363: , x_msg_count => l_msg_count
5364: , x_msg_data => l_msg_data
5365: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_IN_PROGRESS
5366: , p_object_name => G_ENG_CHANGE
5367: , p_object_id1 => p_change_id
5368: , p_object_id2 => NULL
5369: , p_object_id3 => NULL

Line 5392: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

5388: x_return_status := l_return_status;
5389: x_msg_count := l_msg_count;
5390: x_msg_data := l_msg_data;
5391: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
5392: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
5393: --#FND_MSG_PUB.Add;
5394: RAISE FND_API.G_EXC_ERROR;
5395: END IF;
5396: IF g_debug_flag THEN

Line 6137: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

6133: Write_Debug('Before: saving action log');
6134: END IF;
6135: l_action_id := 0;
6136: -- create new action log
6137: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
6138: ( p_api_version => 1.0
6139: , p_init_msg_list => FND_API.G_FALSE --
6140: , p_commit => FND_API.G_FALSE --
6141: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6148: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED

6144: , p_debug_filename => NULL
6145: , x_return_status => l_return_status
6146: , x_msg_count => l_msg_count
6147: , x_msg_data => l_msg_data
6148: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED
6149: , p_object_name => G_ENG_CHANGE
6150: , p_object_id1 => p_change_id
6151: , p_object_id2 => NULL
6152: , p_object_id3 => NULL

Line 6174: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

6170: x_return_status := l_return_status;
6171: x_msg_count := l_msg_count;
6172: x_msg_data := l_msg_data;
6173: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6174: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
6175: --#FND_MSG_PUB.Add;
6176: RAISE FND_API.G_EXC_ERROR;
6177: END IF;
6178: IF g_debug_flag THEN

Line 6730: l_action_id eng_change_actions.action_id%TYPE;

6726: AND ood.LANGUAGE = USERENV('LANG');
6727:
6728: l_request_id NUMBER := 0;
6729:
6730: l_action_id eng_change_actions.action_id%TYPE;
6731: l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
6732: l_wf_only_flag BOOLEAN ;
6733:
6734: BEGIN

Line 7022: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

7018: END IF;
7019: -- Record SUBMIT action log and raise submit business event
7020: l_action_id := 0;
7021: -- create new action log
7022: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
7023: ( p_api_version => 1.0
7024: , p_init_msg_list => FND_API.G_FALSE --
7025: , p_commit => FND_API.G_FALSE --
7026: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 7033: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_SUBMIT

7029: , p_debug_filename => 'engact.CreateAction.log'
7030: , x_return_status => l_return_status
7031: , x_msg_count => l_msg_count
7032: , x_msg_data => l_msg_data
7033: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_SUBMIT
7034: , p_object_name => G_ENG_CHANGE
7035: , p_object_id1 => p_change_id
7036: , p_object_id2 => NULL
7037: , p_object_id3 => NULL

Line 7058: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

7054: x_return_status := l_return_status;
7055: x_msg_count := l_msg_count;
7056: x_msg_data := l_msg_data;
7057: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
7058: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
7059: --#FND_MSG_PUB.Add;
7060: RAISE FND_API.G_EXC_ERROR;
7061: END IF;
7062: IF g_debug_flag THEN

Line 7196: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

7192: -- create new action log
7193: -- Bug Fix: 3547844
7194: -- In case of Auto-Propgation Action Log
7195: -- Who column is Workflow
7196: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
7197: ( p_api_version => 1.0
7198: , p_init_msg_list => FND_API.G_FALSE --
7199: , p_commit => FND_API.G_FALSE --
7200: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 7207: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE

7203: , p_debug_filename => NULL
7204: , x_return_status => l_return_status
7205: , x_msg_count => l_msg_count
7206: , x_msg_data => l_msg_data
7207: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE
7208: , p_object_name => G_ENG_CHANGE
7209: , p_object_id1 => p_change_id
7210: , p_object_id2 => NULL
7211: , p_object_id3 => NULL

Line 7234: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');

7230: x_return_status := l_return_status;
7231: x_msg_count := l_msg_count;
7232: x_msg_data := l_msg_data;
7233: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
7234: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
7235: --#FND_MSG_PUB.Add;
7236: RAISE FND_API.G_EXC_ERROR;
7237: END IF;
7238: IF g_debug_flag THEN