eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_APPROVALS_WF dependencies on STANDARD

Line 70: OE_STANDARD_WF.Set_Msg_Context(actid);

66: if (funcmode = 'RUN') then
67:
68: l_transaction_id := to_number(itemkey);
69:
70: OE_STANDARD_WF.Set_Msg_Context(actid);
71: OE_MSG_PUB.set_msg_context(
72: p_entity_code => 'HEADER'
73: ,p_entity_id => to_number(itemkey)
74: ,p_header_id => to_number(itemkey));

Line 119: OE_STANDARD_WF.Save_Messages;

115: oe_debug_pub.add('Initiate_approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
116: END IF;
117:
118: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: OE_STANDARD_WF.Save_Messages;
120: OE_STANDARD_WF.Clear_Msg_Context;
121: app_exception.raise_exception;
122: END IF;
123:

Line 120: OE_STANDARD_WF.Clear_Msg_Context;

116: END IF;
117:
118: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: OE_STANDARD_WF.Save_Messages;
120: OE_STANDARD_WF.Clear_Msg_Context;
121: app_exception.raise_exception;
122: END IF;
123:
124: */

Line 127: OE_STANDARD_WF.Save_Messages;

123:
124: */
125:
126: resultout := 'COMPLETE:NOT_ELIGIBLE';
127: OE_STANDARD_WF.Save_Messages;
128: OE_STANDARD_WF.Clear_Msg_Context;
129: return;
130:
131: else

Line 128: OE_STANDARD_WF.Clear_Msg_Context;

124: */
125:
126: resultout := 'COMPLETE:NOT_ELIGIBLE';
127: OE_STANDARD_WF.Save_Messages;
128: OE_STANDARD_WF.Clear_Msg_Context;
129: return;
130:
131: else
132: IF l_debug_level > 0 THEN

Line 163: -- OE_STANDARD_WF.Save_Messages;

159: END IF;
160:
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: -- start data fix project
163: -- OE_STANDARD_WF.Save_Messages;
164: -- OE_STANDARD_WF.Clear_Msg_Context;
165: -- end data fix project
166: app_exception.raise_exception;
167: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 164: -- OE_STANDARD_WF.Clear_Msg_Context;

160:
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: -- start data fix project
163: -- OE_STANDARD_WF.Save_Messages;
164: -- OE_STANDARD_WF.Clear_Msg_Context;
165: -- end data fix project
166: app_exception.raise_exception;
167: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: -- start data fix project

Line 169: -- OE_STANDARD_WF.Save_Messages;

165: -- end data fix project
166: app_exception.raise_exception;
167: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: -- start data fix project
169: -- OE_STANDARD_WF.Save_Messages;
170: -- OE_STANDARD_WF.Clear_Msg_Context;
171: -- end data fix project
172: app_exception.raise_exception;
173: END IF;

Line 170: -- OE_STANDARD_WF.Clear_Msg_Context;

166: app_exception.raise_exception;
167: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: -- start data fix project
169: -- OE_STANDARD_WF.Save_Messages;
170: -- OE_STANDARD_WF.Clear_Msg_Context;
171: -- end data fix project
172: app_exception.raise_exception;
173: END IF;
174:

Line 236: -- OE_STANDARD_WF.Save_Messages;

232: END IF;
233:
234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: -- start data fix project
236: -- OE_STANDARD_WF.Save_Messages;
237: -- OE_STANDARD_WF.Clear_Msg_Context;
238: -- end data fix project
239: app_exception.raise_exception;
240: END IF;

Line 237: -- OE_STANDARD_WF.Clear_Msg_Context;

233:
234: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: -- start data fix project
236: -- OE_STANDARD_WF.Save_Messages;
237: -- OE_STANDARD_WF.Clear_Msg_Context;
238: -- end data fix project
239: app_exception.raise_exception;
240: END IF;
241:

Line 244: OE_STANDARD_WF.Clear_Msg_Context;

240: END IF;
241:
242:
243: resultout := 'COMPLETE:COMPLETE';
244: OE_STANDARD_WF.Clear_Msg_Context;
245: return;
246: end if;
247: end if; -- End for 'RUN' mode
248:

Line 282: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

278: -- in the case of an exception.
279: wf_core.context('OE_APPROVALS_WF', 'Initiate_Approval',
280: itemtype, itemkey, to_char(actid), funcmode);
281: -- start data fix project
282: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
283: p_itemtype => itemtype,
284: p_itemkey => itemkey);
285: OE_STANDARD_WF.Save_Messages;
286: OE_STANDARD_WF.Clear_Msg_Context;

Line 285: OE_STANDARD_WF.Save_Messages;

281: -- start data fix project
282: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
283: p_itemtype => itemtype,
284: p_itemkey => itemkey);
285: OE_STANDARD_WF.Save_Messages;
286: OE_STANDARD_WF.Clear_Msg_Context;
287: -- end data fix project
288: raise;
289:

Line 286: OE_STANDARD_WF.Clear_Msg_Context;

282: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
283: p_itemtype => itemtype,
284: p_itemkey => itemkey);
285: OE_STANDARD_WF.Save_Messages;
286: OE_STANDARD_WF.Clear_Msg_Context;
287: -- end data fix project
288: raise;
289:
290:

Line 344: OE_STANDARD_WF.Set_Msg_Context(actid);

340: if (funcmode = 'RUN') then
341:
342: l_transaction_id := to_number(itemkey);
343:
344: OE_STANDARD_WF.Set_Msg_Context(actid);
345: OE_MSG_PUB.set_msg_context(
346: p_entity_code => 'HEADER'
347: ,p_entity_id => to_number(itemkey)
348: ,p_header_id => to_number(itemkey));

Line 397: OE_STANDARD_WF.Save_Messages;

393: oe_debug_pub.add('Get_next_approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
394: END IF;
395:
396: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
397: OE_STANDARD_WF.Save_Messages;
398: OE_STANDARD_WF.Clear_Msg_Context;
399: app_exception.raise_exception;
400: END IF;
401: */

Line 398: OE_STANDARD_WF.Clear_Msg_Context;

394: END IF;
395:
396: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
397: OE_STANDARD_WF.Save_Messages;
398: OE_STANDARD_WF.Clear_Msg_Context;
399: app_exception.raise_exception;
400: END IF;
401: */
402:

Line 404: OE_STANDARD_WF.Save_Messages;

400: END IF;
401: */
402:
403: resultout := 'COMPLETE:N';
404: OE_STANDARD_WF.Save_Messages;
405: OE_STANDARD_WF.Clear_Msg_Context;
406: return;
407:
408: else

Line 405: OE_STANDARD_WF.Clear_Msg_Context;

401: */
402:
403: resultout := 'COMPLETE:N';
404: OE_STANDARD_WF.Save_Messages;
405: OE_STANDARD_WF.Clear_Msg_Context;
406: return;
407:
408: else
409: wf_engine.SetItemAttrText(itemtype,

Line 462: OE_STANDARD_WF.Save_Messages;

458:
459:
460:
461: resultout := 'COMPLETE:Y';
462: OE_STANDARD_WF.Save_Messages;
463: OE_STANDARD_WF.Clear_Msg_Context;
464: return;
465: end if;
466:

Line 463: OE_STANDARD_WF.Clear_Msg_Context;

459:
460:
461: resultout := 'COMPLETE:Y';
462: OE_STANDARD_WF.Save_Messages;
463: OE_STANDARD_WF.Clear_Msg_Context;
464: return;
465: end if;
466:
467: end if; -- End for 'RUN' mode

Line 502: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

498: -- in the case of an exception.
499: wf_core.context('OE_APPROVALS_WF', 'Get_Next_Approver',
500: itemtype, itemkey, to_char(actid), funcmode);
501: -- start data fix project
502: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
503: p_itemtype => itemtype,
504: p_itemkey => itemkey);
505: OE_STANDARD_WF.Save_Messages;
506: OE_STANDARD_WF.Clear_Msg_Context;

Line 505: OE_STANDARD_WF.Save_Messages;

501: -- start data fix project
502: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
503: p_itemtype => itemtype,
504: p_itemkey => itemkey);
505: OE_STANDARD_WF.Save_Messages;
506: OE_STANDARD_WF.Clear_Msg_Context;
507: -- end data fix project
508: raise;
509:

Line 506: OE_STANDARD_WF.Clear_Msg_Context;

502: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
503: p_itemtype => itemtype,
504: p_itemkey => itemkey);
505: OE_STANDARD_WF.Save_Messages;
506: OE_STANDARD_WF.Clear_Msg_Context;
507: -- end data fix project
508: raise;
509:
510:

Line 775: OE_STANDARD_WF.Set_Msg_Context(actid);

771: l_transaction_id,
772: 'SALES_DOCUMENT_TYPE_CODE');
773: END IF;
774:
775: OE_STANDARD_WF.Set_Msg_Context(actid);
776: OE_MSG_PUB.set_msg_context(
777: p_entity_code => 'HEADER'
778: ,p_entity_id => to_number(itemkey)
779: ,p_header_id => to_number(itemkey));

Line 798: -- OE_STANDARD_WF.Save_Messages;

794: END IF;
795:
796: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
797: -- start data fix project
798: -- OE_STANDARD_WF.Save_Messages;
799: -- OE_STANDARD_WF.Clear_Msg_Context;
800: -- end data fix project
801: --app_exception.raise_exception;
802: --bug7386039

Line 799: -- OE_STANDARD_WF.Clear_Msg_Context;

795:
796: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
797: -- start data fix project
798: -- OE_STANDARD_WF.Save_Messages;
799: -- OE_STANDARD_WF.Clear_Msg_Context;
800: -- end data fix project
801: --app_exception.raise_exception;
802: --bug7386039
803:

Line 810: OE_STANDARD_WF.Save_Messages;

806:
807: END IF;
808:
809: resultout := 'COMPLETE';
810: OE_STANDARD_WF.Save_Messages;
811: OE_STANDARD_WF.Clear_Msg_Context;
812: return;
813:
814: end if;

Line 811: OE_STANDARD_WF.Clear_Msg_Context;

807: END IF;
808:
809: resultout := 'COMPLETE';
810: OE_STANDARD_WF.Save_Messages;
811: OE_STANDARD_WF.Clear_Msg_Context;
812: return;
813:
814: end if;
815:

Line 853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

849: END IF;
850: wf_core.context('OE_APPROVALS_WF', 'Approve_Approval',
851: itemtype, itemkey, to_char(actid), funcmode);
852: -- start data fix project
853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
854: p_itemtype => itemtype,
855: p_itemkey => itemkey);
856: OE_STANDARD_WF.Save_Messages;
857: OE_STANDARD_WF.Clear_Msg_Context;

Line 856: OE_STANDARD_WF.Save_Messages;

852: -- start data fix project
853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
854: p_itemtype => itemtype,
855: p_itemkey => itemkey);
856: OE_STANDARD_WF.Save_Messages;
857: OE_STANDARD_WF.Clear_Msg_Context;
858: -- end data fix project
859: raise;
860:

Line 857: OE_STANDARD_WF.Clear_Msg_Context;

853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
854: p_itemtype => itemtype,
855: p_itemkey => itemkey);
856: OE_STANDARD_WF.Save_Messages;
857: OE_STANDARD_WF.Clear_Msg_Context;
858: -- end data fix project
859: raise;
860:
861:

Line 897: OE_STANDARD_WF.Set_Msg_Context(actid);

893: if (funcmode = 'RUN') then
894:
895: l_transaction_id := to_number(itemkey);
896:
897: OE_STANDARD_WF.Set_Msg_Context(actid);
898: OE_MSG_PUB.set_msg_context(
899: p_entity_code => 'HEADER'
900: ,p_entity_id => to_number(itemkey)
901: ,p_header_id => to_number(itemkey));

Line 927: OE_STANDARD_WF.Clear_Msg_Context;

923: 'Y');
924:
925: if l_next_role is NULL THEN
926: resultout := 'COMPLETE:REJECTED';
927: OE_STANDARD_WF.Clear_Msg_Context;
928: return;
929: else
930: resultout := 'COMPLETE:CONTINUE';
931: OE_STANDARD_WF.Clear_Msg_Context;

Line 931: OE_STANDARD_WF.Clear_Msg_Context;

927: OE_STANDARD_WF.Clear_Msg_Context;
928: return;
929: else
930: resultout := 'COMPLETE:CONTINUE';
931: OE_STANDARD_WF.Clear_Msg_Context;
932: return;
933: end if;
934:
935: ELSE

Line 937: OE_STANDARD_WF.Clear_Msg_Context;

933: end if;
934:
935: ELSE
936: resultout := 'COMPLETE:REJECTED';
937: OE_STANDARD_WF.Clear_Msg_Context;
938: return;
939:
940: END IF;
941:

Line 944: OE_STANDARD_WF.Clear_Msg_Context;

940: END IF;
941:
942:
943: resultout := 'COMPLETE';
944: OE_STANDARD_WF.Clear_Msg_Context;
945: return;
946: end if; -- End for 'RUN' mode
947:
948: --

Line 985: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

981: END IF;
982: wf_core.context('OE_APPROVALS_WF', 'Approval_Timeout',
983: itemtype, itemkey, to_char(actid), funcmode);
984: -- start data fix project
985: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
986: p_itemtype => itemtype,
987: p_itemkey => itemkey);
988: OE_STANDARD_WF.Save_Messages;
989: OE_STANDARD_WF.Clear_Msg_Context;

Line 988: OE_STANDARD_WF.Save_Messages;

984: -- start data fix project
985: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
986: p_itemtype => itemtype,
987: p_itemkey => itemkey);
988: OE_STANDARD_WF.Save_Messages;
989: OE_STANDARD_WF.Clear_Msg_Context;
990: -- end data fix project
991: raise;
992:

Line 989: OE_STANDARD_WF.Clear_Msg_Context;

985: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
986: p_itemtype => itemtype,
987: p_itemkey => itemkey);
988: OE_STANDARD_WF.Save_Messages;
989: OE_STANDARD_WF.Clear_Msg_Context;
990: -- end data fix project
991: raise;
992:
993:

Line 1029: OE_STANDARD_WF.Set_Msg_Context(actid);

1025: if (funcmode = 'RUN') then
1026:
1027: l_transaction_id := to_number(itemkey);
1028:
1029: OE_STANDARD_WF.Set_Msg_Context(actid);
1030: OE_MSG_PUB.set_msg_context(
1031: p_entity_code => 'HEADER'
1032: ,p_entity_id => to_number(itemkey)
1033: ,p_header_id => to_number(itemkey));

Line 1074: -- OE_STANDARD_WF.Save_Messages;

1070: END IF;
1071:
1072: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1073: -- start data fix project
1074: -- OE_STANDARD_WF.Save_Messages;
1075: -- OE_STANDARD_WF.Clear_Msg_Context;
1076: -- end data fix project
1077: --app_exception.raise_exception;
1078: --bug7386039

Line 1075: -- OE_STANDARD_WF.Clear_Msg_Context;

1071:
1072: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1073: -- start data fix project
1074: -- OE_STANDARD_WF.Save_Messages;
1075: -- OE_STANDARD_WF.Clear_Msg_Context;
1076: -- end data fix project
1077: --app_exception.raise_exception;
1078: --bug7386039
1079: resultout := 'DEFERRED:'||to_char(sysdate+(TO_NUMBER(g_defer_min)/1440),wf_engine.date_format);

Line 1087: OE_STANDARD_WF.Clear_Msg_Context;

1083:
1084:
1085:
1086: resultout := 'COMPLETE';
1087: OE_STANDARD_WF.Clear_Msg_Context;
1088: return;
1089: end if; -- End for 'RUN' mode
1090:
1091: --

Line 1127: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1123: END IF;
1124: wf_core.context('OE_APPROVALS_WF', 'Reject_Approval',
1125: itemtype, itemkey, to_char(actid), funcmode);
1126: -- start data fix project
1127: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1128: p_itemtype => itemtype,
1129: p_itemkey => itemkey);
1130: OE_STANDARD_WF.Save_Messages;
1131: OE_STANDARD_WF.Clear_Msg_Context;

Line 1130: OE_STANDARD_WF.Save_Messages;

1126: -- start data fix project
1127: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1128: p_itemtype => itemtype,
1129: p_itemkey => itemkey);
1130: OE_STANDARD_WF.Save_Messages;
1131: OE_STANDARD_WF.Clear_Msg_Context;
1132: -- end data fix project
1133: raise;
1134:

Line 1131: OE_STANDARD_WF.Clear_Msg_Context;

1127: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1128: p_itemtype => itemtype,
1129: p_itemkey => itemkey);
1130: OE_STANDARD_WF.Save_Messages;
1131: OE_STANDARD_WF.Clear_Msg_Context;
1132: -- end data fix project
1133: raise;
1134:
1135:

Line 1410: oe_standard_wf.set_msg_context (actid);

1406: INTO l_parent_item_key
1407: FROM wf_items wi
1408: WHERE wi.item_type = itemtype AND wi.item_key = itemkey;
1409:
1410: oe_standard_wf.set_msg_context (actid);
1411: oe_msg_pub.set_msg_context (p_entity_code => 'HEADER',
1412: p_entity_id => TO_NUMBER (itemkey),
1413: p_header_id => TO_NUMBER (itemkey)
1414: );

Line 1696: --oe_standard_wf.save_messages;

1692: );
1693: END IF;
1694:
1695: resultout := 'COMPLETE:INVALID_APPROVER';
1696: --oe_standard_wf.save_messages;
1697: oe_standard_wf.clear_msg_context;
1698: RETURN;
1699: ELSE
1700: IF l_debug_level > 0

Line 1697: oe_standard_wf.clear_msg_context;

1693: END IF;
1694:
1695: resultout := 'COMPLETE:INVALID_APPROVER';
1696: --oe_standard_wf.save_messages;
1697: oe_standard_wf.clear_msg_context;
1698: RETURN;
1699: ELSE
1700: IF l_debug_level > 0
1701: THEN

Line 2000: oe_standard_wf.clear_msg_context;

1996: END IF;
1997: END IF;
1998:
1999: resultout := 'COMPLETE:VALID_APPROVER';
2000: oe_standard_wf.clear_msg_context;
2001: RETURN;
2002: END IF; --approvers count
2003: ELSIF l_complete = ame_util.booleantrue
2004: THEN

Line 2045: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2041: TO_CHAR (actid),
2042: funcmode
2043: );
2044: -- start data fix project
2045: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2046: p_itemtype => itemtype,
2047: p_itemkey => itemkey
2048: );
2049: oe_standard_wf.save_messages;

Line 2049: oe_standard_wf.save_messages;

2045: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2046: p_itemtype => itemtype,
2047: p_itemkey => itemkey
2048: );
2049: oe_standard_wf.save_messages;
2050: oe_standard_wf.clear_msg_context;
2051: -- end data fix project
2052: --resultout := 'COMPLETE:INVALID_APPROVER';
2053: --wf_engine.setitemattrtext (itemtype, itemkey, 'AME_EXCEPTION', 'Y');

Line 2050: oe_standard_wf.clear_msg_context;

2046: p_itemtype => itemtype,
2047: p_itemkey => itemkey
2048: );
2049: oe_standard_wf.save_messages;
2050: oe_standard_wf.clear_msg_context;
2051: -- end data fix project
2052: --resultout := 'COMPLETE:INVALID_APPROVER';
2053: --wf_engine.setitemattrtext (itemtype, itemkey, 'AME_EXCEPTION', 'Y');
2054: ROLLBACK TO get_ame_approvers_launch;

Line 2104: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2100: TO_CHAR (actid),
2101: funcmode,
2102: SQLERRM
2103: );
2104: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2105: p_itemtype => itemtype,
2106: p_itemkey => itemkey
2107: );
2108: oe_standard_wf.save_messages;

Line 2108: oe_standard_wf.save_messages;

2104: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2105: p_itemtype => itemtype,
2106: p_itemkey => itemkey
2107: );
2108: oe_standard_wf.save_messages;
2109: oe_standard_wf.clear_msg_context;
2110: END is_ame_exception;
2111:
2112: PROCEDURE check_parallel_wf_status (

Line 2109: oe_standard_wf.clear_msg_context;

2105: p_itemtype => itemtype,
2106: p_itemkey => itemkey
2107: );
2108: oe_standard_wf.save_messages;
2109: oe_standard_wf.clear_msg_context;
2110: END is_ame_exception;
2111:
2112: PROCEDURE check_parallel_wf_status (
2113: itemtype IN VARCHAR2,

Line 2159: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2155: TO_CHAR (actid),
2156: funcmode,
2157: SQLERRM
2158: );
2159: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2160: p_itemtype => itemtype,
2161: p_itemkey => itemkey
2162: );
2163: oe_standard_wf.save_messages;

Line 2163: oe_standard_wf.save_messages;

2159: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2160: p_itemtype => itemtype,
2161: p_itemkey => itemkey
2162: );
2163: oe_standard_wf.save_messages;
2164: oe_standard_wf.clear_msg_context;
2165: END check_parallel_wf_status;
2166:
2167: PROCEDURE treat_ame_exception_as (

Line 2164: oe_standard_wf.clear_msg_context;

2160: p_itemtype => itemtype,
2161: p_itemkey => itemkey
2162: );
2163: oe_standard_wf.save_messages;
2164: oe_standard_wf.clear_msg_context;
2165: END check_parallel_wf_status;
2166:
2167: PROCEDURE treat_ame_exception_as (
2168: itemtype IN VARCHAR2,

Line 2193: oe_standard_wf.clear_msg_context;

2189: resultout := 'COMPLETE:APPROVAL';
2190: IF l_debug_level > 0 THEN
2191: oe_debug_pub.ADD ('Treating as approval');
2192: END IF ;
2193: oe_standard_wf.clear_msg_context;
2194: RETURN;
2195: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =
2196: 'REJECTION'
2197: THEN

Line 2208: oe_standard_wf.clear_msg_context;

2204: resultout := 'COMPLETE:REJECTION';
2205: IF l_debug_level > 0 THEN
2206: oe_debug_pub.ADD ('Treating as rejection');
2207: END IF ;
2208: oe_standard_wf.clear_msg_context;
2209: RETURN;
2210: END IF;
2211: EXCEPTION
2212: WHEN OTHERS

Line 2225: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2221: TO_CHAR (actid),
2222: funcmode,
2223: SQLERRM
2224: );
2225: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2226: p_itemtype => itemtype,
2227: p_itemkey => itemkey
2228: );
2229: oe_standard_wf.save_messages;

Line 2229: oe_standard_wf.save_messages;

2225: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2226: p_itemtype => itemtype,
2227: p_itemkey => itemkey
2228: );
2229: oe_standard_wf.save_messages;
2230: oe_standard_wf.clear_msg_context;
2231: END treat_ame_exception_as;
2232:
2233: PROCEDURE get_notification_attributes (

Line 2230: oe_standard_wf.clear_msg_context;

2226: p_itemtype => itemtype,
2227: p_itemkey => itemkey
2228: );
2229: oe_standard_wf.save_messages;
2230: oe_standard_wf.clear_msg_context;
2231: END treat_ame_exception_as;
2232:
2233: PROCEDURE get_notification_attributes (
2234: itemtype IN VARCHAR2,

Line 2269: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2265: TO_CHAR (actid),
2266: funcmode,
2267: SQLERRM
2268: );
2269: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2270: p_itemtype => itemtype,
2271: p_itemkey => itemkey
2272: );
2273: oe_standard_wf.save_messages;

Line 2273: oe_standard_wf.save_messages;

2269: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2270: p_itemtype => itemtype,
2271: p_itemkey => itemkey
2272: );
2273: oe_standard_wf.save_messages;
2274: oe_standard_wf.clear_msg_context;
2275: END get_notification_attributes;
2276:
2277: PROCEDURE process_response_approve (

Line 2274: oe_standard_wf.clear_msg_context;

2270: p_itemtype => itemtype,
2271: p_itemkey => itemkey
2272: );
2273: oe_standard_wf.save_messages;
2274: oe_standard_wf.clear_msg_context;
2275: END get_notification_attributes;
2276:
2277: PROCEDURE process_response_approve (
2278: itemtype IN VARCHAR2,

Line 2360: oe_standard_wf.set_msg_context (actid);

2356: END IF ;
2357: END;
2358:
2359: l_transaction_id := TO_NUMBER (itemkey);
2360: oe_standard_wf.set_msg_context (actid);
2361: oe_msg_pub.set_msg_context
2362: (p_entity_code => 'HEADER',
2363: p_entity_id => TO_NUMBER
2364: (l_parent_itemkey),

Line 2594: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2590: TO_CHAR (actid),
2591: funcmode,
2592: SQLERRM
2593: );
2594: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2595: p_itemtype => itemtype,
2596: p_itemkey => itemkey
2597: );
2598: oe_standard_wf.save_messages;

Line 2598: oe_standard_wf.save_messages;

2594: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2595: p_itemtype => itemtype,
2596: p_itemkey => itemkey
2597: );
2598: oe_standard_wf.save_messages;
2599: oe_standard_wf.clear_msg_context;
2600: RAISE;
2601: END process_response_approve;
2602:

Line 2599: oe_standard_wf.clear_msg_context;

2595: p_itemtype => itemtype,
2596: p_itemkey => itemkey
2597: );
2598: oe_standard_wf.save_messages;
2599: oe_standard_wf.clear_msg_context;
2600: RAISE;
2601: END process_response_approve;
2602:
2603: PROCEDURE process_response_reject (

Line 2686: oe_standard_wf.set_msg_context (actid);

2682: END IF ;
2683: END;
2684:
2685: l_transaction_id := TO_NUMBER (itemkey);
2686: oe_standard_wf.set_msg_context (actid);
2687: oe_msg_pub.set_msg_context
2688: (p_entity_code => 'HEADER',
2689: p_entity_id => TO_NUMBER
2690: (l_parent_itemkey),

Line 2920: oe_standard_wf.add_error_activity_msg (p_actid => actid,

2916: TO_CHAR (actid),
2917: funcmode,
2918: SQLERRM
2919: );
2920: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2921: p_itemtype => itemtype,
2922: p_itemkey => itemkey
2923: );
2924: oe_standard_wf.save_messages;

Line 2924: oe_standard_wf.save_messages;

2920: oe_standard_wf.add_error_activity_msg (p_actid => actid,
2921: p_itemtype => itemtype,
2922: p_itemkey => itemkey
2923: );
2924: oe_standard_wf.save_messages;
2925: oe_standard_wf.clear_msg_context;
2926: RAISE;
2927: END process_response_reject;
2928:

Line 2925: oe_standard_wf.clear_msg_context;

2921: p_itemtype => itemtype,
2922: p_itemkey => itemkey
2923: );
2924: oe_standard_wf.save_messages;
2925: oe_standard_wf.clear_msg_context;
2926: RAISE;
2927: END process_response_reject;
2928:
2929: PROCEDURE process_beat_by_first (

Line 3283: oe_standard_wf.add_error_activity_msg (p_actid => actid,

3279: TO_CHAR (actid),
3280: funcmode,
3281: SQLERRM
3282: );
3283: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3284: p_itemtype => itemtype,
3285: p_itemkey => itemkey
3286: );
3287: oe_standard_wf.save_messages;

Line 3287: oe_standard_wf.save_messages;

3283: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3284: p_itemtype => itemtype,
3285: p_itemkey => itemkey
3286: );
3287: oe_standard_wf.save_messages;
3288: oe_standard_wf.clear_msg_context;
3289: RAISE;
3290: END process_beat_by_first;
3291:

Line 3288: oe_standard_wf.clear_msg_context;

3284: p_itemtype => itemtype,
3285: p_itemkey => itemkey
3286: );
3287: oe_standard_wf.save_messages;
3288: oe_standard_wf.clear_msg_context;
3289: RAISE;
3290: END process_beat_by_first;
3291:
3292: PROCEDURE use_ame_approval (

Line 3433: oe_standard_wf.add_error_activity_msg (p_actid => actid,

3429: TO_CHAR (actid),
3430: funcmode,
3431: SQLERRM
3432: );
3433: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3434: p_itemtype => itemtype,
3435: p_itemkey => itemkey
3436: );
3437: oe_standard_wf.save_messages;

Line 3437: oe_standard_wf.save_messages;

3433: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3434: p_itemtype => itemtype,
3435: p_itemkey => itemkey
3436: );
3437: oe_standard_wf.save_messages;
3438: oe_standard_wf.clear_msg_context;
3439: END use_ame_approval;
3440:
3441: PROCEDURE push_block_activity (

Line 3438: oe_standard_wf.clear_msg_context;

3434: p_itemtype => itemtype,
3435: p_itemkey => itemkey
3436: );
3437: oe_standard_wf.save_messages;
3438: oe_standard_wf.clear_msg_context;
3439: END use_ame_approval;
3440:
3441: PROCEDURE push_block_activity (
3442: itemtype IN VARCHAR2,

Line 3496: oe_standard_wf.add_error_activity_msg (p_actid => actid,

3492: TO_CHAR (actid),
3493: funcmode,
3494: SQLERRM
3495: );
3496: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3497: p_itemtype => itemtype,
3498: p_itemkey => itemkey
3499: );
3500: oe_standard_wf.save_messages;

Line 3500: oe_standard_wf.save_messages;

3496: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3497: p_itemtype => itemtype,
3498: p_itemkey => itemkey
3499: );
3500: oe_standard_wf.save_messages;
3501: oe_standard_wf.clear_msg_context;
3502: END push_block_activity;
3503:
3504: PROCEDURE approval_timeout_ame (

Line 3501: oe_standard_wf.clear_msg_context;

3497: p_itemtype => itemtype,
3498: p_itemkey => itemkey
3499: );
3500: oe_standard_wf.save_messages;
3501: oe_standard_wf.clear_msg_context;
3502: END push_block_activity;
3503:
3504: PROCEDURE approval_timeout_ame (
3505: itemtype IN VARCHAR2,

Line 3525: oe_standard_wf.set_msg_context (actid);

3521: --
3522: IF (funcmode = 'RUN')
3523: THEN
3524: l_transaction_id := TO_NUMBER (itemkey);
3525: oe_standard_wf.set_msg_context (actid);
3526: oe_msg_pub.set_msg_context (p_entity_code => 'HEADER',
3527: p_entity_id => TO_NUMBER (itemkey),
3528: p_header_id => TO_NUMBER (itemkey)
3529: );

Line 3542: oe_standard_wf.clear_msg_context;

3538: ) = 'CONTINUE'
3539: THEN
3540: --just check the sys param value for AME. Last approver concept is not applicable here
3541: resultout := 'COMPLETE:CONTINUE';
3542: oe_standard_wf.clear_msg_context;
3543: RETURN;
3544: ELSE
3545: resultout := 'COMPLETE:REJECTED';
3546: oe_standard_wf.clear_msg_context;

Line 3546: oe_standard_wf.clear_msg_context;

3542: oe_standard_wf.clear_msg_context;
3543: RETURN;
3544: ELSE
3545: resultout := 'COMPLETE:REJECTED';
3546: oe_standard_wf.clear_msg_context;
3547: RETURN;
3548: END IF;
3549:
3550: resultout := 'COMPLETE';

Line 3551: oe_standard_wf.clear_msg_context;

3547: RETURN;
3548: END IF;
3549:
3550: resultout := 'COMPLETE';
3551: oe_standard_wf.clear_msg_context;
3552: RETURN;
3553: END IF;
3554:
3555: IF (funcmode = 'CANCEL')

Line 3579: oe_standard_wf.add_error_activity_msg (p_actid => actid,

3575: TO_CHAR (actid),
3576: funcmode
3577: );
3578: -- start data fix project
3579: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3580: p_itemtype => itemtype,
3581: p_itemkey => itemkey
3582: );
3583: oe_standard_wf.save_messages;

Line 3583: oe_standard_wf.save_messages;

3579: oe_standard_wf.add_error_activity_msg (p_actid => actid,
3580: p_itemtype => itemtype,
3581: p_itemkey => itemkey
3582: );
3583: oe_standard_wf.save_messages;
3584: oe_standard_wf.clear_msg_context;
3585: -- end data fix project
3586: RAISE;
3587: END approval_timeout_ame;

Line 3584: oe_standard_wf.clear_msg_context;

3580: p_itemtype => itemtype,
3581: p_itemkey => itemkey
3582: );
3583: oe_standard_wf.save_messages;
3584: oe_standard_wf.clear_msg_context;
3585: -- end data fix project
3586: RAISE;
3587: END approval_timeout_ame;
3588: