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

Line 62: OE_DEBUG_PUB.ADD('OEXPCRGB: In Set_G_CC_Hold_Info', 1);

58: PROCEDURE Set_G_CC_Hold_Info
59: IS
60: BEGIN
61: IF G_debug_flag = 'Y' THEN
62: OE_DEBUG_PUB.ADD('OEXPCRGB: In Set_G_CC_Hold_Info', 1);
63: END IF;
64:
65: SELECT item_type,
66: activity_name

Line 73: OE_DEBUG_PUB.ADD('G_cc_hold_item_type = '||G_cc_hold_item_type, 2);

69: FROM oe_hold_definitions
70: WHERE hold_id = 1;
71:
72: IF G_debug_flag = 'Y' THEN
73: OE_DEBUG_PUB.ADD('G_cc_hold_item_type = '||G_cc_hold_item_type, 2);
74: OE_DEBUG_PUB.ADD('G_cc_hold_activity_name = '||G_cc_hold_activity_name, 2);
75: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Set_G_CC_Hold_Info', 1);
76: END IF;
77: EXCEPTION

Line 74: OE_DEBUG_PUB.ADD('G_cc_hold_activity_name = '||G_cc_hold_activity_name, 2);

70: WHERE hold_id = 1;
71:
72: IF G_debug_flag = 'Y' THEN
73: OE_DEBUG_PUB.ADD('G_cc_hold_item_type = '||G_cc_hold_item_type, 2);
74: OE_DEBUG_PUB.ADD('G_cc_hold_activity_name = '||G_cc_hold_activity_name, 2);
75: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Set_G_CC_Hold_Info', 1);
76: END IF;
77: EXCEPTION
78: WHEN NO_DATA_FOUND THEN

Line 75: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Set_G_CC_Hold_Info', 1);

71:
72: IF G_debug_flag = 'Y' THEN
73: OE_DEBUG_PUB.ADD('G_cc_hold_item_type = '||G_cc_hold_item_type, 2);
74: OE_DEBUG_PUB.ADD('G_cc_hold_activity_name = '||G_cc_hold_activity_name, 2);
75: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Set_G_CC_Hold_Info', 1);
76: END IF;
77: EXCEPTION
78: WHEN NO_DATA_FOUND THEN
79: -- Hold definition should exist. This exception should not occur if setup is correct.

Line 83: OE_DEBUG_PUB.ADD('EXCEPTION: No credit check hold definition found.', 1);

79: -- Hold definition should exist. This exception should not occur if setup is correct.
80: -- Ideally, an error should be raised indicating no cc hold definition found instead
81: -- of unexpected error.
82: IF G_debug_flag = 'Y' THEN
83: OE_DEBUG_PUB.ADD('EXCEPTION: No credit check hold definition found.', 1);
84: END IF;
85: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
86: OE_MSG_PUB.Add_Exc_Msg
87: ( G_PKG_NAME

Line 116: OE_DEBUG_PUB.ADD('OEXPCRGB: In Get_Credit_Check_Rule_ID ');

112: IS
113: BEGIN
114: IF G_debug_flag = 'Y'
115: THEN
116: OE_DEBUG_PUB.ADD('OEXPCRGB: In Get_Credit_Check_Rule_ID ');
117: OE_DEBUG_PUB.ADD('p_order_type_id = '|| p_order_type_id );
118: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action );
119: END IF;
120: x_credit_rule_id := NULL ;

Line 117: OE_DEBUG_PUB.ADD('p_order_type_id = '|| p_order_type_id );

113: BEGIN
114: IF G_debug_flag = 'Y'
115: THEN
116: OE_DEBUG_PUB.ADD('OEXPCRGB: In Get_Credit_Check_Rule_ID ');
117: OE_DEBUG_PUB.ADD('p_order_type_id = '|| p_order_type_id );
118: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action );
119: END IF;
120: x_credit_rule_id := NULL ;
121:

Line 118: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action );

114: IF G_debug_flag = 'Y'
115: THEN
116: OE_DEBUG_PUB.ADD('OEXPCRGB: In Get_Credit_Check_Rule_ID ');
117: OE_DEBUG_PUB.ADD('p_order_type_id = '|| p_order_type_id );
118: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action );
119: END IF;
120: x_credit_rule_id := NULL ;
121:
122: IF p_calling_action in ('BOOKING','BOOKING_INLINE','UPDATE',

Line 204: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit Check Rule ID: '

200: END IF;
201:
202: IF G_debug_flag = 'Y'
203: THEN
204: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit Check Rule ID: '
205: ||TO_CHAR(x_credit_rule_id) );
206:
207: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Get_Credit_Check_Rule_ID');
208: END IF;

Line 207: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Get_Credit_Check_Rule_ID');

203: THEN
204: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit Check Rule ID: '
205: ||TO_CHAR(x_credit_rule_id) );
206:
207: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Get_Credit_Check_Rule_ID');
208: END IF;
209:
210: EXCEPTION
211: WHEN NO_DATA_FOUND

Line 214: OE_DEBUG_PUB.ADD('EXCEPTION:No credit check rule found');

210: EXCEPTION
211: WHEN NO_DATA_FOUND
212: THEN
213: x_credit_rule_id := NULL ;
214: OE_DEBUG_PUB.ADD('EXCEPTION:No credit check rule found');
215: WHEN OTHERS THEN
216: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
217: OE_MSG_PUB.Add_Exc_Msg
218: ( G_PKG_NAME

Line 247: OE_DEBUG_PUB.Add('OEXPCRGB: In Is_Tolerance_Enabled ');

243: l_calling_action VARCHAR2(30);
244: BEGIN
245: IF G_debug_flag = 'Y'
246: THEN
247: OE_DEBUG_PUB.Add('OEXPCRGB: In Is_Tolerance_Enabled ');
248: END IF;
249:
250: l_calling_action := OE_Verify_Payment_PUB.Which_Rule(p_header_id => p_header_id);
251:

Line 281: OE_DEBUG_PUB.Add('OEXPCRGB: Out Is_Tolerance_Enabled ');

277:
278:
279: IF G_debug_flag = 'Y'
280: THEN
281: OE_DEBUG_PUB.Add('OEXPCRGB: Out Is_Tolerance_Enabled ');
282: END IF;
283:
284: EXCEPTION
285:

Line 293: OE_DEBUG_PUB.ADD( SUBSTR( SQLERRM,1,300) ,1 ) ;

289: ( G_PKG_NAME
290: , 'Credit_Tolerance_Check'
291: );
292: END IF;
293: OE_DEBUG_PUB.ADD( SUBSTR( SQLERRM,1,300) ,1 ) ;
294:
295:
296: END Is_Tolerance_Enabled ;
297:

Line 334: OE_DEBUG_PUB.Add('OEXPCRGB: In Credit_Tolerance_Check ');

330:
331: BEGIN
332: IF G_debug_flag = 'Y'
333: THEN
334: OE_DEBUG_PUB.Add('OEXPCRGB: In Credit_Tolerance_Check ');
335: END IF;
336:
337: IF Is_Tolerance_Enabled(p_header_id,l_credit_check_rule_rec) THEN
338:

Line 374: OE_DEBUG_PUB.Add('OEXPCRGB: Currency conversion not required. Released and Transactional currency is same');

370: , p_conversion_date => SYSDATE
371: , p_conversion_type => l_credit_check_rule_rec.conversion_type
372: );
373: ELSE
374: OE_DEBUG_PUB.Add('OEXPCRGB: Currency conversion not required. Released and Transactional currency is same');
375: l_released_order_amount_conv := l_released_order_amount;
376: END IF;
377:
378: /***If No Tolerance Defined , the Credit Checking will always be triggered**/

Line 381: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Not Required');

377:
378: /***If No Tolerance Defined , the Credit Checking will always be triggered**/
379: IF l_credit_check_rule_rec.tolerance_percentage IS NULL and l_credit_check_rule_rec.tolerance_amount IS NULL
380: THEN
381: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Not Required');
382: RETURN FALSE;
383: END IF;
384:
385: IF l_credit_check_rule_rec.tolerance_amount IS NOT NULL

Line 400: OE_DEBUG_PUB.Add('OEXPCRGB: Currency conversion not required. Tolerance and Transactional currency is same');

396: , p_conversion_date => SYSDATE
397: , p_conversion_type => l_credit_check_rule_rec.conversion_type
398: );
399: ELSE
400: OE_DEBUG_PUB.Add('OEXPCRGB: Currency conversion not required. Tolerance and Transactional currency is same');
401: l_tolerance_amount_conv := l_credit_check_rule_rec.tolerance_amount;
402: END IF;
403: END IF;
404:

Line 431: OE_DEBUG_PUB.Add('OEXPCRGB: l_released_order_amount_conv: ' ||l_released_order_amount_conv);

427: END IF;
428:
429: IF G_debug_flag = 'Y'
430: THEN
431: OE_DEBUG_PUB.Add('OEXPCRGB: l_released_order_amount_conv: ' ||l_released_order_amount_conv);
432: OE_DEBUG_PUB.Add('OEXPCRGB: l_tolerance_amount_fin: ' ||l_tolerance_amount_fin);
433: OE_DEBUG_PUB.Add('OEXPCRGB: l_curr_order_amount: ' ||l_curr_order_amount);
434: END IF;
435:

Line 432: OE_DEBUG_PUB.Add('OEXPCRGB: l_tolerance_amount_fin: ' ||l_tolerance_amount_fin);

428:
429: IF G_debug_flag = 'Y'
430: THEN
431: OE_DEBUG_PUB.Add('OEXPCRGB: l_released_order_amount_conv: ' ||l_released_order_amount_conv);
432: OE_DEBUG_PUB.Add('OEXPCRGB: l_tolerance_amount_fin: ' ||l_tolerance_amount_fin);
433: OE_DEBUG_PUB.Add('OEXPCRGB: l_curr_order_amount: ' ||l_curr_order_amount);
434: END IF;
435:
436: IF l_curr_order_amount <= (l_released_order_amount + l_tolerance_amount_fin)

Line 433: OE_DEBUG_PUB.Add('OEXPCRGB: l_curr_order_amount: ' ||l_curr_order_amount);

429: IF G_debug_flag = 'Y'
430: THEN
431: OE_DEBUG_PUB.Add('OEXPCRGB: l_released_order_amount_conv: ' ||l_released_order_amount_conv);
432: OE_DEBUG_PUB.Add('OEXPCRGB: l_tolerance_amount_fin: ' ||l_tolerance_amount_fin);
433: OE_DEBUG_PUB.Add('OEXPCRGB: l_curr_order_amount: ' ||l_curr_order_amount);
434: END IF;
435:
436: IF l_curr_order_amount <= (l_released_order_amount + l_tolerance_amount_fin)
437: THEN

Line 438: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Passed');

434: END IF;
435:
436: IF l_curr_order_amount <= (l_released_order_amount + l_tolerance_amount_fin)
437: THEN
438: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Passed');
439: RETURN TRUE;
440: ELSE
441: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Failed');
442: RETURN FALSE;

Line 441: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Failed');

437: THEN
438: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Passed');
439: RETURN TRUE;
440: ELSE
441: OE_DEBUG_PUB.Add('OEXPCRGB: Tolerance Check Failed');
442: RETURN FALSE;
443: END IF;
444: END IF;
445:

Line 451: OE_DEBUG_PUB.Add('OEXPCRGB: Out Credit_Tolerance_Check ');

447:
448: RETURN FALSE;
449: IF G_debug_flag = 'Y'
450: THEN
451: OE_DEBUG_PUB.Add('OEXPCRGB: Out Credit_Tolerance_Check ');
452: END IF;
453:
454: EXCEPTION
455:

Line 463: OE_DEBUG_PUB.ADD( SUBSTR( SQLERRM,1,300) ,1 ) ;

459: ( G_PKG_NAME
460: , 'Credit_Tolerance_Check'
461: );
462: END IF;
463: OE_DEBUG_PUB.ADD( SUBSTR( SQLERRM,1,300) ,1 ) ;
464:
465:
466: END Credit_Tolerance_Check ;
467: --ER 12363706 end

Line 496: OE_DEBUG_PUB.Add('OEXPCRGB: In Apply_exception_hold ');

492: OE_HOLDS_PVT.G_MISS_Hold_Source_REC;
493: BEGIN
494: IF G_debug_flag = 'Y'
495: THEN
496: OE_DEBUG_PUB.Add('OEXPCRGB: In Apply_exception_hold ');
497: END IF;
498:
499: l_hold_source_rec.hold_id := 1; -- credit hold
500: l_hold_source_rec.hold_entity_code := 'O'; -- order hold

Line 505: OE_DEBUG_PUB.Add('Call OE_HOLDS_PUB.Check_Holds');

501: l_hold_source_rec.hold_entity_id := p_header_id; -- order header
502:
503: IF G_debug_flag = 'Y'
504: THEN
505: OE_DEBUG_PUB.Add('Call OE_HOLDS_PUB.Check_Holds');
506: END IF;
507:
508: OE_HOLDS_PUB.Check_Holds
509: ( p_api_version => 1.0

Line 530: OE_DEBUG_PUB.Add('OEXVCRHB: Hold already applied on Header ID:' ||

526: END IF;
527:
528: IF l_hold_result = FND_API.G_TRUE
529: THEN
530: OE_DEBUG_PUB.Add('OEXVCRHB: Hold already applied on Header ID:' ||
531: p_header_id );
532: ELSE
533: l_hold_comment := 'Credit checking package API Error' ;
534: l_hold_source_rec.hold_comment :=

Line 537: OE_DEBUG_PUB.Add('Call OE_Holds_PUB.Apply_Holds' );

533: l_hold_comment := 'Credit checking package API Error' ;
534: l_hold_source_rec.hold_comment :=
535: NVL(OE_Credit_Engine_GRP.G_currency_error_msg, l_hold_comment) ;
536:
537: OE_DEBUG_PUB.Add('Call OE_Holds_PUB.Apply_Holds' );
538:
539: OE_Holds_PUB.Apply_Holds
540: ( p_api_version => 1.0
541: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 553: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit check hold applied on header_ID: '

549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit check hold applied on header_ID: '
554: ||p_header_id, 1);
555: END IF;
556: END IF; -- Check hold exist
557:

Line 560: OE_DEBUG_PUB.Add('OEXPCRGB: Out Apply_exception_hold ');

556: END IF; -- Check hold exist
557:
558: IF G_debug_flag = 'Y'
559: THEN
560: OE_DEBUG_PUB.Add('OEXPCRGB: Out Apply_exception_hold ');
561: END IF;
562:
563: EXCEPTION
564:

Line 573: OE_DEBUG_PUB.ADD( SUBSTR( SQLERRM,1,300) ,1 ) ;

569: ( G_PKG_NAME
570: , 'Apply_exception_hold'
571: );
572: END IF;
573: OE_DEBUG_PUB.ADD( SUBSTR( SQLERRM,1,300) ,1 ) ;
574:
575:
576: END Apply_Exception_hold ;
577:

Line 594: OE_DEBUG_PUB.ADD('OEXPCRGB: In Get_GL_currency ');

590:
591: BEGIN
592: IF G_debug_flag = 'Y'
593: THEN
594: OE_DEBUG_PUB.ADD('OEXPCRGB: In Get_GL_currency ');
595: END IF;
596:
597: BEGIN
598: l_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID') ;

Line 602: OE_DEBUG_PUB.ADD('l_sob_id = '|| l_sob_id );

598: l_sob_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID') ;
599:
600: IF G_debug_flag = 'Y'
601: THEN
602: OE_DEBUG_PUB.ADD('l_sob_id = '|| l_sob_id );
603: OE_DEBUG_PUB.ADD('GET SOB currency ');
604: END IF;
605:
606: SELECT

Line 603: OE_DEBUG_PUB.ADD('GET SOB currency ');

599:
600: IF G_debug_flag = 'Y'
601: THEN
602: OE_DEBUG_PUB.ADD('l_sob_id = '|| l_sob_id );
603: OE_DEBUG_PUB.ADD('GET SOB currency ');
604: END IF;
605:
606: SELECT
607: currency_code

Line 616: OE_DEBUG_PUB.ADD('l_gl_currency = '|| l_gl_currency );

612: WHERE set_of_books_id = l_sob_id ;
613:
614: IF G_debug_flag = 'Y'
615: THEN
616: OE_DEBUG_PUB.ADD('l_gl_currency = '|| l_gl_currency );
617: END IF;
618:
619: EXCEPTION
620: WHEN NO_DATA_FOUND

Line 623: OE_DEBUG_PUB.ADD('EXCEPTION: NO_DATA_FOUND ');

619: EXCEPTION
620: WHEN NO_DATA_FOUND
621: THEN
622: l_gl_currency := NULL ;
623: OE_DEBUG_PUB.ADD('EXCEPTION: NO_DATA_FOUND ');
624: l_gl_currency := NULL ;
625: WHEN TOO_MANY_ROWS
626: THEN
627: l_gl_currency := NULL ;

Line 628: OE_DEBUG_PUB.ADD('EXCEPTION: TOO_MANY_ROWS');

624: l_gl_currency := NULL ;
625: WHEN TOO_MANY_ROWS
626: THEN
627: l_gl_currency := NULL ;
628: OE_DEBUG_PUB.ADD('EXCEPTION: TOO_MANY_ROWS');
629: l_gl_currency := NULL ;
630: END ;
631:
632: IF G_debug_flag = 'Y'

Line 634: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Get_GL_currency ');

630: END ;
631:
632: IF G_debug_flag = 'Y'
633: THEN
634: OE_DEBUG_PUB.ADD('OEXPCRGB: Out Get_GL_currency ');
635: END IF;
636:
637: RETURN(l_GL_currency);
638:

Line 647: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300) ) ;

643: ( G_PKG_NAME
644: , 'Get_GL_currency'
645: );
646: END IF;
647: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300) ) ;
648: END Get_GL_currency ;
649:
650: ---------------------------------------------------------------------------
651: --PROCEDURE: Credit_check_with_payment_typ

Line 678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);

674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675:
676: IF G_debug_flag = 'Y'
677: THEN
678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);
679: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
680: OE_DEBUG_PUB.ADD('p_calling_action = ' || p_calling_action,1 );
681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );

Line 679: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );

675:
676: IF G_debug_flag = 'Y'
677: THEN
678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);
679: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
680: OE_DEBUG_PUB.ADD('p_calling_action = ' || p_calling_action,1 );
681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );
683: END IF;

Line 680: OE_DEBUG_PUB.ADD('p_calling_action = ' || p_calling_action,1 );

676: IF G_debug_flag = 'Y'
677: THEN
678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);
679: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
680: OE_DEBUG_PUB.ADD('p_calling_action = ' || p_calling_action,1 );
681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );
683: END IF;
684:

Line 681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );

677: THEN
678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);
679: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
680: OE_DEBUG_PUB.ADD('p_calling_action = ' || p_calling_action,1 );
681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );
683: END IF;
684:
685: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

Line 682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );

678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);
679: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
680: OE_DEBUG_PUB.ADD('p_calling_action = ' || p_calling_action,1 );
681: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
682: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id,1 );
683: END IF;
684:
685: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
686:

Line 689: OE_DEBUG_PUB.ADD('call Check_Credit for credit checking',1);

685: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
686:
687: IF G_debug_flag = 'Y'
688: THEN
689: OE_DEBUG_PUB.ADD('call Check_Credit for credit checking',1);
690: END IF;
691:
692: Check_Credit
693: ( p_header_id => p_header_id

Line 706: OE_DEBUG_PUB.ADD('x_return_status '|| x_return_status );

702: );
703:
704: IF G_debug_flag = 'Y'
705: THEN
706: OE_DEBUG_PUB.ADD('x_return_status '|| x_return_status );
707: END IF;
708:
709: IF x_return_status = FND_API.G_RET_STS_ERROR
710: THEN

Line 723: OE_DEBUG_PUB.ADD('OEXPCRGB:Final x_return_status = '|| x_return_status,1 );

719: END IF;
720:
721: IF G_debug_flag = 'Y'
722: THEN
723: OE_DEBUG_PUB.ADD('OEXPCRGB:Final x_return_status = '|| x_return_status,1 );
724: OE_DEBUG_PUB.ADD('OEXPCRGB:l_result_out = '|| l_result_out,1 );
725: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Credit_check_with_payment_typ ',1);
726: END IF;
727:

Line 724: OE_DEBUG_PUB.ADD('OEXPCRGB:l_result_out = '|| l_result_out,1 );

720:
721: IF G_debug_flag = 'Y'
722: THEN
723: OE_DEBUG_PUB.ADD('OEXPCRGB:Final x_return_status = '|| x_return_status,1 );
724: OE_DEBUG_PUB.ADD('OEXPCRGB:l_result_out = '|| l_result_out,1 );
725: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Credit_check_with_payment_typ ',1);
726: END IF;
727:
728: Oe_Globals.G_calling_source:= 'WSH'; --8478151

Line 725: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Credit_check_with_payment_typ ',1);

721: IF G_debug_flag = 'Y'
722: THEN
723: OE_DEBUG_PUB.ADD('OEXPCRGB:Final x_return_status = '|| x_return_status,1 );
724: OE_DEBUG_PUB.ADD('OEXPCRGB:l_result_out = '|| l_result_out,1 );
725: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Credit_check_with_payment_typ ',1);
726: END IF;
727:
728: Oe_Globals.G_calling_source:= 'WSH'; --8478151
729:

Line 735: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );

731:
732: WHEN FND_API.G_EXC_ERROR THEN
733: Oe_Globals.G_calling_source:= 'WSH'; --8478151
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
736: OE_MSG_PUB.Count_And_Get
737: ( p_count => l_msg_count,
738: p_data => l_msg_data
739: );

Line 744: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );

740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: Oe_Globals.G_calling_source:= 'WSH'; --8478151
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
745: OE_MSG_PUB.Count_And_Get
746: ( p_count => l_msg_count,
747: p_data => l_msg_data
748: );

Line 753: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );

749:
750: WHEN OTHERS THEN
751: Oe_Globals.G_calling_source:= 'WSH'; --8478151
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
755: THEN
756: FND_MSG_PUB.Add_Exc_Msg
757: ( G_PKG_NAME

Line 825: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);

821:
822: BEGIN
823: IF G_debug_flag = 'Y'
824: THEN
825: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );

Line 826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );

822: BEGIN
823: IF G_debug_flag = 'Y'
824: THEN
825: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );

Line 827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );

823: IF G_debug_flag = 'Y'
824: THEN
825: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );

Line 828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );

824: THEN
825: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );
832: END IF;

Line 829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );

825: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Get_Customer_Exposure ',1);
826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );
832: END IF;
833:

Line 830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );

826: OE_DEBUG_PUB.ADD('p_party_id => '|| p_party_id );
827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );
832: END IF;
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );

827: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
828: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
829: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );
832: END IF;
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835: l_global_exposure_flag := 'N' ;

Line 849: OE_DEBUG_PUB.ADD('Check entity type ');

845: OE_CREDIT_CHECK_UTIL.GET_System_parameters
846: ( x_system_parameter_rec=>l_system_parameters_rec
847: );
848:
849: OE_DEBUG_PUB.ADD('Check entity type ');
850:
851: -------------------- EXPOSURE -----------------------
852:
853: /* Modified the following condition to fix the bug 5650329 */

Line 860: OE_DEBUG_PUB.ADD('Party level exposure ');

856: l_global_exposure_flag := 'Y' ;
857:
858: IF G_debug_flag = 'Y'
859: THEN
860: OE_DEBUG_PUB.ADD('Party level exposure ');
861: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
862: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||
863: l_global_exposure_flag );
864: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');

Line 861: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');

857:
858: IF G_debug_flag = 'Y'
859: THEN
860: OE_DEBUG_PUB.ADD('Party level exposure ');
861: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
862: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||
863: l_global_exposure_flag );
864: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');
865: END IF;

Line 862: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||

858: IF G_debug_flag = 'Y'
859: THEN
860: OE_DEBUG_PUB.ADD('Party level exposure ');
861: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
862: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||
863: l_global_exposure_flag );
864: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');
865: END IF;
866:

Line 864: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');

860: OE_DEBUG_PUB.ADD('Party level exposure ');
861: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
862: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||
863: l_global_exposure_flag );
864: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for PARTY level ');
865: END IF;
866:
867: ----get table of usages
868: OE_CREDIT_CHECK_UTIL.Get_Usages

Line 881: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');

877: );
878:
879: IF G_debug_flag = 'Y'
880: THEN
881: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
882: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
883: OE_DEBUG_PUB.ADD('---------------------------------------');
884: END IF;
885:

Line 882: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);

878:
879: IF G_debug_flag = 'Y'
880: THEN
881: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
882: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
883: OE_DEBUG_PUB.ADD('---------------------------------------');
884: END IF;
885:
886: ----IF l_include_all_flag is 'Y', assign it to the global variable

Line 883: OE_DEBUG_PUB.ADD('---------------------------------------');

879: IF G_debug_flag = 'Y'
880: THEN
881: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
882: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
883: OE_DEBUG_PUB.ADD('---------------------------------------');
884: END IF;
885:
886: ----IF l_include_all_flag is 'Y', assign it to the global variable
887: --- used later for unchecked exposure

Line 898: OE_DEBUG_PUB.ADD('currency_code=: '

894: FOR a IN 1..l_usage_curr_tbl.COUNT
895: LOOP
896: IF G_debug_flag = 'Y'
897: THEN
898: OE_DEBUG_PUB.ADD('currency_code=: '
899: ||l_usage_curr_tbl(a).usage_curr_code);
900: END IF;
901: END LOOP;
902: --------------------------------------------------------------------------------

Line 910: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

906: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
907:
908: IF G_debug_flag = 'Y'
909: THEN
910: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
911: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
912: OE_DEBUG_PUB.ADD('IN loop for assign table of usge to Glb variable ');
913: END IF;
914:

Line 911: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));

907:
908: IF G_debug_flag = 'Y'
909: THEN
910: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
911: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
912: OE_DEBUG_PUB.ADD('IN loop for assign table of usge to Glb variable ');
913: END IF;
914:
915: FOR i IN l_start..l_end

Line 912: OE_DEBUG_PUB.ADD('IN loop for assign table of usge to Glb variable ');

908: IF G_debug_flag = 'Y'
909: THEN
910: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
911: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
912: OE_DEBUG_PUB.ADD('IN loop for assign table of usge to Glb variable ');
913: END IF;
914:
915: FOR i IN l_start..l_end
916: LOOP

Line 951: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

947: FOR k IN 1..l_error_curr_tbl.COUNT
948: LOOP
949: IF G_debug_flag = 'Y'
950: THEN
951: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
952: !!!!!!!');
953: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(k)
954: .usage_curr_code
955: ||' and credit limit currency '

Line 953: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(k)

949: IF G_debug_flag = 'Y'
950: THEN
951: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
952: !!!!!!!');
953: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(k)
954: .usage_curr_code
955: ||' and credit limit currency '
956: ||p_limit_curr_code
957: ||' is missing for conversion type '

Line 960: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

956: ||p_limit_curr_code
957: ||' is missing for conversion type '
958: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1
959: );
960: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
961: !!!!!!!');
962:
963: END IF;
964: END LOOP;

Line 982: OE_DEBUG_PUB.ADD('Customer level exposure ');

978: ELSIF p_site_id IS NULL
979: THEN
980: IF G_debug_flag = 'Y'
981: THEN
982: OE_DEBUG_PUB.ADD('Customer level exposure ');
983: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
984: END IF;
985:
986: l_global_exposure_flag :=

Line 983: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');

979: THEN
980: IF G_debug_flag = 'Y'
981: THEN
982: OE_DEBUG_PUB.ADD('Customer level exposure ');
983: OE_DEBUG_PUB.ADD('Calling Get_global_exposure_flag ');
984: END IF;
985:
986: l_global_exposure_flag :=
987: OE_CREDIT_CHECK_UTIL.Get_global_exposure_flag

Line 1002: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||

998: /* End MOAC CREDIT CHECK CHANGE */
999:
1000: IF G_debug_flag = 'Y'
1001: THEN
1002: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||
1003: l_global_exposure_flag );
1004: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for CUSTOMER level ');
1005: END IF;
1006:

Line 1004: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for CUSTOMER level ');

1000: IF G_debug_flag = 'Y'
1001: THEN
1002: OE_DEBUG_PUB.ADD('l_global_exposure_flag = '||
1003: l_global_exposure_flag );
1004: OE_DEBUG_PUB.ADD('OEXPCRGB: Get usages for CUSTOMER level ');
1005: END IF;
1006:
1007: ----get table of usages
1008: OE_CREDIT_CHECK_UTIL.Get_Usages

Line 1021: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');

1017: );
1018:
1019: IF G_debug_flag = 'Y'
1020: THEN
1021: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
1022: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
1023: OE_DEBUG_PUB.ADD('---------------------------------------');
1024: END IF;
1025:

Line 1022: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);

1018:
1019: IF G_debug_flag = 'Y'
1020: THEN
1021: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
1022: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
1023: OE_DEBUG_PUB.ADD('---------------------------------------');
1024: END IF;
1025:
1026: ----IF l_include_all_flag is 'Y', assign it to the global variable

Line 1023: OE_DEBUG_PUB.ADD('---------------------------------------');

1019: IF G_debug_flag = 'Y'
1020: THEN
1021: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT of OE_CREDIT_CHECK_UTIL. Get_Usages ');
1022: OE_DEBUG_PUB.ADD('x_include_all_flag: '||l_include_all_flag);
1023: OE_DEBUG_PUB.ADD('---------------------------------------');
1024: END IF;
1025:
1026: ----IF l_include_all_flag is 'Y', assign it to the global variable
1027: --- used later for unchecked exposure

Line 1039: OE_DEBUG_PUB.ADD('currency_code=: '

1035: FOR a IN 1..l_usage_curr_tbl.COUNT
1036: LOOP
1037: IF G_debug_flag = 'Y'
1038: THEN
1039: OE_DEBUG_PUB.ADD('currency_code=: '
1040: ||l_usage_curr_tbl(a).usage_curr_code);
1041: END IF;
1042: END LOOP;
1043: --------------------------------------------------------------------------------

Line 1051: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

1047: l_end:=OE_Credit_Engine_GRP.G_cust_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1048:
1049: IF G_debug_flag = 'Y'
1050: THEN
1051: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1052: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1053: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1054: END IF;
1055:

Line 1052: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));

1048:
1049: IF G_debug_flag = 'Y'
1050: THEN
1051: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1052: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1053: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1054: END IF;
1055:
1056: FOR i IN l_start..l_end

Line 1053: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');

1049: IF G_debug_flag = 'Y'
1050: THEN
1051: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1052: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1053: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1054: END IF;
1055:
1056: FOR i IN l_start..l_end
1057: LOOP

Line 1094: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1090: FOR k IN 1..l_error_curr_tbl.COUNT
1091: LOOP
1092: IF G_debug_flag = 'Y'
1093: THEN
1094: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1095: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(k).usage_curr_code
1096: ||' and credit limit currency '
1097: ||p_limit_curr_code
1098: ||' is missing for conversion type '

Line 1095: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(k).usage_curr_code

1091: LOOP
1092: IF G_debug_flag = 'Y'
1093: THEN
1094: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1095: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(k).usage_curr_code
1096: ||' and credit limit currency '
1097: ||p_limit_curr_code
1098: ||' is missing for conversion type '
1099: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);

Line 1100: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1096: ||' and credit limit currency '
1097: ||p_limit_curr_code
1098: ||' is missing for conversion type '
1099: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);
1100: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1101: END IF;
1102: END LOOP;
1103:
1104: ---bug fix 2439029

Line 1151: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1147: FOR k IN 1..l_conversion_status.COUNT
1148: LOOP
1149: IF G_debug_flag = 'Y'
1150: THEN
1151: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1152: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_conversion_status(k).usage_curr_code
1153: ||' and credit limit currency '
1154: ||p_limit_curr_code
1155: ||' is missing for conversion type '

Line 1152: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_conversion_status(k).usage_curr_code

1148: LOOP
1149: IF G_debug_flag = 'Y'
1150: THEN
1151: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1152: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_conversion_status(k).usage_curr_code
1153: ||' and credit limit currency '
1154: ||p_limit_curr_code
1155: ||' is missing for conversion type '
1156: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);

Line 1157: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1153: ||' and credit limit currency '
1154: ||p_limit_curr_code
1155: ||' is missing for conversion type '
1156: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);
1157: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1158: END IF;
1159: END LOOP;
1160:
1161: ---bug fix 2439029

Line 1195: OE_DEBUG_PUB.ADD ('Exception : No org id via site_id ', 1);

1191:
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN
1194: IF G_debug_flag = 'Y' THEN
1195: OE_DEBUG_PUB.ADD ('Exception : No org id via site_id ', 1);
1196: END IF;
1197:
1198: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1199: THEN

Line 1208: OE_DEBUG_PUB.ADD ('Exception : Unexpected error in finding org id via site_id ', 1);

1204: END IF;
1205:
1206: WHEN OTHERS THEN
1207: IF G_debug_flag = 'Y' THEN
1208: OE_DEBUG_PUB.ADD ('Exception : Unexpected error in finding org id via site_id ', 1);
1209: END IF;
1210:
1211: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1212: THEN

Line 1258: OE_DEBUG_PUB.ADD('currency_code=: '||l_usage_curr_tbl(a).usage_curr_code);

1254: FOR a IN 1..l_usage_curr_tbl.COUNT
1255: LOOP
1256: IF G_debug_flag = 'Y'
1257: THEN
1258: OE_DEBUG_PUB.ADD('currency_code=: '||l_usage_curr_tbl(a).usage_curr_code);
1259: END IF;
1260: END LOOP;
1261: --------------------------------------------------------------------------------
1262:

Line 1269: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));

1265: l_end := OE_Credit_Engine_GRP.G_site_curr_tbl.COUNT+l_usage_curr_tbl.COUNT;
1266:
1267: IF G_debug_flag = 'Y'
1268: THEN
1269: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1270: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1271: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1272: OE_DEBUG_PUB.ADD('table of currencies:');
1273: END IF;

Line 1270: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));

1266:
1267: IF G_debug_flag = 'Y'
1268: THEN
1269: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1270: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1271: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1272: OE_DEBUG_PUB.ADD('table of currencies:');
1273: END IF;
1274:

Line 1271: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');

1267: IF G_debug_flag = 'Y'
1268: THEN
1269: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1270: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1271: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1272: OE_DEBUG_PUB.ADD('table of currencies:');
1273: END IF;
1274:
1275: FOR i IN l_start..l_end

Line 1272: OE_DEBUG_PUB.ADD('table of currencies:');

1268: THEN
1269: OE_DEBUG_PUB.ADD('l_start= '||TO_CHAR(l_start));
1270: OE_DEBUG_PUB.ADD('l_end= '||TO_CHAR(l_end));
1271: OE_DEBUG_PUB.ADD('IN loop for assign table of usages to Global variable ');
1272: OE_DEBUG_PUB.ADD('table of currencies:');
1273: END IF;
1274:
1275: FOR i IN l_start..l_end
1276: LOOP

Line 1284: OE_DEBUG_PUB.ADD('currency= '||l_usage_curr_tbl(j).usage_curr_code);

1280: := l_usage_curr_tbl(j).usage_curr_code;
1281:
1282: IF G_debug_flag = 'Y'
1283: THEN
1284: OE_DEBUG_PUB.ADD('currency= '||l_usage_curr_tbl(j).usage_curr_code);
1285: END IF;
1286: END LOOP;
1287:
1288:

Line 1318: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1314: FOR f IN 1..l_error_curr_tbl.COUNT
1315: LOOP
1316: IF G_debug_flag = 'Y'
1317: THEN
1318: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1319: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(f).usage_curr_code
1320: ||' and credit limit currency '
1321: ||p_limit_curr_code
1322: ||' is missing for conversion type '

Line 1319: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(f).usage_curr_code

1315: LOOP
1316: IF G_debug_flag = 'Y'
1317: THEN
1318: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1319: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_error_curr_tbl(f).usage_curr_code
1320: ||' and credit limit currency '
1321: ||p_limit_curr_code
1322: ||' is missing for conversion type '
1323: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);

Line 1324: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1320: ||' and credit limit currency '
1321: ||p_limit_curr_code
1322: ||' is missing for conversion type '
1323: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);
1324: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1325: END IF;
1326: END LOOP;
1327:
1328: ---bug fix 2439029

Line 1375: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1371: FOR f IN 1..l_conversion_status.COUNT
1372: LOOP
1373: IF G_debug_flag = 'Y'
1374: THEN
1375: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1376: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_conversion_status(f).usage_curr_code
1377: ||' and credit limit currency '
1378: ||p_limit_curr_code
1379: ||' is missing for conversion type '

Line 1376: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_conversion_status(f).usage_curr_code

1372: LOOP
1373: IF G_debug_flag = 'Y'
1374: THEN
1375: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1376: OE_DEBUG_PUB.ADD('!!!!! Exchange rate between '||l_conversion_status(f).usage_curr_code
1377: ||' and credit limit currency '
1378: ||p_limit_curr_code
1379: ||' is missing for conversion type '
1380: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);

Line 1381: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');

1377: ||' and credit limit currency '
1378: ||p_limit_curr_code
1379: ||' is missing for conversion type '
1380: || NVL(l_credit_check_rule_rec.user_conversion_type,'Corporate'),1);
1381: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
1382: END IF;
1383: END LOOP;
1384:
1385: ---bug fix 2439029

Line 1405: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Get_Customer_Exposure with the status='||x_return_status);

1401: END IF;
1402:
1403: IF G_debug_flag = 'Y'
1404: THEN
1405: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Get_Customer_Exposure with the status='||x_return_status);
1406: END IF;
1407:
1408: EXCEPTION
1409:

Line 1469: OE_DEBUG_PUB.ADD(' Into Get_customer_exposure ');

1465: BEGIN
1466:
1467: IF G_debug_flag = 'Y'
1468: THEN
1469: OE_DEBUG_PUB.ADD(' Into Get_customer_exposure ');
1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');
1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );

Line 1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');

1466:
1467: IF G_debug_flag = 'Y'
1468: THEN
1469: OE_DEBUG_PUB.ADD(' Into Get_customer_exposure ');
1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');
1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );

Line 1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );

1467: IF G_debug_flag = 'Y'
1468: THEN
1469: OE_DEBUG_PUB.ADD(' Into Get_customer_exposure ');
1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');
1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1475:

Line 1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );

1468: THEN
1469: OE_DEBUG_PUB.ADD(' Into Get_customer_exposure ');
1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');
1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1475:
1476: END IF;

Line 1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );

1469: OE_DEBUG_PUB.ADD(' Into Get_customer_exposure ');
1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');
1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1475:
1476: END IF;
1477:

Line 1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );

1470: OE_DEBUG_PUB.ADD(' Calling Get_customer_exposure with details');
1471: OE_DEBUG_PUB.ADD('p_customer_id => '|| p_customer_id );
1472: OE_DEBUG_PUB.ADD('p_site_id => '|| p_site_id );
1473: OE_DEBUG_PUB.ADD('p_limit_curr_code => '|| p_limit_curr_code );
1474: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1475:
1476: END IF;
1477:
1478: OE_CREDIT_ENGINE_GRP.Get_customer_exposure

Line 1495: OE_DEBUG_PUB.ADD(' Out x_total_exposure => '|| x_total_exposure );

1491: );
1492:
1493: IF G_debug_flag = 'Y'
1494: THEN
1495: OE_DEBUG_PUB.ADD(' Out x_total_exposure => '|| x_total_exposure );
1496: OE_DEBUG_PUB.ADD(' Out x_return_status => '|| x_return_status );
1497: OE_DEBUG_PUB.ADD(' Out Get_customer_exposure');
1498: END IF;
1499:

Line 1496: OE_DEBUG_PUB.ADD(' Out x_return_status => '|| x_return_status );

1492:
1493: IF G_debug_flag = 'Y'
1494: THEN
1495: OE_DEBUG_PUB.ADD(' Out x_total_exposure => '|| x_total_exposure );
1496: OE_DEBUG_PUB.ADD(' Out x_return_status => '|| x_return_status );
1497: OE_DEBUG_PUB.ADD(' Out Get_customer_exposure');
1498: END IF;
1499:
1500: EXCEPTION

Line 1497: OE_DEBUG_PUB.ADD(' Out Get_customer_exposure');

1493: IF G_debug_flag = 'Y'
1494: THEN
1495: OE_DEBUG_PUB.ADD(' Out x_total_exposure => '|| x_total_exposure );
1496: OE_DEBUG_PUB.ADD(' Out x_return_status => '|| x_return_status );
1497: OE_DEBUG_PUB.ADD(' Out Get_customer_exposure');
1498: END IF;
1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN

Line 1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);

1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555:
1556: IF G_debug_flag = 'Y'
1557: THEN
1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);
1559: OE_DEBUG_PUB.ADD('Input parameters list ');
1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );

Line 1559: OE_DEBUG_PUB.ADD('Input parameters list ');

1555:
1556: IF G_debug_flag = 'Y'
1557: THEN
1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);
1559: OE_DEBUG_PUB.ADD('Input parameters list ');
1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );

Line 1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );

1556: IF G_debug_flag = 'Y'
1557: THEN
1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);
1559: OE_DEBUG_PUB.ADD('Input parameters list ');
1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1564: END IF;

Line 1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );

1557: THEN
1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);
1559: OE_DEBUG_PUB.ADD('Input parameters list ');
1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1564: END IF;
1565:

Line 1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );

1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);
1559: OE_DEBUG_PUB.ADD('Input parameters list ');
1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1564: END IF;
1565:
1566: OE_Credit_Engine_GRP.G_delayed_request := NULL ;

Line 1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );

1559: OE_DEBUG_PUB.ADD('Input parameters list ');
1560: OE_DEBUG_PUB.ADD('p_header_id = '|| p_header_id,1 );
1561: OE_DEBUG_PUB.ADD('p_delayed_request = '|| p_delayed_request,1 );
1562: OE_DEBUG_PUB.ADD('p_calling_action = '|| p_calling_action,1 );
1563: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
1564: END IF;
1565:
1566: OE_Credit_Engine_GRP.G_delayed_request := NULL ;
1567: OE_Credit_Engine_GRP.G_currency_error_msg := NULL ;

Line 1598: OE_DEBUG_PUB.ADD('after query header ');

1594: END IF;
1595:
1596: IF G_debug_flag = 'Y'
1597: THEN
1598: OE_DEBUG_PUB.ADD('after query header ');
1599: OE_DEBUG_PUB.ADD(' ');
1600: OE_DEBUG_PUB.ADD('======================================');
1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1602: OE_DEBUG_PUB.ADD('order_category_code = '||

Line 1599: OE_DEBUG_PUB.ADD(' ');

1595:
1596: IF G_debug_flag = 'Y'
1597: THEN
1598: OE_DEBUG_PUB.ADD('after query header ');
1599: OE_DEBUG_PUB.ADD(' ');
1600: OE_DEBUG_PUB.ADD('======================================');
1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1602: OE_DEBUG_PUB.ADD('order_category_code = '||
1603: l_header_rec.order_category_code );

Line 1600: OE_DEBUG_PUB.ADD('======================================');

1596: IF G_debug_flag = 'Y'
1597: THEN
1598: OE_DEBUG_PUB.ADD('after query header ');
1599: OE_DEBUG_PUB.ADD(' ');
1600: OE_DEBUG_PUB.ADD('======================================');
1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1602: OE_DEBUG_PUB.ADD('order_category_code = '||
1603: l_header_rec.order_category_code );
1604: OE_DEBUG_PUB.ADD('Booked flag = '||

Line 1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );

1597: THEN
1598: OE_DEBUG_PUB.ADD('after query header ');
1599: OE_DEBUG_PUB.ADD(' ');
1600: OE_DEBUG_PUB.ADD('======================================');
1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1602: OE_DEBUG_PUB.ADD('order_category_code = '||
1603: l_header_rec.order_category_code );
1604: OE_DEBUG_PUB.ADD('Booked flag = '||
1605: l_header_rec.booked_flag );

Line 1602: OE_DEBUG_PUB.ADD('order_category_code = '||

1598: OE_DEBUG_PUB.ADD('after query header ');
1599: OE_DEBUG_PUB.ADD(' ');
1600: OE_DEBUG_PUB.ADD('======================================');
1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1602: OE_DEBUG_PUB.ADD('order_category_code = '||
1603: l_header_rec.order_category_code );
1604: OE_DEBUG_PUB.ADD('Booked flag = '||
1605: l_header_rec.booked_flag );
1606: OE_DEBUG_PUB.ADD('Order number = '||

Line 1604: OE_DEBUG_PUB.ADD('Booked flag = '||

1600: OE_DEBUG_PUB.ADD('======================================');
1601: OE_DEBUG_PUB.ADD('Header ID = '|| l_header_rec.header_id );
1602: OE_DEBUG_PUB.ADD('order_category_code = '||
1603: l_header_rec.order_category_code );
1604: OE_DEBUG_PUB.ADD('Booked flag = '||
1605: l_header_rec.booked_flag );
1606: OE_DEBUG_PUB.ADD('Order number = '||
1607: l_header_rec.order_number );
1608: --OE_DEBUG_PUB.ADD('Credit crad approval date = '||

Line 1606: OE_DEBUG_PUB.ADD('Order number = '||

1602: OE_DEBUG_PUB.ADD('order_category_code = '||
1603: l_header_rec.order_category_code );
1604: OE_DEBUG_PUB.ADD('Booked flag = '||
1605: l_header_rec.booked_flag );
1606: OE_DEBUG_PUB.ADD('Order number = '||
1607: l_header_rec.order_number );
1608: --OE_DEBUG_PUB.ADD('Credit crad approval date = '||
1609: -- l_header_rec.credit_card_approval_date );
1610: OE_DEBUG_PUB.ADD('payment_term_id = ' ||

Line 1608: --OE_DEBUG_PUB.ADD('Credit crad approval date = '||

1604: OE_DEBUG_PUB.ADD('Booked flag = '||
1605: l_header_rec.booked_flag );
1606: OE_DEBUG_PUB.ADD('Order number = '||
1607: l_header_rec.order_number );
1608: --OE_DEBUG_PUB.ADD('Credit crad approval date = '||
1609: -- l_header_rec.credit_card_approval_date );
1610: OE_DEBUG_PUB.ADD('payment_term_id = ' ||
1611: l_header_rec.payment_term_id );
1612: OE_DEBUG_PUB.ADD('order_type_id = '||

Line 1610: OE_DEBUG_PUB.ADD('payment_term_id = ' ||

1606: OE_DEBUG_PUB.ADD('Order number = '||
1607: l_header_rec.order_number );
1608: --OE_DEBUG_PUB.ADD('Credit crad approval date = '||
1609: -- l_header_rec.credit_card_approval_date );
1610: OE_DEBUG_PUB.ADD('payment_term_id = ' ||
1611: l_header_rec.payment_term_id );
1612: OE_DEBUG_PUB.ADD('order_type_id = '||
1613: l_header_rec.order_type_id );
1614: OE_DEBUG_PUB.ADD(' ');

Line 1612: OE_DEBUG_PUB.ADD('order_type_id = '||

1608: --OE_DEBUG_PUB.ADD('Credit crad approval date = '||
1609: -- l_header_rec.credit_card_approval_date );
1610: OE_DEBUG_PUB.ADD('payment_term_id = ' ||
1611: l_header_rec.payment_term_id );
1612: OE_DEBUG_PUB.ADD('order_type_id = '||
1613: l_header_rec.order_type_id );
1614: OE_DEBUG_PUB.ADD(' ');
1615: OE_DEBUG_PUB.ADD('======================================');
1616: END IF;

Line 1614: OE_DEBUG_PUB.ADD(' ');

1610: OE_DEBUG_PUB.ADD('payment_term_id = ' ||
1611: l_header_rec.payment_term_id );
1612: OE_DEBUG_PUB.ADD('order_type_id = '||
1613: l_header_rec.order_type_id );
1614: OE_DEBUG_PUB.ADD(' ');
1615: OE_DEBUG_PUB.ADD('======================================');
1616: END IF;
1617:
1618: IF p_credit_check_rule_id is NULL or

Line 1615: OE_DEBUG_PUB.ADD('======================================');

1611: l_header_rec.payment_term_id );
1612: OE_DEBUG_PUB.ADD('order_type_id = '||
1613: l_header_rec.order_type_id );
1614: OE_DEBUG_PUB.ADD(' ');
1615: OE_DEBUG_PUB.ADD('======================================');
1616: END IF;
1617:
1618: IF p_credit_check_rule_id is NULL or
1619: NVL(p_credit_check_rule_id,0) = 0

Line 1642: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '|| OE_Credit_Engine_GRP.GL_currency );

1638: END IF;
1639:
1640: IF G_debug_flag = 'Y'
1641: THEN
1642: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '|| OE_Credit_Engine_GRP.GL_currency );
1643: OE_DEBUG_PUB.ADD('l_credit_check_rule_id = '|| l_credit_check_rule_id );
1644: END IF;
1645:
1646: ----------------------- start Processing --------------------

Line 1643: OE_DEBUG_PUB.ADD('l_credit_check_rule_id = '|| l_credit_check_rule_id );

1639:
1640: IF G_debug_flag = 'Y'
1641: THEN
1642: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = '|| OE_Credit_Engine_GRP.GL_currency );
1643: OE_DEBUG_PUB.ADD('l_credit_check_rule_id = '|| l_credit_check_rule_id );
1644: END IF;
1645:
1646: ----------------------- start Processing --------------------
1647:

Line 1652: OE_DEBUG_PUB.ADD(' No credit check attached, return ');

1648: IF l_credit_check_rule_id is NULL
1649: THEN
1650: IF G_debug_flag = 'Y'
1651: THEN
1652: OE_DEBUG_PUB.ADD(' No credit check attached, return ');
1653: END IF;
1654: RETURN ;
1655: END IF;
1656:

Line 1672: OE_DEBUG_PUB.ADD('credit_check_level_code = '||

1668: );
1669:
1670: IF G_debug_flag = 'Y'
1671: THEN
1672: OE_DEBUG_PUB.ADD('credit_check_level_code = '||
1673: l_credit_check_rule_rec.credit_check_level_code );
1674: END IF;
1675:
1676: IF NVL(l_credit_check_rule_rec.credit_check_level_code,'ORDER')

Line 1694: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_credit ');

1690: );
1691:
1692: IF G_debug_flag = 'Y'
1693: THEN
1694: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_credit ');
1695: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1696: OE_DEBUG_PUB.ADD('x_result_out =>' || x_result_out );
1697: END IF;
1698:

Line 1695: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );

1691:
1692: IF G_debug_flag = 'Y'
1693: THEN
1694: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_credit ');
1695: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1696: OE_DEBUG_PUB.ADD('x_result_out =>' || x_result_out );
1697: END IF;
1698:
1699: ELSIF NVL(l_credit_check_rule_rec.credit_check_level_code,'ORDER')

Line 1696: OE_DEBUG_PUB.ADD('x_result_out =>' || x_result_out );

1692: IF G_debug_flag = 'Y'
1693: THEN
1694: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_credit ');
1695: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1696: OE_DEBUG_PUB.ADD('x_result_out =>' || x_result_out );
1697: END IF;
1698:
1699: ELSIF NVL(l_credit_check_rule_rec.credit_check_level_code,'ORDER')
1700: = 'LINE'

Line 1725: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_lines_credit ');

1721: ) ;
1722:
1723: IF G_debug_flag = 'Y'
1724: THEN
1725: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_lines_credit ');
1726: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1727: OE_DEBUG_PUB.ADD('x_result_out => '|| x_result_out );
1728: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1729: END IF;

Line 1726: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );

1722:
1723: IF G_debug_flag = 'Y'
1724: THEN
1725: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_lines_credit ');
1726: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1727: OE_DEBUG_PUB.ADD('x_result_out => '|| x_result_out );
1728: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1729: END IF;
1730: END IF;

Line 1727: OE_DEBUG_PUB.ADD('x_result_out => '|| x_result_out );

1723: IF G_debug_flag = 'Y'
1724: THEN
1725: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_lines_credit ');
1726: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1727: OE_DEBUG_PUB.ADD('x_result_out => '|| x_result_out );
1728: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1729: END IF;
1730: END IF;
1731:

Line 1728: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);

1724: THEN
1725: OE_DEBUG_PUB.ADD('OEXPCRGB: Out of Check_order_lines_credit ');
1726: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1727: OE_DEBUG_PUB.ADD('x_result_out => '|| x_result_out );
1728: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1729: END IF;
1730: END IF;
1731:
1732: -- Moved calling_action check to outside of status check

Line 1744: OE_DEBUG_PUB.ADD('Apply_exception_hold x_return_status => '

1740: );
1741:
1742: IF G_debug_flag = 'Y'
1743: THEN
1744: OE_DEBUG_PUB.ADD('Apply_exception_hold x_return_status => '
1745: || x_return_status );
1746: END IF;
1747:
1748: IF x_return_status = FND_API.G_RET_STS_SUCCESS

Line 1773: OE_DEBUG_PUB.ADD( ' x_return_status = '|| x_return_status );

1769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1770:
1771: IF G_debug_flag = 'Y'
1772: THEN
1773: OE_DEBUG_PUB.ADD( ' x_return_status = '|| x_return_status );
1774: OE_DEBUG_PUB.ADD( ' G_currency_error_msg = '||
1775: OE_Credit_Engine_GRP.G_currency_error_msg );
1776: END IF;
1777: END IF;

Line 1774: OE_DEBUG_PUB.ADD( ' G_currency_error_msg = '||

1770:
1771: IF G_debug_flag = 'Y'
1772: THEN
1773: OE_DEBUG_PUB.ADD( ' x_return_status = '|| x_return_status );
1774: OE_DEBUG_PUB.ADD( ' G_currency_error_msg = '||
1775: OE_Credit_Engine_GRP.G_currency_error_msg );
1776: END IF;
1777: END IF;
1778:

Line 1790: OE_DEBUG_PUB.ADD('after excp holds x_return_status => '

1786: END IF;
1787:
1788: IF G_debug_flag = 'Y'
1789: THEN
1790: OE_DEBUG_PUB.ADD('after excp holds x_return_status => '
1791: || x_return_status );
1792: OE_DEBUG_PUB.ADD('after excp holds x_result_out => '
1793: || x_result_out );
1794: OE_DEBUG_PUB.ADD('Check for notification send ' ) ;

Line 1792: OE_DEBUG_PUB.ADD('after excp holds x_result_out => '

1788: IF G_debug_flag = 'Y'
1789: THEN
1790: OE_DEBUG_PUB.ADD('after excp holds x_return_status => '
1791: || x_return_status );
1792: OE_DEBUG_PUB.ADD('after excp holds x_result_out => '
1793: || x_result_out );
1794: OE_DEBUG_PUB.ADD('Check for notification send ' ) ;
1795: END IF;
1796:

Line 1794: OE_DEBUG_PUB.ADD('Check for notification send ' ) ;

1790: OE_DEBUG_PUB.ADD('after excp holds x_return_status => '
1791: || x_return_status );
1792: OE_DEBUG_PUB.ADD('after excp holds x_result_out => '
1793: || x_result_out );
1794: OE_DEBUG_PUB.ADD('Check for notification send ' ) ;
1795: END IF;
1796:
1797: IF x_result_out = 'FAIL_HOLD' AND -- Bug 4506263 FP
1798: NVL(p_calling_action, 'BOOKING') NOT IN ('EXTERNAL', 'AUTO RELEASE')

Line 1812: OE_DEBUG_PUB.ADD('after call send_credit_hold_ntf ');

1808:
1809: IF G_debug_flag = 'Y'
1810: THEN
1811:
1812: OE_DEBUG_PUB.ADD('after call send_credit_hold_ntf ');
1813: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1814: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1815: END IF;
1816:

Line 1813: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );

1809: IF G_debug_flag = 'Y'
1810: THEN
1811:
1812: OE_DEBUG_PUB.ADD('after call send_credit_hold_ntf ');
1813: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1814: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1815: END IF;
1816:
1817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 1814: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);

1810: THEN
1811:
1812: OE_DEBUG_PUB.ADD('after call send_credit_hold_ntf ');
1813: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1814: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1815: END IF;
1816:
1817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1818: THEN

Line 1820: OE_DEBUG_PUB.ADD('send failed ');

1816:
1817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1818: THEN
1819:
1820: OE_DEBUG_PUB.ADD('send failed ');
1821:
1822: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1823:
1824: OE_DEBUG_PUB.ADD(' after assign x_return_status = '

Line 1824: OE_DEBUG_PUB.ADD(' after assign x_return_status = '

1820: OE_DEBUG_PUB.ADD('send failed ');
1821:
1822: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1823:
1824: OE_DEBUG_PUB.ADD(' after assign x_return_status = '
1825: || x_return_status );
1826: END IF;
1827:
1828:

Line 1832: OE_DEBUG_PUB.ADD('No need for sending notifications flag OFF or ignored',1);

1828:
1829: ELSE
1830: IF G_debug_flag = 'Y'
1831: THEN
1832: OE_DEBUG_PUB.ADD('No need for sending notifications flag OFF or ignored',1);
1833: END IF;
1834: END IF;
1835:
1836: END IF;

Line 1852: OE_DEBUG_PUB.ADD('Final x_return_status => '|| x_return_status );

1848: END IF;
1849:
1850: IF G_debug_flag = 'Y'
1851: THEN
1852: OE_DEBUG_PUB.ADD('Final x_return_status => '|| x_return_status );
1853: OE_DEBUG_PUB.ADD('Final x_result_out => '|| x_result_out );
1854: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Check_Credit ',1);
1855: END IF;
1856:

Line 1853: OE_DEBUG_PUB.ADD('Final x_result_out => '|| x_result_out );

1849:
1850: IF G_debug_flag = 'Y'
1851: THEN
1852: OE_DEBUG_PUB.ADD('Final x_return_status => '|| x_return_status );
1853: OE_DEBUG_PUB.ADD('Final x_result_out => '|| x_result_out );
1854: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Check_Credit ',1);
1855: END IF;
1856:
1857: Oe_Globals.G_calling_source:= 'WSH'; --8478151

Line 1854: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Check_Credit ',1);

1850: IF G_debug_flag = 'Y'
1851: THEN
1852: OE_DEBUG_PUB.ADD('Final x_return_status => '|| x_return_status );
1853: OE_DEBUG_PUB.ADD('Final x_result_out => '|| x_result_out );
1854: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Check_Credit ',1);
1855: END IF;
1856:
1857: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1858:

Line 1911: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Set_context ' );

1907: l_org_id NUMBER;
1908: --
1909: BEGIN
1910:
1911: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Set_context ' );
1912: BEGIN
1913:
1914: l_org_id := mo_global.get_current_org_id;
1915:

Line 1918: oe_debug_pub.add( 'OEXPCRGB: setting single org context to '|| l_org_id , 1 );

1914: l_org_id := mo_global.get_current_org_id;
1915:
1916: IF l_org_id IS NOT NULL THEN
1917: IF G_debug_flag = 'Y' THEN
1918: oe_debug_pub.add( 'OEXPCRGB: setting single org context to '|| l_org_id , 1 );
1919: END IF;
1920:
1921: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1922: ELSE

Line 1924: oe_debug_pub.add('OEXPCRGB: Unexpected error in setting org context where Customer Exposure flag is ''''N', 1 );

1920:
1921: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1922: ELSE
1923: IF G_debug_flag = 'Y' THEN
1924: oe_debug_pub.add('OEXPCRGB: Unexpected error in setting org context where Customer Exposure flag is ''''N', 1 );
1925: END IF;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: END IF;
1928:

Line 1944: OE_DEBUG_PUB.ADD(' Exception Set context');

1940: l_org_id := NULL ;
1941:
1942: OE_CREDIT_CHECK_UTIL.G_org_id := NULL ;
1943:
1944: OE_DEBUG_PUB.ADD(' Exception Set context');
1945: END ;
1946:
1947: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Set_context ' );
1948:

Line 1947: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Set_context ' );

1943:
1944: OE_DEBUG_PUB.ADD(' Exception Set context');
1945: END ;
1946:
1947: OE_DEBUG_PUB.ADD('OEXPCRGB: OUT Set_context ' );
1948:
1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: IF G_debug_flag = 'Y' THEN

Line 1952: OE_DEBUG_PUB.ADD ('Exception : Unexpected error from Set_Context ', 1);

1948:
1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: IF G_debug_flag = 'Y' THEN
1952: OE_DEBUG_PUB.ADD ('Exception : Unexpected error from Set_Context ', 1);
1953: END IF;
1954:
1955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1956: THEN