DBA Data[Home] [Help]

APPS.AMS_LIST_WF dependencies on AMS_UTILITY_PVT

Line 121: Ams_Utility_pvt.debug_message('Start');

117: -- If workflowprocess is NOT passed, the selector function
118: -- defined in the item type will determine which process to run.
119: IF (AMS_DEBUG_HIGH_ON) THEN
120:
121: Ams_Utility_pvt.debug_message('Start');
122: END IF;
123: IF (AMS_DEBUG_HIGH_ON) THEN
124:
125: Ams_Utility_pvt.debug_message('Item Type : '||itemtype);

Line 125: Ams_Utility_pvt.debug_message('Item Type : '||itemtype);

121: Ams_Utility_pvt.debug_message('Start');
122: END IF;
123: IF (AMS_DEBUG_HIGH_ON) THEN
124:
125: Ams_Utility_pvt.debug_message('Item Type : '||itemtype);
126: END IF;
127: IF (AMS_DEBUG_HIGH_ON) THEN
128:
129: Ams_Utility_pvt.debug_message('Item key : '||itemkey);

Line 129: Ams_Utility_pvt.debug_message('Item key : '||itemkey);

125: Ams_Utility_pvt.debug_message('Item Type : '||itemtype);
126: END IF;
127: IF (AMS_DEBUG_HIGH_ON) THEN
128:
129: Ams_Utility_pvt.debug_message('Item key : '||itemkey);
130: END IF;
131:
132: --dbms_output.put_line('Start');
133: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );

Line 582: AMS_Utility_PVT.Create_Log (

578: RAISE FND_API.G_EXC_ERROR;
579: end if;
580:
581:
582: AMS_Utility_PVT.Create_Log (
583: x_return_status => l_return_status,
584: p_arc_log_used_by => 'LIST',
585: p_log_used_by_id => p_list_header_id,
586: p_msg_data => ' Raise Business event-- in StartListBusinessEventProcess process.',

Line 590: AMS_Utility_PVT.debug_message('Raise Business event-- in StartListBizEventProcess process');

586: p_msg_data => ' Raise Business event-- in StartListBusinessEventProcess process.',
587: p_msg_type => 'DEBUG'
588: );
589:
590: AMS_Utility_PVT.debug_message('Raise Business event-- in StartListBizEventProcess process');
591: -- Raise a business event
592: l_new_item_key := p_list_header_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
593: l_parameter_list := WF_PARAMETER_LIST_T();
594: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');

Line 594: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');

590: AMS_Utility_PVT.debug_message('Raise Business event-- in StartListBizEventProcess process');
591: -- Raise a business event
592: l_new_item_key := p_list_header_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
593: l_parameter_list := WF_PARAMETER_LIST_T();
594: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');
595: AMS_Utility_PVT.Create_Log (
596: x_return_status => l_return_status,
597: p_arc_log_used_by => 'LIST',
598: p_log_used_by_id => p_list_header_id,

Line 595: AMS_Utility_PVT.Create_Log (

591: -- Raise a business event
592: l_new_item_key := p_list_header_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
593: l_parameter_list := WF_PARAMETER_LIST_T();
594: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');
595: AMS_Utility_PVT.Create_Log (
596: x_return_status => l_return_status,
597: p_arc_log_used_by => 'LIST',
598: p_log_used_by_id => p_list_header_id,
599: p_msg_data => ' Raise Business event-- after WF_PARAMETER_LIST_T call',

Line 602: AMS_Utility_PVT.Create_Log (

598: p_log_used_by_id => p_list_header_id,
599: p_msg_data => ' Raise Business event-- after WF_PARAMETER_LIST_T call',
600: p_msg_type => 'DEBUG'
601: );
602: AMS_Utility_PVT.Create_Log (
603: x_return_status => l_return_status,
604: p_arc_log_used_by => 'LIST',
605: p_log_used_by_id => p_list_header_id,
606: p_msg_data => 'Raise Business event p_list_header_id= '||to_char(p_list_header_id),

Line 612: AMS_Utility_PVT.Create_Log (

608: );
609: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
610: p_value => p_list_header_id,
611: p_parameterlist => l_parameter_list);
612: AMS_Utility_PVT.Create_Log (
613: x_return_status => l_return_status,
614: p_arc_log_used_by => 'LIST',
615: p_log_used_by_id => p_list_header_id,
616: p_msg_data => 'Raise Business event-- after AddParameterToList call',

Line 619: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');

615: p_log_used_by_id => p_list_header_id,
616: p_msg_data => 'Raise Business event-- after AddParameterToList call',
617: p_msg_type => 'DEBUG'
618: );
619: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');
620: OPEN c_list_det;
621: FETCH c_list_det INTO l_start_time, l_timezone;
622: CLOSE c_list_det;
623: /*

Line 624: AMS_UTILITY_PVT.Convert_Timezone(

620: OPEN c_list_det;
621: FETCH c_list_det INTO l_start_time, l_timezone;
622: CLOSE c_list_det;
623: /*
624: AMS_UTILITY_PVT.Convert_Timezone(
625: p_init_msg_list => FND_API.G_TRUE,
626: x_return_status => l_return_status,
627: x_msg_count => l_msg_count,
628: x_msg_data => l_msg_data,

Line 643: AMS_Utility_PVT.debug_message('Raise Business event-- Start');

639: l_sys_start_time := SYSDATE;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: l_sys_start_time := SYSDATE;
642: END IF;
643: AMS_Utility_PVT.debug_message('Raise Business event-- Start');
644: /*
645: update ams_list_headers_all set WORKFLOW_ITEM_KEY = l_new_item_key
646: where list_header_id = p_list_header_id;
647: */

Line 657: AMS_Utility_PVT.Create_Log (

653: WORKFLOW_ITEM_KEY = l_new_item_key
654: WHERE list_header_id = p_list_header_id;
655:
656:
657: AMS_Utility_PVT.Create_Log (
658: x_return_status => l_return_status,
659: p_arc_log_used_by => 'LIST',
660: p_log_used_by_id => p_list_header_id,
661: p_msg_data => 'Raise Business event-- Start',

Line 670: AMS_Utility_PVT.Create_Log (

666: p_event_key => l_new_item_key,
667: p_parameters => l_parameter_list,
668: p_send_date => l_start_time);
669: -- p_send_date => l_sys_start_time);
670: AMS_Utility_PVT.Create_Log (
671: x_return_status => l_return_status,
672: p_arc_log_used_by => 'LIST',
673: p_log_used_by_id => p_list_header_id,
674: p_msg_data => 'Raise Business event-- End',

Line 677: AMS_Utility_PVT.debug_message('Raise Business event-- End');

673: p_log_used_by_id => p_list_header_id,
674: p_msg_data => 'Raise Business event-- End',
675: p_msg_type => 'DEBUG'
676: );
677: AMS_Utility_PVT.debug_message('Raise Business event-- End');
678: commit;
679: END StartListBizEventProcess;
680:
681: PROCEDURE Wf_Init_var(itemtype IN VARCHAR2,

Line 710: Ams_Utility_pvt.debug_message('Start');

706: THEN
707:
708: IF (AMS_DEBUG_HIGH_ON) THEN
709:
710: Ams_Utility_pvt.debug_message('Start');
711: END IF;
712:
713: --dbms_output.put_line('Start');
714: l_list_header_id := WF_ENGINE.GetItemAttrText(

Line 719: AMS_Utility_PVT.Create_Log (

715: itemtype => itemtype,
716: itemkey => itemkey ,
717: aname => 'LIST_HEADER_ID');
718:
719: AMS_Utility_PVT.Create_Log (
720: x_return_status => l_return_status,
721: p_arc_log_used_by => 'LIST',
722: p_log_used_by_id => l_list_header_id,
723: p_msg_data => 'WF_INIT_VAR: started',

Line 906: AMS_Utility_PVT.Create_Log (

902: l_list_header_id := WF_ENGINE.GetItemAttrText(
903: itemtype => itemtype,
904: itemkey => itemkey ,
905: aname => 'LIST_HEADER_ID');
906: AMS_Utility_PVT.Create_Log (
907: x_return_status => l_return_status,
908: p_arc_log_used_by => 'LIST',
909: p_log_used_by_id => l_list_header_id,
910: p_msg_data => 'l_list_header_id = ' || l_list_header_id,

Line 916: AMS_Utility_PVT.Create_Log (

912: );
913: OPEN c_item_key_name;
914: FETCH c_item_key_name INTO l_list_item_key;
915: CLOSE c_item_key_name;
916: AMS_Utility_PVT.Create_Log (
917: x_return_status => l_return_status,
918: p_arc_log_used_by => 'LIST',
919: p_log_used_by_id => l_list_header_id,
920: p_msg_data => 'l_list_item_key = ' || l_list_item_key,

Line 925: AMS_Utility_PVT.Create_Log (

921: p_msg_type => 'DEBUG'
922: );
923: IF l_list_item_key <> itemkey THEN
924: result := 'COMPLETE:N' ;
925: AMS_Utility_PVT.Create_Log (
926: x_return_status => l_return_status,
927: p_arc_log_used_by => 'LIST',
928: p_log_used_by_id => l_list_header_id,
929: p_msg_data => 'Check_Item_Key : 1. For List Header ID = ' || itemkey || result,

Line 936: AMS_Utility_PVT.Create_Log (

932: RETURN;
933: End if;
934: IF l_list_item_key = itemkey THEN
935: result := 'COMPLETE:Y' ;
936: AMS_Utility_PVT.Create_Log (
937: x_return_status => l_return_status,
938: p_arc_log_used_by => 'LIST',
939: p_log_used_by_id => l_list_header_id,
940: p_msg_data => 'Check_Item_Key : 1. For List Header ID = ' || itemkey || result,