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 2471: := OE_Globals.G_ENTITY_HEADER;

2467:
2468: p_x_action_request_tbl(p_x_action_request_tbl.COUNT +1).request_type
2469: := l_c_operation_code;
2470: p_x_action_request_tbl(p_x_action_request_tbl.COUNT).entity_code
2471: := OE_Globals.G_ENTITY_HEADER;
2472: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2473:
2474: END IF;
2475:

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

2476: /* -----------------------------------------------------------
2477: Derive Requisition Header Id for Internal Orders
2478: -----------------------------------------------------------
2479: */
2480: IF (p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL)
2481: AND p_x_header_rec.operation IN ('INSERT','CREATE','UPDATE','DELETE')
2482: THEN
2483: BEGIN
2484: IF l_debug_level > 0 THEN

Line 2489: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;

2485: oe_debug_pub.add( 'BEFORE DERIVING REQ HEADER ID FOR INTERNAL ORDERS' ) ;
2486: END IF;
2487:
2488: p_x_header_rec.source_document_type_id :=
2489: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;
2490:
2491: -- Following select is removed because of the po tables are
2492: -- changing to multi-org, and it has been decided that PO
2493: -- will pass ids columns instead of reference as they are unique

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

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

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

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

Line 2677: 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

2673: THEN
2674: p_x_action_request_tbl(b).entity_id := p_x_header_rec.header_id;
2675:
2676: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
2677: 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
2678: l_org_id := mo_global.get_current_org_id;
2679: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
2680: p_x_action_request_tbl(b).param5 := p_x_header_rec.header_id;
2681: END IF;

Line 3721: IF p_x_header_rec.order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL

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

Line 3730: OE_GLOBALS.G_ORDER_SOURCE_INTERNAL;

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

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

5000: if (p_x_action_request_tbl.COUNT >0 ) then
5001: FOR b in l_counter..p_x_action_request_tbl.COUNT
5002: LOOP--{
5003: l_counter_memory := l_counter_memory + 1;
5004: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE
5005: AND p_x_action_request_tbl(b).entity_index = l_line_count THEN
5006: p_x_action_request_tbl(b).entity_id := p_x_line_tbl(I).line_id;
5007: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
5008: 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 5008: 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

5004: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE
5005: AND p_x_action_request_tbl(b).entity_index = l_line_count THEN
5006: p_x_action_request_tbl(b).entity_id := p_x_line_tbl(I).line_id;
5007: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
5008: 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
5009: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
5010: p_x_action_request_tbl(b).param5 := p_x_line_tbl(I).header_id;
5011: END IF;
5012: END IF;

Line 5015: OE_Globals.G_LINK_CONFIG

5011: END IF;
5012: END IF;
5013: /*myerrams, Customer Acceptance, end*/
5014: IF p_x_action_request_tbl(b).request_type =
5015: OE_Globals.G_LINK_CONFIG
5016: THEN
5017: p_x_action_request_tbl(b).param1 :=
5018: p_x_line_tbl(I).inventory_item_id;
5019: END IF;

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

5017: p_x_action_request_tbl(b).param1 :=
5018: p_x_line_tbl(I).inventory_item_id;
5019: END IF;
5020: END IF;
5021: IF p_x_action_request_tbl(b).entity_code = OE_Globals.G_ENTITY_LINE
5022: AND p_x_action_request_tbl(b).entity_index > l_line_count THEN
5023: raise e_break;
5024: END IF;
5025: END LOOP;--}

Line 6166: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI

6162: /* -----------------------------------------------------------
6163: Call EDI Pre-Process
6164: -----------------------------------------------------------
6165: */
6166: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI
6167: THEN
6168: IF l_debug_level > 0 THEN
6169: oe_debug_pub.add( 'BEFORE CALLING EDI PRE-PROCESS' ) ;
6170: END IF;

Line 6490: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI

6486: Call EDI Post-Process
6487: -----------------------------------------------------------
6488: */
6489:
6490: IF p_x_header_rec.order_source_id = OE_Globals.G_ORDER_SOURCE_EDI
6491: THEN
6492: IF l_debug_level > 0 THEN
6493: oe_debug_pub.add( 'BEFORE CALLING EDI POST-PROCESS' ) ;
6494: END IF;