DBA Data[Home] [Help]

APPS.OE_SPLIT_UTIL dependencies on FND_GLOBAL

Line 2670: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

2666:
2667: CURSOR c_split_details IS
2668: SELECT * FROM oe_line_split_details
2669: WHERE line_id = l_init_line_id
2670: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2671: FOR UPDATE NOWAIT;
2672:
2673:
2674: BEGIN

Line 2707: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

2703: END;
2704:
2705: select count(*) into l_count
2706: from oe_line_split_details where line_id = l_init_line_id
2707: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2708:
2709: IF l_count = 0 THEN
2710: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2711: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);

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

2707: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2708:
2709: IF l_count = 0 THEN
2710: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2711: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
2712: OE_Msg_Pub.Add;
2713: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
2714: RETURN;
2715: END IF;

Line 2724: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

2720: SELECT sum(ORDERED_QUANTITY), sum(ORDERED_QUANTITY2)
2721: INTO l_ord_qty_sum, l_ord_qty2_sum
2722: FROM oe_line_split_details
2723: WHERE line_id = l_init_line_id
2724: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
2725:
2726: SELECT ordered_quantity, ordered_quantity2
2727: INTO l_orig_ord_qty, l_orig_ord_qty2
2728: FROM oe_order_lines_all

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

2775: l_x_line_tbl(i).line_id := l_line_conc_tbl(i).line_id;
2776: l_x_line_tbl(i).split_action_code := 'SPLIT';
2777: IF l_line_conc_tbl(i).split_by = 'SCHEDULER' THEN
2778: l_x_line_tbl(i).split_by := 'SYSTEM';
2779: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2780: ELSE
2781: l_x_line_tbl(i).split_by := 'USER';
2782: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2783: END IF;

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

2778: l_x_line_tbl(i).split_by := 'SYSTEM';
2779: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2780: ELSE
2781: l_x_line_tbl(i).split_by := 'USER';
2782: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2783: END IF;
2784: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
2785: IF l_debug_level > 0 THEN
2786: OE_DEBUG_PUB.add('Audit Trail Reason Code being passed as '||

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

2794: END IF;
2795: l_x_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
2796: IF l_line_conc_tbl(i).split_by = 'SCHEDULER' THEN
2797: l_x_line_tbl(i).split_by := 'SYSTEM';
2798: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2799: ELSE
2800: l_x_line_tbl(i).split_by := 'USER';
2801: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2802: END IF;

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

2797: l_x_line_tbl(i).split_by := 'SYSTEM';
2798: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2799: ELSE
2800: l_x_line_tbl(i).split_by := 'USER';
2801: l_x_line_tbl(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
2802: END IF;
2803: END IF;
2804: l_x_line_tbl(i).ordered_quantity := l_line_conc_tbl(i).ordered_quantity;
2805: l_x_line_tbl(i).ordered_quantity2 := l_line_conc_tbl(i).ordered_quantity2;

Line 3069: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

3065:
3066: -- Irrespective of program result, deleting the data from table
3067: DELETE FROM oe_line_split_details
3068: WHERE line_id = l_init_line_id
3069: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
3070:
3071: ELSE -- l_count < 2
3072: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
3073: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);

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

3069: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
3070:
3071: ELSE -- l_count < 2
3072: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
3073: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
3074: OE_Msg_Pub.Add;
3075: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
3076: RETURN;
3077:

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

3092: FND_FILE.put_line(FND_FILE.output, l_msg_data);
3093: -- Writing messages into the concurrent request output file
3094: END LOOP;
3095: oe_debug_pub.add(' Saving the Messages');
3096: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);
3097: -- Bug 6964815
3098:
3099: ELSE
3100: FND_FILE.put_line(FND_FILE.output,' << No Errors or Warnings reported >>');

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

3114: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);
3115: FND_FILE.put_line(FND_FILE.output, l_msg_data);
3116: -- Writing messages into the concurrent request output file
3117: END LOOP;
3118: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);
3119: -- Bug 6964815
3120: END IF;
3121: END IF;
3122:

Line 3132: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

3128: ROLLBACK;
3129: -- Irrespective of program result, deleting the data from table
3130: DELETE FROM oe_line_split_details
3131: WHERE line_id = l_init_line_id
3132: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;
3133: COMMIT;
3134: END Defer_Split;
3135:
3136: PROCEDURE Bulk_Insert (p_line_conc_tbl IN Split_Line_Tbl_Type) is