17: l_approval_status VARCHAR2(1);
18: l_ret_item_app_st INTEGER;
19:
20: BEGIN
21: x_return_status := FND_API.G_RET_STS_SUCCESS;
22: IF p_approval_status = 1 THEN
23: l_approval_status := 'N';
24: ELSIF p_approval_status = 3 THEN
25: l_approval_status := 'S';
98:
99:
100: EXCEPTION WHEN others THEN
101:
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: /*FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
104: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.UPDATE_ITEM_APPROVAL_STATUS '||'itemId: '||l_item_id||' OrgId: '||l_organization_id|| ' approvalStstus: '||l_approval_status);
105: FND_MSG_PUB.Add;*/
106:
198:
199: Eng_Workflow_Util.AbortWorkflow
200: (
201: p_api_version => 1.0
202: , p_init_msg_list => FND_API.G_FALSE
203: , p_commit => p_auto_commit
204: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
205: , x_return_status => l_return_status
206: , x_msg_count => l_msg_count
200: (
201: p_api_version => 1.0
202: , p_init_msg_list => FND_API.G_FALSE
203: , p_commit => p_auto_commit
204: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
205: , x_return_status => l_return_status
206: , x_msg_count => l_msg_count
207: , x_msg_data => l_msg_data
208: , p_item_type => l_wf_item_type
208: , p_item_type => l_wf_item_type
209: , p_item_key => l_wf_item_key
210: , p_process_name => l_wf_process_name
211: , p_wf_user_id => p_wf_user_id
212: , p_debug => FND_API.G_FALSE
213: , p_output_dir => NULL
214: , p_debug_filename => 'Eng_ChangeWF_Abort.log'
215: );
216:
239: -- Create action log entries for the Cancel action.
240: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
241: (
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: p_debug => FND_API.G_FALSE,
247: p_output_dir => '',
240: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
241: (
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: p_debug => FND_API.G_FALSE,
247: p_output_dir => '',
248: p_debug_filename => '',
241: (
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: p_debug => FND_API.G_FALSE,
247: p_output_dir => '',
248: p_debug_filename => '',
249: x_return_status => l_return_status,
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
246: p_debug => FND_API.G_FALSE,
247: p_output_dir => '',
248: p_debug_filename => '',
249: x_return_status => l_return_status,
250: x_msg_count => l_msg_count,
356: -- p_mode => p_item_action, -- (DELETE/CHANGE_ICC)
357: p_wf_user_id => p_wf_user_id,
358: p_fnd_user_id => p_fnd_user_id,
359: p_cancel_comments => p_cancel_comments,
360: P_COMMIT => FND_API.G_FALSE,
361: x_return_status => x_nir_cancel_status
362: );
363: select count(change_id) into l_uncancelled_change_id
364: from eng_change_lines where change_id = nirs.change_id
675: -- p_mode VARCHAR2, -- (DELETE/CHANGE_ICC)
676: p_wf_user_id IN NUMBER,
677: p_fnd_user_id IN NUMBER,
678: p_cancel_comments IN VARCHAR2,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: x_return_status OUT NOCOPY VARCHAR2
681: )
682: IS
683: l_change_line_id NUMBER;
720: -- Update the Action Log of the NIR.
721: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
722: (
723: p_api_version => 1.0,
724: p_init_msg_list => FND_API.G_TRUE,
725: p_commit => FND_API.G_FALSE,
726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
727: p_debug => FND_API.G_FALSE,
728: p_output_dir => '',
721: ENG_CHANGE_ACTIONS_UTIL.Create_Change_Action
722: (
723: p_api_version => 1.0,
724: p_init_msg_list => FND_API.G_TRUE,
725: p_commit => FND_API.G_FALSE,
726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
727: p_debug => FND_API.G_FALSE,
728: p_output_dir => '',
729: p_debug_filename => '',
722: (
723: p_api_version => 1.0,
724: p_init_msg_list => FND_API.G_TRUE,
725: p_commit => FND_API.G_FALSE,
726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
727: p_debug => FND_API.G_FALSE,
728: p_output_dir => '',
729: p_debug_filename => '',
730: x_return_status => l_return_status,
723: p_api_version => 1.0,
724: p_init_msg_list => FND_API.G_TRUE,
725: p_commit => FND_API.G_FALSE,
726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
727: p_debug => FND_API.G_FALSE,
728: p_output_dir => '',
729: p_debug_filename => '',
730: x_return_status => l_return_status,
731: x_msg_count => l_msg_count,
766: l_organization_id NUMBER;
767: l_approval_status VARCHAR2(1);
768: l_ret_item_app_st INTEGER;
769: BEGIN
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: IF p_approval_status = 1 THEN
772: l_approval_status := 'N';
773: ELSIF p_approval_status = 3 THEN
774: l_approval_status := 'S';
795: -- end if;
796:
797: EXCEPTION WHEN others THEN
798:
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
800: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
801: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.UPDATE_ITEM_APPROVAL_STATUS '||'itemId: '||l_item_id||' OrgId: '||l_organization_id|| ' approvalStstus: '||l_approval_status || ' changeId: ' || p_change_id);
802: FND_MSG_PUB.Add;
803: