DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_GENESIS_UTIL

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

674: aPlsqlItem.INVOICE_TO_PARTY_NUMBER := aSqlItem.INVOICE_TO_PARTY_NUMBER;
675: aPlsqlItem.DELIVER_TO_PARTY_NUMBER := aSqlItem.DELIVER_TO_PARTY_NUMBER;
676: aPlsqlItem.ORDER_FIRMED_DATE := aSqlItem.ORDER_FIRMED_DATE;
677:
678: oe_debug_pub.add('Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
679: OE_GENESIS_UTIL.Convert_hdr_null_to_miss(aPlsqlItem);
680: -- Convert_hdr_null_to_miss(aPlsqlItem);
681: --convert_hdr_null_to_miss(aPlsqlItem);
682: oe_debug_pub.add('After Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);

Line 679: OE_GENESIS_UTIL.Convert_hdr_null_to_miss(aPlsqlItem);

675: aPlsqlItem.DELIVER_TO_PARTY_NUMBER := aSqlItem.DELIVER_TO_PARTY_NUMBER;
676: aPlsqlItem.ORDER_FIRMED_DATE := aSqlItem.ORDER_FIRMED_DATE;
677:
678: oe_debug_pub.add('Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
679: OE_GENESIS_UTIL.Convert_hdr_null_to_miss(aPlsqlItem);
680: -- Convert_hdr_null_to_miss(aPlsqlItem);
681: --convert_hdr_null_to_miss(aPlsqlItem);
682: oe_debug_pub.add('After Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
683:

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

678: oe_debug_pub.add('Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
679: OE_GENESIS_UTIL.Convert_hdr_null_to_miss(aPlsqlItem);
680: -- Convert_hdr_null_to_miss(aPlsqlItem);
681: --convert_hdr_null_to_miss(aPlsqlItem);
682: oe_debug_pub.add('After Caliing OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
683:
684: RETURN aPlsqlItem;
685: END SQL_TO_PL1;
686:

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

2117: aPlsqlItem.OPERATION := aSqlItem.OPERATION;
2118: aPlsqlItem.DEFER_PAYMENT_PROCESSING_FLAG := aSqlItem.DEFER_PAYMENT_PROCESSING_FLAG;
2119: aPlsqlItem.LOCK_CONTROL := aSqlItem.LOCK_CONTROL;
2120:
2121: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2122: OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss(aPlsqlItem);
2123: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2124:
2125: RETURN aPlsqlItem;

Line 2122: OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss(aPlsqlItem);

2118: aPlsqlItem.DEFER_PAYMENT_PROCESSING_FLAG := aSqlItem.DEFER_PAYMENT_PROCESSING_FLAG;
2119: aPlsqlItem.LOCK_CONTROL := aSqlItem.LOCK_CONTROL;
2120:
2121: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2122: OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss(aPlsqlItem);
2123: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2124:
2125: RETURN aPlsqlItem;
2126: END SQL_TO_PL33;

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

2119: aPlsqlItem.LOCK_CONTROL := aSqlItem.LOCK_CONTROL;
2120:
2121: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2122: OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss(aPlsqlItem);
2123: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
2124:
2125: RETURN aPlsqlItem;
2126: END SQL_TO_PL33;
2127:

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

3050: aPlsqlItem.ACTUAL_FULFILLMENT_DATE := aSqlItem.ACTUAL_FULFILLMENT_DATE;
3051: aPlsqlItem.CHANGED_LINES_POCAO := aSqlItem.CHANGED_LINES_POCAO;
3052: aPlsqlItem.CHARGE_PERIODICITY_CODE := aSqlItem.CHARGE_PERIODICITY_CODE;
3053:
3054: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload Before Convert_Line_null_to_miss');
3055: -- OE_GENESIS_UTIL.print_po_payload(
3056: -- P_HEADER_REC_,
3057: -- P_HEADER_VAL_REC_,
3058: -- P_HEADER_PAYMENT_TBL_,

Line 3055: -- OE_GENESIS_UTIL.print_po_payload(

3051: aPlsqlItem.CHANGED_LINES_POCAO := aSqlItem.CHANGED_LINES_POCAO;
3052: aPlsqlItem.CHARGE_PERIODICITY_CODE := aSqlItem.CHARGE_PERIODICITY_CODE;
3053:
3054: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload Before Convert_Line_null_to_miss');
3055: -- OE_GENESIS_UTIL.print_po_payload(
3056: -- P_HEADER_REC_,
3057: -- P_HEADER_VAL_REC_,
3058: -- P_HEADER_PAYMENT_TBL_,
3059: -- P_LINE_TBL_

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

3058: -- P_HEADER_PAYMENT_TBL_,
3059: -- P_LINE_TBL_
3060: -- );
3061:
3062: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
3063: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);
3064: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');
3065: -- OE_GENESIS_UTIL.print_po_payload(
3066: -- P_HEADER_REC_,

Line 3063: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);

3059: -- P_LINE_TBL_
3060: -- );
3061:
3062: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
3063: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);
3064: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');
3065: -- OE_GENESIS_UTIL.print_po_payload(
3066: -- P_HEADER_REC_,
3067: -- P_HEADER_VAL_REC_,

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

3060: -- );
3061:
3062: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
3063: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);
3064: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');
3065: -- OE_GENESIS_UTIL.print_po_payload(
3066: -- P_HEADER_REC_,
3067: -- P_HEADER_VAL_REC_,
3068: -- P_HEADER_PAYMENT_TBL_,

Line 3065: -- OE_GENESIS_UTIL.print_po_payload(

3061:
3062: oe_debug_pub.add('Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
3063: OE_GENESIS_UTIL.Convert_Line_null_to_miss(aPlsqlItem);
3064: -- oe_debug_pub.add('Calling OE_GENESIS_UTIL.print_po_payload After Convert_Line_null_to_miss');
3065: -- OE_GENESIS_UTIL.print_po_payload(
3066: -- P_HEADER_REC_,
3067: -- P_HEADER_VAL_REC_,
3068: -- P_HEADER_PAYMENT_TBL_,
3069: -- P_LINE_TBL_

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

3069: -- P_LINE_TBL_
3070: -- );
3071:
3072: -- convert_line_null_to_miss(aPlsqlItem);
3073: oe_debug_pub.add('After Calling OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
3074:
3075: RETURN aPlsqlItem;
3076: END SQL_TO_PL35;
3077:

Line 5108: Oe_Genesis_Util.G_INCOMING_FROM_DOO := FALSE;

5104:
5105: ---
5106: -- DOO/OM Integration Code (Order Source Identification): Start
5107: ---
5108: Oe_Genesis_Util.G_INCOMING_FROM_DOO := FALSE;
5109:
5110: IF P_HEADER_REC.order_source_id = 32 THEN
5111:
5112: Oe_Genesis_Util.G_INCOMING_FROM_DOO := TRUE;

Line 5112: Oe_Genesis_Util.G_INCOMING_FROM_DOO := TRUE;

5108: Oe_Genesis_Util.G_INCOMING_FROM_DOO := FALSE;
5109:
5110: IF P_HEADER_REC.order_source_id = 32 THEN
5111:
5112: Oe_Genesis_Util.G_INCOMING_FROM_DOO := TRUE;
5113:
5114: IF l_debug_level > 0 THEN
5115: oe_debug_pub.ADD('Set G_INCOMING_FROM_DOO at Location 1.', 5);
5116: END IF;

Line 5124: Oe_Genesis_Util.G_INCOMING_FROM_DOO := TRUE;

5120: FOR i in 1..P_LINE_TBL.Count
5121: LOOP
5122: IF P_LINE_TBL(i).order_source_id = 32 THEN
5123:
5124: Oe_Genesis_Util.G_INCOMING_FROM_DOO := TRUE;
5125:
5126: IF l_debug_level > 0 THEN
5127: oe_debug_pub.ADD('Set G_INCOMING_FROM_DOO at Location 2.', 5);
5128: END IF;

Line 5137: IF Oe_Genesis_Util.G_INCOMING_FROM_DOO = TRUE THEN

5133:
5134: END IF; -- on order_source_id = 32 check.
5135:
5136: -- Bug 13789481
5137: IF Oe_Genesis_Util.G_INCOMING_FROM_DOO = TRUE THEN
5138:
5139: -- In case of inbound data from DOO, we will be getting complete
5140: -- exploded structure for models/kits. In other words there is no
5141: -- way Oracle Configurator being used in such case. Given that,

Line 5169: Oe_Genesis_Util.G_INCOMING_FROM_DOO = FALSE -- Bug 13789481

5165: FOR i IN p_line_tbl.first..p_line_tbl.last
5166: LOOP
5167: -- Identify the line record to be passed to process_order(...) API.
5168: IF p_line_tbl(i).operation IN (oe_globals.g_opr_update) AND
5169: Oe_Genesis_Util.G_INCOMING_FROM_DOO = FALSE -- Bug 13789481
5170: THEN
5171: -- For update operation, ignore the config/option/class items lines.
5172: -- Whether a line is the top model line or not, is indicated by
5173: -- the top_model_line_ref being the same as orig_sys_line_ref in

Line 5453: oe_genesis_util.header_rec_to_hdr_rec25(

5449: -- Would it be a good idea to push an additional information message onto x_messages?
5450:
5451: ELSE
5452: -- Step 1: Load the output parameters: x_header_rec, and x_line_tbl.
5453: oe_genesis_util.header_rec_to_hdr_rec25(
5454: l_header_rec_old, x_header_rec
5455: );
5456:
5457: oe_genesis_util.line_tab_to_line_tab25(

Line 5457: oe_genesis_util.line_tab_to_line_tab25(

5453: oe_genesis_util.header_rec_to_hdr_rec25(
5454: l_header_rec_old, x_header_rec
5455: );
5456:
5457: oe_genesis_util.line_tab_to_line_tab25(
5458: l_line_tab_old, x_line_tbl
5459: );
5460:
5461: -- Step 2: Based on profile option set up, populate freight_charge,

Line 5738: oe_genesis_util.line_rec_to_line_rec25(l_line_rec_obj,

5734:
5735: END; -- for the declare.
5736: ------------------
5737: l_line_rec_obj := PL_TO_SQL35(l_line_rec);
5738: oe_genesis_util.line_rec_to_line_rec25(l_line_rec_obj,
5739: l_line_rec25_obj);
5740: x_line_tbl.extend;
5741: l_count := l_count + 1;
5742: x_line_tbl(l_count) := l_line_rec25_obj;

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

6058: end if;
6059: end if;
6060:
6061: if l_debug_level > 0 then
6062: oe_debug_pub.add('22Calling OE_GENESIS_UTIL.print_po_payload');
6063: end if;
6064:
6065: OE_GENESIS_UTIL.print_po_payload(
6066: P_HEADER_REC_,

Line 6065: OE_GENESIS_UTIL.print_po_payload(

6061: if l_debug_level > 0 then
6062: oe_debug_pub.add('22Calling OE_GENESIS_UTIL.print_po_payload');
6063: end if;
6064:
6065: OE_GENESIS_UTIL.print_po_payload(
6066: P_HEADER_REC_,
6067: P_HEADER_VAL_REC_,
6068: P_HEADER_PAYMENT_TBL_,
6069: P_LINE_TBL_

Line 6146: IF Oe_Genesis_Util.G_INCOMING_FROM_DOO THEN

6142:
6143: ---
6144: -- DOO Integration code: Start
6145: ---
6146: IF Oe_Genesis_Util.G_INCOMING_FROM_DOO THEN
6147: ---
6148: -- Set the line level attributes: PRE_EXPLODED_FLAG, and
6149: -- BYPASS_SCH_FLAG to 'Y' depending on the population status of
6150: -- EXPLOSION_DATE and SCHEDULE_SHIP_DATE.

Line 6374: Oe_Genesis_Util.G_INCOMING_FROM_DOO := FALSE;

6370: END IF;
6371:
6372: oe_msg_pub.save_messages(999999999);
6373:
6374: Oe_Genesis_Util.G_INCOMING_FROM_DOO := FALSE;
6375:
6376: END Process_Order; -- Overloaded form with newer signature
6377:
6378: ------------------------------

Line 6585: oe_genesis_util.Convert_Line_null_to_miss(p_x_line_rec);

6581: ----------------- O2C25: Start ---------
6582: PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
6583: IS
6584: BEGIN
6585: oe_genesis_util.Convert_Line_null_to_miss(p_x_line_rec);
6586: EXCEPTION
6587: WHEN OTHERS THEN
6588: RAISE;
6589: END;

Line 6594: oe_genesis_util.Convert_hdr_null_to_miss (p_x_header_rec);

6590:
6591: PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
6592: IS
6593: BEGIN
6594: oe_genesis_util.Convert_hdr_null_to_miss (p_x_header_rec);
6595: EXCEPTION
6596: WHEN OTHERS THEN
6597: RAISE;
6598: END;