DBA Data[Home] [Help]

APPS.OE_SPLIT_UTIL dependencies on FND_GLOBAL

Line 2283: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

2279:
2280: CURSOR c_split_details IS
2281: SELECT * FROM oe_line_split_details
2282: WHERE line_id = l_init_line_id
2283: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2284: FOR UPDATE NOWAIT;
2285:
2286:
2287: BEGIN

Line 2320: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

2316: END;
2317:
2318: select count(*) into l_count
2319: from oe_line_split_details where line_id = l_init_line_id
2320: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2321:
2322: IF l_count = 0 THEN
2323: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2324: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);

Line 2324: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);

2320: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2321:
2322: IF l_count = 0 THEN
2323: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2324: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
2325: OE_Msg_Pub.Add;
2326: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
2327: RETURN;
2328: END IF;

Line 2337: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

2333: SELECT sum(ORDERED_QUANTITY), sum(ORDERED_QUANTITY2)
2334: INTO l_ord_qty_sum, l_ord_qty2_sum
2335: FROM oe_line_split_details
2336: WHERE line_id = l_init_line_id
2337: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2338:
2339: SELECT ordered_quantity, ordered_quantity2
2340: INTO l_orig_ord_qty, l_orig_ord_qty2
2341: FROM oe_order_lines_all

Line 2387: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

2383: l_x_line_tbl(i).line_id := l_line_conc_tbl(i).line_id;
2384: l_x_line_tbl(i).split_action_code := 'SPLIT';
2385: IF l_line_conc_tbl(i).split_by = 'SCHEDULER' THEN
2386: l_x_line_tbl(i).split_by := 'SYSTEM';
2387: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2388: ELSE
2389: l_x_line_tbl(i).split_by := 'USER';
2390: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2391: END IF;

Line 2390: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

2386: l_x_line_tbl(i).split_by := 'SYSTEM';
2387: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2388: ELSE
2389: l_x_line_tbl(i).split_by := 'USER';
2390: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2391: END IF;
2392: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
2393: IF l_debug_level > 0 THEN
2394: OE_DEBUG_PUB.add('Audit Trail Reason Code being passed as '||

Line 2406: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

2402: END IF;
2403: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
2404: IF l_line_conc_tbl(i).split_by = 'SCHEDULER' THEN
2405: l_x_line_tbl(i).split_by := 'SYSTEM';
2406: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2407: ELSE
2408: l_x_line_tbl(i).split_by := 'USER';
2409: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2410: END IF;

Line 2409: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;

2405: l_x_line_tbl(i).split_by := 'SYSTEM';
2406: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2407: ELSE
2408: l_x_line_tbl(i).split_by := 'USER';
2409: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2410: END IF;
2411: END IF;
2412: l_x_line_tbl(i).ordered_quantity := l_line_conc_tbl(i).ordered_quantity;
2413: l_x_line_tbl(i).ordered_quantity2 := l_line_conc_tbl(i).ordered_quantity2;

Line 2629: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

2625:
2626: -- Irrespective of program result, deleting the data from table
2627: DELETE FROM oe_line_split_details
2628: WHERE line_id = l_init_line_id
2629: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2630:
2631: ELSE -- l_count < 2
2632: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2633: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);

Line 2633: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);

2629: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2630:
2631: ELSE -- l_count < 2
2632: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2633: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
2634: OE_Msg_Pub.Add;
2635: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
2636: RETURN;
2637:

Line 2656: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);

2652: FND_FILE.put_line(FND_FILE.output, l_msg_data);
2653: -- Writing messages into the concurrent request output file
2654: END LOOP;
2655: oe_debug_pub.add(' Saving the Messages');
2656: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);
2657: -- Bug 6964815
2658:
2659: ELSE
2660: FND_FILE.put_line(FND_FILE.output,' << No Errors or Warnings reported >>');

Line 2678: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);

2674: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);
2675: FND_FILE.put_line(FND_FILE.output, l_msg_data);
2676: -- Writing messages into the concurrent request output file
2677: END LOOP;
2678: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);
2679: -- Bug 6964815
2680: END IF;
2681: END IF;
2682:

Line 2692: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

2688: ROLLBACK;
2689: -- Irrespective of program result, deleting the data from table
2690: DELETE FROM oe_line_split_details
2691: WHERE line_id = l_init_line_id
2692: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2693: COMMIT;
2694: END Defer_Split;
2695:
2696: PROCEDURE Bulk_Insert (p_line_conc_tbl IN Split_Line_Tbl_Type) is