DBA Data[Home] [Help]

APPS.PA_AUTOALLOC_WF_PKG dependencies on GL_AUTO_ALLOC_WF_PKG

Line 104: If(GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg_flag) then

100: /* dbms_output.put_line(G_Err_Stage); */
101: end if;
102:
103: /* Write to GL debug file */
104: If(GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg_flag) then
105: GL_AUTO_ALLOC_WF_PKG.initialize_debug;
106:
107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');

Line 105: GL_AUTO_ALLOC_WF_PKG.initialize_debug;

101: end if;
102:
103: /* Write to GL debug file */
104: If(GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg_flag) then
105: GL_AUTO_ALLOC_WF_PKG.initialize_debug;
106:
107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));

Line 107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');

103: /* Write to GL debug file */
104: If(GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg_flag) then
105: GL_AUTO_ALLOC_WF_PKG.initialize_debug;
106:
107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);

Line 108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');

104: If(GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg_flag) then
105: GL_AUTO_ALLOC_WF_PKG.initialize_debug;
106:
107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);
112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);

Line 109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));

105: GL_AUTO_ALLOC_WF_PKG.initialize_debug;
106:
107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);
112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);
113: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');

Line 110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);

106:
107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);
112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);
113: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
114: End If;

Line 111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);

107: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);
112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);
113: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
114: End If;
115:

Line 112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);

108: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Launching PA Autoallocation Workflow');
109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);
112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);
113: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
114: End If;
115:
116: /** Set GL itemtype and itemkey as PA attributes **/

Line 113: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');

109: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA Workflow Launch Date and Time: '||to_char(sysdate,'DD-MON-YYYY,HH24:MI:SS'));
110: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('Generated PA item Key is: '||PA_item_Key);
111: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug directory is: '||v_debug_file_dir);
112: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('PA debug file is: '||G_FILE);
113: GL_AUTO_ALLOC_WF_PKG.diagn_debug_msg('*****************************************');
114: End If;
115:
116: /** Set GL itemtype and itemkey as PA attributes **/
117: Wf_Engine.SetItemAttrText( itemtype => PA_item_type,

Line 724: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

720:
721: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
722: itemkey => p_item_key,
723: aname => 'SET_REQ_ID');
724: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
725: ,v_step_number
726: ,'UFE'
727: );
728: Raise;

Line 834: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

830: -- set status code to unexpected fatal error
831: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
832: itemkey => p_item_key,
833: aname => 'SET_REQ_ID');
834: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
835: ,v_step_number
836: ,'UFE'
837: );
838: Raise;

Line 949: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

945: ,v_status_code
946: ,v_message_name);
947:
948: -- Program Error
949: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
950: ,v_step_number
951: ,v_status_code
952: );
953:

Line 981: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

977: -- set status code to unexpected fatal error
978: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
979: itemkey => p_item_key,
980: aname => 'SET_REQ_ID');
981: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
982: ,v_step_number
983: ,'UFE'
984: );
985: Raise;

Line 1112: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1108: -- set status code to unexpected fatal error
1109: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1110: itemkey => p_item_key,
1111: aname => 'SET_REQ_ID');
1112: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1113: ,v_step_number
1114: ,'UFE'
1115: );
1116: Raise;

Line 1128: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1124: -- set status code to unexpected fatal error
1125: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1126: itemkey => p_item_key,
1127: aname => 'SET_REQ_ID');
1128: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1129: ,v_step_number
1130: ,'UFE'
1131: );
1132: Raise;

Line 1237: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1233: -- set status code to unexpected fatal error
1234: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1235: itemkey => p_item_key,
1236: aname => 'SET_REQ_ID');
1237: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1238: ,v_step_number
1239: ,'UFE'
1240: );
1241: Raise;

Line 1483: GL_AUTO_ALLOC_WF_PKG.INSERT_BATCH_HIST_DET(

1479: IF v_request_id <> 0 THEN
1480: WriteDebugMsg('Inserting req id = '||to_char(v_request_id)||
1481: ' into histroy detail');
1482:
1483: GL_AUTO_ALLOC_WF_PKG.INSERT_BATCH_HIST_DET(
1484: p_REQUEST_ID => v_request_id
1485: ,p_PARENT_REQUEST_ID => v_set_req_id
1486: ,p_STEP_NUMBER => v_step_number
1487: ,p_PROGRAM_NAME_CODE => p_prog_code

Line 1501: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1497: ,v_rollback_allowed
1498: ,v_status_code
1499: ,v_message_name);
1500: --Generation pending status
1501: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1502: ,v_step_number
1503: ,v_status_code
1504: );
1505: End If;

Line 1584: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1580: 'STEP_NUMBER');
1581: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1582: itemkey => p_item_key,
1583: aname => 'SET_REQ_ID');
1584: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1585: ,v_step_number
1586: ,'UFE'
1587: );
1588: Raise;

Line 1678: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1674: avalue => v_message_name );
1675: WriteDebugMsg('Message_name = '||v_message_Name);
1676:
1677: -- Program Error
1678: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1679: ,v_step_number
1680: ,v_status_code
1681: );
1682:

Line 1752: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1748: ,v_status_code
1749: ,v_message_name);
1750: WriteDebugMsg('Status Code Value = '||v_status_code);
1751:
1752: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1753: ,v_step_number
1754: ,v_status_code
1755: );
1756:

Line 1777: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1773: ,v_status_code
1774: ,v_message_name);
1775:
1776: -- Program Error
1777: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1778: ,v_step_number
1779: ,v_status_code
1780: );
1781:

Line 1810: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1806: WriteDebugMsg(G_err_msg ||'*'||G_err_stack);
1807: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
1808: itemkey => p_item_key,
1809: aname => 'SET_REQ_ID');
1810: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1811: ,v_step_number
1812: ,'UFE'
1813: );
1814: Raise;

Line 1940: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1936: ,v_rollback_allowed
1937: ,v_status_code
1938: ,v_message_name);
1939: -- Program Error
1940: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1941: ,v_step_number
1942: ,v_status_code
1943: );
1944: wf_engine.SetItemAttrText(itemtype => PA_item_type,

Line 1970: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

1966: ,v_rollback_allowed
1967: ,v_status_code
1968: ,v_message_name);
1969: -- Program Error
1970: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
1971: ,v_step_number
1972: ,v_status_code
1973: );
1974: wf_engine.SetItemAttrText(itemtype => PA_item_type,

Line 2007: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2003: ,v_rollback_allowed
2004: ,v_status_code
2005: ,v_message_name);
2006: -- Program Error
2007: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2008: ,v_step_number
2009: ,v_status_code
2010: );
2011: wf_engine.SetItemAttrText(itemtype => PA_item_type,

Line 2035: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2031: ,v_rollback_allowed
2032: ,v_status_code
2033: ,v_message_name);
2034: -- Program Error
2035: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2036: ,v_step_number
2037: ,v_status_code
2038: );
2039: wf_engine.SetItemAttrText(itemtype => PA_item_type,

Line 2064: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2060: WriteDebugMsg(G_err_msg ||'*'||G_err_stack);
2061: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2062: itemkey => p_item_key,
2063: aname => 'SET_REQ_ID');
2064: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2065: ,v_step_number
2066: ,'UFE'
2067: );
2068: Raise;

Line 2152: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2148: WriteDebugMsg(G_err_msg ||'*'||G_err_stack);
2149: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2150: itemkey => p_item_key,
2151: aname => 'SET_REQ_ID');
2152: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2153: ,v_step_number
2154: ,'UFE'
2155: );
2156: Raise;

Line 2235: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2231: ,v_rollback_allowed
2232: ,v_status_code
2233: ,v_message_name);
2234: -- Program Error
2235: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2236: ,v_step_number
2237: ,v_status_code
2238: );
2239: wf_engine.SetItemAttrText(itemtype => PA_item_type,

Line 2271: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2267: Wf_Core.Context('PA_AUTOALLOC_WF_PKG', 'Check_Costing_Process', p_item_type, p_item_key);
2268: Wf_Core.Get_Error(G_err_name,G_err_msg,G_err_stack);
2269: WriteDebugMsg('********** Encountered Errors ***********');
2270: WriteDebugMsg(G_err_msg ||'*'||G_err_stack);
2271: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2272: ,v_step_number
2273: ,'UFE'
2274: );
2275:

Line 2344: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2340: itemkey => PA_item_key,
2341: aname => 'MESSAGE_NAME',
2342: avalue => v_message_name );
2343: -- Program Error
2344: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2345: ,v_step_number
2346: ,v_status_code
2347: );
2348:

Line 2381: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2377: WriteDebugMsg(G_err_msg ||'*'||G_err_stack);
2378: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2379: itemkey => p_item_key,
2380: aname => 'SET_REQ_ID');
2381: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2382: ,v_step_number
2383: ,'UFE'
2384: );
2385:

Line 2528: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id

2524: -- set status code to unexpected fatal error
2525: v_SET_REQ_ID := WF_ENGINE.GetItemAttrNumber(itemtype => p_item_type,
2526: itemkey => p_item_key,
2527: aname => 'SET_REQ_ID');
2528: GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
2529: ,v_step_number
2530: ,'UFE'
2531: );
2532: Raise;