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

Line 132: --oe_debug_pub.add('Srini 101 header sold_to_org_id '||aSqlItem.SOLD_TO_ORG_ID);

128: aSqlItem.SHIP_TO_ORG_ID := aPlsqlItem.SHIP_TO_ORG_ID;
129: aSqlItem.SOLD_FROM_ORG_ID := aPlsqlItem.SOLD_FROM_ORG_ID;
130: aSqlItem.SOLD_TO_CONTACT_ID := aPlsqlItem.SOLD_TO_CONTACT_ID;
131: aSqlItem.SOLD_TO_ORG_ID := aPlsqlItem.SOLD_TO_ORG_ID;
132: --oe_debug_pub.add('Srini 101 header sold_to_org_id '||aSqlItem.SOLD_TO_ORG_ID);
133: aSqlItem.SOLD_TO_PHONE_ID := aPlsqlItem.SOLD_TO_PHONE_ID;
134: aSqlItem.SOURCE_DOCUMENT_ID := aPlsqlItem.SOURCE_DOCUMENT_ID;
135: aSqlItem.SOURCE_DOCUMENT_TYPE_ID := aPlsqlItem.SOURCE_DOCUMENT_TYPE_ID;
136: aSqlItem.TAX_EXEMPT_FLAG := aPlsqlItem.TAX_EXEMPT_FLAG;

Line 367: --oe_debug_pub.add('Srini 102 header sold_to_org_id '||aPlsqlItem.SOLD_TO_ORG_ID);

363: aPlsqlItem.SHIP_TO_ORG_ID := aSqlItem.SHIP_TO_ORG_ID;
364: aPlsqlItem.SOLD_FROM_ORG_ID := aSqlItem.SOLD_FROM_ORG_ID;
365: aPlsqlItem.SOLD_TO_CONTACT_ID := aSqlItem.SOLD_TO_CONTACT_ID;
366: aPlsqlItem.SOLD_TO_ORG_ID := aSqlItem.SOLD_TO_ORG_ID;
367: --oe_debug_pub.add('Srini 102 header sold_to_org_id '||aPlsqlItem.SOLD_TO_ORG_ID);
368: aPlsqlItem.SOLD_TO_PHONE_ID := aSqlItem.SOLD_TO_PHONE_ID;
369: aPlsqlItem.SOURCE_DOCUMENT_ID := aSqlItem.SOURCE_DOCUMENT_ID;
370: aPlsqlItem.SOURCE_DOCUMENT_TYPE_ID := aSqlItem.SOURCE_DOCUMENT_TYPE_ID;
371: aPlsqlItem.TAX_EXEMPT_FLAG := aSqlItem.TAX_EXEMPT_FLAG;

Line 478: oe_debug_pub.add('Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);

474: aPlsqlItem.INVOICE_TO_PARTY_NUMBER := aSqlItem.INVOICE_TO_PARTY_NUMBER;
475: aPlsqlItem.DELIVER_TO_PARTY_NUMBER := aSqlItem.DELIVER_TO_PARTY_NUMBER;
476: aPlsqlItem.ORDER_FIRMED_DATE := aSqlItem.ORDER_FIRMED_DATE;
477:
478: oe_debug_pub.add('Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
479: OE_GENESIS_UTIL.Convert_hdr_null_to_miss(aPlsqlItem);
480: -- Convert_hdr_null_to_miss(aPlsqlItem);
481: --convert_hdr_null_to_miss(aPlsqlItem);
482: oe_debug_pub.add('After Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);

Line 482: oe_debug_pub.add('After Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);

478: oe_debug_pub.add('Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
479: OE_GENESIS_UTIL.Convert_hdr_null_to_miss(aPlsqlItem);
480: -- Convert_hdr_null_to_miss(aPlsqlItem);
481: --convert_hdr_null_to_miss(aPlsqlItem);
482: oe_debug_pub.add('After Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
483:
484: RETURN aPlsqlItem;
485: END SQL_TO_PL1;
486:

Line 1921: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);

1917: aPlsqlItem.OPERATION := aSqlItem.OPERATION;
1918: aPlsqlItem.DEFER_PAYMENT_PROCESSING_FLAG := aSqlItem.DEFER_PAYMENT_PROCESSING_FLAG;
1919: aPlsqlItem.LOCK_CONTROL := aSqlItem.LOCK_CONTROL;
1920:
1921: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
1922: OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss(aPlsqlItem);
1923: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
1924:
1925: RETURN aPlsqlItem;

Line 1923: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);

1919: aPlsqlItem.LOCK_CONTROL := aSqlItem.LOCK_CONTROL;
1920:
1921: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
1922: OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss(aPlsqlItem);
1923: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
1924:
1925: RETURN aPlsqlItem;
1926: END SQL_TO_PL33;
1927:

Line 2269: --oe_debug_pub.add('Srini 103 header sold_to_org_id '||aSqlItem.SOLD_TO_ORG_ID);

2265: aSqlItem.SHIP_TOLERANCE_BELOW := aPlsqlItem.SHIP_TOLERANCE_BELOW;
2266: aSqlItem.SHIP_TO_CONTACT_ID := aPlsqlItem.SHIP_TO_CONTACT_ID;
2267: aSqlItem.SHIP_TO_ORG_ID := aPlsqlItem.SHIP_TO_ORG_ID;
2268: aSqlItem.SOLD_TO_ORG_ID := aPlsqlItem.SOLD_TO_ORG_ID;
2269: --oe_debug_pub.add('Srini 103 header sold_to_org_id '||aSqlItem.SOLD_TO_ORG_ID);
2270: aSqlItem.SOLD_FROM_ORG_ID := aPlsqlItem.SOLD_FROM_ORG_ID;
2271: aSqlItem.SORT_ORDER := aPlsqlItem.SORT_ORDER;
2272: aSqlItem.SOURCE_DOCUMENT_ID := aPlsqlItem.SOURCE_DOCUMENT_ID;
2273: aSqlItem.SOURCE_DOCUMENT_LINE_ID := aPlsqlItem.SOURCE_DOCUMENT_LINE_ID;

Line 2442: oe_debug_pub.add('Inside the SQL_TO_PL35', 1);

2438: RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
2439: aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
2440: BEGIN
2441:
2442: oe_debug_pub.add('Inside the SQL_TO_PL35', 1);
2443:
2444: aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
2445: aPlsqlItem.ACTUAL_ARRIVAL_DATE := aSqlItem.ACTUAL_ARRIVAL_DATE;
2446: aPlsqlItem.ACTUAL_SHIPMENT_DATE := aSqlItem.ACTUAL_SHIPMENT_DATE;

Line 2688: --oe_debug_pub.add('Srini 104 header sold_to_org_id '||aPlsqlItem.SOLD_TO_ORG_ID);

2684: aPlsqlItem.SHIP_TOLERANCE_BELOW := aSqlItem.SHIP_TOLERANCE_BELOW;
2685: aPlsqlItem.SHIP_TO_CONTACT_ID := aSqlItem.SHIP_TO_CONTACT_ID;
2686: aPlsqlItem.SHIP_TO_ORG_ID := aSqlItem.SHIP_TO_ORG_ID;
2687: aPlsqlItem.SOLD_TO_ORG_ID := aSqlItem.SOLD_TO_ORG_ID;
2688: --oe_debug_pub.add('Srini 104 header sold_to_org_id '||aPlsqlItem.SOLD_TO_ORG_ID);
2689: aPlsqlItem.SOLD_FROM_ORG_ID := aSqlItem.SOLD_FROM_ORG_ID;
2690: aPlsqlItem.SORT_ORDER := aSqlItem.SORT_ORDER;
2691: aPlsqlItem.SOURCE_DOCUMENT_ID := aSqlItem.SOURCE_DOCUMENT_ID;
2692: aPlsqlItem.SOURCE_DOCUMENT_LINE_ID := aSqlItem.SOURCE_DOCUMENT_LINE_ID;

Line 2854: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload Before Convert_Line_null_to_miss');

2850: aPlsqlItem.ACTUAL_FULFILLMENT_DATE := aSqlItem.ACTUAL_FULFILLMENT_DATE;
2851: aPlsqlItem.CHANGED_LINES_POCAO := aSqlItem.CHANGED_LINES_POCAO;
2852: aPlsqlItem.CHARGE_PERIODICITY_CODE := aSqlItem.CHARGE_PERIODICITY_CODE;
2853:
2854: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload Before Convert_Line_null_to_miss');
2855: -- OE_GENESIS_UTIL.print_po_payload(
2856: -- P_HEADER_REC_,
2857: -- P_HEADER_VAL_REC_,
2858: -- P_HEADER_PAYMENT_TBL_,

Line 2862: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);

2858: -- P_HEADER_PAYMENT_TBL_,
2859: -- P_LINE_TBL_
2860: -- );
2861:
2862: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
2863: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);
2864: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');
2865: -- OE_GENESIS_UTIL.print_po_payload(
2866: -- P_HEADER_REC_,

Line 2864: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');

2860: -- );
2861:
2862: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
2863: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);
2864: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');
2865: -- OE_GENESIS_UTIL.print_po_payload(
2866: -- P_HEADER_REC_,
2867: -- P_HEADER_VAL_REC_,
2868: -- P_HEADER_PAYMENT_TBL_,

Line 2873: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);

2869: -- P_LINE_TBL_
2870: -- );
2871:
2872: -- convert_line_null_to_miss(aPlsqlItem);
2873: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
2874:
2875: RETURN aPlsqlItem;
2876: END SQL_TO_PL35;
2877:

Line 2898: oe_debug_pub.add('Inside SQL_TO_PL12', 1);

2894: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
2895: BEGIN
2896: BEGIN
2897: FOR I IN 1..aSqlItem.COUNT LOOP
2898: oe_debug_pub.add('Inside SQL_TO_PL12', 1);
2899: aPlsqlItem(I) := SQL_TO_PL35(aSqlItem(I));
2900: --aPlsqlItem(1) := SQL_TO_PL35(aSqlItem(1));
2901: oe_debug_pub.add('After the call to SQL_TO_PL35', 1);
2902: END LOOP;

Line 2901: oe_debug_pub.add('After the call to SQL_TO_PL35', 1);

2897: FOR I IN 1..aSqlItem.COUNT LOOP
2898: oe_debug_pub.add('Inside SQL_TO_PL12', 1);
2899: aPlsqlItem(I) := SQL_TO_PL35(aSqlItem(I));
2900: --aPlsqlItem(1) := SQL_TO_PL35(aSqlItem(1));
2901: oe_debug_pub.add('After the call to SQL_TO_PL35', 1);
2902: END LOOP;
2903: EXCEPTION
2904: WHEN OTHERS THEN
2905: oe_debug_pub.add('EXCEPTION in SQL_TO_PL12', 1);

Line 2905: oe_debug_pub.add('EXCEPTION in SQL_TO_PL12', 1);

2901: oe_debug_pub.add('After the call to SQL_TO_PL35', 1);
2902: END LOOP;
2903: EXCEPTION
2904: WHEN OTHERS THEN
2905: oe_debug_pub.add('EXCEPTION in SQL_TO_PL12', 1);
2906: NULL;
2907: END;
2908: RETURN aPlsqlItem;
2909: END SQL_TO_PL12;

Line 4744: -- oe_debug_pub.add('Srini psu '

4740: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4741: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL48(aPlsqlItem(I));
4742: -- Oe_Inbound_Int.G_check_action_ret_status :=
4743: -- aSqlItem(1).return_status;
4744: -- oe_debug_pub.add('Srini psu '
4745: -- ||Oe_Inbound_Int.G_check_action_ret_status);
4746: END LOOP;
4747: end if;
4748: RETURN aSqlItem;

Line 4942: oe_debug_pub.initialize;

4938: L_MSG_COUNT NUMBER ;
4939: L_MSG_DATA VARCHAR2(2000);
4940:
4941: BEGIN
4942: oe_debug_pub.initialize;
4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
4944: oe_debug_pub.debug_on;
4945: oe_debug_pub.add('Inside the cover API');
4946: oe_debug_pub.add('222 Inside the cover API');

Line 4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');

4939: L_MSG_DATA VARCHAR2(2000);
4940:
4941: BEGIN
4942: oe_debug_pub.initialize;
4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
4944: oe_debug_pub.debug_on;
4945: oe_debug_pub.add('Inside the cover API');
4946: oe_debug_pub.add('222 Inside the cover API');
4947: --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);

Line 4944: oe_debug_pub.debug_on;

4940:
4941: BEGIN
4942: oe_debug_pub.initialize;
4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
4944: oe_debug_pub.debug_on;
4945: oe_debug_pub.add('Inside the cover API');
4946: oe_debug_pub.add('222 Inside the cover API');
4947: --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);
4948:

Line 4945: oe_debug_pub.add('Inside the cover API');

4941: BEGIN
4942: oe_debug_pub.initialize;
4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
4944: oe_debug_pub.debug_on;
4945: oe_debug_pub.add('Inside the cover API');
4946: oe_debug_pub.add('222 Inside the cover API');
4947: --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);
4948:
4949:

Line 4946: oe_debug_pub.add('222 Inside the cover API');

4942: oe_debug_pub.initialize;
4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
4944: oe_debug_pub.debug_on;
4945: oe_debug_pub.add('Inside the cover API');
4946: oe_debug_pub.add('222 Inside the cover API');
4947: --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);
4948:
4949:
4950: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);

Line 4947: --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);

4943: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
4944: oe_debug_pub.debug_on;
4945: oe_debug_pub.add('Inside the cover API');
4946: oe_debug_pub.add('222 Inside the cover API');
4947: --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);
4948:
4949:
4950: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);
4951: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);

Line 5008: oe_debug_pub.add('+++ Sales order under creation...');

5004: -- being created is a sales order. For quotes, we do not request
5005: -- booking.
5006: --
5007: IF ( Nvl(p_header_rec.transaction_phase_code, 'F') = 'F' ) THEN
5008: oe_debug_pub.add('+++ Sales order under creation...');
5009: -- Bug 7629966
5010: IF ( Nvl(p_header_rec.booked_flag, 'N') = 'Y' ) THEN
5011: oe_debug_pub.add('+++ Requesting booking...');
5012: p_action_request_tbl_(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

Line 5011: oe_debug_pub.add('+++ Requesting booking...');

5007: IF ( Nvl(p_header_rec.transaction_phase_code, 'F') = 'F' ) THEN
5008: oe_debug_pub.add('+++ Sales order under creation...');
5009: -- Bug 7629966
5010: IF ( Nvl(p_header_rec.booked_flag, 'N') = 'Y' ) THEN
5011: oe_debug_pub.add('+++ Requesting booking...');
5012: p_action_request_tbl_(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
5013: p_action_request_tbl_(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
5014: END IF;
5015: ELSIF ( p_header_rec.transaction_phase_code = 'N' ) THEN

Line 5016: oe_debug_pub.add('+++ Quote under creation, not populating action request table.');

5012: p_action_request_tbl_(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
5013: p_action_request_tbl_(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
5014: END IF;
5015: ELSIF ( p_header_rec.transaction_phase_code = 'N' ) THEN
5016: oe_debug_pub.add('+++ Quote under creation, not populating action request table.');
5017: END IF;
5018: --
5019: -- Code Changes End : ER 7025965
5020: --

Line 5023: oe_debug_pub.add('Before calling PO');

5019: -- Code Changes End : ER 7025965
5020: --
5021:
5022:
5023: oe_debug_pub.add('Before calling PO');
5024: oe_debug_pub.add('Header Attributes');
5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);

Line 5024: oe_debug_pub.add('Header Attributes');

5020: --
5021:
5022:
5023: oe_debug_pub.add('Before calling PO');
5024: oe_debug_pub.add('Header Attributes');
5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);

Line 5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);

5021:
5022:
5023: oe_debug_pub.add('Before calling PO');
5024: oe_debug_pub.add('Header Attributes');
5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);

Line 5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);

5022:
5023: oe_debug_pub.add('Before calling PO');
5024: oe_debug_pub.add('Header Attributes');
5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);

Line 5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);

5023: oe_debug_pub.add('Before calling PO');
5024: oe_debug_pub.add('Header Attributes');
5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);
5031: oe_debug_pub.add('Line Attributes');

Line 5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);

5024: oe_debug_pub.add('Header Attributes');
5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);
5031: oe_debug_pub.add('Line Attributes');
5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);

Line 5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);

5025: oe_debug_pub.add('header sold_to_org_id '||p_header_rec_.sold_to_org_id);
5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);
5031: oe_debug_pub.add('Line Attributes');
5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);
5033:

Line 5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);

5026: oe_debug_pub.add('header Order Type '||p_header_rec_.order_type_id);
5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);
5031: oe_debug_pub.add('Line Attributes');
5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);
5033:
5034: if p_line_tbl_.COUNT > 0 then

Line 5031: oe_debug_pub.add('Line Attributes');

5027: oe_debug_pub.add('header order_source_id'||p_header_rec_.order_source_id);
5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);
5031: oe_debug_pub.add('Line Attributes');
5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);
5033:
5034: if p_line_tbl_.COUNT > 0 then
5035: oe_debug_pub.add('line inventory_item_id '||p_line_tbl_(1).inventory_item_id);

Line 5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);

5028: oe_debug_pub.add('header salesrep_id '||p_header_rec_.salesrep_id);
5029: oe_debug_pub.add('header Org Id '||p_header_rec_.Org_id);
5030: oe_debug_pub.add('header orig_sys_document_ref '||p_header_rec_.orig_sys_document_ref);
5031: oe_debug_pub.add('Line Attributes');
5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);
5033:
5034: if p_line_tbl_.COUNT > 0 then
5035: oe_debug_pub.add('line inventory_item_id '||p_line_tbl_(1).inventory_item_id);
5036: oe_debug_pub.add('line ordered_quantity '||p_line_tbl_(1).ordered_quantity);

Line 5035: oe_debug_pub.add('line inventory_item_id '||p_line_tbl_(1).inventory_item_id);

5031: oe_debug_pub.add('Line Attributes');
5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);
5033:
5034: if p_line_tbl_.COUNT > 0 then
5035: oe_debug_pub.add('line inventory_item_id '||p_line_tbl_(1).inventory_item_id);
5036: oe_debug_pub.add('line ordered_quantity '||p_line_tbl_(1).ordered_quantity);
5037: end if;
5038:
5039: oe_debug_pub.add('22Calling OE_GENESIS_UTIL.print_po_payload');

Line 5036: oe_debug_pub.add('line ordered_quantity '||p_line_tbl_(1).ordered_quantity);

5032: oe_debug_pub.add('Line table count is '||p_line_tbl_.COUNT);
5033:
5034: if p_line_tbl_.COUNT > 0 then
5035: oe_debug_pub.add('line inventory_item_id '||p_line_tbl_(1).inventory_item_id);
5036: oe_debug_pub.add('line ordered_quantity '||p_line_tbl_(1).ordered_quantity);
5037: end if;
5038:
5039: oe_debug_pub.add('22Calling OE_GENESIS_UTIL.print_po_payload');
5040:

Line 5039: oe_debug_pub.add('22Calling OE_GENESIS_UTIL.print_po_payload');

5035: oe_debug_pub.add('line inventory_item_id '||p_line_tbl_(1).inventory_item_id);
5036: oe_debug_pub.add('line ordered_quantity '||p_line_tbl_(1).ordered_quantity);
5037: end if;
5038:
5039: oe_debug_pub.add('22Calling OE_GENESIS_UTIL.print_po_payload');
5040:
5041: OE_GENESIS_UTIL.print_po_payload(
5042: P_HEADER_REC_,
5043: P_HEADER_VAL_REC_,

Line 5048: oe_debug_pub.add('Calling OE_ORDER_IMPORT_CONFIG_PVT.Pre_Process');

5044: P_HEADER_PAYMENT_TBL_,
5045: P_LINE_TBL_
5046: );
5047:
5048: oe_debug_pub.add('Calling OE_ORDER_IMPORT_CONFIG_PVT.Pre_Process');
5049: OE_ORDER_IMPORT_CONFIG_PVT.Pre_Process(
5050: p_header_rec => P_HEADER_REC_
5051: ,p_x_line_tbl => P_LINE_TBL_
5052: ,p_return_status => l_return_status);

Line 5053: oe_debug_pub.add('After OE_ORDER_IMPORT_CONFIG_PVT.Pre_Process' ||

5049: OE_ORDER_IMPORT_CONFIG_PVT.Pre_Process(
5050: p_header_rec => P_HEADER_REC_
5051: ,p_x_line_tbl => P_LINE_TBL_
5052: ,p_return_status => l_return_status);
5053: oe_debug_pub.add('After OE_ORDER_IMPORT_CONFIG_PVT.Pre_Process' ||
5054: l_return_status);
5055:
5056:
5057: APPS.OE_ORDER_PUB.PROCESS_ORDER(

Line 5140: oe_debug_pub.add('After calling PO');

5136: X_LOT_SERIAL_VAL_TBL_,
5137: X_ACTION_REQUEST_TBL_,
5138: P_RTRIM_DATA);
5139:
5140: oe_debug_pub.add('After calling PO');
5141:
5142: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);
5143: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
5144: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);

Line 5186: oe_debug_pub.add('In the Rollback section ');

5182: IF Oe_Inbound_Int.G_check_action_ret_status IN ('E','U')
5183: OR
5184: x_return_status IN ('E', 'U')
5185: THEN
5186: oe_debug_pub.add('In the Rollback section ');
5187: ROLLBACK;
5188: ELSE
5189: oe_debug_pub.add('Commit has been triggered here! '||Oe_Inbound_Int.G_check_action_ret_status);
5190: COMMIT;

Line 5189: oe_debug_pub.add('Commit has been triggered here! '||Oe_Inbound_Int.G_check_action_ret_status);

5185: THEN
5186: oe_debug_pub.add('In the Rollback section ');
5187: ROLLBACK;
5188: ELSE
5189: oe_debug_pub.add('Commit has been triggered here! '||Oe_Inbound_Int.G_check_action_ret_status);
5190: COMMIT;
5191: END IF;
5192:
5193: IF l_msg_count > 0 THEN

Line 5197: oe_debug_pub.add('Populating message_tbl for Genesis');

5193: IF l_msg_count > 0 THEN
5194:
5195: -- Populate OM Processing Messages onto the OUT parameter
5196: -- 'x_messages'.
5197: oe_debug_pub.add('Populating message_tbl for Genesis');
5198:
5199: -- Ensure to have a clean message object table
5200: x_messages := OE_MESSAGE_OBJ_T();
5201:

Line 5221: IF ( oe_debug_pub.IsDebugOn ) THEN

5217:
5218: -- If debugging is on, add the name of the debug file as an
5219: -- additional message (so that it can be viewed in the XML
5220: -- message generated in case of BPEL fault).
5221: IF ( oe_debug_pub.IsDebugOn ) THEN
5222: x_messages.EXTEND;
5223: x_messages(x_messages.Count) :=
5224: OE_MESSAGE_OBJ ('Debug File: ' || l_temp_var);
5225: END IF;

Line 5332: oe_debug_pub.add('Oe_Inbound_Int.Process_Order with deprecated signature invoked...');

5328: l_messages oe_message_obj_t;
5329:
5330: BEGIN
5331:
5332: oe_debug_pub.add('Oe_Inbound_Int.Process_Order with deprecated signature invoked...');
5333: oe_debug_pub.add('Calling...');
5334:
5335: Process_Order (
5336: P_API_VERSION_NUMBER => P_API_VERSION_NUMBER,

Line 5333: oe_debug_pub.add('Calling...');

5329:
5330: BEGIN
5331:
5332: oe_debug_pub.add('Oe_Inbound_Int.Process_Order with deprecated signature invoked...');
5333: oe_debug_pub.add('Calling...');
5334:
5335: Process_Order (
5336: P_API_VERSION_NUMBER => P_API_VERSION_NUMBER,
5337: P_INIT_MSG_LIST => P_INIT_MSG_LIST,

Line 5419: oe_debug_pub.add('After calling the newer signature of Process_Order...');

5415: X_ACTION_REQUEST_TBL => X_ACTION_REQUEST_TBL ,
5416: P_RTRIM_DATA => P_RTRIM_DATA
5417: );
5418:
5419: oe_debug_pub.add('After calling the newer signature of Process_Order...');
5420:
5421: oe_debug_pub.add('Setting x_msg_count and x_msg_data...');
5422: x_msg_count := l_messages.COUNT;
5423: x_msg_data := l_messages(1).message_text;

Line 5421: oe_debug_pub.add('Setting x_msg_count and x_msg_data...');

5417: );
5418:
5419: oe_debug_pub.add('After calling the newer signature of Process_Order...');
5420:
5421: oe_debug_pub.add('Setting x_msg_count and x_msg_data...');
5422: x_msg_count := l_messages.COUNT;
5423: x_msg_data := l_messages(1).message_text;
5424:
5425: oe_debug_pub.add('Done... returning to caller...');

Line 5425: oe_debug_pub.add('Done... returning to caller...');

5421: oe_debug_pub.add('Setting x_msg_count and x_msg_data...');
5422: x_msg_count := l_messages.COUNT;
5423: x_msg_data := l_messages(1).message_text;
5424:
5425: oe_debug_pub.add('Done... returning to caller...');
5426:
5427:
5428: END Process_Order; -- Overloaded form with the older deprecated signature.
5429:

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

5431:
5432: PROCEDURE Convert_line_null_to_miss
5433: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
5434: IS
5435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5436: BEGIN
5437:
5438: oe_debug_pub.add('Entering Convert_line_null_to_miss', 1);
5439:

Line 5438: oe_debug_pub.add('Entering Convert_line_null_to_miss', 1);

5434: IS
5435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5436: BEGIN
5437:
5438: oe_debug_pub.add('Entering Convert_line_null_to_miss', 1);
5439:
5440: IF p_x_line_rec.unit_cost IS NULL THEN
5441: p_x_line_rec.unit_cost := FND_API.G_MISS_NUM;
5442: END IF;

Line 6328: oe_debug_pub.add('PSU Salesrep is null');

6324: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
6325: END IF;
6326:
6327: IF p_x_line_rec.salesrep_id IS NULL THEN
6328: oe_debug_pub.add('PSU Salesrep is null');
6329: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
6330: null;
6331: END IF;
6332:

Line 6430: oe_debug_pub.add('Sold to is null');

6426: END IF;
6427:
6428: -- p_x_line_rec.sold_to_org_id := 1006; -- ZB
6429: IF p_x_line_rec.sold_to_org_id IS NULL THEN
6430: oe_debug_pub.add('Sold to is null');
6431: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
6432: END IF;
6433:
6434: IF p_x_line_rec.sort_order IS NULL THEN

Line 6479: oe_debug_pub.add('Tax Exempt is null');

6475: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
6476: END IF;
6477:
6478: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
6479: oe_debug_pub.add('Tax Exempt is null');
6480: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
6481: END IF;
6482:
6483: IF p_x_line_rec.tax_exempt_number IS NULL THEN

Line 6730: oe_debug_pub.add('Exiting CONVERT_LINE_NULL_TO_MISS', 1);

6726: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
6727: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
6728: END IF;
6729:
6730: oe_debug_pub.add('Exiting CONVERT_LINE_NULL_TO_MISS', 1);
6731: EXCEPTION
6732: WHEN OTHERS THEN
6733: oe_debug_pub.add('In Others CONVERT_LINE_NULL_TO_MISS', 1);
6734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6733: oe_debug_pub.add('In Others CONVERT_LINE_NULL_TO_MISS', 1);

6729:
6730: oe_debug_pub.add('Exiting CONVERT_LINE_NULL_TO_MISS', 1);
6731: EXCEPTION
6732: WHEN OTHERS THEN
6733: oe_debug_pub.add('In Others CONVERT_LINE_NULL_TO_MISS', 1);
6734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6735: END Convert_Line_null_to_miss;
6736:
6737: PROCEDURE Convert_hdr_null_to_miss

Line 6741: oe_debug_pub.add('Entering CONVERT_HDR_NULL_TO_MISS', 1);

6737: PROCEDURE Convert_hdr_null_to_miss
6738: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
6739: IS
6740: BEGIN
6741: oe_debug_pub.add('Entering CONVERT_HDR_NULL_TO_MISS', 1);
6742:
6743: IF p_x_header_rec.accounting_rule_id IS NULL THEN
6744: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
6745: END IF;

Line 7174: oe_debug_pub.add('Sold to is = ' || p_x_header_rec.sold_to_org_id);

7170: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
7171: END IF;
7172:
7173: -- p_x_header_rec.sold_to_org_id := 1006; -- ZB
7174: oe_debug_pub.add('Sold to is = ' || p_x_header_rec.sold_to_org_id);
7175: IF p_x_header_rec.sold_to_org_id IS NULL THEN
7176: oe_debug_pub.add('Sold to is null');
7177: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
7178: END IF;

Line 7176: oe_debug_pub.add('Sold to is null');

7172:
7173: -- p_x_header_rec.sold_to_org_id := 1006; -- ZB
7174: oe_debug_pub.add('Sold to is = ' || p_x_header_rec.sold_to_org_id);
7175: IF p_x_header_rec.sold_to_org_id IS NULL THEN
7176: oe_debug_pub.add('Sold to is null');
7177: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
7178: END IF;
7179:
7180: IF p_x_header_rec.sold_to_phone_id IS NULL THEN

Line 7384: oe_debug_pub.add('Exiting CONVERTHDR__NULL_TO_MISS', 1);

7380: IF p_x_header_rec.order_firmed_date IS NULL THEN
7381: p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
7382: END IF;
7383:
7384: oe_debug_pub.add('Exiting CONVERTHDR__NULL_TO_MISS', 1);
7385: EXCEPTION
7386: WHEN OTHERS THEN
7387: oe_debug_pub.add('In Others Convert_hdr_null_to_miss', 1);
7388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7387: oe_debug_pub.add('In Others Convert_hdr_null_to_miss', 1);

7383:
7384: oe_debug_pub.add('Exiting CONVERTHDR__NULL_TO_MISS', 1);
7385: EXCEPTION
7386: WHEN OTHERS THEN
7387: oe_debug_pub.add('In Others Convert_hdr_null_to_miss', 1);
7388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7389:
7390: END Convert_hdr_null_to_miss;
7391: