DBA Data[Home] [Help]

APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_ACTIONS

Line 1538: l_action_id eng_change_actions.action_id%TYPE;

1534: l_api_caller VARCHAR2(2) := NULL;
1535: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1536: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1537:
1538: l_action_id eng_change_actions.action_id%TYPE;
1539:
1540: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
1541: l_wf_route_temp_id eng_lifecycle_statuses.change_wf_route_template_id%TYPE;
1542: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;

Line 1616: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

1612: Write_Debug('Before: saving action log');
1613: END IF;
1614: l_action_id := 0;
1615: -- create new action log
1616: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
1617: ( p_api_version => 1.0
1618: , p_init_msg_list => FND_API.G_FALSE --
1619: , p_commit => FND_API.G_FALSE --
1620: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

1648: x_return_status := l_return_status;
1649: x_msg_count := l_msg_count;
1650: x_msg_data := l_msg_data;
1651: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1652: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
1653: --#FND_MSG_PUB.Add;
1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656: IF g_debug_flag THEN

Line 2061: l_action_id eng_change_actions.action_id%TYPE;

2057: );
2058:
2059: l_request_id NUMBER := 0;
2060:
2061: l_action_id eng_change_actions.action_id%TYPE;
2062:
2063: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
2064: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2065: l_new_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

Line 2750: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

2746: -- create new action log
2747: -- Bug Fix: 3547844
2748: -- In case of Auto-Propgation Action Log
2749: -- Who column is Workflow
2750: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
2751: ( p_api_version => 1.0
2752: , p_init_msg_list => FND_API.G_FALSE --
2753: , p_commit => FND_API.G_FALSE --
2754: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2761: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE

2757: , p_debug_filename => NULL
2758: , x_return_status => l_return_status
2759: , x_msg_count => l_msg_count
2760: , x_msg_data => l_msg_data
2761: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE
2762: , p_object_name => G_ENG_CHANGE
2763: , p_object_id1 => p_change_id
2764: , p_object_id2 => NULL
2765: , p_object_id3 => NULL

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

2785: x_return_status := l_return_status;
2786: x_msg_count := l_msg_count;
2787: x_msg_data := l_msg_data;
2788: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2789: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
2790: --#FND_MSG_PUB.Add;
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793:

Line 4849: l_action_id eng_change_actions.action_id%TYPE;

4845: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4846:
4847: l_api_caller VARCHAR2(2) := NULL;
4848:
4849: l_action_id eng_change_actions.action_id%TYPE;
4850:
4851: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4852: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4853:

Line 5132: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

5128: Write_Debug('Before: saving action log');
5129: END IF;
5130: l_action_id := 0;
5131: -- create new action log
5132: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
5133: ( p_api_version => 1.0
5134: , p_init_msg_list => FND_API.G_FALSE --
5135: , p_commit => FND_API.G_FALSE --
5136: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5143: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED

5139: , p_debug_filename => NULL
5140: , x_return_status => l_return_status
5141: , x_msg_count => l_msg_count
5142: , x_msg_data => l_msg_data
5143: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED
5144: , p_object_name => G_ENG_CHANGE
5145: , p_object_id1 => p_change_id
5146: , p_object_id2 => NULL
5147: , p_object_id3 => NULL

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

5167: x_return_status := l_return_status;
5168: x_msg_count := l_msg_count;
5169: x_msg_data := l_msg_data;
5170: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
5171: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
5172: --#FND_MSG_PUB.Add;
5173: RAISE FND_API.G_EXC_ERROR;
5174: END IF;
5175: IF g_debug_flag THEN

Line 5213: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

5209: Write_Debug('Before: saving action log');
5210: END IF;
5211: l_action_id := 0;
5212: -- create new action log
5213: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
5214: ( p_api_version => 1.0
5215: , p_init_msg_list => FND_API.G_FALSE --
5216: , p_commit => FND_API.G_FALSE --
5217: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5224: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_IN_PROGRESS

5220: , p_debug_filename => NULL
5221: , x_return_status => l_return_status
5222: , x_msg_count => l_msg_count
5223: , x_msg_data => l_msg_data
5224: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_IN_PROGRESS
5225: , p_object_name => G_ENG_CHANGE
5226: , p_object_id1 => p_change_id
5227: , p_object_id2 => NULL
5228: , p_object_id3 => NULL

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

5247: x_return_status := l_return_status;
5248: x_msg_count := l_msg_count;
5249: x_msg_data := l_msg_data;
5250: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
5251: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
5252: --#FND_MSG_PUB.Add;
5253: RAISE FND_API.G_EXC_ERROR;
5254: END IF;
5255: IF g_debug_flag THEN

Line 5975: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

5971: Write_Debug('Before: saving action log');
5972: END IF;
5973: l_action_id := 0;
5974: -- create new action log
5975: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
5976: ( p_api_version => 1.0
5977: , p_init_msg_list => FND_API.G_FALSE --
5978: , p_commit => FND_API.G_FALSE --
5979: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 5986: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED

5982: , p_debug_filename => NULL
5983: , x_return_status => l_return_status
5984: , x_msg_count => l_msg_count
5985: , x_msg_data => l_msg_data
5986: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_IMP_FAILED
5987: , p_object_name => G_ENG_CHANGE
5988: , p_object_id1 => p_change_id
5989: , p_object_id2 => NULL
5990: , p_object_id3 => NULL

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

6008: x_return_status := l_return_status;
6009: x_msg_count := l_msg_count;
6010: x_msg_data := l_msg_data;
6011: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6012: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
6013: --#FND_MSG_PUB.Add;
6014: RAISE FND_API.G_EXC_ERROR;
6015: END IF;
6016: IF g_debug_flag THEN

Line 6560: l_action_id eng_change_actions.action_id%TYPE;

6556: AND ood.LANGUAGE = USERENV('LANG');
6557:
6558: l_request_id NUMBER := 0;
6559:
6560: l_action_id eng_change_actions.action_id%TYPE;
6561: l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
6562: l_wf_only_flag BOOLEAN ;
6563:
6564: BEGIN

Line 6757: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

6753: END IF;
6754: -- Record SUBMIT action log and raise submit business event
6755: l_action_id := 0;
6756: -- create new action log
6757: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
6758: ( p_api_version => 1.0
6759: , p_init_msg_list => FND_API.G_FALSE --
6760: , p_commit => FND_API.G_FALSE --
6761: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6768: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_SUBMIT

6764: , p_debug_filename => 'engact.CreateAction.log'
6765: , x_return_status => l_return_status
6766: , x_msg_count => l_msg_count
6767: , x_msg_data => l_msg_data
6768: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_SUBMIT
6769: , p_object_name => G_ENG_CHANGE
6770: , p_object_id1 => p_change_id
6771: , p_object_id2 => NULL
6772: , p_object_id3 => NULL

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

6789: x_return_status := l_return_status;
6790: x_msg_count := l_msg_count;
6791: x_msg_data := l_msg_data;
6792: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6793: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
6794: --#FND_MSG_PUB.Add;
6795: RAISE FND_API.G_EXC_ERROR;
6796: END IF;
6797: IF g_debug_flag THEN

Line 6919: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action

6915: -- create new action log
6916: -- Bug Fix: 3547844
6917: -- In case of Auto-Propgation Action Log
6918: -- Who column is Workflow
6919: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
6920: ( p_api_version => 1.0
6921: , p_init_msg_list => FND_API.G_FALSE --
6922: , p_commit => FND_API.G_FALSE --
6923: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6930: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE

6926: , p_debug_filename => NULL
6927: , x_return_status => l_return_status
6928: , x_msg_count => l_msg_count
6929: , x_msg_data => l_msg_data
6930: , p_action_type => ENG_CHANGE_ACTIONS_UTIL.G_ACT_PROPAGATE
6931: , p_object_name => G_ENG_CHANGE
6932: , p_object_id1 => p_change_id
6933: , p_object_id2 => NULL
6934: , p_object_id3 => NULL

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

6953: x_return_status := l_return_status;
6954: x_msg_count := l_msg_count;
6955: x_msg_data := l_msg_data;
6956: --#FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6957: --#FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action');
6958: --#FND_MSG_PUB.Add;
6959: RAISE FND_API.G_EXC_ERROR;
6960: END IF;
6961: IF g_debug_flag THEN