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 99: /oe_Debug_pub.setdebuglevel(5);/

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

Line 101: --oe_debug_pub.debug_on;

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

Line 102: --oe_debug_pub.initialize;

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

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

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

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

287: l_chart_of_accounts_rec.chart_of_accounts_id := l_chart_of_accounts_id;
288: G_Chart_Of_Accounts_Tbl(l_ship_from_org_id) := l_chart_of_accounts_rec;
289: END IF;
290: IF l_debug_level > 0 THEN
291: oe_debug_pub.add('Chart Of accounts Id : '|| to_char(l_chart_of_accounts_id),2);
292: END IF;
293: /* Initialize the workflow item attributes */
294: l_itemkey := FND_FLEX_WORKFLOW.INITIALIZE
295: ('SQLGL',

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

297: l_chart_of_accounts_id,
298: 'OECOGS'
299: );
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add('Item Key : '||l_itemkey,2);
302: oe_debug_pub.add('Initilizing Workflow Item Attributes');
303: END If;
304: g_stmt:='35';
305:

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

298: 'OECOGS'
299: );
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add('Item Key : '||l_itemkey,2);
302: oe_debug_pub.add('Initilizing Workflow Item Attributes');
303: END If;
304: g_stmt:='35';
305:
306: l_aname(1) := 'COMMITMENT_ID';

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

370: itemkey => l_itemkey,
371: aname => l_aname2,
372: avalue => l_avaluetext);
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add('Calling FND_ELEX_WORKFLOW.GENERATE from START_PROCESS');
375: END IF;
376: g_stmt:='75';
377: l_result := FND_FLEX_WORKFLOW.GENERATE( itemtype => 'OECOGS', -- 1775305
378: itemkey => l_itemkey,

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

397: x_concat_descrs:=lx_concat_descrs;
398:
399: Exception
400: When Others Then
401: oe_debug_pub.add(SQLERRM||':'||g_stmt);
402: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
403: End;
404:
405: IF INSTR(l_errmsg, CHR(0)) > 0 THEN -- 2352606

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

409:
410: g_stmt:='80';
411:
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
414: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
415: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
416: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
417: END IF;

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

410: g_stmt:='80';
411:
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
414: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
415: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
416: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
417: END IF;
418:

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

411:
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
414: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
415: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
416: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
417: END IF;
418:
419: IF l_result THEN

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

412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add('Return CCID : '|| x_return_ccid,2);
414: oe_debug_pub.add('Concat Segments : '|| x_concat_segs,2);
415: oe_debug_pub.add('Concat Id : '|| x_concat_ids,2);
416: oe_debug_pub.add('Concat Descriptions : '|| x_concat_descrs,2);
417: END IF;
418:
419: IF l_result THEN
420: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

419: IF l_result THEN
420: l_return_status := FND_API.G_RET_STS_SUCCESS;
421: ELSE
422: IF l_debug_level > 0 THEN
423: oe_debug_pub.add('Error Message : '|| l_errmsg,2);
424: END IF;
425: FND_MESSAGE.SET_NAME('ONT','OE_COGS_ACC_GEN_FAILED');
426: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
427: OE_MSG_PUB.ADD;

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

426: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
427: OE_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606
431: RETURN l_return_status;
432: EXCEPTION
433:
434: WHEN NO_DATA_FOUND THEN

Line 447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 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 : NDF', 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 : NDF', 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_ERROR THEN
453: x_msg_count := OE_MSG_PUB.Count_Msg; -- 2352606 start

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

457: , p_msg_index => OE_MSG_PUB.G_LAST
458: );
459: OE_MSG_PUB.Reset;
460: END IF;
461: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end
462:
463: oe_debug_pub.add(SQLERRM||':'||g_stmt);
464: return FND_API.G_RET_STS_ERROR;
465:

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

459: OE_MSG_PUB.Reset;
460: END IF;
461: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end
462:
463: oe_debug_pub.add(SQLERRM||':'||g_stmt);
464: return FND_API.G_RET_STS_ERROR;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:

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

474: , p_msg_index => OE_MSG_PUB.G_LAST
475: );
476: OE_MSG_PUB.Reset;
477: END IF;
478: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
479:
480: oe_debug_pub.add(SQLERRM||':'||g_stmt);
481: return FND_API.G_RET_STS_UNEXP_ERROR ;
482:

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

476: OE_MSG_PUB.Reset;
477: END IF;
478: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
479:
480: oe_debug_pub.add(SQLERRM||':'||g_stmt);
481: return FND_API.G_RET_STS_UNEXP_ERROR ;
482:
483: WHEN OTHERS THEN
484:

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

501: );
502: OE_MSG_PUB.Reset;
503: END IF;
504:
505: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
506: oe_debug_pub.add(SQLERRM||':'||g_stmt);
507: return FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: END Start_Process; /* START_PROCESS */

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

502: OE_MSG_PUB.Reset;
503: END IF;
504:
505: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
506: oe_debug_pub.add(SQLERRM||':'||g_stmt);
507: return FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: END Start_Process; /* START_PROCESS */
510:

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

529: l_error_msg VARCHAR2(240) DEFAULT NULL;
530: l_item_type_code VARCHAR2(30);
531: l_link_to_line_id NUMBER;
532:
533: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
534: BEGIN
535: -- start data fix project
536: OE_STANDARD_WF.Set_Msg_Context(actid);
537: -- end data fix project

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

535: -- start data fix project
536: OE_STANDARD_WF.Set_Msg_Context(actid);
537: -- end data fix project
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
540: oe_debug_pub.add(' Item Type : '||itemtype,2);
541: oe_debug_pub.add(' Item Key : '||itemkey,2);
542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);

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

536: OE_STANDARD_WF.Set_Msg_Context(actid);
537: -- end data fix project
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
540: oe_debug_pub.add(' Item Type : '||itemtype,2);
541: oe_debug_pub.add(' Item Key : '||itemkey,2);
542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);
544: END IF;

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

537: -- end data fix project
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
540: oe_debug_pub.add(' Item Type : '||itemtype,2);
541: oe_debug_pub.add(' Item Key : '||itemkey,2);
542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);
544: END IF;
545: IF (FUNCMODE = 'RUN') THEN

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

538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
540: oe_debug_pub.add(' Item Type : '||itemtype,2);
541: oe_debug_pub.add(' Item Key : '||itemkey,2);
542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);
544: END IF;
545: IF (FUNCMODE = 'RUN') THEN
546: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

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

539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
540: oe_debug_pub.add(' Item Type : '||itemtype,2);
541: oe_debug_pub.add(' Item Key : '||itemkey,2);
542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);
544: END IF;
545: IF (FUNCMODE = 'RUN') THEN
546: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
547: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

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

588: IF l_cost_sale_item_derived IS NULL THEN
589:
590: IF l_item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add('Going for Model line for CONFIG',2);
593: END IF;
594: BEGIN
595:
596: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)

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

638:
639: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));
640: result := 'COMPLETE:SUCCESS';
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Input Paramerers : ');
643: oe_debug_pub.add('Line id :'||to_char(l_line_id));
644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);

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

639: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));
640: result := 'COMPLETE:SUCCESS';
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Input Paramerers : ');
643: oe_debug_pub.add('Line id :'||to_char(l_line_id));
644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
647:

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

640: result := 'COMPLETE:SUCCESS';
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Input Paramerers : ');
643: oe_debug_pub.add('Line id :'||to_char(l_line_id));
644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
647:
648: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);

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

641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Input Paramerers : ');
643: oe_debug_pub.add('Line id :'||to_char(l_line_id));
644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
647:
648: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
649: END IF;

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

642: oe_debug_pub.add('Input Paramerers : ');
643: oe_debug_pub.add('Line id :'||to_char(l_line_id));
644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
647:
648: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
649: END IF;
650: RETURN;

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

644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
647:
648: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
649: END IF;
650: RETURN;
651: ELSIF (funcmode = 'CANCEL') THEN
652: result := wf_engine.eng_completed;

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

694: l_ship_from_org_id NUMBER;
695: l_inventory_item_id NUMBER;
696: l_top_model_line_id NUMBER;
697:
698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
699: BEGIN
700: -- start data fix project
701: OE_STANDARD_WF.Set_Msg_Context(actid);
702: -- end data fix project

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

700: -- start data fix project
701: OE_STANDARD_WF.Set_Msg_Context(actid);
702: -- end data fix project
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
705:
706: oe_debug_pub.add(' Item Type : '||itemtype,2);
707: oe_debug_pub.add(' Item Key : '||itemkey,2);
708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);

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

702: -- end data fix project
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
705:
706: oe_debug_pub.add(' Item Type : '||itemtype,2);
707: oe_debug_pub.add(' Item Key : '||itemkey,2);
708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
709: oe_debug_pub.add(' funcmode : '||funcmode,2);
710: END IF;

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

703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
705:
706: oe_debug_pub.add(' Item Type : '||itemtype,2);
707: oe_debug_pub.add(' Item Key : '||itemkey,2);
708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
709: oe_debug_pub.add(' funcmode : '||funcmode,2);
710: END IF;
711: IF (FUNCMODE = 'RUN') THEN

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

704: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
705:
706: oe_debug_pub.add(' Item Type : '||itemtype,2);
707: oe_debug_pub.add(' Item Key : '||itemkey,2);
708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
709: oe_debug_pub.add(' funcmode : '||funcmode,2);
710: END IF;
711: IF (FUNCMODE = 'RUN') THEN
712: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

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

705:
706: oe_debug_pub.add(' Item Type : '||itemtype,2);
707: oe_debug_pub.add(' Item Key : '||itemkey,2);
708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
709: oe_debug_pub.add(' funcmode : '||funcmode,2);
710: END IF;
711: IF (FUNCMODE = 'RUN') THEN
712: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
713:

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

722:
723: l_model_line_id := l_top_model_line_id;
724: l_organization_id := l_ship_from_org_id;
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add('Model Line Id : '||to_char(l_model_line_id),2);
727: END IF;
728: l_cost_sale_model_derived := NULL;
729:
730: IF (l_model_line_id IS NOT NULL) THEN

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

772:
773: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));
774: result := 'COMPLETE:SUCCESS';
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add('Input Paramerers : ');
777: oe_debug_pub.add('Line id :'||to_char(l_line_id));
778: oe_debug_pub.add('Output : ');
779: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
780:

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

773: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));
774: result := 'COMPLETE:SUCCESS';
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add('Input Paramerers : ');
777: oe_debug_pub.add('Line id :'||to_char(l_line_id));
778: oe_debug_pub.add('Output : ');
779: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
780:
781: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);

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

774: result := 'COMPLETE:SUCCESS';
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add('Input Paramerers : ');
777: oe_debug_pub.add('Line id :'||to_char(l_line_id));
778: oe_debug_pub.add('Output : ');
779: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
780:
781: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
782: END IF;

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

775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add('Input Paramerers : ');
777: oe_debug_pub.add('Line id :'||to_char(l_line_id));
778: oe_debug_pub.add('Output : ');
779: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
780:
781: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
782: END IF;
783: RETURN;

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

777: oe_debug_pub.add('Line id :'||to_char(l_line_id));
778: oe_debug_pub.add('Output : ');
779: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
780:
781: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
782: END IF;
783: RETURN;
784: ELSIF (funcmode = 'CANCEL') THEN
785: result := wf_engine.eng_completed;

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

821: l_order_type_id NUMBER;
822: fb_error_msg VARCHAR2(240) DEFAULT NULL;
823: l_error_msg VARCHAR2(240) DEFAULT NULL;
824:
825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
826: BEGIN
827: -- start data fix project
828: OE_STANDARD_WF.Set_Msg_Context(actid);
829: -- end data fix project

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

827: -- start data fix project
828: OE_STANDARD_WF.Set_Msg_Context(actid);
829: -- end data fix project
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
832: oe_debug_pub.add(' Item Type : '||itemtype,2);
833: oe_debug_pub.add(' Item Key : '||itemkey,2);
834: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
835: oe_debug_pub.add(' funcmode : '||funcmode,2);

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

828: OE_STANDARD_WF.Set_Msg_Context(actid);
829: -- end data fix project
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
832: oe_debug_pub.add(' Item Type : '||itemtype,2);
833: oe_debug_pub.add(' Item Key : '||itemkey,2);
834: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
835: oe_debug_pub.add(' funcmode : '||funcmode,2);
836: END IF;

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

829: -- end data fix project
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
832: oe_debug_pub.add(' Item Type : '||itemtype,2);
833: oe_debug_pub.add(' Item Key : '||itemkey,2);
834: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
835: oe_debug_pub.add(' funcmode : '||funcmode,2);
836: END IF;
837:

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

830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
832: oe_debug_pub.add(' Item Type : '||itemtype,2);
833: oe_debug_pub.add(' Item Key : '||itemkey,2);
834: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
835: oe_debug_pub.add(' funcmode : '||funcmode,2);
836: END IF;
837:
838: IF (funcmode = 'RUN') THEN

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

831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
832: oe_debug_pub.add(' Item Type : '||itemtype,2);
833: oe_debug_pub.add(' Item Key : '||itemkey,2);
834: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
835: oe_debug_pub.add(' funcmode : '||funcmode,2);
836: END IF;
837:
838: IF (funcmode = 'RUN') THEN
839: l_order_type_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

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

880:
881: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
882: result := 'COMPLETE:SUCCESS';
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add('Input Paramerers : ',2);
885: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
886: oe_debug_pub.add('Output : ',2);
887: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
888: END IF;

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

881: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
882: result := 'COMPLETE:SUCCESS';
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add('Input Paramerers : ',2);
885: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
886: oe_debug_pub.add('Output : ',2);
887: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
888: END IF;
889: RETURN;

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

882: result := 'COMPLETE:SUCCESS';
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add('Input Paramerers : ',2);
885: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
886: oe_debug_pub.add('Output : ',2);
887: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
888: END IF;
889: RETURN;
890: ELSIF (funcmode = 'CANCEL') THEN

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

883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add('Input Paramerers : ',2);
885: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);
886: oe_debug_pub.add('Output : ',2);
887: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
888: END IF;
889: RETURN;
890: ELSIF (funcmode = 'CANCEL') THEN
891: result := wf_engine.eng_completed;

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

927: l_salesrep_rev_derived VARCHAR2(240) DEFAULT NULL;
928: l_salesrep_id NUMBER;
929: fb_error_msg VARCHAR2(240) DEFAULT NULL;
930: l_error_msg VARCHAR2(240) DEFAULT NULL;
931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
932: BEGIN
933: -- start data fix project
934: OE_STANDARD_WF.Set_Msg_Context(actid);
935: -- end data fix project

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

933: -- start data fix project
934: OE_STANDARD_WF.Set_Msg_Context(actid);
935: -- end data fix project
936: IF l_debug_level > 0 THEN
937: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED',1);
938: END IF;
939: IF (FUNCMODE = 'RUN') THEN
940: l_salesrep_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'SALESREP_ID');
941: IF l_debug_level > 0 THEN

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

938: END IF;
939: IF (FUNCMODE = 'RUN') THEN
940: l_salesrep_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'SALESREP_ID');
941: IF l_debug_level > 0 THEN
942: oe_debug_pub.add('Sales rep id : '||to_char(l_salesrep_id),2);
943: END If;
944: l_salesrep_rev_derived := NULL;
945:
946: IF (l_salesrep_id IS NOT NULL) THEN

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

989:
990: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));
991: result := 'COMPLETE:SUCCESS';
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add('Input Paramerers : ',2);
994: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
995: oe_debug_pub.add('Output : ',2);
996: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
997: END IF;

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

990: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));
991: result := 'COMPLETE:SUCCESS';
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add('Input Paramerers : ',2);
994: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
995: oe_debug_pub.add('Output : ',2);
996: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
997: END IF;
998: RETURN;

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

991: result := 'COMPLETE:SUCCESS';
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add('Input Paramerers : ',2);
994: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
995: oe_debug_pub.add('Output : ',2);
996: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
997: END IF;
998: RETURN;
999: ELSIF (funcmode = 'CANCEL') THEN

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

992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add('Input Paramerers : ',2);
994: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);
995: oe_debug_pub.add('Output : ',2);
996: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
997: END IF;
998: RETURN;
999: ELSIF (funcmode = 'CANCEL') THEN
1000: result := wf_engine.eng_completed;

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

1035: l_header_id NUMBER;
1036: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1037: l_error_msg VARCHAR2(240) DEFAULT NULL;
1038: l_order_type_id NUMBER; --a.k.a transaction_type_id, line_type_id
1039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1040: BEGIN
1041: -- start data fix project
1042: OE_STANDARD_WF.Set_Msg_Context(actid);
1043: -- end data fix project

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

1041: -- start data fix project
1042: OE_STANDARD_WF.Set_Msg_Context(actid);
1043: -- end data fix project
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add('Entering Get_type_from_line',2);
1046: END IF;
1047: --DBMS_OUTPUT.PUT_LINE('Entering get_line_from_line');
1048:
1049: IF (FUNCMODE = 'RUN') THEN

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

1048:
1049: IF (FUNCMODE = 'RUN') THEN
1050: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1051: IF l_debug_level > 0 THEN
1052: oe_debug_pub.add('Input Paramerers : ',2);
1053: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1054: END IF;
1055:
1056: IF (l_order_line_id IS NOT NULL) THEN

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

1049: IF (FUNCMODE = 'RUN') THEN
1050: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1051: IF l_debug_level > 0 THEN
1052: oe_debug_pub.add('Input Paramerers : ',2);
1053: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1054: END IF;
1055:
1056: IF (l_order_line_id IS NOT NULL) THEN
1057: BEGIN

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

1079: result := 'COMPLETE:FAILURE';
1080: RETURN;
1081: END IF;
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add('Output : ',2);
1084: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);
1085: END IF;
1086: RETURN;
1087: ELSIF (funcmode = 'CANCEL') THEN

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

1080: RETURN;
1081: END IF;
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add('Output : ',2);
1084: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);
1085: END IF;
1086: RETURN;
1087: ELSIF (funcmode = 'CANCEL') THEN
1088: result := wf_engine.eng_completed;

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

1125: l_order_line_id NUMBER;
1126: l_header_id NUMBER;
1127: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1128: l_error_msg VARCHAR2(240) DEFAULT NULL;
1129: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1130: BEGIN
1131: -- start data fix project
1132: OE_STANDARD_WF.Set_Msg_Context(actid);
1133: -- end data fix project

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

1131: -- start data fix project
1132: OE_STANDARD_WF.Set_Msg_Context(actid);
1133: -- end data fix project
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_ID',2);
1136: END IF;
1137: IF (FUNCMODE = 'RUN') THEN
1138: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1139: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

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

1138: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1139: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Input Paramerers : ',2);
1143: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1144: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);
1145: END IF;
1146: l_salesrep_id := NULL;

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

1139: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Input Paramerers : ',2);
1143: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1144: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);
1145: END IF;
1146: l_salesrep_id := NULL;
1147:

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

1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Input Paramerers : ',2);
1143: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1144: oe_debug_pub.add('Order Header ID :'|| to_char(l_header_id),2);
1145: END IF;
1146: l_salesrep_id := NULL;
1147:
1148: IF (l_order_line_id IS NOT NULL) THEN

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

1171:
1172: EXCEPTION
1173: WHEN NO_DATA_FOUND THEN
1174: IF l_debug_level > 0 THEN
1175: oe_debug_pub.add('Sales rep not found at line level',2);
1176: END IF;
1177: BEGIN
1178: SELECT SALESREP_ID
1179: INTO l_salesrep_id

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

1219: result := 'COMPLETE:FAILURE';
1220: RETURN;
1221: END IF;
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add('Output : ',2);
1224: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);
1225: END IF;
1226: RETURN;
1227: ELSIF (funcmode = 'CANCEL') THEN

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

1220: RETURN;
1221: END IF;
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add('Output : ',2);
1224: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);
1225: END IF;
1226: RETURN;
1227: ELSIF (funcmode = 'CANCEL') THEN
1228: result := wf_engine.eng_completed;

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

1265: l_ship_from_org_id NUMBER;
1266: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1267: l_error_msg VARCHAR2(240) DEFAULT NULL;
1268:
1269: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1270: BEGIN
1271: -- start data fix project
1272: OE_STANDARD_WF.Set_Msg_Context(actid);
1273: -- end data fix project

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

1271: -- start data fix project
1272: OE_STANDARD_WF.Set_Msg_Context(actid);
1273: -- end data fix project
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Get_Invitm_Org_Derived',1);
1276: END IF;
1277: IF (FUNCMODE = 'RUN') THEN
1278: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1279: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

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

1277: IF (FUNCMODE = 'RUN') THEN
1278: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1279: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add('Input Paramerers : ',2);
1282: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1283: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);
1284: END IF;
1285: L_ACCOUNT_DERIVED := NULL;

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

1278: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1279: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add('Input Paramerers : ',2);
1282: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1283: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);
1284: END IF;
1285: L_ACCOUNT_DERIVED := NULL;
1286: IF (L_INV_ITEM_ID IS NOT NULL) THEN

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

1279: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add('Input Paramerers : ',2);
1282: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1283: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);
1284: END IF;
1285: L_ACCOUNT_DERIVED := NULL;
1286: IF (L_INV_ITEM_ID IS NOT NULL) THEN
1287: BEGIN

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

1328: result := 'COMPLETE:FAILURE';
1329: RETURN;
1330: END IF;
1331: IF l_debug_level > 0 THEN
1332: oe_debug_pub.add('Output : ',2);
1333: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);
1334: END IF;
1335: RETURN;
1336: ELSIF (funcmode = 'CANCEL') THEN

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

1329: RETURN;
1330: END IF;
1331: IF l_debug_level > 0 THEN
1332: oe_debug_pub.add('Output : ',2);
1333: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);
1334: END IF;
1335: RETURN;
1336: ELSIF (funcmode = 'CANCEL') THEN
1337: result := wf_engine.eng_completed;

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

1367: IS
1368:
1369: l_option_flag VARCHAR2(1);
1370: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1371: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1372: BEGIN
1373: -- start data fix project
1374: OE_STANDARD_WF.Set_Msg_Context(actid);
1375: -- end data fix project

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

1373: -- start data fix project
1374: OE_STANDARD_WF.Set_Msg_Context(actid);
1375: -- end data fix project
1376: IF l_debug_level > 0 THEN
1377: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Check_Option',1);
1378: END IF;
1379: IF (FUNCMODE = 'RUN') THEN
1380: l_option_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1381: IF l_debug_level > 0 THEN

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

1378: END IF;
1379: IF (FUNCMODE = 'RUN') THEN
1380: l_option_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add('Option Flag :'|| l_option_flag,2);
1383: END IF;
1384: IF l_option_flag = 'Y' THEN
1385:
1386: result := 'COMPLETE:TRUE';

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

1429: l_trx_type VARCHAR2(240) DEFAULT NULL;
1430: l_commitment_id NUMBER;
1431: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1432: l_error_msg VARCHAR2(240) DEFAULT NULL;
1433: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1434: BEGIN
1435: -- start data fix project
1436: OE_STANDARD_WF.Set_Msg_Context(actid);
1437: -- end data fix project

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

1435: -- start data fix project
1436: OE_STANDARD_WF.Set_Msg_Context(actid);
1437: -- end data fix project
1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_TRX_TYPE',2);
1440: END IF;
1441: IF (FUNCMODE = 'RUN') THEN
1442: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1443: IF l_debug_level > 0 THEN

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

1440: END IF;
1441: IF (FUNCMODE = 'RUN') THEN
1442: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1443: IF l_debug_level > 0 THEN
1444: oe_debug_pub.add('Input Paramerers : ',2);
1445: oe_debug_pub.add('Commitment ID :'|| to_char(l_commitment_id),2);
1446: END IF;
1447: l_trx_type := NULL;
1448:

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

1441: IF (FUNCMODE = 'RUN') THEN
1442: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1443: IF l_debug_level > 0 THEN
1444: oe_debug_pub.add('Input Paramerers : ',2);
1445: oe_debug_pub.add('Commitment ID :'|| to_char(l_commitment_id),2);
1446: END IF;
1447: l_trx_type := NULL;
1448:
1449: IF (l_commitment_id IS NOT NULL) THEN

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

1471: result := 'COMPLETE:FAILURE';
1472: RETURN;
1473: END IF;
1474: IF l_debug_level > 0 THEN
1475: oe_debug_pub.add('Output : ',2);
1476: oe_debug_pub.add('Transaction Type'||l_trx_type,2);
1477: END IF;
1478: RETURN;
1479: ELSIF (funcmode = 'CANCEL') THEN

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

1472: RETURN;
1473: END IF;
1474: IF l_debug_level > 0 THEN
1475: oe_debug_pub.add('Output : ',2);
1476: oe_debug_pub.add('Transaction Type'||l_trx_type,2);
1477: END IF;
1478: RETURN;
1479: ELSIF (funcmode = 'CANCEL') THEN
1480: result := wf_engine.eng_completed;

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

1522: fb_flex_seg IN OUT NOCOPY VARCHAR2,
1523: fb_error_msg IN OUT NOCOPY VARCHAR2)
1524: RETURN BOOLEAN
1525: IS
1526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1527: BEGIN
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1530: END IF;

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

1525: IS
1526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1527: BEGIN
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1530: END IF;
1531: fb_flex_seg := NULL;
1532:
1533: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');

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

1562: l_option_flag VARCHAR2(2);
1563: l_flex_num NUMBER;
1564: l_fb_flex_segs VARCHAR2(240) DEFAULT NULL;
1565: l_fb_error_msg VARCHAR2(240) DEFAULT NULL;
1566: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1567: BEGIN
1568: -- start data fix project
1569: OE_STANDARD_WF.Set_Msg_Context(actid);
1570: -- end data fix project

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

1568: -- start data fix project
1569: OE_STANDARD_WF.Set_Msg_Context(actid);
1570: -- end data fix project
1571: IF l_debug_level > 0 THEN
1572: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',1);
1573: END IF;
1574: IF (FUNCMODE = 'RUN') THEN
1575:
1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

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

1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1585:
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Input Paramerers : ',2);
1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);

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

1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1585:
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Input Paramerers : ',2);
1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);

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

1585:
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Input Paramerers : ',2);
1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);

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

1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Input Paramerers : ',2);
1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);

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

1587: oe_debug_pub.add('Input Paramerers : ',2);
1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1595: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);

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

1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);
1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1595: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1596: END IF;

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

1589: oe_debug_pub.add('Organization id :'||to_char(l_organization_id),2);
1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1595: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1596: END IF;
1597: IF (OE_FLEX_COGS_PUB.Build(

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

1590: oe_debug_pub.add('Commitment ID :'||to_char(l_commitment_id),2);
1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1595: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1596: END IF;
1597: IF (OE_FLEX_COGS_PUB.Build(
1598: l_flex_num,

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

1591: oe_debug_pub.add('Customer ID :'||to_char(l_customer_id),2);
1592: oe_debug_pub.add('Order Category :'||l_order_category,2);
1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1595: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1596: END IF;
1597: IF (OE_FLEX_COGS_PUB.Build(
1598: l_flex_num,
1599: l_commitment_id,