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.POS_WCAPPROVE_PVT dependencies on FND_LOG

Line 29: /* Taken from Package FND_LOG

25: p_msg in varchar2)
26: IS
27: l_module varchar2(2000);
28: BEGIN
29: /* Taken from Package FND_LOG
30: LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
31: LEVEL_ERROR CONSTANT NUMBER := 5;
32: LEVEL_EXCEPTION CONSTANT NUMBER := 4;
33: LEVEL_EVENT CONSTANT NUMBER := 3;

Line 40: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

36: */
37:
38: l_module := 'pos.plsql.pos_wcapprove_pvt.'||p_api_name;
39: IF(g_asn_debug = 'Y')THEN
40: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
41: FND_LOG.string(LOG_LEVEL => p_level,
42: MODULE => l_module,
43: MESSAGE => p_msg);
44: END IF;

Line 41: FND_LOG.string(LOG_LEVEL => p_level,

37:
38: l_module := 'pos.plsql.pos_wcapprove_pvt.'||p_api_name;
39: IF(g_asn_debug = 'Y')THEN
40: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
41: FND_LOG.string(LOG_LEVEL => p_level,
42: MODULE => l_module,
43: MESSAGE => p_msg);
44: END IF;
45:

Line 104: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

100: begin
101: l_progress := 'POS_WCAPPROVE_PVT.start_wf_progress: 01';
102:
103: IF (g_asn_debug = 'Y') THEN
104: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
105: 'Enter Start_wf_process ' || l_progress);
106: END IF;
107:
108: If (p_itemkey is NULL) then

Line 138: debug_log(FND_LOG.LEVEL_UNEXPECTED,

134:
135: exception
136: when others then
137: IF (g_asn_debug = 'Y') THEN
138: debug_log(FND_LOG.LEVEL_UNEXPECTED,
139: l_api_name,'Exception to check process '
140: || l_progress);
141: END IF;
142: raise;

Line 147: debug_log(FND_LOG.LEVEL_STATEMENT,

143: end;
144:
145:
146: IF (g_asn_debug = 'Y') THEN
147: debug_log(FND_LOG.LEVEL_STATEMENT,
148: l_api_name,'l_wf_created ' || l_wf_created);
149: END IF;
150:
151: if l_wf_created = 0 then

Line 157: debug_log(FND_LOG.LEVEL_STATEMENT,

153: ItemType => p_itemtype,
154: ItemKey => l_itemkey,
155: process => p_workflow_process );
156: IF (g_asn_debug = 'Y') THEN
157: debug_log(FND_LOG.LEVEL_STATEMENT,
158: l_api_name,'Workflow process created ' );
159: END IF;
160: end if;
161:

Line 165: debug_log(FND_LOG.LEVEL_STATEMENT,

161:
162:
163: /* Initialize workflow item attributes */
164: IF (g_asn_debug = 'Y') THEN
165: debug_log(FND_LOG.LEVEL_STATEMENT,
166: l_api_name,'Initialize workflow attributes ' );
167: END IF;
168:
169: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

Line 176: debug_log(FND_LOG.LEVEL_STATEMENT,

172: avalue => p_work_confirmation_id);
173:
174:
175: IF (g_asn_debug = 'Y') THEN
176: debug_log(FND_LOG.LEVEL_STATEMENT,
177: l_api_name,'p_work_confirmation_id '||p_work_confirmation_id );
178: END IF;
179:
180: select shipment_num

Line 187: debug_log(FND_LOG.LEVEL_STATEMENT,

183: where shipment_header_id = p_work_confirmation_id
184: and nvl(asn_type,'STD') = 'WC';
185:
186: IF (g_asn_debug = 'Y') THEN
187: debug_log(FND_LOG.LEVEL_STATEMENT,
188: l_api_name,'l_work_confirmation_number '
189: ||l_work_confirmation_number );
190:
191: END IF;

Line 206: debug_log(FND_LOG.LEVEL_STATEMENT,

202: from rcv_shipment_lines
203: where shipment_header_id = p_work_confirmation_id;
204:
205: IF (g_asn_debug = 'Y') THEN
206: debug_log(FND_LOG.LEVEL_STATEMENT,
207: l_api_name,'l_po_header_id ' || l_po_header_id); END IF;
208:
209: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
210: itemkey => l_itemkey,

Line 255: debug_log(FND_LOG.LEVEL_STATEMENT,

251: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
252: end if;
253:
254: IF (g_asn_debug = 'Y') THEN
255: debug_log(FND_LOG.LEVEL_STATEMENT,
256: l_api_name,'Start process ' );
257: debug_log(FND_LOG.LEVEL_STATEMENT,
258: l_api_name,'itemtype '||p_itemtype );
259: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 257: debug_log(FND_LOG.LEVEL_STATEMENT,

253:
254: IF (g_asn_debug = 'Y') THEN
255: debug_log(FND_LOG.LEVEL_STATEMENT,
256: l_api_name,'Start process ' );
257: debug_log(FND_LOG.LEVEL_STATEMENT,
258: l_api_name,'itemtype '||p_itemtype );
259: debug_log(FND_LOG.LEVEL_STATEMENT,
260: l_api_name,'l_itemkey '||l_itemkey );
261: END IF;

Line 259: debug_log(FND_LOG.LEVEL_STATEMENT,

255: debug_log(FND_LOG.LEVEL_STATEMENT,
256: l_api_name,'Start process ' );
257: debug_log(FND_LOG.LEVEL_STATEMENT,
258: l_api_name,'itemtype '||p_itemtype );
259: debug_log(FND_LOG.LEVEL_STATEMENT,
260: l_api_name,'l_itemkey '||l_itemkey );
261: END IF;
262: wf_engine.StartProcess(itemtype => p_itemtype,
263: itemkey => l_itemkey );

Line 268: debug_log(FND_LOG.LEVEL_STATEMENT,

264:
265: end if; --} itemtype, itemkey and work_confirmation_id not null
266:
267: IF (g_asn_debug = 'Y') THEN
268: debug_log(FND_LOG.LEVEL_STATEMENT,
269: l_api_name,'Leave start_wf_process ' );
270: End if;
271: Exception
272: when others then

Line 274: debug_log(FND_LOG.LEVEL_UNEXPECTED,

270: End if;
271: Exception
272: when others then
273: IF (g_asn_debug = 'Y') THEN
274: debug_log(FND_LOG.LEVEL_UNEXPECTED,
275: l_api_name,'Exception in Start_wf_process ' || l_progress);
276: END IF;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: raise;

Line 314: debug_log(FND_LOG.LEVEL_STATEMENT,

310:
311: l_progress := 'POS_WCAPPROVE_PVT.close_old_notifications: 01';
312:
313: IF (g_asn_debug = 'Y') THEN
314: debug_log(FND_LOG.LEVEL_STATEMENT,
315: l_api_name,'Enter close_old_notif ' || l_progress);
316: debug_log(FND_LOG.LEVEL_STATEMENT,
317: l_api_name,'p_itemtype ' || p_itemtype);
318: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 316: debug_log(FND_LOG.LEVEL_STATEMENT,

312:
313: IF (g_asn_debug = 'Y') THEN
314: debug_log(FND_LOG.LEVEL_STATEMENT,
315: l_api_name,'Enter close_old_notif ' || l_progress);
316: debug_log(FND_LOG.LEVEL_STATEMENT,
317: l_api_name,'p_itemtype ' || p_itemtype);
318: debug_log(FND_LOG.LEVEL_STATEMENT,
319: l_api_name,'p_itemkey ' || p_itemkey);
320: END IF;

Line 318: debug_log(FND_LOG.LEVEL_STATEMENT,

314: debug_log(FND_LOG.LEVEL_STATEMENT,
315: l_api_name,'Enter close_old_notif ' || l_progress);
316: debug_log(FND_LOG.LEVEL_STATEMENT,
317: l_api_name,'p_itemtype ' || p_itemtype);
318: debug_log(FND_LOG.LEVEL_STATEMENT,
319: l_api_name,'p_itemkey ' || p_itemkey);
320: END IF;
321:
322: if (p_funcmode <> wf_engine.eng_run) then

Line 334: debug_log(FND_LOG.LEVEL_STATEMENT,

330: itemkey => p_itemkey,
331: aname => 'WORK_CONFIRMATION_ID');
332:
333: IF (g_asn_debug = 'Y') THEN
334: debug_log(FND_LOG.LEVEL_STATEMENT,
335: l_api_name,'l_work_confirmation_id ' ||
336: l_work_confirmation_id);
337: END IF;
338: /* If the document has been previously submitted to workflow,

Line 350: debug_log(FND_LOG.LEVEL_STATEMENT,

346: fetch ship_header_cursor into l_wf_itemkey;
347: close ship_header_cursor;
348:
349: IF (g_asn_debug = 'Y') THEN
350: debug_log(FND_LOG.LEVEL_STATEMENT,
351: l_api_name,'l_wf_itemkey ' || l_wf_itemkey);
352: END IF;
353:
354: if (l_wf_itemkey is not null) then

Line 365: debug_log(FND_LOG.LEVEL_STATEMENT,

361:
362: l_progress := 'POS_WCAPPROVE_PVT.close_old_notif: 02.';
363:
364: IF (g_asn_debug = 'Y') THEN
365: debug_log(FND_LOG.LEVEL_STATEMENT,
366: l_api_name,'Leave close_old_notif ' || l_progress);
367: END IF;
368:
369: exception

Line 372: debug_log(FND_LOG.LEVEL_UNEXPECTED,

368:
369: exception
370: when others then
371: IF (g_asn_debug = 'Y') THEN
372: debug_log(FND_LOG.LEVEL_UNEXPECTED,
373: l_api_name,'Exception in close_old_notif ' || l_progress);
374: END IF;
375: raise;
376: end Close_old_notif;

Line 402: debug_log(FND_LOG.LEVEL_STATEMENT,

398:
399: begin
400: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 01.';
401: IF (g_asn_debug = 'Y') THEN
402: debug_log(FND_LOG.LEVEL_STATEMENT,
403: l_api_name,'Enter in set_startup_values ' || l_progress);
404: END IF;
405:
406: if (p_funcmode <> wf_engine.eng_run) then

Line 418: debug_log(FND_LOG.LEVEL_STATEMENT,

414: aname => 'WORK_CONFIRMATION_ID');
415:
416:
417: IF (g_asn_debug = 'Y') THEN
418: debug_log(FND_LOG.LEVEL_STATEMENT,
419: l_api_name,'l_work_confirmation_id ' ||
420: l_work_confirmation_id);
421: END IF;
422:

Line 436: debug_log(FND_LOG.LEVEL_STATEMENT,

432: from fnd_user
433: where user_id = l_wc_preparer_id;
434:
435: IF (g_asn_debug = 'Y') THEN
436: debug_log(FND_LOG.LEVEL_STATEMENT,
437: l_api_name,'l_wc_preparer_id ' ||
438: l_wc_preparer_id);
439: END IF;
440:

Line 457: debug_log(FND_LOG.LEVEL_STATEMENT,

453: end if;
454:
455:
456: IF (g_asn_debug = 'Y') THEN
457: debug_log(FND_LOG.LEVEL_STATEMENT,
458: l_api_name,'l_wc_preparer_name ' || l_wc_preparer_name);
459: debug_log(FND_LOG.LEVEL_STATEMENT,
460: l_api_name,'l_wc_preparer_display_name ' ||
461: l_wc_preparer_display_name);

Line 459: debug_log(FND_LOG.LEVEL_STATEMENT,

455:
456: IF (g_asn_debug = 'Y') THEN
457: debug_log(FND_LOG.LEVEL_STATEMENT,
458: l_api_name,'l_wc_preparer_name ' || l_wc_preparer_name);
459: debug_log(FND_LOG.LEVEL_STATEMENT,
460: l_api_name,'l_wc_preparer_display_name ' ||
461: l_wc_preparer_display_name);
462: END IF;
463: wf_engine.SetItemAttrText ( itemtype => p_itemType,

Line 480: debug_log(FND_LOG.LEVEL_STATEMENT,

476: itemkey => p_itemkey,
477: aname => 'PO_DOCUMENT_ID');
478:
479: IF (g_asn_debug = 'Y') THEN
480: debug_log(FND_LOG.LEVEL_STATEMENT,
481: l_api_name,'l_po_header_id ' || l_po_header_id);
482: END IF;
483:
484: /* We need doc_status only if the document is rejected.

Line 503: debug_log(FND_LOG.LEVEL_STATEMENT,

499: from po_headers_all poh
500: where po_header_id = l_po_header_id;
501:
502: IF (g_asn_debug = 'Y') THEN
503: debug_log(FND_LOG.LEVEL_STATEMENT,
504: l_api_name,'l_po_number ' || l_po_number);
505: debug_log(FND_LOG.LEVEL_STATEMENT,
506: l_api_name,'l_preparer_id ' || l_po_preparer_id);
507: END IF;

Line 505: debug_log(FND_LOG.LEVEL_STATEMENT,

501:
502: IF (g_asn_debug = 'Y') THEN
503: debug_log(FND_LOG.LEVEL_STATEMENT,
504: l_api_name,'l_po_number ' || l_po_number);
505: debug_log(FND_LOG.LEVEL_STATEMENT,
506: l_api_name,'l_preparer_id ' || l_po_preparer_id);
507: END IF;
508:
509: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

Line 519: debug_log(FND_LOG.LEVEL_STATEMENT,

515: get_user_name('PER',l_po_preparer_id, l_po_preparer_name,
516: l_po_preparer_display_name);
517:
518: IF (g_asn_debug = 'Y') THEN
519: debug_log(FND_LOG.LEVEL_STATEMENT,
520: l_api_name,'l_po_preparer_name ' || l_po_preparer_name);
521: debug_log(FND_LOG.LEVEL_STATEMENT,
522: l_api_name,'l_po_preparer_display_name ' ||
523: l_po_preparer_display_name);

Line 521: debug_log(FND_LOG.LEVEL_STATEMENT,

517:
518: IF (g_asn_debug = 'Y') THEN
519: debug_log(FND_LOG.LEVEL_STATEMENT,
520: l_api_name,'l_po_preparer_name ' || l_po_preparer_name);
521: debug_log(FND_LOG.LEVEL_STATEMENT,
522: l_api_name,'l_po_preparer_display_name ' ||
523: l_po_preparer_display_name);
524: END IF;
525: wf_engine.SetItemAttrText ( itemtype => p_itemType,

Line 596: debug_log(FND_LOG.LEVEL_STATEMENT,

592: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
593:
594: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 06.';
595: IF (g_asn_debug = 'Y') THEN
596: debug_log(FND_LOG.LEVEL_STATEMENT,
597: l_api_name,'Leave set_startup_values '
598: || l_progress);
599: END IF;
600: exception

Line 603: debug_log(FND_LOG.LEVEL_UNEXPECTED,

599: END IF;
600: exception
601: when others then
602: IF (g_asn_debug = 'Y') THEN
603: debug_log(FND_LOG.LEVEL_UNEXPECTED,
604: l_api_name,'Exception in set_startup_values '
605: || l_progress);
606: END IF;
607: raise;

Line 623: debug_log(FND_LOG.LEVEL_STATEMENT,

619: begin
620:
621: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 01.';
622: IF (g_asn_debug = 'Y') THEN
623: debug_log(FND_LOG.LEVEL_STATEMENT,
624: l_api_name,'Enter in update_workflow_info ' || l_progress);
625: END IF;
626:
627: if (p_funcmode <> wf_engine.eng_run) then

Line 640: debug_log(FND_LOG.LEVEL_STATEMENT,

636: aname => 'WORK_CONFIRMATION_ID');
637:
638: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';
639: IF (g_asn_debug = 'Y') THEN
640: debug_log(FND_LOG.LEVEL_STATEMENT,
641: l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
642: END IF;
643:
644: UpdateWorkflowInfo(p_itemtype,p_itemkey,l_shipment_header_id);

Line 650: debug_log(FND_LOG.LEVEL_STATEMENT,

646: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
647:
648: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';
649: IF (g_asn_debug = 'Y') THEN
650: debug_log(FND_LOG.LEVEL_STATEMENT,
651: l_api_name,'Leave update_workflow_info ' || l_progress);
652: END IF;
653:
654: exception

Line 657: debug_log(FND_LOG.LEVEL_UNEXPECTED,

653:
654: exception
655: when others then
656: IF (g_asn_debug = 'Y') THEN
657: debug_log(FND_LOG.LEVEL_UNEXPECTED,
658: l_api_name,'Exception in update_workflow_info '
659: || l_progress);
660: END IF;
661: raise;

Line 688: debug_log(FND_LOG.LEVEL_STATEMENT,

684: l_api_name varchar2(50) := p_itemkey || ' get_wc_attributes';
685: begin
686: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 01.';
687: IF (g_asn_debug = 'Y') THEN
688: debug_log(FND_LOG.LEVEL_STATEMENT,
689: l_api_name,'Enter in get_wc_attributes '
690: || l_progress);
691: end if;
692:

Line 705: debug_log(FND_LOG.LEVEL_STATEMENT,

701: itemkey => p_itemkey,
702: aname => 'WORK_CONFIRMATION_ID');
703:
704: IF (g_asn_debug = 'Y') THEN
705: debug_log(FND_LOG.LEVEL_STATEMENT,
706: l_api_name,'l_shipment_header_id '|| l_shipment_header_id);
707: end if;
708:
709: /* See if atleast one shipment have attachments*/

Line 722: debug_log(FND_LOG.LEVEL_STATEMENT,

718: from rcv_shipment_lines
719: where shipment_header_id=l_shipment_header_id);
720:
721: IF (g_asn_debug = 'Y') THEN
722: debug_log(FND_LOG.LEVEL_STATEMENT,
723: l_api_name,'l_attach_count '||
724: l_attach_count);
725: end if;
726:

Line 737: debug_log(FND_LOG.LEVEL_STATEMENT,

733: fetch get_attachments into l_shipment_line_id;
734: exit when get_attachments%notfound;
735:
736: IF (g_asn_debug = 'Y') THEN
737: debug_log(FND_LOG.LEVEL_STATEMENT,
738: l_api_name,'l_shipment_line_id '||
739: l_shipment_line_id);
740: end if;
741:

Line 753: debug_log(FND_LOG.LEVEL_UNEXPECTED,

749: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
750: exception
751: when others then
752: IF (g_asn_debug = 'Y') THEN
753: debug_log(FND_LOG.LEVEL_UNEXPECTED,
754: l_api_name,'Exception in Get_WC_Attributes '
755: || l_progress);
756: END IF;
757: raise;

Line 803: debug_log(FND_LOG.LEVEL_STATEMENT,

799: BEGIN
800:
801: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 01.';
802: IF (g_asn_debug = 'Y') THEN
803: debug_log(FND_LOG.LEVEL_STATEMENT,
804: l_api_name,'Enter in Ins_Actionhist_submit '
805: || l_progress);
806: END IF;
807:

Line 819: debug_log(FND_LOG.LEVEL_STATEMENT,

815: itemkey => p_itemkey,
816: aname => 'WORK_CONFIRMATION_ID');
817:
818: IF (g_asn_debug = 'Y') THEN
819: debug_log(FND_LOG.LEVEL_STATEMENT,
820: l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
821: END IF;
822:
823: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 02.';

Line 830: debug_log(FND_LOG.LEVEL_STATEMENT,

826: itemkey => p_itemkey,
827: aname => 'WC_PREPARER_ID');
828:
829: IF (g_asn_debug = 'Y') THEN
830: debug_log(FND_LOG.LEVEL_STATEMENT,
831: l_api_name,'l_wc_preparer_id ' || l_wc_preparer_id);
832: END IF;
833:
834:

Line 863: debug_log(FND_LOG.LEVEL_STATEMENT,

859: l_sequence_num := l_sequence_num +1;
860: END IF;
861:
862: IF (g_asn_debug = 'Y') THEN
863: debug_log(FND_LOG.LEVEL_STATEMENT,
864: l_api_name,'l_sequence_num ' ||
865: l_sequence_num);
866: END IF;
867:

Line 876: debug_log(FND_LOG.LEVEL_STATEMENT,

872: (l_sequence_num > 0 and l_action_code is NOT NULL)) THEN --{
873:
874:
875: IF (g_asn_debug = 'Y') THEN
876: debug_log(FND_LOG.LEVEL_STATEMENT,
877: l_api_name,'before call to InsertPOActionHistory ' ||
878: l_sequence_num);
879: END IF;
880:

Line 907: debug_log(FND_LOG.LEVEL_STATEMENT,

903: ELSE --}{
904: l_sequence_num := l_sequence_num - 1;
905:
906: IF (g_asn_debug = 'Y') THEN
907: debug_log(FND_LOG.LEVEL_STATEMENT,
908: l_api_name,'before call to Upd_ActionHistory_Submit ' ||
909: l_sequence_num);
910: END IF;
911:

Line 926: debug_log(FND_LOG.LEVEL_STATEMENT,

922: END IF; --}
923:
924: /* Insert the null action code*/
925: IF (g_asn_debug = 'Y') THEN
926: debug_log(FND_LOG.LEVEL_STATEMENT,
927: l_api_name,'insert null action_code ' ||
928: l_sequence_num);
929: END IF;
930:

Line 959: debug_log(FND_LOG.LEVEL_STATEMENT,

955: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
956:
957: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 07.';
958: IF (g_asn_debug = 'Y') THEN
959: debug_log(FND_LOG.LEVEL_STATEMENT,
960: l_api_name,'Leave Ins_Actionhist_submit ' || l_progress);
961: END IF;
962: exception
963: when others then

Line 965: debug_log(FND_LOG.LEVEL_UNEXPECTED,

961: END IF;
962: exception
963: when others then
964: IF (g_asn_debug = 'Y') THEN
965: debug_log(FND_LOG.LEVEL_UNEXPECTED,
966: l_api_name,'Exception in Ins_Actionhist_submit '
967: || l_progress);
968: END IF;
969: raise;

Line 1004: debug_log(FND_LOG.LEVEL_STATEMENT,

1000: BEGIN
1001:
1002: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 01.';
1003: IF (g_asn_debug = 'Y') THEN
1004: debug_log(FND_LOG.LEVEL_STATEMENT,
1005: l_api_name,'Enter in get_next_approver '
1006: || l_progress);
1007: END IF;
1008:

Line 1011: debug_log(FND_LOG.LEVEL_STATEMENT,

1007: END IF;
1008:
1009: if (p_funcmode <> wf_engine.eng_run) then
1010: IF (g_asn_debug = 'Y') THEN
1011: debug_log(FND_LOG.LEVEL_STATEMENT,
1012: l_api_name,'funcmode in get_next_approver '
1013: || l_progress);
1014: END IF;
1015:

Line 1026: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

1022: itemkey => p_itemkey,
1023: aname => 'WORK_CONFIRMATION_ID');
1024:
1025: IF (g_asn_debug = 'Y') THEN
1026: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1027: 'l_shipment_header_id ' || l_shipment_header_id);
1028: END IF;
1029:
1030: l_po_header_id := wf_engine.GetItemAttrNumber

Line 1036: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

1032: itemkey => p_itemkey,
1033: aname => 'PO_DOCUMENT_ID');
1034:
1035: IF (g_asn_debug = 'Y') THEN
1036: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1037: 'l_po_header_id ' || l_po_header_id);
1038: END IF;
1039:
1040: l_work_confirmation_number :=

Line 1046: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

1042: itemkey => p_itemkey,
1043: aname => 'WORK_CONFIRMATION_NUMBER');
1044:
1045: IF (g_asn_debug = 'Y') THEN
1046: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1047: 'l_work_confirmation_number ' || l_work_confirmation_number);
1048: END IF;
1049:
1050: l_transaction_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,

Line 1055: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

1051: itemkey => p_itemkey,
1052: aname => 'AME_TRANSACTION_TYPE');
1053:
1054: IF (g_asn_debug = 'Y') THEN
1055: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1056: 'l_transaction_type ' || l_transaction_type);
1057: END IF;
1058: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 02.';
1059: IF (g_asn_debug = 'Y') THEN

Line 1060: debug_log(FND_LOG.LEVEL_STATEMENT,

1056: 'l_transaction_type ' || l_transaction_type);
1057: END IF;
1058: l_progress := 'POS_WCAPPROVE_PVT.get_next_approver: 02.';
1059: IF (g_asn_debug = 'Y') THEN
1060: debug_log(FND_LOG.LEVEL_STATEMENT,
1061: l_api_name,'in get_next_approver '
1062: || l_progress);
1063: End if;
1064:

Line 1077: debug_log(FND_LOG.LEVEL_STATEMENT,

1073: itemkey => p_itemkey,
1074: aname => 'APPROVER_USER_NAME');
1075:
1076: IF (g_asn_debug = 'Y') THEN
1077: debug_log(FND_LOG.LEVEL_STATEMENT,
1078: l_api_name,'l_forward_from_user_name '
1079: || nvl(l_forward_from_user_name,'NONAME'));
1080: End if;
1081: If (l_forward_from_user_name is null) then

Line 1088: debug_log(FND_LOG.LEVEL_STATEMENT,

1084: itemkey => p_itemkey,
1085: aname => 'WC_PREPARER_NAME');
1086:
1087: IF (g_asn_debug = 'Y') THEN
1088: debug_log(FND_LOG.LEVEL_STATEMENT,
1089: l_api_name,'l_wc_preparer_name '
1090: || nvl(l_wc_preparer_name ,'NONAME'));
1091: End if;
1092:

Line 1121: debug_log(FND_LOG.LEVEL_STATEMENT,

1117: aname => 'RESPOND_TO_WC_URL' ,
1118: avalue => l_respond_to_wc_url);
1119:
1120: IF (g_asn_debug = 'Y') THEN
1121: debug_log(FND_LOG.LEVEL_STATEMENT,
1122: l_api_name,'before call to applicablerule ');
1123: End if;
1124: ame_api3.getApplicableRules1(applicationIdIn=>l_application_Id,
1125: transactionIdIn=>l_shipment_header_id,

Line 1138: debug_log(FND_LOG.LEVEL_STATEMENT,

1134: * value.
1135: */
1136: if (l_rule_id.count = 0 ) then --{
1137: IF (g_asn_debug = 'Y') THEN
1138: debug_log(FND_LOG.LEVEL_STATEMENT,
1139: l_api_name,'no rule is setup ');
1140: End if;
1141: l_default_approver :=
1142: wf_engine.GetItemAttrText (itemtype => p_itemtype,

Line 1147: debug_log(FND_LOG.LEVEL_STATEMENT,

1143: itemkey => p_itemkey,
1144: aname => 'DEFAULT_APPROVER');
1145:
1146: IF (g_asn_debug = 'Y') THEN
1147: debug_log(FND_LOG.LEVEL_STATEMENT,
1148: l_api_name,'l_default_approver '
1149: || l_default_approver);
1150: END IF;
1151:

Line 1155: debug_log(FND_LOG.LEVEL_STATEMENT,

1151:
1152: If l_default_approver = 'BUYER' then --{
1153:
1154: IF (g_asn_debug = 'Y') THEN
1155: debug_log(FND_LOG.LEVEL_STATEMENT,
1156: l_api_name,'already approved by buyer ');
1157: End if;
1158:
1159: x_resultout:='COMPLETE:'||'NO_NEXT_APPROVER';

Line 1163: debug_log(FND_LOG.LEVEL_STATEMENT,

1159: x_resultout:='COMPLETE:'||'NO_NEXT_APPROVER';
1160: return;
1161: elsif(l_default_approver= 'NONE') then --}{
1162: IF (g_asn_debug = 'Y') THEN
1163: debug_log(FND_LOG.LEVEL_STATEMENT,
1164: l_api_name,'Send buyer as default approver ');
1165: End if;
1166:
1167: wf_engine.SetItemAttrText ( itemtype => p_itemType,

Line 1178: debug_log(FND_LOG.LEVEL_STATEMENT,

1174: itemkey => p_itemkey,
1175: aname => 'PO_PREPARER_ID');
1176:
1177: IF (g_asn_debug = 'Y') THEN
1178: debug_log(FND_LOG.LEVEL_STATEMENT,
1179: l_api_name,'l_po_preparer_id '
1180: || l_po_preparer_id);
1181: end if;
1182:

Line 1192: debug_log(FND_LOG.LEVEL_STATEMENT,

1188:
1189: else --}{
1190:
1191: IF (g_asn_debug = 'Y') THEN
1192: debug_log(FND_LOG.LEVEL_STATEMENT,
1193: l_api_name,'call ame api ');
1194: End if;
1195:
1196: ame_api2.getNextApprovers4(applicationIdIn=>l_application_Id,

Line 1211: debug_log(FND_LOG.LEVEL_STATEMENT,

1207: elsif (l_next_approver.count = 0 ) then --}{
1208: x_resultout:='COMPLETE:'||'NO_NEXT_APPROVER';
1209: return;
1210: IF (g_asn_debug = 'Y') THEN
1211: debug_log(FND_LOG.LEVEL_STATEMENT,
1212: l_api_name,'no_next_approver ');
1213: End if;
1214: return;
1215: ELSE --}{

Line 1260: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

1256: end if; --}
1257:
1258:
1259: IF (g_asn_debug = 'Y') THEN
1260: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1261: 'person_id ' || l_next_approver_id);
1262: END IF;
1263:
1264: IF (g_asn_debug = 'Y') THEN

Line 1265: debug_log(FND_LOG.LEVEL_STATEMENT,

1261: 'person_id ' || l_next_approver_id);
1262: END IF;
1263:
1264: IF (g_asn_debug = 'Y') THEN
1265: debug_log(FND_LOG.LEVEL_STATEMENT,
1266: l_api_name,'l_next_approver_id '
1267: || l_next_approver_id);
1268: debug_log(FND_LOG.LEVEL_STATEMENT,
1269: l_api_name,'l_insertion_type '

Line 1268: debug_log(FND_LOG.LEVEL_STATEMENT,

1264: IF (g_asn_debug = 'Y') THEN
1265: debug_log(FND_LOG.LEVEL_STATEMENT,
1266: l_api_name,'l_next_approver_id '
1267: || l_next_approver_id);
1268: debug_log(FND_LOG.LEVEL_STATEMENT,
1269: l_api_name,'l_insertion_type '
1270: || l_insertion_type);
1271: debug_log(FND_LOG.LEVEL_STATEMENT,
1272: l_api_name,'l_authority_type '

Line 1271: debug_log(FND_LOG.LEVEL_STATEMENT,

1267: || l_next_approver_id);
1268: debug_log(FND_LOG.LEVEL_STATEMENT,
1269: l_api_name,'l_insertion_type '
1270: || l_insertion_type);
1271: debug_log(FND_LOG.LEVEL_STATEMENT,
1272: l_api_name,'l_authority_type '
1273: || l_authority_type);
1274: END IF;
1275:

Line 1310: debug_log(FND_LOG.LEVEL_STATEMENT,

1306: l_next_approver_user_name,
1307: l_next_approver_disp_name);
1308:
1309: IF (g_asn_debug = 'Y') THEN
1310: debug_log(FND_LOG.LEVEL_STATEMENT,
1311: l_api_name,'l_next_approver_user_name '
1312: || l_next_approver_user_name);
1313: debug_log(FND_LOG.LEVEL_STATEMENT,
1314: l_api_name,'l_next_approver_disp_name '

Line 1313: debug_log(FND_LOG.LEVEL_STATEMENT,

1309: IF (g_asn_debug = 'Y') THEN
1310: debug_log(FND_LOG.LEVEL_STATEMENT,
1311: l_api_name,'l_next_approver_user_name '
1312: || l_next_approver_user_name);
1313: debug_log(FND_LOG.LEVEL_STATEMENT,
1314: l_api_name,'l_next_approver_disp_name '
1315: || l_next_approver_disp_name);
1316: end if;
1317: wf_engine.SetItemAttrText( itemtype => p_itemType,

Line 1346: debug_log(FND_LOG.LEVEL_UNEXPECTED,

1342:
1343: Exception
1344: when approver_exception then
1345: IF (g_asn_debug = 'Y') THEN
1346: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1347: l_api_name,
1348: 'Exception in ame_util.getNextApprove '
1349: || l_progress);
1350: END IF;

Line 1354: debug_log(FND_LOG.LEVEL_UNEXPECTED,

1350: END IF;
1351: raise;
1352: when others then
1353: IF (g_asn_debug = 'Y') THEN
1354: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1355: l_api_name,'Exception in get_next_approve '
1356: || l_progress);
1357: END IF;
1358: raise;

Line 1418: debug_log(FND_LOG.LEVEL_STATEMENT,

1414:
1415:
1416: l_progress := 'POS_WCAPPROVE_PVT.Insert_Action_History: 01.';
1417: IF (g_asn_debug = 'Y') THEN
1418: debug_log(FND_LOG.LEVEL_STATEMENT,
1419: l_api_name,'Enter in Insert_Action_History '
1420: || l_progress);
1421: END IF;
1422:

Line 1429: debug_log(FND_LOG.LEVEL_STATEMENT,

1425: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
1426: itemkey=>p_itemkey,
1427: aname=>'APPROVER_EMPID');
1428: IF (g_asn_debug = 'Y') THEN
1429: debug_log(FND_LOG.LEVEL_STATEMENT,
1430: l_api_name,'l_approver_id '
1431: || l_approver_id);
1432: END IF;
1433:

Line 1438: debug_log(FND_LOG.LEVEL_STATEMENT,

1434: l_shipment_header_id:= wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
1435: itemkey=>p_itemkey,
1436: aname=>'WORK_CONFIRMATION_ID');
1437: IF (g_asn_debug = 'Y') THEN
1438: debug_log(FND_LOG.LEVEL_STATEMENT,
1439: l_api_name,'l_shipment_header_id '
1440: || l_shipment_header_id);
1441: END IF;
1442:

Line 1456: debug_log(FND_LOG.LEVEL_STATEMENT,

1452: AND object_id = l_shipment_header_id
1453: AND action_code IS NULL;
1454:
1455: IF (g_asn_debug = 'Y') THEN
1456: debug_log(FND_LOG.LEVEL_STATEMENT,
1457: l_api_name,'l_count '
1458: || l_count);
1459: END IF;
1460:

Line 1475: debug_log(FND_LOG.LEVEL_STATEMENT,

1471: WHERE object_type_code = 'WC'
1472: AND object_id = l_shipment_header_id;
1473:
1474: IF (g_asn_debug = 'Y') THEN
1475: debug_log(FND_LOG.LEVEL_STATEMENT,
1476: l_api_name,'l_sequence_num '
1477: || l_sequence_num);
1478: END IF;
1479:

Line 1486: debug_log(FND_LOG.LEVEL_STATEMENT,

1482: FETCH get_action_history INTO Recinfo;
1483:
1484: IF (get_action_history%NOTFOUND) then
1485: IF (g_asn_debug = 'Y') THEN
1486: debug_log(FND_LOG.LEVEL_STATEMENT,
1487: l_api_name,
1488: 'no_data_round ' );
1489: END IF;
1490:

Line 1508: debug_log(FND_LOG.LEVEL_STATEMENT,

1504: If l_count = 1 then
1505:
1506:
1507: IF (g_asn_debug = 'Y') THEN
1508: debug_log(FND_LOG.LEVEL_STATEMENT,
1509: l_api_name,
1510: 'update Action history ' );
1511: END IF;
1512:

Line 1531: debug_log(FND_LOG.LEVEL_STATEMENT,

1527: raise invalid_data;
1528:
1529: Else --}{
1530: IF (g_asn_debug = 'Y') THEN
1531: debug_log(FND_LOG.LEVEL_STATEMENT,
1532: l_api_name,
1533: 'Insert Action history ' );
1534: END IF;
1535:

Line 1566: debug_log(FND_LOG.LEVEL_STATEMENT,

1562:
1563:
1564: --end loop;--}
1565: IF (g_asn_debug = 'Y') THEN
1566: debug_log(FND_LOG.LEVEL_STATEMENT,
1567: l_api_name,
1568: 'Exit Insert Action history ' );
1569: END IF;
1570:

Line 1574: debug_log(FND_LOG.LEVEL_EXCEPTION,

1570:
1571: exception
1572: when invalid_action then
1573: IF (g_asn_debug = 'Y') THEN
1574: debug_log(FND_LOG.LEVEL_EXCEPTION,
1575: l_api_name,'invalid_action in Insert_Action_History '
1576: || l_progress);
1577: END IF;
1578: raise;

Line 1581: debug_log(FND_LOG.LEVEL_EXCEPTION,

1577: END IF;
1578: raise;
1579: when invalid_data then
1580: IF (g_asn_debug = 'Y') THEN
1581: debug_log(FND_LOG.LEVEL_EXCEPTION,
1582: l_api_name,'invalid_data in Insert_Action_History '
1583: || l_progress);
1584: END IF;
1585: raise;

Line 1588: debug_log(FND_LOG.LEVEL_UNEXPECTED,

1584: END IF;
1585: raise;
1586: when others then
1587: IF (g_asn_debug = 'Y') THEN
1588: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1589: l_api_name,'Exception in Insert_Action_History '
1590: || l_progress);
1591: END IF;
1592: raise;

Line 1627: debug_log(FND_LOG.LEVEL_STATEMENT,

1623: BEGIN
1624:
1625: l_progress := 'POS_WCAPPROVE_PVT.Approve_shipment_lines: 01.';
1626: IF (g_asn_debug = 'Y') THEN
1627: debug_log(FND_LOG.LEVEL_STATEMENT,
1628: l_api_name,'Enter in Approve_shipment_lines '
1629: || l_progress);
1630: END IF;
1631:

Line 1648: debug_log(FND_LOG.LEVEL_STATEMENT,

1644: FETCH c_group_id INTO l_notification_id;
1645: CLOSE c_group_id;
1646:
1647: IF (g_asn_debug = 'Y') THEN
1648: debug_log(FND_LOG.LEVEL_STATEMENT,
1649: l_api_name,
1650: ' l_notification_id ' || l_notification_id);
1651: END IF;
1652:

Line 1663: debug_log(FND_LOG.LEVEL_STATEMENT,

1659: AND attribute_name = 'NOTE';
1660: end if;
1661:
1662: IF (g_asn_debug = 'Y') THEN
1663: debug_log(FND_LOG.LEVEL_STATEMENT,
1664: l_api_name,
1665: ' l_note ' || l_note);
1666: END IF;
1667:

Line 1677: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' || l_shipment_header_id);

1673:
1674:
1675:
1676: IF (g_asn_debug = 'Y') THEN
1677: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
1678: END IF;
1679: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1680: exception
1681: when others then

Line 1683: debug_log(FND_LOG.LEVEL_UNEXPECTED,

1679: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1680: exception
1681: when others then
1682: IF (g_asn_debug = 'Y') THEN
1683: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1684: l_api_name,'Exception in Approve_shipment_lines '
1685: || l_progress);
1686: END IF;
1687: raise;

Line 1723: debug_log(FND_LOG.LEVEL_STATEMENT,

1719: BEGIN
1720:
1721: l_progress := 'POS_WCAPPROVE_PVT Reject_shipment_lines: 01.';
1722: IF (g_asn_debug = 'Y') THEN
1723: debug_log(FND_LOG.LEVEL_STATEMENT,
1724: l_api_name,'Enter in Reject_shipment_lines '
1725: || l_progress);
1726: END IF;
1727:

Line 1744: debug_log(FND_LOG.LEVEL_STATEMENT,

1740: FETCH c_group_id INTO l_notification_id;
1741: CLOSE c_group_id;
1742:
1743: IF (g_asn_debug = 'Y') THEN
1744: debug_log(FND_LOG.LEVEL_STATEMENT,
1745: l_api_name,
1746: ' l_notification_id ' || l_notification_id);
1747: END IF;
1748:

Line 1759: debug_log(FND_LOG.LEVEL_STATEMENT,

1755: AND attribute_name = 'NOTE';
1756: end if;
1757:
1758: IF (g_asn_debug = 'Y') THEN
1759: debug_log(FND_LOG.LEVEL_STATEMENT,
1760: l_api_name,
1761: ' l_note ' || l_note);
1762: END IF;
1763:

Line 1775: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' || l_shipment_header_id);

1771:
1772:
1773:
1774: IF (g_asn_debug = 'Y') THEN
1775: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
1776: END IF;
1777: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1778: exception
1779: when others then

Line 1781: debug_log(FND_LOG.LEVEL_UNEXPECTED,

1777: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1778: exception
1779: when others then
1780: IF (g_asn_debug = 'Y') THEN
1781: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1782: l_api_name,'Exception in Reject_shipment_lines '
1783: || l_progress);
1784: END IF;
1785: raise;

Line 1807: debug_log(FND_LOG.LEVEL_STATEMENT,

1803: BEGIN
1804:
1805: l_progress := 'POS_WCAPPROVE_PVT.Approve_OR_Reject: 01.';
1806: IF (g_asn_debug = 'Y') THEN
1807: debug_log(FND_LOG.LEVEL_STATEMENT,
1808: l_api_name,'Enter in Approve_OR_Reject '
1809: || l_progress);
1810: END IF;
1811:

Line 1823: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' || l_shipment_header_id);

1819: itemkey => p_itemkey,
1820: aname => 'WORK_CONFIRMATION_ID');
1821:
1822: IF (g_asn_debug = 'Y') THEN
1823: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
1824: END IF;
1825:
1826:
1827: select count(*)

Line 1834: debug_log(FND_LOG.LEVEL_STATEMENT,

1830: where shipment_header_id = l_shipment_header_id
1831: and approval_status = 'REJECTED';
1832:
1833: IF (g_asn_debug = 'Y') THEN
1834: debug_log(FND_LOG.LEVEL_STATEMENT,
1835: l_api_name,'l_reject_lines ' || l_reject_lines);
1836: END IF;
1837:
1838: If (l_reject_lines > 0) then

Line 1851: debug_log(FND_LOG.LEVEL_UNEXPECTED,

1847:
1848: exception
1849: when others then
1850: IF (g_asn_debug = 'Y') THEN
1851: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1852: l_api_name,'Exception in Approve_OR_Reject '
1853: || l_progress);
1854: END IF;
1855: raise;

Line 1934: debug_log(FND_LOG.LEVEL_STATEMENT,

1930:
1931: begin
1932: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response: 01.';
1933: IF (g_asn_debug = 'Y') THEN
1934: debug_log(FND_LOG.LEVEL_STATEMENT,
1935: l_api_name,
1936: 'Enter in Update_Approval_List_Response '
1937: || l_progress);
1938: END IF;

Line 1967: debug_log(FND_LOG.LEVEL_STATEMENT,

1963: FETCH c_group_id INTO l_group_id;
1964: CLOSE c_group_id;
1965:
1966: IF (g_asn_debug = 'Y') THEN
1967: debug_log(FND_LOG.LEVEL_STATEMENT,
1968: l_api_name,
1969: ' l_group_id ' || l_group_id);
1970: END IF;
1971:

Line 1979: debug_log(FND_LOG.LEVEL_STATEMENT,

1975: FETCH c_response INTO l_role, l_response;
1976: CLOSE c_response;
1977:
1978: IF (g_asn_debug = 'Y') THEN
1979: debug_log(FND_LOG.LEVEL_STATEMENT,
1980: l_api_name,
1981: ' l_role ' || l_role);
1982: debug_log(FND_LOG.LEVEL_STATEMENT,
1983: l_api_name,

Line 1982: debug_log(FND_LOG.LEVEL_STATEMENT,

1978: IF (g_asn_debug = 'Y') THEN
1979: debug_log(FND_LOG.LEVEL_STATEMENT,
1980: l_api_name,
1981: ' l_role ' || l_role);
1982: debug_log(FND_LOG.LEVEL_STATEMENT,
1983: l_api_name,
1984: ' l_response '
1985: || substr(l_response,1,50));
1986: END IF;

Line 1998: debug_log(FND_LOG.LEVEL_STATEMENT,

1994: FROM wf_notifications wfn
1995: WHERE wfn.notification_id = l_group_id;
1996:
1997: IF (g_asn_debug = 'Y') THEN
1998: debug_log(FND_LOG.LEVEL_STATEMENT,
1999: l_api_name,
2000: ' l_responder ' || l_responder);
2001: debug_log(FND_LOG.LEVEL_STATEMENT,
2002: l_api_name,

Line 2001: debug_log(FND_LOG.LEVEL_STATEMENT,

1997: IF (g_asn_debug = 'Y') THEN
1998: debug_log(FND_LOG.LEVEL_STATEMENT,
1999: l_api_name,
2000: ' l_responder ' || l_responder);
2001: debug_log(FND_LOG.LEVEL_STATEMENT,
2002: l_api_name,
2003: ' l_recipient_role '
2004: || l_recipient_role);
2005: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 2005: debug_log(FND_LOG.LEVEL_STATEMENT,

2001: debug_log(FND_LOG.LEVEL_STATEMENT,
2002: l_api_name,
2003: ' l_recipient_role '
2004: || l_recipient_role);
2005: debug_log(FND_LOG.LEVEL_STATEMENT,
2006: l_api_name,
2007: ' l_response_end_date '
2008: || to_char(l_response_end_date,'DD-MON-YYYY'));
2009: end if;

Line 2015: debug_log(FND_LOG.LEVEL_STATEMENT,

2011: OPEN c_responderid(l_responder);
2012: FETCH c_responderid INTO l_responder_id;
2013:
2014: IF (g_asn_debug = 'Y') THEN
2015: debug_log(FND_LOG.LEVEL_STATEMENT,
2016: l_api_name,
2017: ' l_responder_id ' || l_responder_id);
2018: end if;
2019:

Line 2028: debug_log(FND_LOG.LEVEL_STATEMENT,

2024: FETCH c_responderid INTO l_responder_id;
2025: CLOSE c_responderid;
2026:
2027: IF (g_asn_debug = 'Y') THEN
2028: debug_log(FND_LOG.LEVEL_STATEMENT,
2029: l_api_name,
2030: ' l_responder_id1 ' || l_responder_id);
2031: end if;
2032: End if;--}

Line 2054: debug_log(FND_LOG.LEVEL_STATEMENT,

2050: l_responder_user_name,
2051: l_responder_disp_name);
2052:
2053: IF (g_asn_debug = 'Y') THEN
2054: debug_log(FND_LOG.LEVEL_STATEMENT,
2055: l_api_name,
2056: ' l_responder_user_name '
2057: || l_responder_user_name);
2058: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 2058: debug_log(FND_LOG.LEVEL_STATEMENT,

2054: debug_log(FND_LOG.LEVEL_STATEMENT,
2055: l_api_name,
2056: ' l_responder_user_name '
2057: || l_responder_user_name);
2058: debug_log(FND_LOG.LEVEL_STATEMENT,
2059: l_api_name,
2060: ' l_responder_disp_name '
2061: || l_responder_disp_name);
2062: end if;

Line 2087: debug_log(FND_LOG.LEVEL_STATEMENT,

2083: itemkey => p_itemkey,
2084: aname => 'FORWARD_TO_ID');
2085: END IF;
2086: IF (g_asn_debug = 'Y') THEN
2087: debug_log(FND_LOG.LEVEL_STATEMENT,
2088: l_api_name,
2089: ' l_forward_to_id '
2090: || l_forward_to_id);
2091: END IF;

Line 2106: debug_log(FND_LOG.LEVEL_STATEMENT,

2102: itemkey => p_itemkey,
2103: aname => 'WORK_CONFIRMATION_ID');
2104:
2105: IF (g_asn_debug = 'Y') THEN
2106: debug_log(FND_LOG.LEVEL_STATEMENT,
2107: l_api_name,
2108: ' l_shipment_header_id '
2109: || l_shipment_header_id);
2110: END IF;

Line 2117: debug_log(FND_LOG.LEVEL_STATEMENT,

2113: itemkey=>p_itemkey,
2114: aname=>'APPROVER_EMPID');
2115:
2116: IF (g_asn_debug = 'Y') THEN
2117: debug_log(FND_LOG.LEVEL_STATEMENT,
2118: l_api_name,
2119: ' l_approver_id '
2120: || l_approver_id);
2121: END IF;

Line 2128: debug_log(FND_LOG.LEVEL_STATEMENT,

2124: itemkey => p_itemkey,
2125: aname => 'AME_INSERTION_TYPE');
2126:
2127: IF (g_asn_debug = 'Y') THEN
2128: debug_log(FND_LOG.LEVEL_STATEMENT,
2129: l_api_name,
2130: ' l_insertion_type '
2131: || l_insertion_type);
2132: END IF;

Line 2139: debug_log(FND_LOG.LEVEL_STATEMENT,

2135: itemkey => p_itemkey,
2136: aname => 'AME_AUTHORITY_TYPE');
2137:
2138: IF (g_asn_debug = 'Y') THEN
2139: debug_log(FND_LOG.LEVEL_STATEMENT,
2140: l_api_name,
2141: ' l_authority_type '
2142: || l_authority_type);
2143: END IF;

Line 2150: debug_log(FND_LOG.LEVEL_STATEMENT,

2146: itemkey => p_itemkey,
2147: aname => 'AME_TRANSACTION_TYPE');
2148:
2149: IF (g_asn_debug = 'Y') THEN
2150: debug_log(FND_LOG.LEVEL_STATEMENT,
2151: l_api_name,
2152: ' l_transaction_type '
2153: || l_transaction_type);
2154: END IF;

Line 2161: debug_log(FND_LOG.LEVEL_STATEMENT,

2157: (itemtype => p_itemtype,
2158: itemkey => p_itemkey,
2159: aname => 'AME_APPROVER_TYPE');
2160: IF (g_asn_debug = 'Y') THEN
2161: debug_log(FND_LOG.LEVEL_STATEMENT,
2162: l_api_name,
2163: ' l_approver_type '
2164: || l_approver_type);
2165: END IF;

Line 2173: debug_log(FND_LOG.LEVEL_STATEMENT,

2169: itemkey => p_itemkey,
2170: aname => 'DEFAULT_APPROVER');
2171:
2172: IF (g_asn_debug = 'Y') THEN
2173: debug_log(FND_LOG.LEVEL_STATEMENT,
2174: l_api_name,'l_default_approver '
2175: || l_default_approver);
2176: END IF;
2177:

Line 2180: debug_log(FND_LOG.LEVEL_STATEMENT,

2176: END IF;
2177:
2178: If l_default_approver = 'BUYER' then --{
2179: IF (g_asn_debug = 'Y') THEN
2180: debug_log(FND_LOG.LEVEL_STATEMENT,
2181: l_api_name,'Approved by buyer. Dont call ame api ');
2182: END IF;
2183: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
2184: return;

Line 2197: debug_log(FND_LOG.LEVEL_STATEMENT,

2193: l_current_approver.orig_system := 'PER';
2194: end if;
2195:
2196: IF (g_asn_debug = 'Y') THEN
2197: debug_log(FND_LOG.LEVEL_STATEMENT,
2198: l_api_name,
2199: ' orig_system '
2200: || l_current_approver.orig_system);
2201: END IF;

Line 2242: debug_log(FND_LOG.LEVEL_STATEMENT,

2238:
2239:
2240:
2241: IF (g_asn_debug = 'Y') THEN
2242: debug_log(FND_LOG.LEVEL_STATEMENT,
2243: l_api_name,
2244: ' name '
2245: || l_current_approver.name);
2246: END IF;

Line 2265: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2261: RETURN;
2262: Exception
2263: when others then
2264: IF (g_asn_debug = 'Y') THEN
2265: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2266: l_api_name,'Exception in update_approval_list_response '
2267: || l_progress);
2268: END IF;
2269: raise;

Line 2283: debug_log(FND_LOG.LEVEL_STATEMENT,

2279: l_api_name varchar2(50) := p_itemkey || ' update_action_history_approve';
2280: begin
2281: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_History_Approve: 01.';
2282: IF (g_asn_debug = 'Y') THEN
2283: debug_log(FND_LOG.LEVEL_STATEMENT,
2284: l_api_name,
2285: 'Enter in Update_Action_History_Approve '
2286: || l_progress);
2287: END IF;

Line 2301: debug_log(FND_LOG.LEVEL_STATEMENT,

2297:
2298: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
2299:
2300: IF (g_asn_debug = 'Y') THEN
2301: debug_log(FND_LOG.LEVEL_STATEMENT,
2302: l_api_name,
2303: 'Leave in Update_Action_History_Approve '
2304: || l_progress);
2305: END IF;

Line 2313: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2309:
2310: Exception
2311: when others then
2312: IF (g_asn_debug = 'Y') THEN
2313: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2314: l_api_name,'Exception in update_action_history_approve '
2315: || l_progress);
2316: END IF;
2317: raise;

Line 2331: debug_log(FND_LOG.LEVEL_STATEMENT,

2327: l_api_name varchar2(50) := p_itemkey || ' update_action_history_Reject';
2328: begin
2329: l_progress := 'POS_WCAPPROVE_PVT.Update_action_history_reject: 01.';
2330: IF (g_asn_debug = 'Y') THEN
2331: debug_log(FND_LOG.LEVEL_STATEMENT,
2332: l_api_name,
2333: 'Enter in Update_Action_History_Reject '
2334: || l_progress);
2335: END IF;

Line 2349: debug_log(FND_LOG.LEVEL_STATEMENT,

2345:
2346: x_resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
2347:
2348: IF (g_asn_debug = 'Y') THEN
2349: debug_log(FND_LOG.LEVEL_STATEMENT,
2350: l_api_name,
2351: 'Leave in Update_Action_History_Reject '
2352: || l_progress);
2353: END IF;

Line 2361: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2357:
2358: Exception
2359: when others then
2360: IF (g_asn_debug = 'Y') THEN
2361: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2362: l_api_name,'Exception in update_action_history_Reject '
2363: || l_progress);
2364: END IF;
2365: raise;

Line 2412: debug_log(FND_LOG.LEVEL_STATEMENT,

2408:
2409: begin
2410: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 01.';
2411: IF (g_asn_debug = 'Y') THEN
2412: debug_log(FND_LOG.LEVEL_STATEMENT,
2413: l_api_name,
2414: 'Enter in Update_Action_History '
2415: || l_progress);
2416: END IF;

Line 2425: debug_log(FND_LOG.LEVEL_STATEMENT,

2421: itemkey => p_itemkey,
2422: aname => 'WORK_CONFIRMATION_ID');
2423:
2424: IF (g_asn_debug = 'Y') THEN
2425: debug_log(FND_LOG.LEVEL_STATEMENT,
2426: l_api_name,
2427: ' l_shipment_header_id '
2428: || l_shipment_header_id);
2429: END IF;

Line 2442: debug_log(FND_LOG.LEVEL_STATEMENT,

2438: and wias.item_key = p_itemkey
2439: and wias.notification_id = wf.group_id;
2440:
2441: IF (g_asn_debug = 'Y') THEN
2442: debug_log(FND_LOG.LEVEL_STATEMENT,
2443: l_api_name,
2444: ' l_notification_id '
2445: || l_notification_id);
2446: END IF;

Line 2458: debug_log(FND_LOG.LEVEL_STATEMENT,

2454: FROM wf_notifications wfn
2455: WHERE wfn.notification_id = l_notification_id;
2456:
2457: IF (g_asn_debug = 'Y') THEN
2458: debug_log(FND_LOG.LEVEL_STATEMENT,
2459: l_api_name,
2460: ' l_responder ' || l_responder);
2461: debug_log(FND_LOG.LEVEL_STATEMENT,
2462: l_api_name,

Line 2461: debug_log(FND_LOG.LEVEL_STATEMENT,

2457: IF (g_asn_debug = 'Y') THEN
2458: debug_log(FND_LOG.LEVEL_STATEMENT,
2459: l_api_name,
2460: ' l_responder ' || l_responder);
2461: debug_log(FND_LOG.LEVEL_STATEMENT,
2462: l_api_name,
2463: ' l_recipient_role ' || l_recipient_role);
2464: debug_log(FND_LOG.LEVEL_STATEMENT,
2465: l_api_name,

Line 2464: debug_log(FND_LOG.LEVEL_STATEMENT,

2460: ' l_responder ' || l_responder);
2461: debug_log(FND_LOG.LEVEL_STATEMENT,
2462: l_api_name,
2463: ' l_recipient_role ' || l_recipient_role);
2464: debug_log(FND_LOG.LEVEL_STATEMENT,
2465: l_api_name,
2466: ' l_original_recipient '||l_original_recipient);
2467: debug_log(FND_LOG.LEVEL_STATEMENT,
2468: l_api_name,

Line 2467: debug_log(FND_LOG.LEVEL_STATEMENT,

2463: ' l_recipient_role ' || l_recipient_role);
2464: debug_log(FND_LOG.LEVEL_STATEMENT,
2465: l_api_name,
2466: ' l_original_recipient '||l_original_recipient);
2467: debug_log(FND_LOG.LEVEL_STATEMENT,
2468: l_api_name,
2469: ' l_more_info_role ' || l_more_info_role);
2470: END IF;
2471:

Line 2522: debug_log(FND_LOG.LEVEL_STATEMENT,

2518: l_progress := 'POS_WCAPPROVE_PVT.update_approval_history: 04.';
2519:
2520:
2521: IF (g_asn_debug = 'Y') THEN
2522: debug_log(FND_LOG.LEVEL_STATEMENT,
2523: l_api_name,'l_comments ' ||
2524: l_comments);
2525: END IF;
2526:

Line 2537: debug_log(FND_LOG.LEVEL_STATEMENT,

2533: l_comments,
2534: l_shipment_header_id);
2535:
2536: IF (g_asn_debug = 'Y') THEN
2537: debug_log(FND_LOG.LEVEL_STATEMENT,
2538: l_api_name,'After updateactionhistory' ||
2539: l_shipment_header_id);
2540: end if;
2541: --end loop; --}

Line 2544: debug_log(FND_LOG.LEVEL_STATEMENT,

2540: end if;
2541: --end loop; --}
2542:
2543: IF (g_asn_debug = 'Y') THEN
2544: debug_log(FND_LOG.LEVEL_STATEMENT,
2545: l_api_name,'Leave update_action_history' );
2546: end if;
2547:
2548: return;

Line 2553: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2549:
2550: EXCEPTION
2551: when others then
2552: IF (g_asn_debug = 'Y') THEN
2553: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2554: l_api_name,'Exception in Update_Action_History '
2555: || l_progress);
2556: END IF;
2557: raise;

Line 2601: debug_log(FND_LOG.LEVEL_STATEMENT,

2597: BEGIN
2598:
2599: l_progress := 'POS_WCAPPROVE_PVT.UpdateActionHistory: 01.';
2600: IF (g_asn_debug = 'Y') THEN
2601: debug_log(FND_LOG.LEVEL_STATEMENT,
2602: l_api_name,'Enter in UpdateActionHistory '
2603: || l_progress);
2604: debug_log(FND_LOG.LEVEL_STATEMENT,
2605: l_api_name,'p_shipment_header_id '

Line 2604: debug_log(FND_LOG.LEVEL_STATEMENT,

2600: IF (g_asn_debug = 'Y') THEN
2601: debug_log(FND_LOG.LEVEL_STATEMENT,
2602: l_api_name,'Enter in UpdateActionHistory '
2603: || l_progress);
2604: debug_log(FND_LOG.LEVEL_STATEMENT,
2605: l_api_name,'p_shipment_header_id '
2606: || p_shipment_header_id);
2607: END IF;
2608:

Line 2633: debug_log(FND_LOG.LEVEL_STATEMENT,

2629:
2630: /* Add a blank line if the last line is not blank.
2631: */
2632: IF (g_asn_debug = 'Y') THEN
2633: debug_log(FND_LOG.LEVEL_STATEMENT,
2634: l_api_name,
2635: 'Before call to InsertPOActionHistory ');
2636: End if;
2637:

Line 2736: debug_log(FND_LOG.LEVEL_STATEMENT,

2732: /**
2733: ** update pending row of action history with approval action
2734: */
2735: IF (g_asn_debug = 'Y') THEN
2736: debug_log(FND_LOG.LEVEL_STATEMENT,
2737: l_api_name,
2738: 'Before call to UpdatePOActionHistory '
2739: ||l_progress);
2740: End if;

Line 2758: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2754:
2755: EXCEPTION
2756: when no_data_found then
2757: IF (g_asn_debug = 'Y') THEN
2758: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2759: l_api_name,
2760: 'No data found in UpdateActionHistory '
2761: || l_progress);
2762: END IF;

Line 2767: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2763: raise;
2764:
2765: when others then
2766: IF (g_asn_debug = 'Y') THEN
2767: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2768: l_api_name,'Exception in UpdateActionHistory '
2769: || l_progress);
2770: END IF;
2771: raise;

Line 2787: debug_log(FND_LOG.LEVEL_STATEMENT,

2783: BEGIN
2784:
2785: l_progress := 'POS_WCAPPROVE_PVT.get_user_name: 01.';
2786: IF (g_asn_debug = 'Y') THEN
2787: debug_log(FND_LOG.LEVEL_STATEMENT,
2788: l_api_name,'Enter in get_user_name '
2789: || l_progress);
2790: END IF;
2791:

Line 2798: debug_log(FND_LOG.LEVEL_STATEMENT,

2794: x_username,
2795: x_user_display_name);
2796:
2797: IF (g_asn_debug = 'Y') THEN
2798: debug_log(FND_LOG.LEVEL_STATEMENT,
2799: l_api_name,'x_username '
2800: || x_username);
2801: debug_log(FND_LOG.LEVEL_STATEMENT,
2802: l_api_name,'x_user_display_name '

Line 2801: debug_log(FND_LOG.LEVEL_STATEMENT,

2797: IF (g_asn_debug = 'Y') THEN
2798: debug_log(FND_LOG.LEVEL_STATEMENT,
2799: l_api_name,'x_username '
2800: || x_username);
2801: debug_log(FND_LOG.LEVEL_STATEMENT,
2802: l_api_name,'x_user_display_name '
2803: || x_user_display_name);
2804: END IF;
2805: EXCEPTION

Line 2808: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2804: END IF;
2805: EXCEPTION
2806: when others then
2807: IF (g_asn_debug = 'Y') THEN
2808: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2809: l_api_name,'Exception in get_user_name '
2810: || l_progress);
2811: END IF;
2812: raise;

Line 2834: debug_log(FND_LOG.LEVEL_STATEMENT,

2830:
2831: BEGIN
2832: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 01.';
2833: IF (g_asn_debug = 'Y') THEN
2834: debug_log(FND_LOG.LEVEL_STATEMENT,
2835: l_api_name,'Enter in UpdatePOActionHistory '
2836: || l_progress);
2837: debug_log(FND_LOG.LEVEL_STATEMENT,
2838: l_api_name,'object_id '||p_object_id

Line 2837: debug_log(FND_LOG.LEVEL_STATEMENT,

2833: IF (g_asn_debug = 'Y') THEN
2834: debug_log(FND_LOG.LEVEL_STATEMENT,
2835: l_api_name,'Enter in UpdatePOActionHistory '
2836: || l_progress);
2837: debug_log(FND_LOG.LEVEL_STATEMENT,
2838: l_api_name,'object_id '||p_object_id
2839: || 'object_type_code '|| p_object_type_code
2840: || 'p_employee_id '|| nvl(p_employee_id,-9999)
2841: || 'p_action_code '|| nvl(p_action_code,'NO ACTION')

Line 2855: debug_log(FND_LOG.LEVEL_STATEMENT,

2851: * user taking the action, not the employee id to
2852: * which the work confirmation was forwarded to.
2853: */
2854: IF (g_asn_debug = 'Y') THEN
2855: debug_log(FND_LOG.LEVEL_STATEMENT,
2856: l_api_name,'ohject_id and '
2857: || 'object_type_code not null');
2858: END IF;
2859:

Line 2863: debug_log(FND_LOG.LEVEL_STATEMENT,

2859:
2860: /*
2861: If (p_old_employee_id is NULL) then
2862: IF (g_asn_debug = 'Y') THEN
2863: debug_log(FND_LOG.LEVEL_STATEMENT,
2864: l_api_name,'p_employee_id is null '
2865: || l_progress);
2866: END IF;
2867:

Line 2874: debug_log(FND_LOG.LEVEL_STATEMENT,

2870: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2871: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2872: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2873: IF (g_asn_debug = 'Y') THEN
2874: debug_log(FND_LOG.LEVEL_STATEMENT,
2875: l_api_name,'l_employee_id '
2876: || l_employee_id);
2877: END IF;
2878:

Line 2883: debug_log(FND_LOG.LEVEL_STATEMENT,

2879: end if;
2880:
2881: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 02.';
2882: IF (g_asn_debug = 'Y') THEN
2883: debug_log(FND_LOG.LEVEL_STATEMENT,
2884: l_api_name,'Before Update '
2885: || l_progress);
2886: END IF;
2887: */

Line 2891: debug_log(FND_LOG.LEVEL_STATEMENT,

2887: */
2888:
2889:
2890: IF (g_asn_debug = 'Y') THEN
2891: debug_log(FND_LOG.LEVEL_STATEMENT,
2892: l_api_name,'l_note '
2893: || l_note);
2894: end if;
2895:

Line 2926: debug_log(FND_LOG.LEVEL_STATEMENT,

2922:
2923: ELSE --}{
2924: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 02.';
2925: IF (g_asn_debug = 'Y') THEN
2926: debug_log(FND_LOG.LEVEL_STATEMENT,
2927: l_api_name,
2928: 'Either object id or code is null '
2929: || l_progress);
2930: END IF;

Line 2937: debug_log(FND_LOG.LEVEL_EXCEPTION,

2933:
2934: EXCEPTION
2935: when invalid_action then
2936: IF (g_asn_debug = 'Y') THEN
2937: debug_log(FND_LOG.LEVEL_EXCEPTION,
2938: l_api_name,'invalid_action in UpdatePOActionHistory '
2939: || l_progress);
2940: END IF;
2941: raise;

Line 2944: debug_log(FND_LOG.LEVEL_UNEXPECTED,

2940: END IF;
2941: raise;
2942: when others then
2943: IF (g_asn_debug = 'Y') THEN
2944: debug_log(FND_LOG.LEVEL_UNEXPECTED,
2945: l_api_name,'Exception in UpdatePOActionHistory '
2946: || l_progress);
2947: END IF;
2948: raise;

Line 2983: debug_log(FND_LOG.LEVEL_STATEMENT,

2979:
2980:
2981: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 01.';
2982: IF (g_asn_debug = 'Y') THEN
2983: debug_log(FND_LOG.LEVEL_STATEMENT,
2984: l_api_name,'Enter in InsertPOActionHistory '
2985: || l_progress);
2986: END IF;
2987:

Line 2991: debug_log(FND_LOG.LEVEL_STATEMENT,

2987:
2988: l_sequence_num := p_sequence_num;
2989:
2990: IF (g_asn_debug = 'Y') THEN
2991: debug_log(FND_LOG.LEVEL_STATEMENT,
2992: l_api_name,'l_sequence_num '
2993: || l_sequence_num);
2994: END IF;
2995:

Line 3025: debug_log(FND_LOG.LEVEL_STATEMENT,

3021:
3022: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 07.';
3023:
3024: IF (g_asn_debug = 'Y') THEN
3025: debug_log(FND_LOG.LEVEL_STATEMENT,
3026: l_api_name,'l_sequence_num before insert '
3027: || l_sequence_num);
3028: END IF;
3029:

Line 3080: debug_log(FND_LOG.LEVEL_UNEXPECTED,

3076:
3077: EXCEPTION
3078: when others then
3079: IF (g_asn_debug = 'Y') THEN
3080: debug_log(FND_LOG.LEVEL_UNEXPECTED,
3081: l_api_name,'Exception in InsertPOActionHistory '
3082: || l_progress);
3083: END IF;
3084: raise;

Line 3137: debug_log(FND_LOG.LEVEL_STATEMENT,

3133:
3134: begin
3135: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 01.';
3136: IF (g_asn_debug = 'Y') THEN
3137: debug_log(FND_LOG.LEVEL_STATEMENT,
3138: l_api_name,
3139: 'Enter in post_approval_notif '
3140: || l_progress);
3141: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3141: debug_log(FND_LOG.LEVEL_STATEMENT,

3137: debug_log(FND_LOG.LEVEL_STATEMENT,
3138: l_api_name,
3139: 'Enter in post_approval_notif '
3140: || l_progress);
3141: debug_log(FND_LOG.LEVEL_STATEMENT,
3142: l_api_name,
3143: 'p_funcmode '
3144: || p_funcmode);
3145: END IF;

Line 3163: debug_log(FND_LOG.LEVEL_STATEMENT,

3159: (itemtype => p_itemtype,
3160: itemkey => p_itemkey,
3161: aname => 'WORK_CONFIRMATION_ID');
3162: IF (g_asn_debug = 'Y') THEN
3163: debug_log(FND_LOG.LEVEL_STATEMENT,
3164: l_api_name,'l_shipment_header_id ' ||
3165: l_shipment_header_id);
3166: END IF;
3167:

Line 3190: debug_log(FND_LOG.LEVEL_STATEMENT,

3186: FETCH get_action_history INTO Recinfo;
3187:
3188: IF (get_action_history%NOTFOUND) then
3189: IF (g_asn_debug = 'Y') THEN
3190: debug_log(FND_LOG.LEVEL_STATEMENT,
3191: l_api_name,
3192: 'no_data_round ' );
3193: END IF;
3194:

Line 3240: debug_log(FND_LOG.LEVEL_STATEMENT,

3236:
3237: if (p_funcmode = 'RESPOND') then --{
3238: l_notification_id := WF_ENGINE.context_nid;
3239: IF (g_asn_debug = 'Y') THEN
3240: debug_log(FND_LOG.LEVEL_STATEMENT,
3241: l_api_name,
3242: 'l_notification_id '||l_notification_id );
3243: END IF;
3244:

Line 3251: debug_log(FND_LOG.LEVEL_STATEMENT,

3247: (l_notification_id, 'RESULT');
3248:
3249:
3250: IF (g_asn_debug = 'Y') THEN
3251: debug_log(FND_LOG.LEVEL_STATEMENT,
3252: l_api_name,
3253: 'l_result '||l_result );
3254: END IF;
3255:

Line 3285: debug_log(FND_LOG.LEVEL_UNEXPECTED,

3281:
3282: EXCEPTION
3283: when no_data_found then
3284: IF (g_asn_debug = 'Y') THEN
3285: debug_log(FND_LOG.LEVEL_UNEXPECTED,
3286: l_api_name,
3287: 'No data found in post_approval_notif '
3288: || l_progress);
3289: END IF;

Line 3294: debug_log(FND_LOG.LEVEL_UNEXPECTED,

3290: raise;
3291:
3292: when others then
3293: IF (g_asn_debug = 'Y') THEN
3294: debug_log(FND_LOG.LEVEL_UNEXPECTED,
3295: l_api_name,'Exception in post_approval_notif '
3296: || l_progress);
3297: END IF;
3298: raise;

Line 3321: debug_log(FND_LOG.LEVEL_STATEMENT,

3317: l_view_wc_lines_detail_url varchar2(1000);
3318: begin
3319: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 01.';
3320: IF (g_asn_debug = 'Y') THEN
3321: debug_log(FND_LOG.LEVEL_STATEMENT,
3322: l_api_name,
3323: 'Enter in reject_doc '
3324: || l_progress);
3325: END IF;

Line 3351: debug_log(FND_LOG.LEVEL_STATEMENT,

3347: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 03.';
3348: IF (l_result = 'N') THEN
3349:
3350: IF (g_asn_debug = 'Y') THEN
3351: debug_log(FND_LOG.LEVEL_STATEMENT,
3352: l_api_name,
3353: 'Could not Reject the document '
3354: || l_progress);
3355: END IF;

Line 3362: debug_log(FND_LOG.LEVEL_STATEMENT,

3358:
3359: IF (l_result = 'Y') THEN
3360:
3361: IF (g_asn_debug = 'Y') THEN
3362: debug_log(FND_LOG.LEVEL_STATEMENT,
3363: l_api_name,
3364: 'Rejected the document '
3365: || l_progress);
3366: END IF;

Line 3379: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

3375: itemkey => p_itemkey,
3376: aname => 'PO_DOCUMENT_ID');
3377:
3378: IF (g_asn_debug = 'Y') THEN
3379: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
3380: 'l_po_header_id ' || l_po_header_id);
3381: END IF;
3382:
3383: l_work_confirmation_number :=

Line 3389: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

3385: itemkey => p_itemkey,
3386: aname => 'WORK_CONFIRMATION_NUMBER');
3387:
3388: IF (g_asn_debug = 'Y') THEN
3389: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
3390: 'l_work_confirmation_number ' || l_work_confirmation_number);
3391: END IF;
3392:
3393: l_view_wc_lines_detail_url :=

Line 3411: debug_log(FND_LOG.LEVEL_UNEXPECTED,

3407: END IF;
3408: EXCEPTION
3409: when others then
3410: IF (g_asn_debug = 'Y') THEN
3411: debug_log(FND_LOG.LEVEL_UNEXPECTED,
3412: l_api_name,'Exception in reject_doc '
3413: || l_progress);
3414: END IF;
3415: raise;

Line 3438: debug_log(FND_LOG.LEVEL_STATEMENT,

3434: l_work_confirmation_number varchar2(30);
3435: begin
3436: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 01.';
3437: IF (g_asn_debug = 'Y') THEN
3438: debug_log(FND_LOG.LEVEL_STATEMENT,
3439: l_api_name,
3440: 'Enter in Approve_doc '
3441: || l_progress);
3442: END IF;

Line 3466: debug_log(FND_LOG.LEVEL_STATEMENT,

3462: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 03.';
3463: IF (l_result = 'N') THEN
3464:
3465: IF (g_asn_debug = 'Y') THEN
3466: debug_log(FND_LOG.LEVEL_STATEMENT,
3467: l_api_name,
3468: 'Could not Reject the document '
3469: || l_progress);
3470: END IF;

Line 3477: debug_log(FND_LOG.LEVEL_STATEMENT,

3473:
3474: IF (l_result = 'Y') THEN
3475:
3476: IF (g_asn_debug = 'Y') THEN
3477: debug_log(FND_LOG.LEVEL_STATEMENT,
3478: l_api_name,
3479: 'Approved the document '
3480: || l_progress);
3481: END IF;

Line 3493: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

3489: itemkey => p_itemkey,
3490: aname => 'PO_DOCUMENT_ID');
3491:
3492: IF (g_asn_debug = 'Y') THEN
3493: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
3494: 'l_po_header_id ' || l_po_header_id);
3495: END IF;
3496:
3497: l_work_confirmation_number :=

Line 3503: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

3499: itemkey => p_itemkey,
3500: aname => 'WORK_CONFIRMATION_NUMBER');
3501:
3502: IF (g_asn_debug = 'Y') THEN
3503: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
3504: 'l_work_confirmation_number ' || l_work_confirmation_number);
3505: END IF;
3506:
3507: l_view_wc_lines_detail_url :=

Line 3526: debug_log(FND_LOG.LEVEL_UNEXPECTED,

3522: END IF;
3523: EXCEPTION
3524: when others then
3525: IF (g_asn_debug = 'Y') THEN
3526: debug_log(FND_LOG.LEVEL_UNEXPECTED,
3527: l_api_name,'Exception in Approve_doc '
3528: || l_progress);
3529: END IF;
3530: raise;

Line 3558: debug_log(FND_LOG.LEVEL_STATEMENT,

3554: l_note po_action_history.note%type;
3555: begin
3556: l_progress := 'POS_WCAPPROVE_PVT.update_approval_status: 01.';
3557: IF (g_asn_debug = 'Y') THEN
3558: debug_log(FND_LOG.LEVEL_STATEMENT,
3559: l_api_name,
3560: 'Enter in update_approval_status '
3561: || l_progress);
3562: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3562: debug_log(FND_LOG.LEVEL_STATEMENT,

3558: debug_log(FND_LOG.LEVEL_STATEMENT,
3559: l_api_name,
3560: 'Enter in update_approval_status '
3561: || l_progress);
3562: debug_log(FND_LOG.LEVEL_STATEMENT,
3563: l_api_name,
3564: 'p_note '
3565: || p_note);
3566: END IF;

Line 3593: debug_log(FND_LOG.LEVEL_STATEMENT,

3589:
3590: IF (NOT l_locked_doc) THEN
3591:
3592: IF (g_asn_debug = 'Y') THEN
3593: debug_log(FND_LOG.LEVEL_STATEMENT,
3594: l_api_name,'Could not lock row '
3595: || l_progress);
3596: END IF;
3597: ROLLBACK;

Line 3628: debug_log(FND_LOG.LEVEL_UNEXPECTED,

3624: x_resultout := 'Y';
3625: exception
3626: when others then
3627: IF (g_asn_debug = 'Y') THEN
3628: debug_log(FND_LOG.LEVEL_UNEXPECTED,
3629: l_api_name,'Exception in update_approval_status '
3630: || l_progress);
3631: END IF;
3632: raise;

Line 3815: debug_log(FND_LOG.LEVEL_STATEMENT,

3811:
3812: begin
3813: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti: 01.';
3814: IF (g_asn_debug = 'Y') THEN
3815: debug_log(FND_LOG.LEVEL_STATEMENT,
3816: l_api_name,
3817: 'Enter in insert_into_rti '
3818: || l_progress);
3819: END IF;

Line 3841: debug_log(FND_LOG.LEVEL_STATEMENT,

3837: into l_group_id
3838: from dual;
3839:
3840: IF (g_asn_debug = 'Y') THEN
3841: debug_log(FND_LOG.LEVEL_STATEMENT,
3842: l_api_name,'l_header_interface_id ' ||
3843: l_header_interface_id ||
3844: ' l_group_id ' || l_group_id);
3845: END IF;

Line 3857: debug_log(FND_LOG.LEVEL_STATEMENT,

3853: X_emp_name, X_location_id, X_location_code,
3854: X_is_buyer, X_emp_flag );
3855:
3856: IF (g_asn_debug = 'Y') THEN
3857: debug_log(FND_LOG.LEVEL_STATEMENT,
3858: l_api_name,'x_emp_id ' ||
3859: x_emp_id);
3860: END IF;
3861:

Line 3879: debug_log(FND_LOG.LEVEL_STATEMENT,

3875: from rcv_shipment_headers
3876: where shipment_header_id=l_shipment_header_id;
3877:
3878: IF (g_asn_debug = 'Y') THEN
3879: debug_log(FND_LOG.LEVEL_STATEMENT,
3880: l_api_name,'insert into rhi');
3881: END IF;
3882:
3883:

Line 3930: debug_log(FND_LOG.LEVEL_STATEMENT,

3926: /*
3927: */
3928:
3929: IF (g_asn_debug = 'Y') THEN
3930: debug_log(FND_LOG.LEVEL_STATEMENT,
3931: l_api_name,'before cursor open');
3932: END IF;
3933:
3934: open get_wcr_info(l_shipment_header_id);

Line 3940: debug_log(FND_LOG.LEVEL_STATEMENT,

3936:
3937: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti:02.';
3938:
3939: IF (g_asn_debug = 'Y') THEN
3940: debug_log(FND_LOG.LEVEL_STATEMENT,
3941: l_api_name,'before cursor fetch');
3942: END IF;
3943: fetch get_wcr_info into wcr_line_info;
3944: exit when get_wcr_info%notfound;

Line 3947: debug_log(FND_LOG.LEVEL_STATEMENT,

3943: fetch get_wcr_info into wcr_line_info;
3944: exit when get_wcr_info%notfound;
3945:
3946: IF (g_asn_debug = 'Y') THEN
3947: debug_log(FND_LOG.LEVEL_STATEMENT,
3948: l_api_name,'l_shipment_line_id ' ||
3949: wcr_line_info.shipment_line_id);
3950: END IF;
3951:

Line 3960: debug_log(FND_LOG.LEVEL_STATEMENT,

3956: from mtl_units_of_measure muom
3957: WHERE muom.unit_of_measure =
3958: wcr_line_info.unit_of_measure;
3959: IF (g_asn_debug = 'Y') THEN
3960: debug_log(FND_LOG.LEVEL_STATEMENT,
3961: l_api_name,'l_uom_code ' ||
3962: l_uom_code);
3963: END IF;
3964:

Line 3969: debug_log(FND_LOG.LEVEL_STATEMENT,

3965: end if;
3966:
3967:
3968: IF (g_asn_debug = 'Y') THEN
3969: debug_log(FND_LOG.LEVEL_STATEMENT,
3970: l_api_name,'before cursor open');
3971: END IF;
3972:
3973:

Line 3989: debug_log(FND_LOG.LEVEL_STATEMENT,

3985: l_progress := 'POS_WCAPPROVE_PVT.insert_into_rti:03.';
3986:
3987:
3988: IF (g_asn_debug = 'Y') THEN
3989: debug_log(FND_LOG.LEVEL_STATEMENT,
3990: l_api_name,'before cursor fetch');
3991: END IF;
3992: /* Bug 6709928 ,getting the destination_type_code,destination_type_context*/
3993: fetch get_dist_info into

Line 4011: debug_log(FND_LOG.LEVEL_STATEMENT,

4007: or
4008: (l_matching_basis = 'QUANTITY' and l_remaining_quantity <= 0);
4009:
4010: IF (g_asn_debug = 'Y') THEN
4011: debug_log(FND_LOG.LEVEL_STATEMENT,
4012: l_api_name,'l_distribution_id ' ||
4013: wcr_line_info.po_distribution_id);
4014: END IF;
4015:

Line 4017: debug_log(FND_LOG.LEVEL_STATEMENT,

4013: wcr_line_info.po_distribution_id);
4014: END IF;
4015:
4016: IF (g_asn_debug = 'Y') THEN
4017: debug_log(FND_LOG.LEVEL_STATEMENT,
4018: l_api_name,'matching_basis '||l_matching_basis );
4019: END IF;
4020: If (l_matching_basis = 'AMOUNT') then--{
4021: select nvl(sum(amount),0)

Line 4029: debug_log(FND_LOG.LEVEL_STATEMENT,

4025: wcr_line_info.po_distribution_id
4026: and transaction_type = 'RECEIVE';
4027:
4028: IF (g_asn_debug = 'Y') THEN
4029: debug_log(FND_LOG.LEVEL_STATEMENT,
4030: l_api_name,'l_transacted_amount '||
4031: l_transacted_amount );
4032: END IF;
4033: select nvl(sum(amount),0)

Line 4043: debug_log(FND_LOG.LEVEL_STATEMENT,

4039: and transaction_status_code = 'PENDING'
4040: and transaction_type = 'RECEIVE';
4041:
4042: IF (g_asn_debug = 'Y') THEN
4043: debug_log(FND_LOG.LEVEL_STATEMENT,
4044: l_api_name,'l_interface_amount '||
4045: l_interface_amount );
4046: END IF;
4047:

Line 4053: debug_log(FND_LOG.LEVEL_STATEMENT,

4049: (l_transacted_amount +
4050: l_interface_amount);
4051:
4052: IF (g_asn_debug = 'Y') THEN
4053: debug_log(FND_LOG.LEVEL_STATEMENT,
4054: l_api_name,'l_available_amount '||
4055: l_available_amount );
4056: END IF;
4057: If (l_available_amount > 0) then --{

Line 4060: debug_log(FND_LOG.LEVEL_STATEMENT,

4056: END IF;
4057: If (l_available_amount > 0) then --{
4058: If l_first_time then--{
4059: IF (g_asn_debug = 'Y') THEN
4060: debug_log(FND_LOG.LEVEL_STATEMENT,
4061: l_api_name,'first time '||
4062: l_available_amount );
4063: END IF;
4064: l_first_time := FALSE;

Line 4071: debug_log(FND_LOG.LEVEL_STATEMENT,

4067: l_remaining_amount :=
4068: wcr_line_info.amount_shipped - l_available_amount;
4069:
4070: IF (g_asn_debug = 'Y') THEN
4071: debug_log(FND_LOG.LEVEL_STATEMENT,
4072: l_api_name,'l_remaining_amount '||
4073: l_remaining_amount );
4074: END IF;
4075: else --} {

Line 4077: debug_log(FND_LOG.LEVEL_STATEMENT,

4073: l_remaining_amount );
4074: END IF;
4075: else --} {
4076: IF (g_asn_debug = 'Y') THEN
4077: debug_log(FND_LOG.LEVEL_STATEMENT,
4078: l_api_name,'not first time '||
4079: l_available_amount );
4080: END IF;
4081: l_old_remaining_amount :=

Line 4087: debug_log(FND_LOG.LEVEL_STATEMENT,

4083: l_remaining_amount :=
4084: l_remaining_amount - l_available_amount;
4085:
4086: IF (g_asn_debug = 'Y') THEN
4087: debug_log(FND_LOG.LEVEL_STATEMENT,
4088: l_api_name,'l_remaining_amount '||
4089: l_remaining_amount );
4090: END IF;
4091: end if; --}

Line 4102: debug_log(FND_LOG.LEVEL_STATEMENT,

4098: l_old_remaining_amount;
4099: end if;
4100:
4101: IF (g_asn_debug = 'Y') THEN
4102: debug_log(FND_LOG.LEVEL_STATEMENT,
4103: l_api_name,'amount to be inserted '||
4104: wcr_line_info.amount );
4105: END IF;
4106: l_insert_into_rti := TRUE;

Line 4119: debug_log(FND_LOG.LEVEL_STATEMENT,

4115: wcr_line_info.po_distribution_id
4116: and transaction_type = 'RECEIVE';
4117:
4118: IF (g_asn_debug = 'Y') THEN
4119: debug_log(FND_LOG.LEVEL_STATEMENT,
4120: l_api_name,'l_transacted_quantity '||
4121: l_transacted_quantity );
4122: END IF;
4123:

Line 4134: debug_log(FND_LOG.LEVEL_STATEMENT,

4130: and transaction_status_code = 'PENDING'
4131: and transaction_type = 'RECEIVE';
4132:
4133: IF (g_asn_debug = 'Y') THEN
4134: debug_log(FND_LOG.LEVEL_STATEMENT,
4135: l_api_name,'l_interface_quantity '||
4136: l_interface_quantity );
4137: END IF;
4138:

Line 4143: debug_log(FND_LOG.LEVEL_STATEMENT,

4139: l_available_quantity := wcr_line_info.quantity_ordered -
4140: (l_transacted_quantity +
4141: l_interface_quantity);
4142: IF (g_asn_debug = 'Y') THEN
4143: debug_log(FND_LOG.LEVEL_STATEMENT,
4144: l_api_name,'l_available_quantity '||
4145: l_available_quantity );
4146: END IF;
4147:

Line 4151: debug_log(FND_LOG.LEVEL_STATEMENT,

4147:
4148: If (l_available_quantity > 0) then --{
4149: If l_first_time then --{
4150: IF (g_asn_debug = 'Y') THEN
4151: debug_log(FND_LOG.LEVEL_STATEMENT,
4152: l_api_name,'first time '||
4153: l_available_quantity );
4154: END IF;
4155:

Line 4162: debug_log(FND_LOG.LEVEL_STATEMENT,

4158: wcr_line_info.quantity_shipped;
4159: l_remaining_quantity :=
4160: wcr_line_info.quantity_shipped - l_available_quantity;
4161: IF (g_asn_debug = 'Y') THEN
4162: debug_log(FND_LOG.LEVEL_STATEMENT,
4163: l_api_name,'l_old_remaining_quantity '||
4164: l_old_remaining_quantity );
4165: END IF;
4166: IF (g_asn_debug = 'Y') THEN

Line 4167: debug_log(FND_LOG.LEVEL_STATEMENT,

4163: l_api_name,'l_old_remaining_quantity '||
4164: l_old_remaining_quantity );
4165: END IF;
4166: IF (g_asn_debug = 'Y') THEN
4167: debug_log(FND_LOG.LEVEL_STATEMENT,
4168: l_api_name,'l_remaining_quantity '||
4169: l_remaining_quantity );
4170: END IF;
4171: else --} {

Line 4173: debug_log(FND_LOG.LEVEL_STATEMENT,

4169: l_remaining_quantity );
4170: END IF;
4171: else --} {
4172: IF (g_asn_debug = 'Y') THEN
4173: debug_log(FND_LOG.LEVEL_STATEMENT,
4174: l_api_name,'not first time '||
4175: l_available_quantity );
4176: END IF;
4177: l_old_remaining_quantity :=

Line 4182: debug_log(FND_LOG.LEVEL_STATEMENT,

4178: l_remaining_quantity;
4179: l_remaining_quantity :=
4180: l_remaining_quantity - l_available_quantity;
4181: IF (g_asn_debug = 'Y') THEN
4182: debug_log(FND_LOG.LEVEL_STATEMENT,
4183: l_api_name,'l_old_remaining_quantity '||
4184: l_old_remaining_quantity );
4185: END IF;
4186: IF (g_asn_debug = 'Y') THEN

Line 4187: debug_log(FND_LOG.LEVEL_STATEMENT,

4183: l_api_name,'l_old_remaining_quantity '||
4184: l_old_remaining_quantity );
4185: END IF;
4186: IF (g_asn_debug = 'Y') THEN
4187: debug_log(FND_LOG.LEVEL_STATEMENT,
4188: l_api_name,'l_remaining_quantity '||
4189: l_remaining_quantity );
4190: END IF;
4191:

Line 4203: debug_log(FND_LOG.LEVEL_STATEMENT,

4199: l_old_remaining_quantity;
4200: end if;
4201:
4202: IF (g_asn_debug = 'Y') THEN
4203: debug_log(FND_LOG.LEVEL_STATEMENT,
4204: l_api_name,'quantity to be inserted '||
4205: wcr_line_info.quantity );
4206: END IF;
4207: l_insert_into_rti := TRUE;

Line 4219: debug_log(FND_LOG.LEVEL_STATEMENT,

4215: into l_interface_id
4216: from dual;
4217:
4218: IF (g_asn_debug = 'Y') THEN
4219: debug_log(FND_LOG.LEVEL_STATEMENT,
4220: l_api_name,'l_interface_id ' || l_interface_id);
4221: END IF;
4222:
4223: rcv_asn_interface_trx_ins_pkg.insert_row

Line 4470: debug_log(FND_LOG.LEVEL_STATEMENT,

4466: wcr_line_info.material_stored_amount
4467:
4468: );
4469: IF (g_asn_debug = 'Y') THEN
4470: debug_log(FND_LOG.LEVEL_STATEMENT,
4471: l_api_name,'After insert ' );
4472: END IF;
4473: END IF; --}
4474:

Line 4481: debug_log(FND_LOG.LEVEL_STATEMENT,

4477: Close get_dist_info;
4478: end if;
4479:
4480: IF (g_asn_debug = 'Y') THEN
4481: debug_log(FND_LOG.LEVEL_STATEMENT,
4482: l_api_name,'Going to fetch the next shipment line if it exists ' );
4483: END IF;
4484: end loop; --}
4485:

Line 4492: debug_log(FND_LOG.LEVEL_STATEMENT,

4488: end if;
4489:
4490: GenReceiptNum(l_shipment_header_id,l_receipt_num);
4491: IF (g_asn_debug = 'Y') THEN
4492: debug_log(FND_LOG.LEVEL_STATEMENT,
4493: l_api_name,'l_receipt_num '||l_receipt_num);
4494: END IF;
4495:
4496: update rcv_shipment_headers

Line 4503: debug_log(FND_LOG.LEVEL_STATEMENT,

4499: last_updated_by = fnd_global.user_id,
4500: last_update_login = fnd_global.login_id
4501: where shipment_header_id = l_shipment_header_id;
4502: IF (g_asn_debug = 'Y') THEN
4503: debug_log(FND_LOG.LEVEL_STATEMENT,
4504: l_api_name,'Leave insert_into_rti ' );
4505: END IF;
4506:
4507: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 4514: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4510:
4511: exception
4512: when others then
4513: IF (g_asn_debug = 'Y') THEN
4514: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4515: l_api_name,'Exception in insert_into_rti '
4516: || l_progress);
4517: END IF;
4518: raise;

Line 4536: debug_log(FND_LOG.LEVEL_STATEMENT,

4532: l_api_name varchar2(50) := p_itemkey || ' Launch_RTP_Immediate';
4533: begin
4534: l_progress := 'POS_WCAPPROVE_PVT.Launch_RTP_Immediate: 01.';
4535: IF (g_asn_debug = 'Y') THEN
4536: debug_log(FND_LOG.LEVEL_STATEMENT,
4537: l_api_name,
4538: 'Enter in Launch_RTP_Immediate '
4539: || l_progress);
4540: END IF;

Line 4553: debug_log(FND_LOG.LEVEL_STATEMENT,

4549: itemkey => p_itemkey,
4550: aname => 'INTERFACE_GROUP_ID');
4551:
4552: IF (g_asn_debug = 'Y') THEN
4553: debug_log(FND_LOG.LEVEL_STATEMENT,
4554: l_api_name,
4555: 'l_group_id '
4556: || l_group_id);
4557: END IF;

Line 4591: debug_log(FND_LOG.LEVEL_STATEMENT,

4587: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
4588: NULL, NULL, NULL, NULL, NULL, NULL, NULL);
4589:
4590: IF (g_asn_debug = 'Y') THEN
4591: debug_log(FND_LOG.LEVEL_STATEMENT,
4592: l_api_name, 'l_result_id '
4593: || l_result_id);
4594: END IF;
4595: if (l_result_id <= 0 or l_result_id is null) then

Line 4607: debug_log(FND_LOG.LEVEL_STATEMENT,

4603:
4604: end if;
4605:
4606: IF (g_asn_debug = 'Y') THEN
4607: debug_log(FND_LOG.LEVEL_STATEMENT,
4608: l_api_name, 'Leave RTP launch ' );
4609: END IF;
4610: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4611: return;

Line 4616: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4612:
4613: exception
4614: when others then
4615: IF (g_asn_debug = 'Y') THEN
4616: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4617: l_api_name,'Exception in Launch_RTP_Immediate '
4618: || l_progress);
4619: END IF;
4620: raise;

Line 4636: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4632:
4633: l_progress := 'POS_WCAPPROVE_PVT.CloseOldNotif: 01';
4634:
4635: IF (g_asn_debug = 'Y') THEN
4636: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4637: l_api_name,'Enter in CloseOldNotif ' || l_progress);
4638: END IF;
4639: update wf_notifications set status = 'CLOSED'
4640: where notification_id in (

Line 4652: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4648:
4649: exception
4650: when others then
4651: IF (g_asn_debug = 'Y') THEN
4652: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4653: l_api_name,'Exception in CloseOldNotif ' || l_progress);
4654: END IF;
4655: raise;
4656: end CloseOldNotif;

Line 4672: debug_log(FND_LOG.LEVEL_STATEMENT,

4668:
4669: l_progress := 'POS_WCAPPROVE_PVT.UpdateWorkflowInfo: 01';
4670:
4671: IF (g_asn_debug = 'Y') THEN
4672: debug_log(FND_LOG.LEVEL_STATEMENT,
4673: l_api_name,'Enter in UpdateWorkflowInfo ' || l_progress);
4674: debug_log(FND_LOG.LEVEL_STATEMENT,
4675: l_api_name,'p_itemtype ' || p_itemtype);
4676: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 4674: debug_log(FND_LOG.LEVEL_STATEMENT,

4670:
4671: IF (g_asn_debug = 'Y') THEN
4672: debug_log(FND_LOG.LEVEL_STATEMENT,
4673: l_api_name,'Enter in UpdateWorkflowInfo ' || l_progress);
4674: debug_log(FND_LOG.LEVEL_STATEMENT,
4675: l_api_name,'p_itemtype ' || p_itemtype);
4676: debug_log(FND_LOG.LEVEL_STATEMENT,
4677: l_api_name,'p_itemkey ' || p_itemkey);
4678: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 4676: debug_log(FND_LOG.LEVEL_STATEMENT,

4672: debug_log(FND_LOG.LEVEL_STATEMENT,
4673: l_api_name,'Enter in UpdateWorkflowInfo ' || l_progress);
4674: debug_log(FND_LOG.LEVEL_STATEMENT,
4675: l_api_name,'p_itemtype ' || p_itemtype);
4676: debug_log(FND_LOG.LEVEL_STATEMENT,
4677: l_api_name,'p_itemkey ' || p_itemkey);
4678: debug_log(FND_LOG.LEVEL_STATEMENT,
4679: l_api_name,'p_shipment_header_id ' || p_shipment_header_id);
4680: END IF;

Line 4678: debug_log(FND_LOG.LEVEL_STATEMENT,

4674: debug_log(FND_LOG.LEVEL_STATEMENT,
4675: l_api_name,'p_itemtype ' || p_itemtype);
4676: debug_log(FND_LOG.LEVEL_STATEMENT,
4677: l_api_name,'p_itemkey ' || p_itemkey);
4678: debug_log(FND_LOG.LEVEL_STATEMENT,
4679: l_api_name,'p_shipment_header_id ' || p_shipment_header_id);
4680: END IF;
4681:
4682: UPDATE rcv_shipment_headers

Line 4692: debug_log(FND_LOG.LEVEL_STATEMENT,

4688: WHERE shipment_header_id = p_shipment_header_id;
4689:
4690:
4691:
4692: debug_log(FND_LOG.LEVEL_STATEMENT,
4693: l_api_name,'do i see this now? ' || p_shipment_header_id);
4694: exception
4695: when others then
4696: IF (g_asn_debug = 'Y') THEN

Line 4697: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4693: l_api_name,'do i see this now? ' || p_shipment_header_id);
4694: exception
4695: when others then
4696: IF (g_asn_debug = 'Y') THEN
4697: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4698: l_api_name,'Exception in UpdateWorkflowInfo ' || l_progress);
4699: END IF;
4700: raise;
4701: end UpdateWorkflowInfo;

Line 4718: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4714: begin
4715:
4716: l_progress := 'POS_WCAPPROVE_PVT.Upd_ActionHistory_Submit: 01';
4717: IF (g_asn_debug = 'Y') THEN
4718: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4719: l_api_name,'Enter in Upd_ActionHistory_Submit '
4720: || l_progress);
4721: END IF;
4722:

Line 4747: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4743: sequence_num = p_sequence_num;
4744: exception
4745: when others then
4746: IF (g_asn_debug = 'Y') THEN
4747: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4748: l_api_name,'Exception in Upd_ActionHistory_Submit ' || l_progress);
4749: END IF;
4750: raise;
4751: end Upd_ActionHistory_Submit;

Line 4766: debug_log(FND_LOG.LEVEL_STATEMENT,

4762: l_api_name varchar2(50) := ' get_multiorg_context';
4763: begin
4764: l_progress := 'POS_WCAPPROVE_PVT.get_multiorg_context: 01';
4765: IF (g_asn_debug = 'Y') THEN
4766: debug_log(FND_LOG.LEVEL_STATEMENT,
4767: l_api_name,'Enter in get_multiorg_context '
4768: || l_progress);
4769: END IF;
4770:

Line 4777: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4773: CLOSE get_po_orgid;
4774: exception
4775: when others then
4776: IF (g_asn_debug = 'Y') THEN
4777: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4778: l_api_name,'Exception in get_multiorg_context ' || l_progress);
4779: END IF;
4780: raise;
4781: end get_multiorg_context;

Line 4813: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4809: l_api_name varchar2(50) := 'get_PoHeaderId';
4810: begin
4811: l_progress := 'POS_WCAPPROVE_PVT.get_PoHeaderId: 01';
4812: IF (g_asn_debug = 'Y') THEN
4813: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4814: l_api_name,'Enter in get_PoHeaderId ' || l_progress);
4815: END IF;
4816:
4817: select max(po_header_id)

Line 4827: debug_log(FND_LOG.LEVEL_UNEXPECTED,

4823:
4824: exception
4825: when others then
4826: IF (g_asn_debug = 'Y') THEN
4827: debug_log(FND_LOG.LEVEL_UNEXPECTED,
4828: l_api_name,'Exception in get_PoHeaderId ' || l_progress);
4829: END IF;
4830: raise;
4831:

Line 4850: debug_log(FND_LOG.LEVEL_STATEMENT,

4846: from rcv_shipment_headers
4847: where shipment_header_id=p_shipment_header_id;
4848:
4849: IF (g_asn_debug = 'Y') THEN
4850: debug_log(FND_LOG.LEVEL_STATEMENT,
4851: l_api_name,'l_ship_to_org_id '
4852: ||l_ship_to_org_id);
4853: END IF;
4854: