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

Line 25: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

21: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
22: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
23: BEGIN
24:
25: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
26:
27: -- Check for the following required fields on a booked order:
28: -- Order Number, Sold To Org, Invoice To Org,
29: -- Price List, Tax Exempt Flag, Sales Person, Order Date

Line 81: oe_debug_pub.add('p_header_rec.ship_to_org_id' || to_char(p_header_rec.ship_to_org_id),2);

77: -- Fix bug 1262790
78: -- Ship To Org and Payment Term are required only on regular or
79: -- MIXED orders, NOT on RETURN orders
80:
81: oe_debug_pub.add('p_header_rec.ship_to_org_id' || to_char(p_header_rec.ship_to_org_id),2);
82:
83: IF p_header_rec.order_category_code <>
84: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
85:

Line 217: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

213: */
214:
215: END IF; -- END of checks related to payment type
216:
217: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
218: EXCEPTION
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221:

Line 361: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.ENTITY',1);

357: AND ROWNUM = 1;
358:
359:
360: BEGIN
361: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.ENTITY',1);
362:
363: -- Check required attributes.
364: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
365: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

Line 375: oe_debug_pub.add('p_header_rec.order_type_id' || p_header_rec.order_type_id, 2);

371: -- Check rest of required attributes here.
372: ----------------------------------------------------------
373:
374:
375: oe_debug_pub.add('p_header_rec.order_type_id' || p_header_rec.order_type_id, 2);
376:
377: IF p_header_rec.order_type_id IS NULL
378: THEN
379: l_return_status := FND_API.G_RET_STS_ERROR;

Line 393: oe_debug_pub.add('p_header_rec.transactional_curr_code' || p_header_rec.transactional_curr_code, 2);

389:
390: --add messages
391:
392:
393: oe_debug_pub.add('p_header_rec.transactional_curr_code' || p_header_rec.transactional_curr_code, 2);
394:
395: IF p_header_rec.transactional_curr_code IS NULL
396: THEN
397: l_return_status := FND_API.G_RET_STS_ERROR;

Line 424: oe_debug_pub.add('p_header_rec.booked_flag' || p_header_rec.booked_flag, 2);

420:
421: -- Check attributes required for booked header
422:
423:
424: oe_debug_pub.add('p_header_rec.booked_flag' || p_header_rec.booked_flag, 2);
425:
426:
427: IF p_header_rec.booked_flag = 'Y' THEN
428:

Line 438: oe_debug_pub.add('p_header_rec.tax_exempt_flag' || p_header_rec.tax_exempt_flag, 2);

434: END IF;
435:
436: -- IF the Tax handling is "Exempt"
437:
438: oe_debug_pub.add('p_header_rec.tax_exempt_flag' || p_header_rec.tax_exempt_flag, 2);
439:
440: IF p_header_rec.tax_exempt_flag = 'E'
441: THEN
442: -- Check for Tax exempt reason

Line 498: oe_debug_pub.add('New price ' || p_header_rec.price_list_id,2);

494: ----------------------------------------------------------------
495: -- VALIDATE ATTRIBUTE DEPENDENCIES
496: ----------------------------------------------------------------
497:
498: oe_debug_pub.add('New price ' || p_header_rec.price_list_id,2);
499: oe_debug_pub.add('New curr ' || p_header_rec.transactional_curr_code,2);
500: -- Validate currency
501:
502: l_price_list_rec :=

Line 499: oe_debug_pub.add('New curr ' || p_header_rec.transactional_curr_code,2);

495: -- VALIDATE ATTRIBUTE DEPENDENCIES
496: ----------------------------------------------------------------
497:
498: oe_debug_pub.add('New price ' || p_header_rec.price_list_id,2);
499: oe_debug_pub.add('New curr ' || p_header_rec.transactional_curr_code,2);
500: -- Validate currency
501:
502: l_price_list_rec :=
503: OE_Order_Cache.Load_Price_List ( p_header_rec.price_list_id );

Line 506: oe_debug_pub.add('p_header_rec.price_list_id' || p_header_rec.price_list_id, 2);

502: l_price_list_rec :=
503: OE_Order_Cache.Load_Price_List ( p_header_rec.price_list_id );
504:
505:
506: oe_debug_pub.add('p_header_rec.price_list_id' || p_header_rec.price_list_id, 2);
507:
508:
509: IF p_header_rec.price_list_id IS NOT NULL
510: THEN

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

525:
526: -- Currency_date, currency_rate should be null when type is null.
527:
528:
529: oe_debug_pub.add('p_header_rec.Conversion_type_code' || p_header_rec.Conversion_type_code, 2);
530:
531: IF p_header_rec.Conversion_type_code IS NULL
532: THEN
533: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)

Line 557: oe_debug_pub.add('p_header_rec.ordered_date' || p_header_rec.ordered_date, 2);

553: OE_MSG_PUB.ADD;
554:
555: END IF; -- END of checks based on conversion type
556:
557: oe_debug_pub.add('p_header_rec.ordered_date' || p_header_rec.ordered_date, 2);
558:
559: -- Order Type has to be valid
560: BEGIN
561:

Line 600: oe_debug_pub.add('p_header_rec.agreement_id' || p_header_rec.agreement_id, 2);

596:
597: -- Agreement depends on Order Type AND Sold To Org
598:
599:
600: oe_debug_pub.add('p_header_rec.agreement_id' || p_header_rec.agreement_id, 2);
601:
602: IF p_header_rec.agreement_id IS NOT NULL THEN
603: -- commented by Geresh
604: -- l_agreement_rec :=

Line 641: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);

637: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
638: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
639: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
640: OE_MSG_PUB.Add;
641: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
642: raise FND_API.G_EXC_ERROR;
643: END IF;
644: END IF;
645:

Line 654: oe_debug_pub.add

650: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
651: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
652: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
653: OE_MSG_PUB.Add;
654: oe_debug_pub.add
655: ('No Data Found Agreement+price_list_id combination',2);
656: raise FND_API.G_EXC_ERROR;
657: END;
658:

Line 666: oe_debug_pub.add('p_header_rec.ship_to_org_id' || p_header_rec.ship_to_org_id, 2);

662: END IF; -- Agreement is not null
663:
664: -- Ship to Org id depends on sold to org.
665:
666: oe_debug_pub.add('p_header_rec.ship_to_org_id' || p_header_rec.ship_to_org_id, 2);
667:
668: IF p_header_rec.ship_to_org_id IS NOT NULL
669: THEN
670:

Line 672: oe_debug_pub.add

668: IF p_header_rec.ship_to_org_id IS NOT NULL
669: THEN
670:
671: BEGIN
672: oe_debug_pub.add
673: ('ship_to_org_id :'||to_char(p_header_rec.ship_to_org_id),2);
674: oe_debug_pub.add
675: ('Customer Relation :'||lcustomer_relations,2);
676:

Line 674: oe_debug_pub.add

670:
671: BEGIN
672: oe_debug_pub.add
673: ('ship_to_org_id :'||to_char(p_header_rec.ship_to_org_id),2);
674: oe_debug_pub.add
675: ('Customer Relation :'||lcustomer_relations,2);
676:
677: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
678:

Line 680: oe_debug_pub.add

676:
677: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
678:
679: IF nvl(lcustomer_relations,'N') = 'N' THEN
680: oe_debug_pub.add
681: ('Cr: No',2);
682:
683: SELECT 'VALID'
684: INTO l_dummy

Line 695: oe_debug_pub.add

691: --
692: -- AND status = 'A';
693:
694: ELSIF lcustomer_relations = 'Y' THEN
695: oe_debug_pub.add
696: ('Cr: Yes',2);
697:
698: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'
699: Into l_dummy

Line 730: oe_debug_pub.add

726:
727: /* added the following ELSIF condition to fix the bug 2002486 */
728:
729: ELSIF nvl(lcustomer_relations,'N') = 'A' THEN
730: oe_debug_pub.add
731: ('Cr: A',2);
732:
733: SELECT 'VALID'
734: INTO l_dummy

Line 740: oe_debug_pub.add

736: WHERE site_use_id = p_header_rec.ship_to_org_id
737: AND ROWNUM = 1;
738:
739:
740: oe_debug_pub.add
741: ('Cr: Yes- After the select',2);
742:
743: END IF;
744:

Line 751: oe_debug_pub.add

747:
748: EXCEPTION
749:
750: WHEN NO_DATA_FOUND THEN
751: oe_debug_pub.add
752: ('In: No data found',2);
753: l_return_status := FND_API.G_RET_STS_ERROR;
754: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name

Line 776: oe_debug_pub.add('p_header_rec.deliver_to_org_id'|| to_char(p_header_rec.deliver_to_org_id),2);

772:
773: END IF; -- Ship To needed validation.
774:
775: -- Deliver to Org id depends on sold to org.
776: oe_debug_pub.add('p_header_rec.deliver_to_org_id'|| to_char(p_header_rec.deliver_to_org_id),2);
777: IF p_header_rec.deliver_to_org_id IS NOT NULL
778: THEN
779:
780: BEGIN

Line 793: oe_debug_pub.add('Cr: Yes deliver',2);

789: AND ROWNUM = 1;
790:
791: ELSIF lcustomer_relations = 'Y' THEN
792:
793: oe_debug_pub.add('Cr: Yes deliver',2);
794:
795: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
796: Into l_dummy
797: FROM HZ_CUST_SITE_USES_ALL SITE,

Line 811: oe_debug_pub.add('Cr: Yes- After the select',2);

807: R.ORG_ID = ACCT_SITE.ORG_ID
808: AND R.RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
809: and R.ship_to_flag = 'Y')
810: AND ROWNUM = 1;
811: oe_debug_pub.add('Cr: Yes- After the select',2);
812:
813: ELSIF lcustomer_relations = 'A' THEN
814:
815: SELECT 'VALID'

Line 855: oe_debug_pub.add

851:
852: -- Invoice to Org id depends on sold to org.
853:
854:
855: oe_debug_pub.add
856: ('invoice_to_org_id :'||to_char(p_header_rec.invoice_to_org_id),2);
857:
858: IF p_header_rec.invoice_to_org_id IS NOT NULL
859: THEN

Line 861: oe_debug_pub.add

857:
858: IF p_header_rec.invoice_to_org_id IS NOT NULL
859: THEN
860: BEGIN
861: oe_debug_pub.add
862: ('invoice_to_org_id :'||to_char(p_header_rec.invoice_to_org_id),2);
863:
864: IF nvl(lcustomer_relations,'N') = 'N' THEN
865:

Line 904: oe_debug_pub.add

900:
901: /* added the following ELSIF condition to fix the bug 2002486 */
902:
903: ELSIF nvl(lcustomer_relations,'N') = 'A' THEN
904: oe_debug_pub.add
905: ('Cr: A',2);
906:
907: SELECT 'VALID'
908: INTO l_dummy

Line 942: oe_debug_pub.add('p_header_rec.sold_to_site_use_id'|| to_char(p_header_rec.sold_to_site_use_id),2);

938:
939: END IF; -- Invoice to org needed validation.
940:
941: -- Customer Location depends on Sold To Org
942: oe_debug_pub.add('p_header_rec.sold_to_site_use_id'|| to_char(p_header_rec.sold_to_site_use_id),2);
943: IF p_header_rec.sold_to_site_use_id IS NOT NULL
944: THEN
945:
946: BEGIN

Line 984: oe_debug_pub.add('p_header_rec.sold_to_contact_id'|| to_char(p_header_rec.sold_to_contact_id),2);

980: END; -- BEGIN
981:
982: END IF; --
983: -- Sold to contact depends on Sold To Org
984: oe_debug_pub.add('p_header_rec.sold_to_contact_id'|| to_char(p_header_rec.sold_to_contact_id),2);
985: IF p_header_rec.sold_to_contact_id IS NOT NULL
986: THEN
987:
988: BEGIN

Line 1029: oe_debug_pub.add('p_header_rec.invoice_to_contact_id'|| to_char(p_header_rec.invoice_to_contact_id),2);

1025: END IF; -- Sold to contact needed validation.
1026:
1027:
1028: -- Invoice to contact depends on Invoice To Org
1029: oe_debug_pub.add('p_header_rec.invoice_to_contact_id'|| to_char(p_header_rec.invoice_to_contact_id),2);
1030: IF p_header_rec.invoice_to_contact_id IS NOT NULL
1031: THEN
1032: BEGIN
1033: oe_debug_pub.add

Line 1033: oe_debug_pub.add

1029: oe_debug_pub.add('p_header_rec.invoice_to_contact_id'|| to_char(p_header_rec.invoice_to_contact_id),2);
1030: IF p_header_rec.invoice_to_contact_id IS NOT NULL
1031: THEN
1032: BEGIN
1033: oe_debug_pub.add
1034: ('inv_to_contact :'||to_char(p_header_rec.invoice_to_contact_id),2);
1035:
1036: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1037: INTO l_dummy

Line 1081: oe_debug_pub.add('p_header_rec.ship_to_contact_id'|| to_char(p_header_rec.ship_to_contact_id),2);

1077: END IF; -- Invoice to contact needed validation.
1078:
1079:
1080: -- Ship to contact depends on Ship To Org
1081: oe_debug_pub.add('p_header_rec.ship_to_contact_id'|| to_char(p_header_rec.ship_to_contact_id),2);
1082: IF p_header_rec.ship_to_contact_id IS NOT NULL
1083: THEN
1084:
1085: BEGIN

Line 1136: oe_debug_pub.add('p_header_rec.deliver_to_contact_id' || to_char(p_header_rec.deliver_to_contact_id),2);

1132: END IF; -- Ship to contact needed validation.
1133:
1134:
1135: -- Deliver to contact depends on Deliver To Org
1136: oe_debug_pub.add('p_header_rec.deliver_to_contact_id' || to_char(p_header_rec.deliver_to_contact_id),2);
1137: IF p_header_rec.deliver_to_contact_id IS NOT NULL
1138: THEN
1139:
1140: BEGIN

Line 1188: oe_debug_pub.add('p_header_rec.tax_exempt_number'|| p_header_rec.tax_exempt_number,2);

1184:
1185:
1186: -- Check for Tax Exempt number/Tax exempt reason code IF the Tax exempt
1187: -- flag is 'S' (StANDard).
1188: oe_debug_pub.add('p_header_rec.tax_exempt_number'|| p_header_rec.tax_exempt_number,2);
1189: oe_debug_pub.add('p_header_rec.tax_exempt_flag'|| p_header_rec.tax_exempt_flag,2);
1190: IF p_header_rec.tax_exempt_flag IS NOT NULL
1191: THEN
1192:

Line 1189: oe_debug_pub.add('p_header_rec.tax_exempt_flag'|| p_header_rec.tax_exempt_flag,2);

1185:
1186: -- Check for Tax Exempt number/Tax exempt reason code IF the Tax exempt
1187: -- flag is 'S' (StANDard).
1188: oe_debug_pub.add('p_header_rec.tax_exempt_number'|| p_header_rec.tax_exempt_number,2);
1189: oe_debug_pub.add('p_header_rec.tax_exempt_flag'|| p_header_rec.tax_exempt_flag,2);
1190: IF p_header_rec.tax_exempt_flag IS NOT NULL
1191: THEN
1192:
1193: BEGIN

Line 1312: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_HEADER.ENTITY',1);

1308:
1309: -- Done validating entity
1310: x_return_status := l_return_status;
1311:
1312: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_HEADER.ENTITY',1);
1313:
1314: EXCEPTION
1315:
1316: WHEN FND_API.G_EXC_ERROR THEN

Line 1350: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);

1346: )
1347: IS
1348: BEGIN
1349:
1350: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);
1351:
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353: -- validate Sales agreements Attributes
1354: IF p_x_header_rec.Blanket_number IS NOT NULL

Line 2291: oe_debug_pub.add('Before calling header_desc_flex',2);

2287: OR p_x_header_rec.attribute9 IS NOT NULL
2288: OR p_x_header_rec.context IS NOT NULL
2289: THEN
2290: --
2291: oe_debug_pub.add('Before calling header_desc_flex',2);
2292: IF NOT OE_CNCL_VALIDATE.Header_Desc_Flex
2293: (p_context => p_x_header_rec.context
2294: ,p_attribute1 => p_x_header_rec.attribute1
2295: ,p_attribute2 => p_x_header_rec.attribute2

Line 2375: oe_debug_pub.add('After header_desc_flex ' || x_return_status,2);

2371: END IF;
2372: --
2373: END IF;
2374: --
2375: oe_debug_pub.add('After header_desc_flex ' || x_return_status,2);
2376: --
2377: IF p_x_header_rec.global_attribute1 IS NOT NULL
2378: OR p_x_header_rec.global_attribute10 IS NOT NULL
2379: OR p_x_header_rec.global_attribute11 IS NOT NULL

Line 2401: OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);

2397: OR p_x_header_rec.global_attribute_category IS NOT NULL
2398: THEN
2399:
2400: --
2401: OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);
2402: IF NOT OE_CNCL_VALIDATE.G_Header_Desc_Flex
2403: (p_context => p_x_header_rec.global_attribute_category
2404: ,p_attribute1 => p_x_header_rec.global_attribute1
2405: ,p_attribute2 => p_x_header_rec.global_attribute2

Line 2485: OE_DEBUG_PUB.ADD('After G_header_desc_flex ' || x_return_status,2);

2481: END IF;
2482: --
2483:
2484: --
2485: OE_DEBUG_PUB.ADD('After G_header_desc_flex ' || x_return_status,2);
2486: -- Done validating attributes
2487:
2488: -- Salesrep_id
2489: IF p_x_header_rec.salesrep_id IS NOT NULL THEN

Line 2586: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);

2582: END IF;
2583: --
2584: END IF;
2585: --
2586: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);
2587:
2588: EXCEPTION
2589:
2590: WHEN FND_API.G_EXC_ERROR THEN