eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_BLANKET_SV dependencies on RLM_CORE_SV

Line 27: process_status <> rlm_core_sv.k_PS_PROCESSED

23: ship_to_address_id = x_Group_rec.ship_to_address_id AND
24: customer_item_id = x_Group_rec.customer_item_id AND
25: blanket_number = x_Group_rec.setup_terms_rec.blanket_number AND
26: item_detail_type IN (k_FIRM, k_PAST_DUE_FIRM, k_FORECAST) AND
27: process_status <> rlm_core_sv.k_PS_PROCESSED
28: ORDER BY request_date;
29: --
30: v_rso_hdr_id NUMBER;
31: v_count NUMBER;

Line 46: rlm_core_sv.dpush(C_SDEBUG, 'DeriveRSO');

42: --
43: BEGIN
44: --
45: IF (l_debug <> -1) THEN
46: rlm_core_sv.dpush(C_SDEBUG, 'DeriveRSO');
47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);
48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);

Line 47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);

43: BEGIN
44: --
45: IF (l_debug <> -1) THEN
46: rlm_core_sv.dpush(C_SDEBUG, 'DeriveRSO');
47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);
48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);

Line 48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);

44: --
45: IF (l_debug <> -1) THEN
46: rlm_core_sv.dpush(C_SDEBUG, 'DeriveRSO');
47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);
48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);

Line 49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);

45: IF (l_debug <> -1) THEN
46: rlm_core_sv.dpush(C_SDEBUG, 'DeriveRSO');
47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);
48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
53: END IF;

Line 50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);

46: rlm_core_sv.dpush(C_SDEBUG, 'DeriveRSO');
47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);
48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
53: END IF;
54: --

Line 51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);

47: rlm_core_sv.dlog(C_DEBUG, 'Ship From Org', x_Group_Rec.ship_from_org_id);
48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
53: END IF;
54: --
55: x_return_status := rlm_core_sv.k_PROC_SUCCESS;

Line 52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);

48: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address ID', x_Group_rec.ship_to_address_id);
49: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
50: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
53: END IF;
54: --
55: x_return_status := rlm_core_sv.k_PROC_SUCCESS;
56: --

Line 55: x_return_status := rlm_core_sv.k_PROC_SUCCESS;

51: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
52: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
53: END IF;
54: --
55: x_return_status := rlm_core_sv.k_PROC_SUCCESS;
56: --
57: g_LineIdTab.DELETE;
58: g_RSOIdTab.DELETE;
59: l_index := 1;

Line 68: rlm_core_sv.dlog(C_DEBUG, '====================================');

64: --
65: FOR c_lines_rec IN c_lines LOOP
66: --
67: IF (l_debug <> -1) THEN
68: rlm_core_sv.dlog(C_DEBUG, '====================================');
69: rlm_core_sv.dlog(C_DEBUG, 'Processing line', c_lines_rec.line_id);
70: rlm_core_sv.dlog(C_DEBUG, 'Request Date', c_lines_rec.request_date);
71: rlm_core_sv.dlog(C_DEBUG, 'Item Detail Type', c_lines_rec.item_Detail_type);
72: END IF;

Line 69: rlm_core_sv.dlog(C_DEBUG, 'Processing line', c_lines_rec.line_id);

65: FOR c_lines_rec IN c_lines LOOP
66: --
67: IF (l_debug <> -1) THEN
68: rlm_core_sv.dlog(C_DEBUG, '====================================');
69: rlm_core_sv.dlog(C_DEBUG, 'Processing line', c_lines_rec.line_id);
70: rlm_core_sv.dlog(C_DEBUG, 'Request Date', c_lines_rec.request_date);
71: rlm_core_sv.dlog(C_DEBUG, 'Item Detail Type', c_lines_rec.item_Detail_type);
72: END IF;
73: --

Line 70: rlm_core_sv.dlog(C_DEBUG, 'Request Date', c_lines_rec.request_date);

66: --
67: IF (l_debug <> -1) THEN
68: rlm_core_sv.dlog(C_DEBUG, '====================================');
69: rlm_core_sv.dlog(C_DEBUG, 'Processing line', c_lines_rec.line_id);
70: rlm_core_sv.dlog(C_DEBUG, 'Request Date', c_lines_rec.request_date);
71: rlm_core_sv.dlog(C_DEBUG, 'Item Detail Type', c_lines_rec.item_Detail_type);
72: END IF;
73: --
74: g_line_id := c_lines_rec.line_id; --Bugfix 6884912

Line 71: rlm_core_sv.dlog(C_DEBUG, 'Item Detail Type', c_lines_rec.item_Detail_type);

67: IF (l_debug <> -1) THEN
68: rlm_core_sv.dlog(C_DEBUG, '====================================');
69: rlm_core_sv.dlog(C_DEBUG, 'Processing line', c_lines_rec.line_id);
70: rlm_core_sv.dlog(C_DEBUG, 'Request Date', c_lines_rec.request_date);
71: rlm_core_sv.dlog(C_DEBUG, 'Item Detail Type', c_lines_rec.item_Detail_type);
72: END IF;
73: --
74: g_line_id := c_lines_rec.line_id; --Bugfix 6884912
75: -- 4302492 :start

Line 87: rlm_core_sv.dlog(C_DEBUG, 'v_RFFlag is:', v_RFFlag);

83: v_RFFlag := x_Group_rec.setup_terms_rec.seq_frozen_flag;
84: END IF;
85: --
86: IF (l_debug <> -1) THEN
87: rlm_core_sv.dlog(C_DEBUG, 'v_RFFlag is:', v_RFFlag);
88: rlm_core_sv.dlog(C_DEBUG, 'before calling CalFenceDays');
89: END IF;
90: --
91: CalFenceDays(x_Sched_rec,x_Group_rec,v_fence_days);

Line 88: rlm_core_sv.dlog(C_DEBUG, 'before calling CalFenceDays');

84: END IF;
85: --
86: IF (l_debug <> -1) THEN
87: rlm_core_sv.dlog(C_DEBUG, 'v_RFFlag is:', v_RFFlag);
88: rlm_core_sv.dlog(C_DEBUG, 'before calling CalFenceDays');
89: END IF;
90: --
91: CalFenceDays(x_Sched_rec,x_Group_rec,v_fence_days);
92: --

Line 94: rlm_core_sv.dlog(C_DEBUG, 'v_fence_days is:', v_fence_days);

90: --
91: CalFenceDays(x_Sched_rec,x_Group_rec,v_fence_days);
92: --
93: IF (l_debug <> -1) THEN
94: rlm_core_sv.dlog(C_DEBUG, 'v_fence_days is:', v_fence_days);
95: END IF;
96: --
97: l_Group_rec:= x_group_rec;
98: l_Group_rec.frozen_days := v_fence_days;

Line 123: rlm_core_sv.dlog(C_DEBUG, 'v_rso_hdr_id', v_rso_hdr_id);

119: --
120: END IF;
121: --
122: IF (l_debug <> -1) THEN
123: rlm_core_sv.dlog(C_DEBUG, 'v_rso_hdr_id', v_rso_hdr_id);
124: rlm_core_sv.dlog(C_DEBUG, 'v_start_date', v_start_date);
125: rlm_core_sv.dlog(C_DEBUG, 'v_end_date', v_end_date);
126: rlm_core_sv.dlog(C_DEBUG, 'v_maxend_date', v_maxend_date);
127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);

Line 124: rlm_core_sv.dlog(C_DEBUG, 'v_start_date', v_start_date);

120: END IF;
121: --
122: IF (l_debug <> -1) THEN
123: rlm_core_sv.dlog(C_DEBUG, 'v_rso_hdr_id', v_rso_hdr_id);
124: rlm_core_sv.dlog(C_DEBUG, 'v_start_date', v_start_date);
125: rlm_core_sv.dlog(C_DEBUG, 'v_end_date', v_end_date);
126: rlm_core_sv.dlog(C_DEBUG, 'v_maxend_date', v_maxend_date);
127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);
128: END IF;

Line 125: rlm_core_sv.dlog(C_DEBUG, 'v_end_date', v_end_date);

121: --
122: IF (l_debug <> -1) THEN
123: rlm_core_sv.dlog(C_DEBUG, 'v_rso_hdr_id', v_rso_hdr_id);
124: rlm_core_sv.dlog(C_DEBUG, 'v_start_date', v_start_date);
125: rlm_core_sv.dlog(C_DEBUG, 'v_end_date', v_end_date);
126: rlm_core_sv.dlog(C_DEBUG, 'v_maxend_date', v_maxend_date);
127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);
128: END IF;
129: --

Line 126: rlm_core_sv.dlog(C_DEBUG, 'v_maxend_date', v_maxend_date);

122: IF (l_debug <> -1) THEN
123: rlm_core_sv.dlog(C_DEBUG, 'v_rso_hdr_id', v_rso_hdr_id);
124: rlm_core_sv.dlog(C_DEBUG, 'v_start_date', v_start_date);
125: rlm_core_sv.dlog(C_DEBUG, 'v_end_date', v_end_date);
126: rlm_core_sv.dlog(C_DEBUG, 'v_maxend_date', v_maxend_date);
127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);
128: END IF;
129: --
130: -- Bug 4901148 : QueryRSO() returns one of the following values

Line 127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);

123: rlm_core_sv.dlog(C_DEBUG, 'v_rso_hdr_id', v_rso_hdr_id);
124: rlm_core_sv.dlog(C_DEBUG, 'v_start_date', v_start_date);
125: rlm_core_sv.dlog(C_DEBUG, 'v_end_date', v_end_date);
126: rlm_core_sv.dlog(C_DEBUG, 'v_maxend_date', v_maxend_date);
127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);
128: END IF;
129: --
130: -- Bug 4901148 : QueryRSO() returns one of the following values
131: -- * A valid RSO Header ID, corresponding to a record in oe_order_headers

Line 141: rlm_core_sv.dlog(C_DEBUG, 'Recreating RSO, since DSP found a closed one');

137: --{
138: IF (v_rso_hdr_id = -1) THEN
139: --{
140: IF (l_debug <> -1) THEN
141: rlm_core_sv.dlog(C_DEBUG, 'Recreating RSO, since DSP found a closed one');
142: END IF;
143: --
144: RLM_TPA_SV.CreateRSOHeader(x_Sched_rec, x_Group_rec, v_rso_hdr_id);
145: RLM_TPA_SV.InsertRSO(x_Sched_rec, x_Group_rec, v_rso_hdr_id, v_start_date,

Line 151: rlm_core_sv.dlog(C_DEBUG, 'Orphan record in RLM table, so recreate RSO and log exception');

147: --}
148: ELSIF (v_rso_hdr_id = -99) THEN
149: --{
150: IF (l_debug <> -1) THEN
151: rlm_core_sv.dlog(C_DEBUG, 'Orphan record in RLM table, so recreate RSO and log exception');
152: END IF;
153: --
154: rlm_message_sv.app_error(
155: x_ExceptionLevel => rlm_message_sv.k_warn_level,

Line 225: rlm_core_sv.dlog(C_DEBUG, 'Line id', g_LineIdTab(l_index));

221: g_LineIdTab(l_index) := c_lines_rec.line_id;
222: g_RSOIdTab(l_index) := v_rso_hdr_id;
223: --
224: IF (l_debug <> -1) THEN
225: rlm_core_sv.dlog(C_DEBUG, 'Line id', g_LineIdTab(l_index));
226: rlm_core_sv.dlog(C_DEBUG, 'RSO Id', g_RSOIdTab(l_index));
227: END IF;
228: --
229: l_index := l_index + 1;

Line 226: rlm_core_sv.dlog(C_DEBUG, 'RSO Id', g_RSOIdTab(l_index));

222: g_RSOIdTab(l_index) := v_rso_hdr_id;
223: --
224: IF (l_debug <> -1) THEN
225: rlm_core_sv.dlog(C_DEBUG, 'Line id', g_LineIdTab(l_index));
226: rlm_core_sv.dlog(C_DEBUG, 'RSO Id', g_RSOIdTab(l_index));
227: END IF;
228: --
229: l_index := l_index + 1;
230: --

Line 237: rlm_core_sv.dpop(C_SDEBUG);

233: --Bug Fix 4254471 Added parameter to procedure
234: UpdateLinesWithRSO(x_Sched_rec.schedule_header_id);
235: --
236: IF (l_debug <> -1) THEN
237: rlm_core_sv.dpop(C_SDEBUG);
238: END IF;
239: --
240: EXCEPTION
241: --

Line 244: x_return_Status := rlm_core_sv.k_PROC_ERROR;

240: EXCEPTION
241: --
242: WHEN e_RSOCreationError THEN
243: --
244: x_return_Status := rlm_core_sv.k_PROC_ERROR;
245: --
246: IF (l_debug <> -1) THEN
247: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');
248: END IF;

Line 247: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');

243: --
244: x_return_Status := rlm_core_sv.k_PROC_ERROR;
245: --
246: IF (l_debug <> -1) THEN
247: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');
248: END IF;
249: --
250: WHEN OTHERS THEN
251: x_return_Status := RLM_CORE_SV.k_PROC_ERROR;

Line 251: x_return_Status := RLM_CORE_SV.k_PROC_ERROR;

247: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');
248: END IF;
249: --
250: WHEN OTHERS THEN
251: x_return_Status := RLM_CORE_SV.k_PROC_ERROR;
252: rlm_message_sv.sql_error('RLM_BLANKET_SV.DeriveRSO', '040');
253: --
254: IF (l_debug <> -1) THEN
255: rlm_core_sv.dlog(C_DEBUG, 'When others of DeriveRSO');

Line 255: rlm_core_sv.dlog(C_DEBUG, 'When others of DeriveRSO');

251: x_return_Status := RLM_CORE_SV.k_PROC_ERROR;
252: rlm_message_sv.sql_error('RLM_BLANKET_SV.DeriveRSO', '040');
253: --
254: IF (l_debug <> -1) THEN
255: rlm_core_sv.dlog(C_DEBUG, 'When others of DeriveRSO');
256: rlm_core_sv.dpop(C_SDEBUG,'DeriveRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));
257: END IF;
258: --
259: END DeriveRSO;

Line 256: rlm_core_sv.dpop(C_SDEBUG,'DeriveRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));

252: rlm_message_sv.sql_error('RLM_BLANKET_SV.DeriveRSO', '040');
253: --
254: IF (l_debug <> -1) THEN
255: rlm_core_sv.dlog(C_DEBUG, 'When others of DeriveRSO');
256: rlm_core_sv.dpop(C_SDEBUG,'DeriveRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));
257: END IF;
258: --
259: END DeriveRSO;
260:

Line 311: rlm_core_sv.dpush(C_SDEBUG, 'QueryRSO');

307: --
308: BEGIN
309: --
310: IF (l_debug <> -1) THEN
311: rlm_core_sv.dpush(C_SDEBUG, 'QueryRSO');
312: END IF;
313: --
314: v_rel_rule := x_Group_rec.setup_terms_rec.release_rule;
315: --

Line 317: rlm_core_sv.dlog(C_DEBUG, 'p_customer_id', p_customer_id);

313: --
314: v_rel_rule := x_Group_rec.setup_terms_rec.release_rule;
315: --
316: IF (l_debug <> -1) THEN
317: rlm_core_sv.dlog(C_DEBUG, 'p_customer_id', p_customer_id);
318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);
319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);
320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);
321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);

Line 318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);

314: v_rel_rule := x_Group_rec.setup_terms_rec.release_rule;
315: --
316: IF (l_debug <> -1) THEN
317: rlm_core_sv.dlog(C_DEBUG, 'p_customer_id', p_customer_id);
318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);
319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);
320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);
321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);
322: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);

Line 319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);

315: --
316: IF (l_debug <> -1) THEN
317: rlm_core_sv.dlog(C_DEBUG, 'p_customer_id', p_customer_id);
318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);
319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);
320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);
321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);
322: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
323: END IF;

Line 320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);

316: IF (l_debug <> -1) THEN
317: rlm_core_sv.dlog(C_DEBUG, 'p_customer_id', p_customer_id);
318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);
319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);
320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);
321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);
322: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
323: END IF;
324: --

Line 321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);

317: rlm_core_sv.dlog(C_DEBUG, 'p_customer_id', p_customer_id);
318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);
319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);
320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);
321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);
322: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
323: END IF;
324: --
325: v_first := TRUE;

Line 322: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);

318: rlm_core_sv.dlog(C_DEBUG, 'p_blanket_number', x_Group_rec.setup_terms_rec.blanket_number);
319: rlm_core_sv.dlog(C_DEBUG, 'p_request_date', p_request_date);
320: rlm_core_sv.dlog(C_DEBUG, 'p_cust_item_id', p_cust_item_id);
321: rlm_core_sv.dlog(C_DEBUG, 'Release Creation Rule', v_rel_rule);
322: rlm_core_sv.dlog(C_DEBUG, 'Release Time Frame', x_Group_rec.setup_terms_rec.release_time_frame);
323: END IF;
324: --
325: v_first := TRUE;
326: --

Line 338: rlm_core_sv.dlog(C_DEBUG, 'Inside PI if');

334: IF (TRUNC(p_request_date) >= TRUNC(v_start_date) AND
335: TRUNC(p_request_date) < TRUNC(v_end_date) + 1) THEN
336: --
337: IF (l_debug <> -1) THEN
338: rlm_core_sv.dlog(C_DEBUG, 'Inside PI if');
339: END IF;
340: --
341: x_rso_hdr_id := v_rsohdr_id;
342: x_start_date := v_start_date;

Line 372: rlm_core_sv.dlog(C_DEBUG, 'Inside AI if');

368: IF (TRUNC(p_request_date) >= v_start_date AND
369: TRUNC(p_request_date) < TRUNC(v_end_date)+1) THEN
370: --
371: IF (l_debug <> -1) THEN
372: rlm_core_sv.dlog(C_DEBUG, 'Inside AI if');
373: END IF;
374: --
375: x_rso_hdr_id := v_rsohdr_id;
376: x_start_date := v_start_date;

Line 404: rlm_core_sv.dpop(C_SDEBUG, x_rso_hdr_id);

400: x_maxend_date := NVL(v_maxend_date, k_DNULL);
401: x_minstart_date := NVL(v_minstart_date, k_DNULL);
402: --
403: IF (l_debug <> -1) THEN
404: rlm_core_sv.dpop(C_SDEBUG, x_rso_hdr_id);
405: END IF;
406: --
407: EXCEPTION
408: --

Line 412: rlm_core_sv.dpop(C_SDEBUG,'QueryRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));

408: --
409: WHEN OTHERS THEN
410: --
411: IF (l_debug <> -1) THEN
412: rlm_core_sv.dpop(C_SDEBUG,'QueryRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));
413: END IF;
414: --
415: RAISE;
416: --

Line 434: rlm_core_sv.dpush(C_SDEBUG, 'CalcEffectiveDates');

430: --
431: BEGIN
432: --
433: IF (l_debug <> -1) THEN
434: rlm_core_sv.dpush(C_SDEBUG, 'CalcEffectiveDates');
435: END IF;
436: --
437: IF x_maxend_date = k_DNULL THEN
438: --

Line 440: rlm_core_sv.dlog(C_DEBUG, 'This will the first entry of its type in the RLM_RSO table');

436: --
437: IF x_maxend_date = k_DNULL THEN
438: --
439: IF (l_debug <> -1) THEN
440: rlm_core_sv.dlog(C_DEBUG, 'This will the first entry of its type in the RLM_RSO table');
441: END IF;
442: --
443: IF to_char(p_request_date, 'D') = g_SundayDOW THEN
444: --

Line 458: rlm_core_sv.dlog(C_DEBUG, 'Using context of existing RSOs');

454: --
455: ELSE
456: --
457: IF (l_debug <> -1) THEN
458: rlm_core_sv.dlog(C_DEBUG, 'Using context of existing RSOs');
459: rlm_core_sv.dlog(C_DEBUG, 'End effective date of last RSO', x_maxend_date);
460: END IF;
461: --
462: x_start_date := x_maxend_date + 1;

Line 459: rlm_core_sv.dlog(C_DEBUG, 'End effective date of last RSO', x_maxend_date);

455: ELSE
456: --
457: IF (l_debug <> -1) THEN
458: rlm_core_sv.dlog(C_DEBUG, 'Using context of existing RSOs');
459: rlm_core_sv.dlog(C_DEBUG, 'End effective date of last RSO', x_maxend_date);
460: END IF;
461: --
462: x_start_date := x_maxend_date + 1;
463: x_end_date := x_start_date + (x_Group_rec.setup_terms_rec.release_time_frame * 7) - 1;

Line 470: rlm_core_sv.dlog(C_DEBUG, 'Effective start date of new RSO', x_start_date);

466: --
467: x_maxend_date := x_end_date;
468: --
469: IF (l_debug <> -1) THEN
470: rlm_core_sv.dlog(C_DEBUG, 'Effective start date of new RSO', x_start_date);
471: rlm_core_sv.dlog(C_DEBUG, 'Effective end date of new RSO', x_end_date);
472: rlm_core_sv.dlog(C_DEBUG, 'Max Effec. end date', x_maxend_date);
473: rlm_core_sv.dpop(C_SDEBUG);
474: END IF;

Line 471: rlm_core_sv.dlog(C_DEBUG, 'Effective end date of new RSO', x_end_date);

467: x_maxend_date := x_end_date;
468: --
469: IF (l_debug <> -1) THEN
470: rlm_core_sv.dlog(C_DEBUG, 'Effective start date of new RSO', x_start_date);
471: rlm_core_sv.dlog(C_DEBUG, 'Effective end date of new RSO', x_end_date);
472: rlm_core_sv.dlog(C_DEBUG, 'Max Effec. end date', x_maxend_date);
473: rlm_core_sv.dpop(C_SDEBUG);
474: END IF;
475: --

Line 472: rlm_core_sv.dlog(C_DEBUG, 'Max Effec. end date', x_maxend_date);

468: --
469: IF (l_debug <> -1) THEN
470: rlm_core_sv.dlog(C_DEBUG, 'Effective start date of new RSO', x_start_date);
471: rlm_core_sv.dlog(C_DEBUG, 'Effective end date of new RSO', x_end_date);
472: rlm_core_sv.dlog(C_DEBUG, 'Max Effec. end date', x_maxend_date);
473: rlm_core_sv.dpop(C_SDEBUG);
474: END IF;
475: --
476: EXCEPTION

Line 473: rlm_core_sv.dpop(C_SDEBUG);

469: IF (l_debug <> -1) THEN
470: rlm_core_sv.dlog(C_DEBUG, 'Effective start date of new RSO', x_start_date);
471: rlm_core_sv.dlog(C_DEBUG, 'Effective end date of new RSO', x_end_date);
472: rlm_core_sv.dlog(C_DEBUG, 'Max Effec. end date', x_maxend_date);
473: rlm_core_sv.dpop(C_SDEBUG);
474: END IF;
475: --
476: EXCEPTION
477: --

Line 481: rlm_core_sv.dpop(C_SDEBUG,'CalcEffectiveDates EXCEPTION: '||SUBSTR(SQLERRM,1,200));

477: --
478: WHEN OTHERS THEN
479: --
480: IF (l_debug <> -1) THEN
481: rlm_core_sv.dpop(C_SDEBUG,'CalcEffectiveDates EXCEPTION: '||SUBSTR(SQLERRM,1,200));
482: END IF;
483: --
484: RAISE;
485: --

Line 503: rlm_core_sv.dpush(C_SDEBUG, 'CalcPriorEffectDates');

499: x_minstart_date IN OUT NOCOPY DATE) IS
500: BEGIN
501: --
502: IF (l_debug <> -1) THEN
503: rlm_core_sv.dpush(C_SDEBUG, 'CalcPriorEffectDates');
504: rlm_core_sv.dlog(C_DEBUG, 'x_minstart_date', x_minstart_date);
505: END IF;
506: --
507: x_end_date := x_minstart_date - 1;

Line 504: rlm_core_sv.dlog(C_DEBUG, 'x_minstart_date', x_minstart_date);

500: BEGIN
501: --
502: IF (l_debug <> -1) THEN
503: rlm_core_sv.dpush(C_SDEBUG, 'CalcPriorEffectDates');
504: rlm_core_sv.dlog(C_DEBUG, 'x_minstart_date', x_minstart_date);
505: END IF;
506: --
507: x_end_date := x_minstart_date - 1;
508: x_start_date := x_end_date - (7 * x_Group_rec.setup_terms_rec.release_time_frame) + 1;

Line 512: rlm_core_sv.dlog(C_DEBUG, 'x_start_date', x_start_date);

508: x_start_date := x_end_date - (7 * x_Group_rec.setup_terms_rec.release_time_frame) + 1;
509: x_minstart_date := x_start_date;
510: --
511: IF (l_debug <> -1) THEN
512: rlm_core_sv.dlog(C_DEBUG, 'x_start_date', x_start_date);
513: rlm_core_sv.dlog(C_DEBUG, 'x_end_date', x_end_date);
514: rlm_core_sv.dlog(C_DEBUG, 'New x_minstart_date', x_minstart_date);
515: rlm_core_sv.dpop(C_SDEBUG);
516: END IF;

Line 513: rlm_core_sv.dlog(C_DEBUG, 'x_end_date', x_end_date);

509: x_minstart_date := x_start_date;
510: --
511: IF (l_debug <> -1) THEN
512: rlm_core_sv.dlog(C_DEBUG, 'x_start_date', x_start_date);
513: rlm_core_sv.dlog(C_DEBUG, 'x_end_date', x_end_date);
514: rlm_core_sv.dlog(C_DEBUG, 'New x_minstart_date', x_minstart_date);
515: rlm_core_sv.dpop(C_SDEBUG);
516: END IF;
517: --

Line 514: rlm_core_sv.dlog(C_DEBUG, 'New x_minstart_date', x_minstart_date);

510: --
511: IF (l_debug <> -1) THEN
512: rlm_core_sv.dlog(C_DEBUG, 'x_start_date', x_start_date);
513: rlm_core_sv.dlog(C_DEBUG, 'x_end_date', x_end_date);
514: rlm_core_sv.dlog(C_DEBUG, 'New x_minstart_date', x_minstart_date);
515: rlm_core_sv.dpop(C_SDEBUG);
516: END IF;
517: --
518: EXCEPTION

Line 515: rlm_core_sv.dpop(C_SDEBUG);

511: IF (l_debug <> -1) THEN
512: rlm_core_sv.dlog(C_DEBUG, 'x_start_date', x_start_date);
513: rlm_core_sv.dlog(C_DEBUG, 'x_end_date', x_end_date);
514: rlm_core_sv.dlog(C_DEBUG, 'New x_minstart_date', x_minstart_date);
515: rlm_core_sv.dpop(C_SDEBUG);
516: END IF;
517: --
518: EXCEPTION
519: --

Line 523: rlm_core_sv.dpop(C_SDEBUG,'CalcPriorEffectDates EXCEPTION: '||SUBSTR(SQLERRM,1,200));

519: --
520: WHEN OTHERS THEN
521: --
522: IF (l_debug <> -1) THEN
523: rlm_core_sv.dpop(C_SDEBUG,'CalcPriorEffectDates EXCEPTION: '||SUBSTR(SQLERRM,1,200));
524: END IF;
525: --
526: RAISE;
527: --

Line 547: rlm_core_sv.dpush(C_SDEBUG, 'InsertRSO');

543: --
544: BEGIN
545: --
546: IF (l_debug <> -1) THEN
547: rlm_core_sv.dpush(C_SDEBUG, 'InsertRSO');
548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);

Line 548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);

544: BEGIN
545: --
546: IF (l_debug <> -1) THEN
547: rlm_core_sv.dpush(C_SDEBUG, 'InsertRSO');
548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);

Line 549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);

545: --
546: IF (l_debug <> -1) THEN
547: rlm_core_sv.dpush(C_SDEBUG, 'InsertRSO');
548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);

Line 550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);

546: IF (l_debug <> -1) THEN
547: rlm_core_sv.dpush(C_SDEBUG, 'InsertRSO');
548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);
554: rlm_core_sv.dlog(C_DEBUG, 'p_end_date', p_end_date);

Line 551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);

547: rlm_core_sv.dpush(C_SDEBUG, 'InsertRSO');
548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);
554: rlm_core_sv.dlog(C_DEBUG, 'p_end_date', p_end_date);
555: END IF;

Line 552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);

548: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);
554: rlm_core_sv.dlog(C_DEBUG, 'p_end_date', p_end_date);
555: END IF;
556: --

Line 553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);

549: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);
554: rlm_core_sv.dlog(C_DEBUG, 'p_end_date', p_end_date);
555: END IF;
556: --
557: IF x_Group_rec.setup_terms_rec.release_rule = 'AI' THEN

Line 554: rlm_core_sv.dlog(C_DEBUG, 'p_end_date', p_end_date);

550: rlm_core_sv.dlog(C_DEBUG, 'Release Rule', x_Group_rec.setup_terms_rec.release_rule);
551: rlm_core_sv.dlog(C_DEBUG, 'p_rso_hdr_id', p_rso_hdr_id);
552: rlm_core_sv.dlog(C_DEBUG, 'Customer Item Id', x_Group_rec.customer_item_id);
553: rlm_core_sv.dlog(C_DEBUG, 'p_start_date', p_start_date);
554: rlm_core_sv.dlog(C_DEBUG, 'p_end_date', p_end_date);
555: END IF;
556: --
557: IF x_Group_rec.setup_terms_rec.release_rule = 'AI' THEN
558: v_customer_item_id := k_NNULL;

Line 564: rlm_core_sv.dlog(C_DEBUG, 'v_customer_item_id', v_customer_item_id);

560: v_customer_item_id := x_Group_rec.customer_item_id;
561: END IF;
562: --
563: IF (l_debug <> -1) THEN
564: rlm_core_sv.dlog(C_DEBUG, 'v_customer_item_id', v_customer_item_id);
565: END IF;
566: --
567: INSERT INTO RLM_BLANKET_RSO
568: (

Line 579: rlm_core_sv.dpop(C_SDEBUG);

575: p_rso_hdr_id, v_customer_item_id, TRUNC(p_start_date), TRUNC(p_end_date)
576: );
577: --
578: IF (l_debug <> -1) THEN
579: rlm_core_sv.dpop(C_SDEBUG);
580: END IF;
581: --
582: EXCEPTION
583: --

Line 587: rlm_core_sv.dpop(C_SDEBUG,'InsertRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));

583: --
584: WHEN OTHERS THEN
585: --
586: IF (l_debug <> -1) THEN
587: rlm_core_sv.dpop(C_SDEBUG,'InsertRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));
588: END IF;
589: --
590: RAISE;
591: --

Line 649: rlm_core_sv.dpush(C_SDEBUG, 'CreateRSOHeader');

645: --
646: BEGIN
647: --
648: IF (l_debug <> -1) THEN
649: rlm_core_sv.dpush(C_SDEBUG, 'CreateRSOHeader');
650: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
651: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
652: rlm_core_sv.dlog(C_DEBUG, 'Org ID', x_Sched_rec.org_id);
653: END IF;

Line 650: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);

646: BEGIN
647: --
648: IF (l_debug <> -1) THEN
649: rlm_core_sv.dpush(C_SDEBUG, 'CreateRSOHeader');
650: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
651: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
652: rlm_core_sv.dlog(C_DEBUG, 'Org ID', x_Sched_rec.org_id);
653: END IF;
654: --

Line 651: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);

647: --
648: IF (l_debug <> -1) THEN
649: rlm_core_sv.dpush(C_SDEBUG, 'CreateRSOHeader');
650: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
651: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
652: rlm_core_sv.dlog(C_DEBUG, 'Org ID', x_Sched_rec.org_id);
653: END IF;
654: --
655: l_oe_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

Line 652: rlm_core_sv.dlog(C_DEBUG, 'Org ID', x_Sched_rec.org_id);

648: IF (l_debug <> -1) THEN
649: rlm_core_sv.dpush(C_SDEBUG, 'CreateRSOHeader');
650: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
651: rlm_core_sv.dlog(C_DEBUG, 'Customer id', x_Sched_rec.customer_id);
652: rlm_core_sv.dlog(C_DEBUG, 'Org ID', x_Sched_rec.org_id);
653: END IF;
654: --
655: l_oe_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
656: l_oe_header_rec.operation := OE_Globals.G_OPR_CREATE;

Line 701: rlm_core_sv.dlog(C_DEBUG,'Process Order return Status',l_return_Status);

697: , x_action_request_tbl => l_action_request_tbl_out
698: );
699: --
700: IF (l_debug <> -1) THEN
701: rlm_core_sv.dlog(C_DEBUG,'Process Order return Status',l_return_Status);
702: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Count',x_msg_count);
703: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Message',x_msg_data);
704: END IF;
705: --

Line 702: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Count',x_msg_count);

698: );
699: --
700: IF (l_debug <> -1) THEN
701: rlm_core_sv.dlog(C_DEBUG,'Process Order return Status',l_return_Status);
702: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Count',x_msg_count);
703: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Message',x_msg_data);
704: END IF;
705: --
706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

Line 703: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Message',x_msg_data);

699: --
700: IF (l_debug <> -1) THEN
701: rlm_core_sv.dlog(C_DEBUG,'Process Order return Status',l_return_Status);
702: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Count',x_msg_count);
703: rlm_core_sv.dlog(C_DEBUG,'Process Order Error Message',x_msg_data);
704: END IF;
705: --
706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
707: l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 723: rlm_core_sv.dlog(C_DEBUG, 'Sales order header id ',

719: --
720: END IF;
721: --
722: IF (l_debug <> -1) THEN
723: rlm_core_sv.dlog(C_DEBUG, 'Sales order header id ',
724: l_oe_header_rec_out.header_id);
725: rlm_core_sv.dlog(C_DEBUG, 'Sales order number',
726: l_oe_header_rec_out.order_number);
727: END IF;

Line 725: rlm_core_sv.dlog(C_DEBUG, 'Sales order number',

721: --
722: IF (l_debug <> -1) THEN
723: rlm_core_sv.dlog(C_DEBUG, 'Sales order header id ',
724: l_oe_header_rec_out.header_id);
725: rlm_core_sv.dlog(C_DEBUG, 'Sales order number',
726: l_oe_header_rec_out.order_number);
727: END IF;
728: --
729: x_rso_hdr_id := l_oe_header_rec_out.header_id;

Line 732: rlm_core_sv.dpop(C_SDEBUG);

728: --
729: x_rso_hdr_id := l_oe_header_rec_out.header_id;
730: --
731: IF (l_debug <> -1) THEN
732: rlm_core_sv.dpop(C_SDEBUG);
733: END IF;
734: --
735: EXCEPTION
736: --

Line 747: rlm_core_sv.dlog(C_DEBUG, 'RSO Creation Error: ' || x_msg_data);

743: x_msg_count, rlm_message_sv.k_ERROR_LEVEL,
744: x_token, x_msg_name);
745: --
746: IF (l_debug <> -1) THEN
747: rlm_core_sv.dlog(C_DEBUG, 'RSO Creation Error: ' || x_msg_data);
748: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');
749: END IF;
750: --
751: RAISE e_RSOCreationError;

Line 748: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');

744: x_token, x_msg_name);
745: --
746: IF (l_debug <> -1) THEN
747: rlm_core_sv.dlog(C_DEBUG, 'RSO Creation Error: ' || x_msg_data);
748: rlm_core_sv.dpop(C_SDEBUG, 'e_RSOCreationError');
749: END IF;
750: --
751: RAISE e_RSOCreationError;
752: --

Line 757: rlm_core_sv.dpop(C_SDEBUG, 'CreateRSOHeader');

753: WHEN OTHERS THEN
754: rlm_message_sv.sql_error('rlm_blanket_sv.CreateRSOHeader', v_progress);
755: --
756: IF (l_debug <> -1) THEN
757: rlm_core_sv.dpop(C_SDEBUG, 'CreateRSOHeader');
758: END IF;
759: --
760: RAISE;
761: --

Line 778: rlm_core_sv.dpush(C_SDEBUG, 'UpdateLinesWithRSO');

774: --
775: BEGIN
776: --
777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dpush(C_SDEBUG, 'UpdateLinesWithRSO');
779: rlm_core_sv.dlog(C_DEBUG, 'x_header_id', x_header_id);
780: rlm_core_sv.dlog(C_DEBUG, '# of lines', g_LineIdTab.COUNT);
781: rlm_core_sv.dlog(C_DEBUG, '# of RSOs', g_RSOIdTab.COUNT);
782: END IF;

Line 779: rlm_core_sv.dlog(C_DEBUG, 'x_header_id', x_header_id);

775: BEGIN
776: --
777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dpush(C_SDEBUG, 'UpdateLinesWithRSO');
779: rlm_core_sv.dlog(C_DEBUG, 'x_header_id', x_header_id);
780: rlm_core_sv.dlog(C_DEBUG, '# of lines', g_LineIdTab.COUNT);
781: rlm_core_sv.dlog(C_DEBUG, '# of RSOs', g_RSOIdTab.COUNT);
782: END IF;
783: --

Line 780: rlm_core_sv.dlog(C_DEBUG, '# of lines', g_LineIdTab.COUNT);

776: --
777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dpush(C_SDEBUG, 'UpdateLinesWithRSO');
779: rlm_core_sv.dlog(C_DEBUG, 'x_header_id', x_header_id);
780: rlm_core_sv.dlog(C_DEBUG, '# of lines', g_LineIdTab.COUNT);
781: rlm_core_sv.dlog(C_DEBUG, '# of RSOs', g_RSOIdTab.COUNT);
782: END IF;
783: --
784: FORALL i IN 1..g_LineIdTab.COUNT

Line 781: rlm_core_sv.dlog(C_DEBUG, '# of RSOs', g_RSOIdTab.COUNT);

777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dpush(C_SDEBUG, 'UpdateLinesWithRSO');
779: rlm_core_sv.dlog(C_DEBUG, 'x_header_id', x_header_id);
780: rlm_core_sv.dlog(C_DEBUG, '# of lines', g_LineIdTab.COUNT);
781: rlm_core_sv.dlog(C_DEBUG, '# of RSOs', g_RSOIdTab.COUNT);
782: END IF;
783: --
784: FORALL i IN 1..g_LineIdTab.COUNT
785: --

Line 791: rlm_core_sv.dlog(C_DEBUG, '# of interface lines updated', SQL%ROWCOUNT);

787: SET order_header_id = g_RSOIdTab(i)
788: WHERE line_id = g_LineIdTab(i);
789: --
790: IF (l_debug <> -1) THEN
791: rlm_core_sv.dlog(C_DEBUG, '# of interface lines updated', SQL%ROWCOUNT);
792: END IF;
793: --
794: FORALL i IN 1..g_LineIdTab.COUNT
795: --

Line 802: rlm_core_sv.dlog(C_DEBUG, '# of schedule lines updated', SQL%ROWCOUNT);

798: WHERE interface_line_id = g_LineIdTab(i)
799: AND header_id = x_header_id; /* 4254471 */
800: --
801: IF (l_debug <> -1) THEN
802: rlm_core_sv.dlog(C_DEBUG, '# of schedule lines updated', SQL%ROWCOUNT);
803: rlm_core_sv.dpop(C_SDEBUG);
804: END IF;
805: --
806: EXCEPTION

Line 803: rlm_core_sv.dpop(C_SDEBUG);

799: AND header_id = x_header_id; /* 4254471 */
800: --
801: IF (l_debug <> -1) THEN
802: rlm_core_sv.dlog(C_DEBUG, '# of schedule lines updated', SQL%ROWCOUNT);
803: rlm_core_sv.dpop(C_SDEBUG);
804: END IF;
805: --
806: EXCEPTION
807: --

Line 813: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

809: --
810: rlm_message_sv.sql_error('rlm_blanket_sv.UpdateLinesWithRSO', v_Progress);
811: --
812: IF (l_debug <> -1) THEN
813: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
814: END IF;
815: --
816: raise;
817:

Line 865: rlm_core_sv.dpush(C_SDEBUG, 'InsertOMMessages');

861: --
862: BEGIN
863: --
864: IF (l_debug <> -1) THEN
865: rlm_core_sv.dpush(C_SDEBUG, 'InsertOMMessages');
866: END IF;
867: --
868: IF x_msg_count >0 THEN
869: --

Line 876: rlm_core_sv.dlog(C_DEBUG,'Message Found', substr(x_msg,1,200));

872: x_msg := oe_msg_pub.get(p_msg_index => I,
873: p_encoded => 'F');
874: --
875: IF (l_debug <> -1) THEN
876: rlm_core_sv.dlog(C_DEBUG,'Message Found', substr(x_msg,1,200));
877: END IF;
878: --
879: oe_msg_pub.Get_msg_context(
880: p_msg_index => I

Line 902: rlm_core_sv.dlog(C_DEBUG,'l_header_id', l_header_id);

898: ,x_type => l_type
899: );
900: --
901: IF (l_debug <> -1) THEN
902: rlm_core_sv.dlog(C_DEBUG,'l_header_id', l_header_id);
903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);
904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);

Line 903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);

899: );
900: --
901: IF (l_debug <> -1) THEN
902: rlm_core_sv.dlog(C_DEBUG,'l_header_id', l_header_id);
903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);
904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);
907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);

Line 904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);

900: --
901: IF (l_debug <> -1) THEN
902: rlm_core_sv.dlog(C_DEBUG,'l_header_id', l_header_id);
903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);
904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);
907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);
908: rlm_core_sv.dlog(C_DEBUG,'x_InventoryItemId',x_Group_rec.inventory_item_id);

Line 905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);

901: IF (l_debug <> -1) THEN
902: rlm_core_sv.dlog(C_DEBUG,'l_header_id', l_header_id);
903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);
904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);
907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);
908: rlm_core_sv.dlog(C_DEBUG,'x_InventoryItemId',x_Group_rec.inventory_item_id);
909: END IF;

Line 906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);

902: rlm_core_sv.dlog(C_DEBUG,'l_header_id', l_header_id);
903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);
904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);
907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);
908: rlm_core_sv.dlog(C_DEBUG,'x_InventoryItemId',x_Group_rec.inventory_item_id);
909: END IF;
910: --

Line 907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);

903: rlm_core_sv.dlog(C_DEBUG,'x_msg_level', x_msg_level);
904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);
907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);
908: rlm_core_sv.dlog(C_DEBUG,'x_InventoryItemId',x_Group_rec.inventory_item_id);
909: END IF;
910: --
911: SELECT line_id

Line 908: rlm_core_sv.dlog(C_DEBUG,'x_InventoryItemId',x_Group_rec.inventory_item_id);

904: rlm_core_sv.dlog(C_DEBUG,'x_msg_name', x_msg_name);
905: rlm_core_sv.dlog(C_DEBUG,'Industry Att15', x_Group_rec.industry_attribute15);
906: rlm_core_sv.dlog(C_DEBUG,'x_ShipToAddressId',x_Group_rec.ship_to_address_id);
907: rlm_core_sv.dlog(C_DEBUG,'x_CustomerItemId',x_Group_rec.customer_item_id);
908: rlm_core_sv.dlog(C_DEBUG,'x_InventoryItemId',x_Group_rec.inventory_item_id);
909: END IF;
910: --
911: SELECT line_id
912: INTO v_InterfaceLineId

Line 936: rlm_core_sv.dlog(C_DEBUG, 'l_msg_level', l_msg_level);

932: l_msg_level := x_msg_level;
933: END IF;
934: --
935: IF (l_debug <> -1) THEN
936: rlm_core_sv.dlog(C_DEBUG, 'l_msg_level', l_msg_level);
937: END IF;
938: --
939: --Bugfix 6884912 Start
940: IF g_req_flag = 1 THEN

Line 991: rlm_core_sv.dpop(C_SDEBUG);

987: --
988: END IF;
989: --
990: IF (l_debug <> -1) THEN
991: rlm_core_sv.dpop(C_SDEBUG);
992: END IF;
993: --
994: EXCEPTION
995: --

Line 1001: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

997: --
998: rlm_message_sv.sql_error('rlm_blanket_sv.InsertOMMessages', v_Progress);
999: --
1000: IF (l_debug <> -1) THEN
1001: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1002: END IF;
1003: --
1004: raise;
1005: --

Line 1027: rlm_core_sv.dpush(C_SDEBUG,'GetTPContext');

1023: --
1024: BEGIN
1025: --
1026: IF (l_debug <> -1) THEN
1027: rlm_core_sv.dpush(C_SDEBUG,'GetTPContext');
1028: rlm_core_sv.dlog(C_DEBUG,'customer_id', x_Sched_rec.customer_id);
1029: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_translator_code',
1030: x_sched_rec.ece_tp_translator_code);
1031: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_location_code_ext',

Line 1028: rlm_core_sv.dlog(C_DEBUG,'customer_id', x_Sched_rec.customer_id);

1024: BEGIN
1025: --
1026: IF (l_debug <> -1) THEN
1027: rlm_core_sv.dpush(C_SDEBUG,'GetTPContext');
1028: rlm_core_sv.dlog(C_DEBUG,'customer_id', x_Sched_rec.customer_id);
1029: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_translator_code',
1030: x_sched_rec.ece_tp_translator_code);
1031: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_location_code_ext',
1032: x_sched_rec.ece_tp_location_code_ext);

Line 1029: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_translator_code',

1025: --
1026: IF (l_debug <> -1) THEN
1027: rlm_core_sv.dpush(C_SDEBUG,'GetTPContext');
1028: rlm_core_sv.dlog(C_DEBUG,'customer_id', x_Sched_rec.customer_id);
1029: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_translator_code',
1030: x_sched_rec.ece_tp_translator_code);
1031: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_location_code_ext',
1032: x_sched_rec.ece_tp_location_code_ext);
1033: rlm_core_sv.dlog(C_DEBUG,'x_group_rec.ship_to_address_id',

Line 1031: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_location_code_ext',

1027: rlm_core_sv.dpush(C_SDEBUG,'GetTPContext');
1028: rlm_core_sv.dlog(C_DEBUG,'customer_id', x_Sched_rec.customer_id);
1029: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_translator_code',
1030: x_sched_rec.ece_tp_translator_code);
1031: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_location_code_ext',
1032: x_sched_rec.ece_tp_location_code_ext);
1033: rlm_core_sv.dlog(C_DEBUG,'x_group_rec.ship_to_address_id',
1034: x_group_rec.ship_to_address_id);
1035: END IF;

Line 1033: rlm_core_sv.dlog(C_DEBUG,'x_group_rec.ship_to_address_id',

1029: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_translator_code',
1030: x_sched_rec.ece_tp_translator_code);
1031: rlm_core_sv.dlog(C_DEBUG,'x_sched_rec.ece_tp_location_code_ext',
1032: x_sched_rec.ece_tp_location_code_ext);
1033: rlm_core_sv.dlog(C_DEBUG,'x_group_rec.ship_to_address_id',
1034: x_group_rec.ship_to_address_id);
1035: END IF;
1036: --
1037: IF x_sched_rec.ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN

Line 1084: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);

1080: --
1081: END IF;
1082: --
1083: IF (l_debug <> -1) THEN
1084: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

Line 1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);

1081: END IF;
1082: --
1083: IF (l_debug <> -1) THEN
1084: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
1089: rlm_core_sv.dpop(C_SDEBUG);

Line 1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);

1082: --
1083: IF (l_debug <> -1) THEN
1084: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
1089: rlm_core_sv.dpop(C_SDEBUG);
1090: END IF;

Line 1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);

1083: IF (l_debug <> -1) THEN
1084: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
1089: rlm_core_sv.dpop(C_SDEBUG);
1090: END IF;
1091: --

Line 1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

1084: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
1089: rlm_core_sv.dpop(C_SDEBUG);
1090: END IF;
1091: --
1092: EXCEPTION

Line 1089: rlm_core_sv.dpop(C_SDEBUG);

1085: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
1086: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
1087: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
1088: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
1089: rlm_core_sv.dpop(C_SDEBUG);
1090: END IF;
1091: --
1092: EXCEPTION
1093: --

Line 1099: rlm_core_sv.dlog(C_DEBUG, 'No data found for' , x_sched_rec.customer_id);

1095: --
1096: x_customer_number := NULL;
1097: --
1098: IF (l_debug <> -1) THEN
1099: rlm_core_sv.dlog(C_DEBUG, 'No data found for' , x_sched_rec.customer_id);
1100: rlm_core_sv.dpop(C_SDEBUG);
1101: END IF;
1102: --
1103: WHEN OTHERS THEN

Line 1100: rlm_core_sv.dpop(C_SDEBUG);

1096: x_customer_number := NULL;
1097: --
1098: IF (l_debug <> -1) THEN
1099: rlm_core_sv.dlog(C_DEBUG, 'No data found for' , x_sched_rec.customer_id);
1100: rlm_core_sv.dpop(C_SDEBUG);
1101: END IF;
1102: --
1103: WHEN OTHERS THEN
1104: --

Line 1108: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

1104: --
1105: rlm_message_sv.sql_error('rlm_blanket_sv.GetTPContext',v_Progress);
1106: --
1107: IF (l_debug <> -1) THEN
1108: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1109: END IF;
1110: --
1111: raise;
1112:

Line 1134: rlm_core_sv.dpush(C_DEBUG,'CalFenceDays');

1130: --
1131: BEGIN
1132: --
1133: IF (l_debug <> -1) THEN
1134: rlm_core_sv.dpush(C_DEBUG,'CalFenceDays');
1135: rlm_core_sv.dlog(C_DEBUG,'x_roll_forward_flag', x_Group_rec.roll_forward_frozen_flag);
1136: END IF;
1137: --
1138: IF x_Sched_rec.Schedule_type = k_PLANNING THEN

Line 1135: rlm_core_sv.dlog(C_DEBUG,'x_roll_forward_flag', x_Group_rec.roll_forward_frozen_flag);

1131: BEGIN
1132: --
1133: IF (l_debug <> -1) THEN
1134: rlm_core_sv.dpush(C_DEBUG,'CalFenceDays');
1135: rlm_core_sv.dlog(C_DEBUG,'x_roll_forward_flag', x_Group_rec.roll_forward_frozen_flag);
1136: END IF;
1137: --
1138: IF x_Sched_rec.Schedule_type = k_PLANNING THEN
1139: --

Line 1141: rlm_core_sv.dlog(C_DEBUG,'PLANNING');

1137: --
1138: IF x_Sched_rec.Schedule_type = k_PLANNING THEN
1139: --
1140: IF (l_debug <> -1) THEN
1141: rlm_core_sv.dlog(C_DEBUG,'PLANNING');
1142: END IF;
1143: --
1144: v_FrozenFenceDayFrom := x_Group_rec.setup_terms_rec.pln_frozen_day_from;
1145: v_FrozenFenceDayTo := x_Group_rec.setup_terms_rec.pln_frozen_day_to;

Line 1150: rlm_core_sv.dlog(C_DEBUG,'SHIPPING');

1146: --
1147: ELSIF x_Sched_rec.Schedule_type = k_SHIPPING THEN
1148: --
1149: IF (l_debug <> -1) THEN
1150: rlm_core_sv.dlog(C_DEBUG,'SHIPPING');
1151: END IF;
1152: --
1153: v_FrozenFenceDayFrom := x_Group_rec.setup_terms_rec.shp_frozen_day_from;
1154: v_FrozenFenceDayTo := x_Group_rec.setup_terms_rec.shp_frozen_day_to;

Line 1159: rlm_core_sv.dlog(C_DEBUG,'SEQUENCED');

1155: --
1156: ELSIF x_Sched_rec.Schedule_type = k_SEQUENCED THEN
1157: --
1158: IF (l_debug <> -1) THEN
1159: rlm_core_sv.dlog(C_DEBUG,'SEQUENCED');
1160: END IF;
1161: --
1162: v_FrozenFenceDayFrom := x_Group_rec.setup_terms_rec.seq_frozen_day_from;
1163: v_FrozenFenceDayTo := x_Group_rec.setup_terms_rec.seq_frozen_day_to;

Line 1176: rlm_core_sv.dpop(C_SDEBUG);

1172: --
1173: x_fence_days :=v_FrozenFenceDays;
1174: --
1175: IF (l_debug <> -1) THEN
1176: rlm_core_sv.dpop(C_SDEBUG);
1177: END IF;
1178: --
1179: END CalFenceDays;
1180: