DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_GLOBALS

Line 878: AND p_x_header_rec.order_source_id <> OE_GLOBALS.G_ORDER_SOURCE_INTERNAL

874: -- p_x_header_rec.FREIGHT_CARRIER_CODE := FND_API.G_MISS_CHAR;
875: END IF;
876:
877: IF p_x_header_rec.ORG_ID <> FND_API.G_MISS_NUM
878: AND p_x_header_rec.order_source_id <> OE_GLOBALS.G_ORDER_SOURCE_INTERNAL
879: THEN
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add( 'CANNOT POPULATE DERIVED COLUMN ORG_ID... ' ) ;
882: END IF;

Line 955: (p_x_header_rec.OPERATION<>OE_GLOBALS.G_OPR_UPDATE))

951: oe_debug_pub.add(' in CHECK_DERIVED_FLAGS , operation : '||p_x_header_rec.OPERATION);
952: oe_debug_pub.add(' cancelled flag :'||p_x_header_rec.cancelled_flag||'**');
953: IF ( p_x_header_rec.CANCELLED_FLAG='Y'
954: and
955: (p_x_header_rec.OPERATION<>OE_GLOBALS.G_OPR_UPDATE))
956: THEN
957: IF l_debug_level > 0 THEN
958: oe_debug_pub.add( 'CANCELLATION IS NOT ALLOWED WHILE CREATING AN ORDER... ' ) ;
959: END IF;

Line 1101: AND p_x_header_rec.order_source_id <> OE_GLOBALS.G_ORDER_SOURCE_INTERNAL

1097: -- p_x_line_tbl(I).FULFILLED_QUANTITY := FND_API.G_MISS_NUM;
1098: END IF;
1099: /*
1100: IF p_x_line_tbl(I).ITEM_TYPE_CODE <> FND_API.G_MISS_CHAR
1101: AND p_x_header_rec.order_source_id <> OE_GLOBALS.G_ORDER_SOURCE_INTERNAL
1102: THEN
1103: oe_debug_pub.add('Cannot populate derived column ITEM_TYPE_CODE... ');
1104: FND_MESSAGE.SET_NAME('ONT','OE_OIM_DERIVED_COLUMNS');
1105: FND_MESSAGE.SET_TOKEN('DERIVED_COL','ITEM_TYPE_CODE');

Line 1137: AND p_x_header_rec.order_source_id <> OE_GLOBALS.G_ORDER_SOURCE_INTERNAL

1133: -- p_x_line_tbl(I).OPTION_NUMBER := FND_API.G_MISS_NUM;
1134: END IF;
1135:
1136: IF p_x_line_tbl(I).ORG_ID <> FND_API.G_MISS_NUM
1137: AND p_x_header_rec.order_source_id <> OE_GLOBALS.G_ORDER_SOURCE_INTERNAL
1138: THEN
1139: IF l_debug_level > 0 THEN
1140: oe_debug_pub.add( 'CANNOT POPULATE DERIVED COLUMN ORG_ID... ' ) ;
1141: END IF;

Line 2251: IF p_x_header_rec.operation = OE_Globals.G_OPR_UPDATE THEN

2247: IF l_debug_level > 0 THEN
2248: oe_debug_pub.add( 'BEFORE VALIDATING CHANGE SEQUENCE' ) ;
2249: END IF;
2250:
2251: IF p_x_header_rec.operation = OE_Globals.G_OPR_UPDATE THEN
2252:
2253: -----------------------------------------------------------
2254: -- Validate change sequence
2255:

Line 2330: IF (p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL)

2326: END IF; -- If header operation code is update
2327:
2328: END IF; --code release >= 110510
2329: ----added for internal req check so that correct message context is set later .bug# 11854440,9937537
2330: IF (p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL)
2331: AND p_x_header_rec.operation IN ('INSERT','CREATE','UPDATE','DELETE')
2332: THEN
2333: BEGIN
2334: IF l_debug_level > 0 THEN

Line 2339: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;

2335: oe_debug_pub.add( 'BEFORE DERIVING REQ HEADER ID FOR INTERNAL ORDERS' ) ;
2336: END IF;
2337:
2338: p_x_header_rec.source_document_type_id :=
2339: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;
2340:
2341: -- Following select is removed because of the po tables are
2342: -- changing to multi-org, and it has been decided that PO
2343: -- will pass ids columns instead of reference as they are unique

Line 2515: := OE_Globals.G_ENTITY_HEADER;

2511:
2512: p_x_action_request_tbl(p_x_action_request_tbl.COUNT +1).request_type
2513: := l_c_operation_code;
2514: p_x_action_request_tbl(p_x_action_request_tbl.COUNT).entity_code
2515: := OE_Globals.G_ENTITY_HEADER;
2516: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2517:
2518: END IF;
2519:

Line 2542: IF (p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL)

2538: IF p_x_header_rec.operation IN ('INSERT','CREATE')
2539: THEN --{
2540: Begin
2541: -- Start for the fix of bug 1794206
2542: IF (p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL)
2543: THEN
2544: IF l_debug_level > 0 THEN
2545: oe_debug_pub.add( 'BEFORE VALIDATING INTERNAL ORDER FOR INSERT OPR' ) ;
2546: END IF;

Line 2675: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_HEADER

2671: BEGIN
2672: IF p_x_header_rec.operation IN ('UPDATE','DELETE') THEN
2673: FOR b in 1..p_x_action_request_tbl.COUNT
2674: LOOP--{
2675: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_HEADER
2676: THEN
2677: p_x_action_request_tbl(b).entity_id := p_x_header_rec.header_id;
2678:
2679: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/

Line 2680: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN

2676: THEN
2677: p_x_action_request_tbl(b).entity_id := p_x_header_rec.header_id;
2678:
2679: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
2680: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN
2681: l_org_id := mo_global.get_current_org_id;
2682: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
2683: p_x_action_request_tbl(b).param5 := p_x_header_rec.header_id;
2684: END IF;

Line 3724: IF p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL

3720: /* -----------------------------------------------------------
3721: Derive Requisition Line Id for Internal Orders
3722: -----------------------------------------------------------
3723: */
3724: IF p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL
3725: AND p_x_line_tbl(I).operation IN ('INSERT','CREATE','UPDATE','DELETE')
3726: THEN
3727: BEGIN
3728: IF l_debug_level > 0 THEN

Line 3733: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;

3729: oe_debug_pub.add( 'BEFORE DERIVING REQ LINE ID FOR INTERNAL ORDERS' ) ;
3730: END IF;
3731:
3732: p_x_line_tbl(I).source_document_type_id :=
3733: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;
3734: p_x_line_tbl(I).source_document_id := p_x_header_rec.source_document_id;
3735: p_x_line_tbl(I).orig_sys_document_ref := p_x_header_rec.orig_sys_document_ref;
3736: p_x_line_tbl(I).sold_to_org_id := p_x_header_rec.sold_to_org_id;
3737:

Line 5071: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE

5067: if (p_x_action_request_tbl.COUNT >0 ) then
5068: FOR b in l_counter..p_x_action_request_tbl.COUNT
5069: LOOP--{
5070: l_counter_memory := l_counter_memory + 1;
5071: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE
5072: AND p_x_action_request_tbl(b).entity_index = l_line_count THEN
5073: p_x_action_request_tbl(b).entity_id := p_x_line_tbl(I).line_id;
5074: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
5075: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN

Line 5075: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN

5071: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE
5072: AND p_x_action_request_tbl(b).entity_index = l_line_count THEN
5073: p_x_action_request_tbl(b).entity_id := p_x_line_tbl(I).line_id;
5074: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
5075: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN
5076: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
5077: p_x_action_request_tbl(b).param5 := p_x_line_tbl(I).header_id;
5078: END IF;
5079: END IF;

Line 5082: OE_Globals.G_LINK_CONFIG

5078: END IF;
5079: END IF;
5080: /*myerrams, Customer Acceptance, end*/
5081: IF p_x_action_request_tbl(b).request_type =
5082: OE_Globals.G_LINK_CONFIG
5083: THEN
5084: p_x_action_request_tbl(b).param1 :=
5085: p_x_line_tbl(I).inventory_item_id;
5086: END IF;

Line 5088: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE

5084: p_x_action_request_tbl(b).param1 :=
5085: p_x_line_tbl(I).inventory_item_id;
5086: END IF;
5087: END IF;
5088: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE
5089: AND p_x_action_request_tbl(b).entity_index > l_line_count THEN
5090: raise e_break;
5091: END IF;
5092: END LOOP;--}

Line 6233: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI

6229: /* -----------------------------------------------------------
6230: Call EDI Pre-Process
6231: -----------------------------------------------------------
6232: */
6233: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI
6234: THEN
6235: IF l_debug_level > 0 THEN
6236: oe_debug_pub.add( 'BEFORE CALLING EDI PRE-PROCESS' ) ;
6237: END IF;

Line 6557: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI

6553: Call EDI Post-Process
6554: -----------------------------------------------------------
6555: */
6556:
6557: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI
6558: THEN
6559: IF l_debug_level > 0 THEN
6560: oe_debug_pub.add( 'BEFORE CALLING EDI POST-PROCESS' ) ;
6561: END IF;