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_FLEX_COGS_PUB dependencies on OE_DEBUG_PUB

Line 85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

81: l_avalue wf_engine.numtabtyp;
82: l_aname2 wf_engine.nametabtyp;
83: l_avaluetext wf_engine.texttabtyp;
84: l_chart_of_accounts_rec Chart_Of_Accounts_Rec_Type;
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
86: --Exception Management begin
87: l_order_source_id NUMBER;
88: l_orig_sys_document_ref VARCHAR2(50);
89: l_orig_sys_line_ref VARCHAR2(50);

Line 97: /oe_Debug_pub.setdebuglevel(5);/

93: l_source_document_id NUMBER;
94: l_source_document_line_id NUMBER;
95: --Exception Management end
96: BEGIN
97: /*oe_Debug_pub.setdebuglevel(5);*/
98: --Commented out the call to debug on for bug 3406720
99: --oe_debug_pub.debug_on;
100: --oe_debug_pub.initialize;
101: g_stmt:='1';

Line 99: --oe_debug_pub.debug_on;

95: --Exception Management end
96: BEGIN
97: /*oe_Debug_pub.setdebuglevel(5);*/
98: --Commented out the call to debug on for bug 3406720
99: --oe_debug_pub.debug_on;
100: --oe_debug_pub.initialize;
101: g_stmt:='1';
102:
103: IF l_debug_level > 0 THEN

Line 100: --oe_debug_pub.initialize;

96: BEGIN
97: /*oe_Debug_pub.setdebuglevel(5);*/
98: --Commented out the call to debug on for bug 3406720
99: --oe_debug_pub.debug_on;
100: --oe_debug_pub.initialize;
101: g_stmt:='1';
102:
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);

Line 104: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);

100: --oe_debug_pub.initialize;
101: g_stmt:='1';
102:
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);
105: END IF;
106:
107: IF NOT FND_API.Compatible_API_Call
108: ( l_api_version_number

Line 277: oe_debug_pub.add('Chart Of accounts Id : '|| to_char(l_chart_of_accounts_id),2);

273: l_chart_of_accounts_rec.chart_of_accounts_id := l_chart_of_accounts_id;
274: G_Chart_Of_Accounts_Tbl(l_ship_from_org_id) := l_chart_of_accounts_rec;
275: END IF;
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add('Chart Of accounts Id : '|| to_char(l_chart_of_accounts_id),2);
278: END IF;
279: /* Initialize the workflow item attributes */
280: l_itemkey := FND_FLEX_WORKFLOW.INITIALIZE
281: ('SQLGL',

Line 287: oe_debug_pub.add('Item Key : '||l_itemkey,2);

283: l_chart_of_accounts_id,
284: 'OECOGS'
285: );
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add('Item Key : '||l_itemkey,2);
288: oe_debug_pub.add('Initilizing Workflow Item Attributes');
289: END If;
290: g_stmt:='35';
291:

Line 288: oe_debug_pub.add('Initilizing Workflow Item Attributes');

284: 'OECOGS'
285: );
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add('Item Key : '||l_itemkey,2);
288: oe_debug_pub.add('Initilizing Workflow Item Attributes');
289: END If;
290: g_stmt:='35';
291:
292: l_aname(1) := 'COMMITMENT_ID';

Line 360: oe_debug_pub.add('Calling FND_ELEX_WORKFLOW.GENERATE from START_PROCESS');

356: itemkey => l_itemkey,
357: aname => l_aname2,
358: avalue => l_avaluetext);
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add('Calling FND_ELEX_WORKFLOW.GENERATE from START_PROCESS');
361: END IF;
362: g_stmt:='75';
363: l_result := FND_FLEX_WORKFLOW.GENERATE( itemtype => 'OECOGS', -- 1775305
364: itemkey => l_itemkey,

Line 387: oe_debug_pub.add(SQLERRM||':'||g_stmt);

383: x_concat_descrs:=lx_concat_descrs;
384:
385: Exception
386: When Others Then
387: oe_debug_pub.add(SQLERRM||':'||g_stmt);
388: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
389: End;
390:
391: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606

Line 399: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);

395:
396: g_stmt:='80';
397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
400: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
401: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
402: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
403: END IF;

Line 400: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);

396: g_stmt:='80';
397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
400: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
401: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
402: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
403: END IF;
404:

Line 401: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);

397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
400: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
401: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
402: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
403: END IF;
404:
405: IF l_result THEN

Line 402: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);

398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
400: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
401: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
402: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
403: END IF;
404:
405: IF l_result THEN
406: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 409: oe_debug_pub.add('Error Message : '|| l_errmsg,2);

405: IF l_result THEN
406: l_return_status := FND_API.G_RET_STS_SUCCESS;
407: ELSE
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
410: END IF;
411: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
412: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
413: OE_MSG_PUB.ADD;

Line 416: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606

412: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
413: OE_MSG_PUB.ADD;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606
417: RETURN l_return_status;
418: EXCEPTION
419:
420: WHEN NO_DATA_FOUND THEN

Line 433: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end

429: , p_msg_index => OE_MSG_PUB.G_LAST
430: );
431: OE_MSG_PUB.Reset;
432: END IF;
433: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end
434:
435: oe_debug_pub.add(SQLERRM||':'||g_stmt);
436: return FND_API.G_RET_STS_ERROR;
437:

Line 435: oe_debug_pub.add(SQLERRM||':'||g_stmt);

431: OE_MSG_PUB.Reset;
432: END IF;
433: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end
434:
435: oe_debug_pub.add(SQLERRM||':'||g_stmt);
436: return FND_API.G_RET_STS_ERROR;
437:
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

Line 447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end

443: , p_msg_index => OE_MSG_PUB.G_LAST
444: );
445: OE_MSG_PUB.Reset;
446: END IF;
447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end
448:
449: oe_debug_pub.add(SQLERRM||':'||g_stmt);
450: return FND_API.G_RET_STS_ERROR;
451:

Line 449: oe_debug_pub.add(SQLERRM||':'||g_stmt);

445: OE_MSG_PUB.Reset;
446: END IF;
447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end
448:
449: oe_debug_pub.add(SQLERRM||':'||g_stmt);
450: return FND_API.G_RET_STS_ERROR;
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:

Line 464: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end

460: , p_msg_index => OE_MSG_PUB.G_LAST
461: );
462: OE_MSG_PUB.Reset;
463: END IF;
464: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
465:
466: oe_debug_pub.add(SQLERRM||':'||g_stmt);
467: return FND_API.G_RET_STS_UNEXP_ERROR ;
468:

Line 466: oe_debug_pub.add(SQLERRM||':'||g_stmt);

462: OE_MSG_PUB.Reset;
463: END IF;
464: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
465:
466: oe_debug_pub.add(SQLERRM||':'||g_stmt);
467: return FND_API.G_RET_STS_UNEXP_ERROR ;
468:
469: WHEN OTHERS THEN
470:

Line 491: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end

487: );
488: OE_MSG_PUB.Reset;
489: END IF;
490:
491: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
492: oe_debug_pub.add(SQLERRM||':'||g_stmt);
493: return FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: END Start_Process; /* START_PROCESS */

Line 492: oe_debug_pub.add(SQLERRM||':'||g_stmt);

488: OE_MSG_PUB.Reset;
489: END IF;
490:
491: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
492: oe_debug_pub.add(SQLERRM||':'||g_stmt);
493: return FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: END Start_Process; /* START_PROCESS */
496:

Line 519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

515: l_error_msg VARCHAR2(240) DEFAULT NULL;
516: l_item_type_code VARCHAR2(30);
517: l_link_to_line_id NUMBER;
518:
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: BEGIN
521: -- start data fix project
522: OE_STANDARD_WF.Set_Msg_Context(actid);
523: -- end data fix project

Line 525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');

521: -- start data fix project
522: OE_STANDARD_WF.Set_Msg_Context(actid);
523: -- end data fix project
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
526: oe_debug_pub.add(' Item Type : '||itemtype,2);
527: oe_debug_pub.add(' Item Key : '||itemkey,2);
528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
529: oe_debug_pub.add(' funcmode : '||funcmode,2);

Line 526: oe_debug_pub.add(' Item Type : '||itemtype,2);

522: OE_STANDARD_WF.Set_Msg_Context(actid);
523: -- end data fix project
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
526: oe_debug_pub.add(' Item Type : '||itemtype,2);
527: oe_debug_pub.add(' Item Key : '||itemkey,2);
528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
529: oe_debug_pub.add(' funcmode : '||funcmode,2);
530: END IF;

Line 527: oe_debug_pub.add(' Item Key : '||itemkey,2);

523: -- end data fix project
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
526: oe_debug_pub.add(' Item Type : '||itemtype,2);
527: oe_debug_pub.add(' Item Key : '||itemkey,2);
528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
529: oe_debug_pub.add(' funcmode : '||funcmode,2);
530: END IF;
531: IF (FUNCMODE = 'RUN') THEN

Line 528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);

524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
526: oe_debug_pub.add(' Item Type : '||itemtype,2);
527: oe_debug_pub.add(' Item Key : '||itemkey,2);
528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
529: oe_debug_pub.add(' funcmode : '||funcmode,2);
530: END IF;
531: IF (FUNCMODE = 'RUN') THEN
532: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

Line 529: oe_debug_pub.add(' funcmode : '||funcmode,2);

525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
526: oe_debug_pub.add(' Item Type : '||itemtype,2);
527: oe_debug_pub.add(' Item Key : '||itemkey,2);
528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
529: oe_debug_pub.add(' funcmode : '||funcmode,2);
530: END IF;
531: IF (FUNCMODE = 'RUN') THEN
532: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
533: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

Line 578: oe_debug_pub.add('Going for Model line for CONFIG',2);

574: IF l_cost_sale_item_derived IS NULL THEN
575:
576: IF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add('Going for Model line for CONFIG',2);
579: END IF;
580: BEGIN
581:
582: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)

Line 628: oe_debug_pub.add('Input Paramerers : ');

624:
625: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));
626: result := 'COMPLETE:SUCCESS';
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Input Paramerers : ');
629: oe_debug_pub.add('Line id :'||to_char(l_line_id));
630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);

Line 629: oe_debug_pub.add('Line id :'||to_char(l_line_id));

625: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));
626: result := 'COMPLETE:SUCCESS';
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Input Paramerers : ');
629: oe_debug_pub.add('Line id :'||to_char(l_line_id));
630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
633:

Line 630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));

626: result := 'COMPLETE:SUCCESS';
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Input Paramerers : ');
629: oe_debug_pub.add('Line id :'||to_char(l_line_id));
630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
633:
634: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);

Line 631: oe_debug_pub.add('Output : ');

627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Input Paramerers : ');
629: oe_debug_pub.add('Line id :'||to_char(l_line_id));
630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
633:
634: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
635: END IF;

Line 632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);

628: oe_debug_pub.add('Input Paramerers : ');
629: oe_debug_pub.add('Line id :'||to_char(l_line_id));
630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
633:
634: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
635: END IF;
636: RETURN;

Line 634: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);

630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
633:
634: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
635: END IF;
636: RETURN;
637: ELSIF (funcmode = 'CANCEL') THEN
638: result := wf_engine.eng_completed;

Line 684: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

680: l_ship_from_org_id NUMBER;
681: l_inventory_item_id NUMBER;
682: l_top_model_line_id NUMBER;
683:
684: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
685: BEGIN
686: -- start data fix project
687: OE_STANDARD_WF.Set_Msg_Context(actid);
688: -- end data fix project

Line 690: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');

686: -- start data fix project
687: OE_STANDARD_WF.Set_Msg_Context(actid);
688: -- end data fix project
689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
691:
692: oe_debug_pub.add(' Item Type : '||itemtype,2);
693: oe_debug_pub.add(' Item Key : '||itemkey,2);
694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);

Line 692: oe_debug_pub.add(' Item Type : '||itemtype,2);

688: -- end data fix project
689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
691:
692: oe_debug_pub.add(' Item Type : '||itemtype,2);
693: oe_debug_pub.add(' Item Key : '||itemkey,2);
694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
695: oe_debug_pub.add(' funcmode : '||funcmode,2);
696: END IF;

Line 693: oe_debug_pub.add(' Item Key : '||itemkey,2);

689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
691:
692: oe_debug_pub.add(' Item Type : '||itemtype,2);
693: oe_debug_pub.add(' Item Key : '||itemkey,2);
694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
695: oe_debug_pub.add(' funcmode : '||funcmode,2);
696: END IF;
697: IF (FUNCMODE = 'RUN') THEN

Line 694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);

690: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
691:
692: oe_debug_pub.add(' Item Type : '||itemtype,2);
693: oe_debug_pub.add(' Item Key : '||itemkey,2);
694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
695: oe_debug_pub.add(' funcmode : '||funcmode,2);
696: END IF;
697: IF (FUNCMODE = 'RUN') THEN
698: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

Line 695: oe_debug_pub.add(' funcmode : '||funcmode,2);

691:
692: oe_debug_pub.add(' Item Type : '||itemtype,2);
693: oe_debug_pub.add(' Item Key : '||itemkey,2);
694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
695: oe_debug_pub.add(' funcmode : '||funcmode,2);
696: END IF;
697: IF (FUNCMODE = 'RUN') THEN
698: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
699:

Line 712: oe_debug_pub.add('Model Line Id : '||to_char(l_model_line_id),2);

708:
709: l_model_line_id := l_top_model_line_id;
710: l_organization_id := l_ship_from_org_id;
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add('Model Line Id : '||to_char(l_model_line_id),2);
713: END IF;
714: l_cost_sale_model_derived := NULL;
715:
716: IF (l_model_line_id IS NOT NULL) THEN

Line 762: oe_debug_pub.add('Input Paramerers : ');

758:
759: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));
760: result := 'COMPLETE:SUCCESS';
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add('Input Paramerers : ');
763: oe_debug_pub.add('Line id :'||to_char(l_line_id));
764: oe_debug_pub.add('Output : ');
765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
766:

Line 763: oe_debug_pub.add('Line id :'||to_char(l_line_id));

759: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));
760: result := 'COMPLETE:SUCCESS';
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add('Input Paramerers : ');
763: oe_debug_pub.add('Line id :'||to_char(l_line_id));
764: oe_debug_pub.add('Output : ');
765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
766:
767: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);

Line 764: oe_debug_pub.add('Output : ');

760: result := 'COMPLETE:SUCCESS';
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add('Input Paramerers : ');
763: oe_debug_pub.add('Line id :'||to_char(l_line_id));
764: oe_debug_pub.add('Output : ');
765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
766:
767: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
768: END IF;

Line 765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);

761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add('Input Paramerers : ');
763: oe_debug_pub.add('Line id :'||to_char(l_line_id));
764: oe_debug_pub.add('Output : ');
765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
766:
767: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
768: END IF;
769: RETURN;

Line 767: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);

763: oe_debug_pub.add('Line id :'||to_char(l_line_id));
764: oe_debug_pub.add('Output : ');
765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
766:
767: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
768: END IF;
769: RETURN;
770: ELSIF (funcmode = 'CANCEL') THEN
771: result := wf_engine.eng_completed;

Line 811: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

807: l_order_type_id NUMBER;
808: fb_error_msg VARCHAR2(240) DEFAULT NULL;
809: l_error_msg VARCHAR2(240) DEFAULT NULL;
810:
811: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
812: BEGIN
813: -- start data fix project
814: OE_STANDARD_WF.Set_Msg_Context(actid);
815: -- end data fix project

Line 817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');

813: -- start data fix project
814: OE_STANDARD_WF.Set_Msg_Context(actid);
815: -- end data fix project
816: IF l_debug_level > 0 THEN
817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
818: oe_debug_pub.add(' Item Type : '||itemtype,2);
819: oe_debug_pub.add(' Item Key : '||itemkey,2);
820: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
821: oe_debug_pub.add(' funcmode : '||funcmode,2);

Line 818: oe_debug_pub.add(' Item Type : '||itemtype,2);

814: OE_STANDARD_WF.Set_Msg_Context(actid);
815: -- end data fix project
816: IF l_debug_level > 0 THEN
817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
818: oe_debug_pub.add(' Item Type : '||itemtype,2);
819: oe_debug_pub.add(' Item Key : '||itemkey,2);
820: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
821: oe_debug_pub.add(' funcmode : '||funcmode,2);
822: END IF;

Line 819: oe_debug_pub.add(' Item Key : '||itemkey,2);

815: -- end data fix project
816: IF l_debug_level > 0 THEN
817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
818: oe_debug_pub.add(' Item Type : '||itemtype,2);
819: oe_debug_pub.add(' Item Key : '||itemkey,2);
820: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
821: oe_debug_pub.add(' funcmode : '||funcmode,2);
822: END IF;
823:

Line 820: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);

816: IF l_debug_level > 0 THEN
817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
818: oe_debug_pub.add(' Item Type : '||itemtype,2);
819: oe_debug_pub.add(' Item Key : '||itemkey,2);
820: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
821: oe_debug_pub.add(' funcmode : '||funcmode,2);
822: END IF;
823:
824: IF (funcmode = 'RUN') THEN

Line 821: oe_debug_pub.add(' funcmode : '||funcmode,2);

817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
818: oe_debug_pub.add(' Item Type : '||itemtype,2);
819: oe_debug_pub.add(' Item Key : '||itemkey,2);
820: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
821: oe_debug_pub.add(' funcmode : '||funcmode,2);
822: END IF;
823:
824: IF (funcmode = 'RUN') THEN
825: l_order_type_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

Line 870: oe_debug_pub.add('Input Paramerers : ',2);

866:
867: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
868: result := 'COMPLETE:SUCCESS';
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('Input Paramerers : ',2);
871: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
872: oe_debug_pub.add('Output : ',2);
873: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
874: END IF;

Line 871: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);

867: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
868: result := 'COMPLETE:SUCCESS';
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('Input Paramerers : ',2);
871: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
872: oe_debug_pub.add('Output : ',2);
873: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
874: END IF;
875: RETURN;

Line 872: oe_debug_pub.add('Output : ',2);

868: result := 'COMPLETE:SUCCESS';
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('Input Paramerers : ',2);
871: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
872: oe_debug_pub.add('Output : ',2);
873: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
874: END IF;
875: RETURN;
876: ELSIF (funcmode = 'CANCEL') THEN

Line 873: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);

869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('Input Paramerers : ',2);
871: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
872: oe_debug_pub.add('Output : ',2);
873: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
874: END IF;
875: RETURN;
876: ELSIF (funcmode = 'CANCEL') THEN
877: result := wf_engine.eng_completed;

Line 917: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

913: l_salesrep_rev_derived VARCHAR2(240) DEFAULT NULL;
914: l_salesrep_id NUMBER;
915: fb_error_msg VARCHAR2(240) DEFAULT NULL;
916: l_error_msg VARCHAR2(240) DEFAULT NULL;
917: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
918: BEGIN
919: -- start data fix project
920: OE_STANDARD_WF.Set_Msg_Context(actid);
921: -- end data fix project

Line 923: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED',1);

919: -- start data fix project
920: OE_STANDARD_WF.Set_Msg_Context(actid);
921: -- end data fix project
922: IF l_debug_level > 0 THEN
923: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED',1);
924: END IF;
925: IF (FUNCMODE = 'RUN') THEN
926: l_salesrep_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'SALESREP_ID');
927: IF l_debug_level > 0 THEN

Line 928: oe_debug_pub.add('Sales rep id : '||to_char(l_salesrep_id),2);

924: END IF;
925: IF (FUNCMODE = 'RUN') THEN
926: l_salesrep_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'SALESREP_ID');
927: IF l_debug_level > 0 THEN
928: oe_debug_pub.add('Sales rep id : '||to_char(l_salesrep_id),2);
929: END If;
930: l_salesrep_rev_derived := NULL;
931:
932: IF (l_salesrep_id IS NOT NULL) THEN

Line 979: oe_debug_pub.add('Input Paramerers : ',2);

975:
976: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));
977: result := 'COMPLETE:SUCCESS';
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Input Paramerers : ',2);
980: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
981: oe_debug_pub.add('Output : ',2);
982: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
983: END IF;

Line 980: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);

976: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));
977: result := 'COMPLETE:SUCCESS';
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Input Paramerers : ',2);
980: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
981: oe_debug_pub.add('Output : ',2);
982: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
983: END IF;
984: RETURN;

Line 981: oe_debug_pub.add('Output : ',2);

977: result := 'COMPLETE:SUCCESS';
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Input Paramerers : ',2);
980: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
981: oe_debug_pub.add('Output : ',2);
982: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
983: END IF;
984: RETURN;
985: ELSIF (funcmode = 'CANCEL') THEN

Line 982: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);

978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Input Paramerers : ',2);
980: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
981: oe_debug_pub.add('Output : ',2);
982: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
983: END IF;
984: RETURN;
985: ELSIF (funcmode = 'CANCEL') THEN
986: result := wf_engine.eng_completed;

Line 1025: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1021: l_header_id NUMBER;
1022: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1023: l_error_msg VARCHAR2(240) DEFAULT NULL;
1024: l_order_type_id NUMBER; --a.k.a transaction_type_id, line_type_id
1025: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1026: BEGIN
1027: -- start data fix project
1028: OE_STANDARD_WF.Set_Msg_Context(actid);
1029: -- end data fix project

Line 1031: oe_debug_pub.add('Entering Get_type_from_line',2);

1027: -- start data fix project
1028: OE_STANDARD_WF.Set_Msg_Context(actid);
1029: -- end data fix project
1030: IF l_debug_level > 0 THEN
1031: oe_debug_pub.add('Entering Get_type_from_line',2);
1032: END IF;
1033: --DBMS_OUTPUT.PUT_LINE('Entering get_line_from_line');
1034:
1035: IF (FUNCMODE = 'RUN') THEN

Line 1038: oe_debug_pub.add('Input Paramerers : ',2);

1034:
1035: IF (FUNCMODE = 'RUN') THEN
1036: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add('Input Paramerers : ',2);
1039: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1040: END IF;
1041:
1042: IF (l_order_line_id IS NOT NULL) THEN

Line 1039: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);

1035: IF (FUNCMODE = 'RUN') THEN
1036: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add('Input Paramerers : ',2);
1039: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1040: END IF;
1041:
1042: IF (l_order_line_id IS NOT NULL) THEN
1043: BEGIN

Line 1069: oe_debug_pub.add('Output : ',2);

1065: result := 'COMPLETE:FAILURE';
1066: RETURN;
1067: END IF;
1068: IF l_debug_level > 0 THEN
1069: oe_debug_pub.add('Output : ',2);
1070: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);
1071: END IF;
1072: RETURN;
1073: ELSIF (funcmode = 'CANCEL') THEN

Line 1070: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);

1066: RETURN;
1067: END IF;
1068: IF l_debug_level > 0 THEN
1069: oe_debug_pub.add('Output : ',2);
1070: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);
1071: END IF;
1072: RETURN;
1073: ELSIF (funcmode = 'CANCEL') THEN
1074: result := wf_engine.eng_completed;

Line 1115: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1111: l_order_line_id NUMBER;
1112: l_header_id NUMBER;
1113: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1114: l_error_msg VARCHAR2(240) DEFAULT NULL;
1115: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1116: BEGIN
1117: -- start data fix project
1118: OE_STANDARD_WF.Set_Msg_Context(actid);
1119: -- end data fix project

Line 1121: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_ID',2);

1117: -- start data fix project
1118: OE_STANDARD_WF.Set_Msg_Context(actid);
1119: -- end data fix project
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_ID',2);
1122: END IF;
1123: IF (FUNCMODE = 'RUN') THEN
1124: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1125: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

Line 1128: oe_debug_pub.add('Input Paramerers : ',2);

1124: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1125: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1126:
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add('Input Paramerers : ',2);
1129: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1130: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);
1131: END IF;
1132: l_salesrep_id := NULL;

Line 1129: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);

1125: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1126:
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add('Input Paramerers : ',2);
1129: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1130: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);
1131: END IF;
1132: l_salesrep_id := NULL;
1133:

Line 1130: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);

1126:
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add('Input Paramerers : ',2);
1129: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1130: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);
1131: END IF;
1132: l_salesrep_id := NULL;
1133:
1134: IF (l_order_line_id IS NOT NULL) THEN

Line 1161: oe_debug_pub.add('Sales rep not found at line level',2);

1157:
1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN
1160: IF l_debug_level > 0 THEN
1161: oe_debug_pub.add('Sales rep not found at line level',2);
1162: END IF;
1163: BEGIN
1164: SELECT SALESREP_ID
1165: INTO l_salesrep_id

Line 1209: oe_debug_pub.add('Output : ',2);

1205: result := 'COMPLETE:FAILURE';
1206: RETURN;
1207: END IF;
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add('Output : ',2);
1210: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);
1211: END IF;
1212: RETURN;
1213: ELSIF (funcmode = 'CANCEL') THEN

Line 1210: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);

1206: RETURN;
1207: END IF;
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add('Output : ',2);
1210: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);
1211: END IF;
1212: RETURN;
1213: ELSIF (funcmode = 'CANCEL') THEN
1214: result := wf_engine.eng_completed;

Line 1255: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1251: l_ship_from_org_id NUMBER;
1252: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1253: l_error_msg VARCHAR2(240) DEFAULT NULL;
1254:
1255: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1256: BEGIN
1257: -- start data fix project
1258: OE_STANDARD_WF.Set_Msg_Context(actid);
1259: -- end data fix project

Line 1261: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Get_Invitm_Org_Derived',1);

1257: -- start data fix project
1258: OE_STANDARD_WF.Set_Msg_Context(actid);
1259: -- end data fix project
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Get_Invitm_Org_Derived',1);
1262: END IF;
1263: IF (FUNCMODE = 'RUN') THEN
1264: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1265: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

Line 1267: oe_debug_pub.add('Input Paramerers : ',2);

1263: IF (FUNCMODE = 'RUN') THEN
1264: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1265: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add('Input Paramerers : ',2);
1268: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1269: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);
1270: END IF;
1271: L_ACCOUNT_DERIVED := NULL;

Line 1268: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);

1264: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1265: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add('Input Paramerers : ',2);
1268: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1269: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);
1270: END IF;
1271: L_ACCOUNT_DERIVED := NULL;
1272: IF (L_INV_ITEM_ID IS NOT NULL) THEN

Line 1269: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);

1265: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add('Input Paramerers : ',2);
1268: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1269: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);
1270: END IF;
1271: L_ACCOUNT_DERIVED := NULL;
1272: IF (L_INV_ITEM_ID IS NOT NULL) THEN
1273: BEGIN

Line 1318: oe_debug_pub.add('Output : ',2);

1314: result := 'COMPLETE:FAILURE';
1315: RETURN;
1316: END IF;
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add('Output : ',2);
1319: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);
1320: END IF;
1321: RETURN;
1322: ELSIF (funcmode = 'CANCEL') THEN

Line 1319: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);

1315: RETURN;
1316: END IF;
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add('Output : ',2);
1319: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);
1320: END IF;
1321: RETURN;
1322: ELSIF (funcmode = 'CANCEL') THEN
1323: result := wf_engine.eng_completed;

Line 1357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1353: IS
1354:
1355: l_option_flag VARCHAR2(1);
1356: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1358: BEGIN
1359: -- start data fix project
1360: OE_STANDARD_WF.Set_Msg_Context(actid);
1361: -- end data fix project

Line 1363: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Check_Option',1);

1359: -- start data fix project
1360: OE_STANDARD_WF.Set_Msg_Context(actid);
1361: -- end data fix project
1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Check_Option',1);
1364: END IF;
1365: IF (FUNCMODE = 'RUN') THEN
1366: l_option_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1367: IF l_debug_level > 0 THEN

Line 1368: oe_debug_pub.add('Option Flag :'|| l_option_flag,2);

1364: END IF;
1365: IF (FUNCMODE = 'RUN') THEN
1366: l_option_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1367: IF l_debug_level > 0 THEN
1368: oe_debug_pub.add('Option Flag :'|| l_option_flag,2);
1369: END IF;
1370: IF l_option_flag = 'Y' THEN
1371:
1372: result := 'COMPLETE:TRUE';

Line 1419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1415: l_trx_type VARCHAR2(240) DEFAULT NULL;
1416: l_commitment_id NUMBER;
1417: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1418: l_error_msg VARCHAR2(240) DEFAULT NULL;
1419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1420: BEGIN
1421: -- start data fix project
1422: OE_STANDARD_WF.Set_Msg_Context(actid);
1423: -- end data fix project

Line 1425: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_TRX_TYPE',2);

1421: -- start data fix project
1422: OE_STANDARD_WF.Set_Msg_Context(actid);
1423: -- end data fix project
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_TRX_TYPE',2);
1426: END IF;
1427: IF (FUNCMODE = 'RUN') THEN
1428: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1429: IF l_debug_level > 0 THEN

Line 1430: oe_debug_pub.add('Input Paramerers : ',2);

1426: END IF;
1427: IF (FUNCMODE = 'RUN') THEN
1428: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add('Input Paramerers : ',2);
1431: oe_debug_pub.add('Commitment ID :'|| to_char(l_commitment_id),2);
1432: END IF;
1433: l_trx_type := NULL;
1434:

Line 1431: oe_debug_pub.add('Commitment ID :'|| to_char(l_commitment_id),2);

1427: IF (FUNCMODE = 'RUN') THEN
1428: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add('Input Paramerers : ',2);
1431: oe_debug_pub.add('Commitment ID :'|| to_char(l_commitment_id),2);
1432: END IF;
1433: l_trx_type := NULL;
1434:
1435: IF (l_commitment_id IS NOT NULL) THEN

Line 1461: oe_debug_pub.add('Output : ',2);

1457: result := 'COMPLETE:FAILURE';
1458: RETURN;
1459: END IF;
1460: IF l_debug_level > 0 THEN
1461: oe_debug_pub.add('Output : ',2);
1462: oe_debug_pub.add('Transaction Type'||l_trx_type,2);
1463: END IF;
1464: RETURN;
1465: ELSIF (funcmode = 'CANCEL') THEN

Line 1462: oe_debug_pub.add('Transaction Type'||l_trx_type,2);

1458: RETURN;
1459: END IF;
1460: IF l_debug_level > 0 THEN
1461: oe_debug_pub.add('Output : ',2);
1462: oe_debug_pub.add('Transaction Type'||l_trx_type,2);
1463: END IF;
1464: RETURN;
1465: ELSIF (funcmode = 'CANCEL') THEN
1466: result := wf_engine.eng_completed;

Line 1512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1508: fb_flex_seg IN OUT NOCOPY VARCHAR2,
1509: fb_error_msg IN OUT NOCOPY VARCHAR2)
1510: RETURN BOOLEAN
1511: IS
1512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1513: BEGIN
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1516: END IF;

Line 1515: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);

1511: IS
1512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1513: BEGIN
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1516: END IF;
1517: fb_flex_seg := NULL;
1518:
1519: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');

Line 1552: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1548: l_option_flag VARCHAR2(2);
1549: l_flex_num NUMBER;
1550: l_fb_flex_segs VARCHAR2(240) DEFAULT NULL;
1551: l_fb_error_msg VARCHAR2(240) DEFAULT NULL;
1552: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1553: BEGIN
1554: -- start data fix project
1555: OE_STANDARD_WF.Set_Msg_Context(actid);
1556: -- end data fix project

Line 1558: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',1);

1554: -- start data fix project
1555: OE_STANDARD_WF.Set_Msg_Context(actid);
1556: -- end data fix project
1557: IF l_debug_level > 0 THEN
1558: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',1);
1559: END IF;
1560: IF (FUNCMODE = 'RUN') THEN
1561:
1562: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

Line 1573: oe_debug_pub.add('Input Paramerers : ',2);

1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add('Input Paramerers : ',2);
1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);

Line 1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);

1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add('Input Paramerers : ',2);
1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);

Line 1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);

1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add('Input Paramerers : ',2);
1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);

Line 1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);

1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add('Input Paramerers : ',2);
1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);

Line 1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);

1573: oe_debug_pub.add('Input Paramerers : ',2);
1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);

Line 1578: oe_debug_pub.add('Order Category :'||l_order_category,2);

1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1582: END IF;

Line 1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);

1575: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1582: END IF;
1583: IF (OE_FLEX_COGS_PUB.Build(

Line 1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);

1576: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1582: END IF;
1583: IF (OE_FLEX_COGS_PUB.Build(
1584: l_flex_num,

Line 1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);

1577: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1578: oe_debug_pub.add('Order Category :'||l_order_category,2);
1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1582: END IF;
1583: IF (OE_FLEX_COGS_PUB.Build(
1584: l_flex_num,
1585: l_commitment_id,