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.OE_BLANKET_WF_UTIL dependencies on OE_DEBUG_PUB

Line 22: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

18: l_item_type varchar2(20);
19: l_sales_doc_type_code varchar2(10) := 'B';
20: l_flow_status_code varchar2(30);
21: --
22: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
23: --
24: BEGIN
25:
26: if l_debug_level > 0 then

Line 27: oe_debug_pub.ADD('Entering create_and_start_flow ', 1);

23: --
24: BEGIN
25:
26: if l_debug_level > 0 then
27: oe_debug_pub.ADD('Entering create_and_start_flow ', 1);
28: end if;
29:
30: /* OE_MSG_PUB.set_msg_context(
31: p_entity_code => 'BLANKET_HEADER_WF'

Line 46: oe_debug_pub.ADD('Entering create_and_start_flow '||x_return_status,2 );

42:
43: -- if x_return_status = FND_API.G_RET_STS_SUCCESS THEN
44:
45: if l_debug_level > 0 then
46: oe_debug_pub.ADD('Entering create_and_start_flow '||x_return_status,2 );
47: end if;
48: IF p_transaction_phase_code = 'F' then
49: l_item_type := 'OEBH';
50: ELSE

Line 65: oe_debug_pub.ADD('Entering create_and_start_flow in full '||x_return_status,3 );

61:
62: IF p_transaction_phase_code = 'F' then
63:
64: if l_debug_level > 0 then
65: oe_debug_pub.ADD('Entering create_and_start_flow in full '||x_return_status,3 );
66: end if;
67:
68: select count(1)
69: into l_count

Line 85: oe_debug_pub.ADD('Exiting create_and_start_flow in full '||x_return_status,3 );

81: P_ITEM_TYPE => l_item_type,
82: P_SALES_DOCUMENT_TYPE_CODE => l_sales_doc_type_code,
83: X_RETURN_STATUS => x_return_status );
84: if l_debug_level > 0 then
85: oe_debug_pub.ADD('Exiting create_and_start_flow in full '||x_return_status,3 );
86: end if;
87: END IF;
88:
89: -- Call workflow api to update the flow

Line 93: oe_debug_pub.ADD('Entering create_and_start_flow in neg '||x_return_status,3 );

89: -- Call workflow api to update the flow
90:
91: ELSE
92: if l_debug_level > 0 then
93: oe_debug_pub.ADD('Entering create_and_start_flow in neg '||x_return_status,3 );
94: end if;
95: l_flow_status_code := 'DRAFT';
96: oe_order_wf_util.update_flow_status_code (
97: P_HEADER_ID => p_header_id,

Line 104: oe_debug_pub.ADD('Exiting create_and_start_flow in neg '||x_return_status,3 );

100: P_ITEM_TYPE => l_item_type,
101: P_SALES_DOCUMENT_TYPE_CODE => l_sales_doc_type_code,
102: X_RETURN_STATUS => x_return_status );
103: if l_debug_level > 0 then
104: oe_debug_pub.ADD('Exiting create_and_start_flow in neg '||x_return_status,3 );
105: end if;
106:
107: -- Call workflow api to update the flow
108:

Line 113: oe_debug_pub.ADD(' Exsiting create_and_start_flow '||x_return_status,2 );

109: END IF;
110:
111: -- Get message count and data
112: -- end if;
113: oe_debug_pub.ADD(' Exsiting create_and_start_flow '||x_return_status,2 );
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: if l_debug_level > 0 then

Line 118: oe_debug_pub.ADD('Blanket Workflow Exception ', 1);

114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: if l_debug_level > 0 then
118: oe_debug_pub.ADD('Blanket Workflow Exception ', 1);
119: end if;
120:
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122:

Line 139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

135: x_msg_data OUT NOCOPY VARCHAR2)
136: IS
137:
138: --
139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
140: submit_draft_exception exception;
141: l_return_status varchar2(1);
142: l_qa_return_status varchar2(1) := 'Y';
143: l_msg_count number;

Line 150: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft ', 1);

146: l_Last_Updated_By number; --bug6627904
147: --
148: BEGIN
149: if l_debug_level > 0 then
150: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft ', 1);
151: end if;
152: OE_MSG_PUB.initialize;
153: OE_MSG_PUB.set_msg_context(
154: p_entity_code => 'BLANKET_HEADER'

Line 171: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft before QA'||to_char(p_header_id));

167:
168: -- Calling Q and A Contracts
169: -- qa_articles is called with NORMAL mode
170: if l_debug_level > 0 then
171: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft before QA'||to_char(p_header_id));
172: end if;
173:
174: l_qa_return_status := 'S'; --- Temporally setting this value .
175:

Line 179: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA'||to_char(p_header_id));

175:
176:
177:
178: if l_debug_level > 0 then
179: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA'||to_char(p_header_id));
180: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_qa_R '||l_qa_return_status);
181: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_r'||l_return_status);
182: end if;
183: --- If the Qand A is passed

Line 180: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_qa_R '||l_qa_return_status);

176:
177:
178: if l_debug_level > 0 then
179: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA'||to_char(p_header_id));
180: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_qa_R '||l_qa_return_status);
181: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_r'||l_return_status);
182: end if;
183: --- If the Qand A is passed
184:

Line 181: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_r'||l_return_status);

177:
178: if l_debug_level > 0 then
179: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA'||to_char(p_header_id));
180: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_qa_R '||l_qa_return_status);
181: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after QA l_r'||l_return_status);
182: end if;
183: --- If the Qand A is passed
184:
185: IF p_transaction_phase_code = 'N'

Line 190: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after Neg ret'||l_return_status);

186: THEN
187: OE_NEGOTIATE_WF.submit_draft(p_header_id => p_header_id,
188: x_return_status => l_return_status);
189: if l_debug_level > 0 then
190: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after Neg ret'||l_return_status);
191: end if;
192: ELSE
193: oe_blanket_wf.submit_draft(p_header_id => p_header_id,
194: p_transaction_phase_code => p_transaction_phase_code,

Line 197: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after Ful ret'||l_return_status);

193: oe_blanket_wf.submit_draft(p_header_id => p_header_id,
194: p_transaction_phase_code => p_transaction_phase_code,
195: x_return_status => l_return_status);
196: if l_debug_level > 0 then
197: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Submit_draft after Ful ret'||l_return_status);
198: end if;
199: END IF;
200: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
201: THEN

Line 219: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft return status'||l_return_status);

215: OE_MSG_PUB.Count_And_Get(p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: if l_debug_level > 0 then
219: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft return status'||l_return_status);
220: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft qa return status'||l_qa_return_status);
221: end if;
222:
223: EXCEPTION

Line 220: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft qa return status'||l_qa_return_status);

216: p_data => x_msg_data);
217:
218: if l_debug_level > 0 then
219: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft return status'||l_return_status);
220: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Submit_draft qa return status'||l_qa_return_status);
221: end if;
222:
223: EXCEPTION
224:

Line 231: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228:
229: WHEN OTHERS THEN
230: if l_debug_level > 0 then
231: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
232: oe_debug_pub.ADD('In Blanket Workflow Exception QA return Status'||l_qa_return_Status);
233: oe_debug_pub.ADD('In Blanket Workflow Exception l return Status'||l_return_Status);
234: end if;
235:

Line 232: oe_debug_pub.ADD('In Blanket Workflow Exception QA return Status'||l_qa_return_Status);

228:
229: WHEN OTHERS THEN
230: if l_debug_level > 0 then
231: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
232: oe_debug_pub.ADD('In Blanket Workflow Exception QA return Status'||l_qa_return_Status);
233: oe_debug_pub.ADD('In Blanket Workflow Exception l return Status'||l_return_Status);
234: end if;
235:
236: x_return_status := l_return_status;

Line 233: oe_debug_pub.ADD('In Blanket Workflow Exception l return Status'||l_return_Status);

229: WHEN OTHERS THEN
230: if l_debug_level > 0 then
231: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
232: oe_debug_pub.ADD('In Blanket Workflow Exception QA return Status'||l_qa_return_Status);
233: oe_debug_pub.ADD('In Blanket Workflow Exception l return Status'||l_return_Status);
234: end if;
235:
236: x_return_status := l_return_status;
237:

Line 251: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

247: x_return_status OUT NOCOPY VARCHAR2)
248: IS
249:
250: --
251: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
252: --
253: l_status VARCHAR2(30);
254: BEGIN
255: if l_debug_level > 0 then

Line 256: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Blanket_Date_Changed ', 1);

252: --
253: l_status VARCHAR2(30);
254: BEGIN
255: if l_debug_level > 0 then
256: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Blanket_Date_Changed ', 1);
257: end if;
258:
259: -- Bug 3217417
260: -- Call Extend API if status is Expired and Date is Changed

Line 281: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: if l_debug_level > 0 then
281: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
282: end if;
283:
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285:

Line 305: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

301:
302: IS
303:
304: --
305: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
306: --
307: BEGIN
308: if l_debug_level > 0 then
309: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Accepted ', 1);

Line 309: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Accepted ', 1);

305: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
306: --
307: BEGIN
308: if l_debug_level > 0 then
309: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Accepted ', 1);
310: end if;
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: OE_NEGOTIATE_WF.Customer_Accepted(p_header_id => p_header_id,

Line 322: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: if l_debug_level > 0 then
322: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
323: end if;
324:
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326:

Line 356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

352: l_reason_code varchar2(240) := p_reason_code;
353: l_reason_comments varchar2(2000) := p_reason_comments;
354: l_return_status varchar2(1);
355: --
356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
357: --
358: BEGIN
359: if l_debug_level > 0 then
360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);

Line 360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);

356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
357: --
358: BEGIN
359: if l_debug_level > 0 then
360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);
361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);
362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);

Line 361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);

357: --
358: BEGIN
359: if l_debug_level > 0 then
360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);
361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);
362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);
365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);

Line 362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);

358: BEGIN
359: if l_debug_level > 0 then
360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);
361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);
362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);
365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);
366: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_RejecteD RETSTAT'||x_return_status);

Line 363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);

359: if l_debug_level > 0 then
360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);
361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);
362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);
365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);
366: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_RejecteD RETSTAT'||x_return_status);
367: end if;

Line 364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);

360: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected ', 1);
361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);
362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);
365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);
366: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_RejecteD RETSTAT'||x_return_status);
367: end if;
368: OE_NEGOTIATE_WF.Customer_Rejected(p_header_id => l_header_id,

Line 365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);

361: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected HID'||l_header_id);
362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);
365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);
366: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_RejecteD RETSTAT'||x_return_status);
367: end if;
368: OE_NEGOTIATE_WF.Customer_Rejected(p_header_id => l_header_id,
369: p_entity_code => l_entity_id,

Line 366: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_RejecteD RETSTAT'||x_return_status);

362: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected VNUM'||l_version_number);
363: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RTYPE'||l_reason_type);
364: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCODE'||l_reason_code);
365: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_Rejected RCOMM'||l_reason_comments);
366: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Customer_RejecteD RETSTAT'||x_return_status);
367: end if;
368: OE_NEGOTIATE_WF.Customer_Rejected(p_header_id => l_header_id,
369: p_entity_code => l_entity_id,
370: p_version_number => l_version_number,

Line 376: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected ', 1);

372: p_reason_code => l_reason_code,
373: p_reason_comments => l_reason_comments,
374: x_return_status => x_return_status);
375: if l_debug_level > 0 then
376: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected ', 1);
377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);
378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);

Line 377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);

373: p_reason_comments => l_reason_comments,
374: x_return_status => x_return_status);
375: if l_debug_level > 0 then
376: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected ', 1);
377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);
378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);
381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);

Line 378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);

374: x_return_status => x_return_status);
375: if l_debug_level > 0 then
376: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected ', 1);
377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);
378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);
381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);
382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);

Line 379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);

375: if l_debug_level > 0 then
376: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected ', 1);
377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);
378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);
381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);
382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);
383: end if;

Line 380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);

376: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected ', 1);
377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);
378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);
381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);
382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);
383: end if;
384:

Line 381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);

377: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected HID '||l_header_id);
378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);
381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);
382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);
383: end if;
384:
385: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);

378: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected VNUM '||l_version_number);
379: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RTYPE '||l_reason_type);
380: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCODE '||l_reason_code);
381: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_Rejected RCOMM '||l_reason_comments);
382: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.Customer_RejecteD RETSTAT '||x_return_status);
383: end if;
384:
385: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
386: , p_data => x_msg_data);

Line 392: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: if l_debug_level > 0 then
392: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
393: end if;
394:
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:

Line 417: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

413:
414: --
415: l_dumy varchar2(10) := 'FALSE';
416: l_return_status varchar2(10);
417: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
418: --
419: BEGIN
420:
421: if l_debug_level > 0 then

Line 422: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Check_release ', 1);

418: --
419: BEGIN
420:
421: if l_debug_level > 0 then
422: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Check_release ', 1);
423: end if;
424: l_return_status := FND_API.G_RET_STS_SUCCESS;
425: if p_blanket_number is not null then
426:

Line 462: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

458:
459: WHEN OTHERS THEN
460: x_return_status :='P';
461: if l_debug_level > 0 then
462: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
463: end if;
464:
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466:

Line 480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

476: x_return_status OUT NOCOPY VARCHAR2)
477: IS
478:
479: --
480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
481: --
482: BEGIN
483: if l_debug_level > 0 then
484: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Extend ', 1);

Line 484: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Extend ', 1);

480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
481: --
482: BEGIN
483: if l_debug_level > 0 then
484: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Extend ', 1);
485: end if;
486: OE_BLANKET_WF.Extend(p_header_id => p_header_id,
487: x_return_status => x_return_status);
488:

Line 492: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

488:
489: EXCEPTION
490: WHEN OTHERS THEN
491: if l_debug_level > 0 then
492: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
493: end if;
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496:

Line 512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

508: x_msg_data OUT NOCOPY VARCHAR2)
509: IS
510:
511: --
512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
513: --
514: BEGIN
515: if l_debug_level > 0 then
516: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Close ', 1);

Line 516: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Close ', 1);

512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
513: --
514: BEGIN
515: if l_debug_level > 0 then
516: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Close ', 1);
517: end if;
518: OE_BLANKET_WF.Close(p_header_id => p_header_id,
519: x_return_status => x_return_status);
520: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 526: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: if l_debug_level > 0 then
526: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
527: end if;
528:
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530:

Line 556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

552: l_reason_type varchar2(240) := p_reason_type;
553: l_reason_code varchar2(240) := p_reason_code;
554: l_reason_comments varchar2(2000) := p_reason_comments;
555: --
556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
557: --
558: BEGIN
559: if l_debug_level > 0 then
560: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Terminate ', 1);

Line 560: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Terminate ', 1);

556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
557: --
558: BEGIN
559: if l_debug_level > 0 then
560: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Terminate ', 1);
561: end if;
562: OE_BLANKET_WF.Terminate(p_header_id => l_header_id,
563: p_terminated_by => l_terminated_by,
564: p_version_number => l_version_number,

Line 575: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

571:
572: EXCEPTION
573: WHEN OTHERS THEN
574: if l_debug_level > 0 then
575: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
576: end if;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578:
579: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

603: l_reason_type varchar2(240) := p_reason_type;
604: l_reason_code varchar2(240) := p_reason_code;
605: l_reason_comments varchar2(2000) := p_reason_comments;
606: --
607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
608: --
609: BEGIN
610: if l_debug_level > 0 then
611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);

Line 611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);

607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
608: --
609: BEGIN
610: if l_debug_level > 0 then
611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);
612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);
613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);

Line 612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);

608: --
609: BEGIN
610: if l_debug_level > 0 then
611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);
612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);
613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);

Line 613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);

609: BEGIN
610: if l_debug_level > 0 then
611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);
612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);
613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);
617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);

Line 614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);

610: if l_debug_level > 0 then
611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);
612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);
613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);
617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);
618: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RETSTAT'||x_return_status);

Line 615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);

611: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ', 1);
612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);
613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);
617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);
618: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RETSTAT'||x_return_status);
619: end if;

Line 616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);

612: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST HID'||l_header_id);
613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);
617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);
618: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RETSTAT'||x_return_status);
619: end if;
620: OE_NEGOTIATE_WF.Lost(p_header_id => l_header_id,

Line 617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);

613: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST ECODE'||l_entity_code);
614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);
617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);
618: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RETSTAT'||x_return_status);
619: end if;
620: OE_NEGOTIATE_WF.Lost(p_header_id => l_header_id,
621: p_entity_code => l_entity_code,

Line 618: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RETSTAT'||x_return_status);

614: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST VNUM'||l_version_number);
615: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RTYPE'||l_reason_type);
616: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCODE'||l_reason_code);
617: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RCOMM'||l_reason_comments);
618: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.LOST RETSTAT'||x_return_status);
619: end if;
620: OE_NEGOTIATE_WF.Lost(p_header_id => l_header_id,
621: p_entity_code => l_entity_code,
622: p_version_number => l_version_number,

Line 628: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ', 1);

624: p_reason_code => l_reason_code,
625: p_reason_comments => l_reason_comments,
626: x_return_status => x_return_status);
627: if l_debug_level > 0 then
628: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ', 1);
629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);
630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);

Line 629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);

625: p_reason_comments => l_reason_comments,
626: x_return_status => x_return_status);
627: if l_debug_level > 0 then
628: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ', 1);
629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);
630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);

Line 630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);

626: x_return_status => x_return_status);
627: if l_debug_level > 0 then
628: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ', 1);
629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);
630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);

Line 631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);

627: if l_debug_level > 0 then
628: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ', 1);
629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);
630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);
635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);

Line 632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);

628: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ', 1);
629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);
630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);
635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);
636: end if;

Line 633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);

629: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST HID'||l_header_id);
630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);
635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);
636: end if;
637: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count

Line 634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);

630: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST ECODE'||l_entity_code);
631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);
635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);
636: end if;
637: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
638: , p_data => x_msg_data);

Line 635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);

631: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST VNUM'||l_version_number);
632: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RTYPE'||l_reason_type);
633: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCODE'||l_reason_code);
634: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RCOMM'||l_reason_comments);
635: oe_debug_pub.ADD('Entering OE_NEGOTIATE_WF.LOST RETSTAT'||x_return_status);
636: end if;
637: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
638: , p_data => x_msg_data);
639:

Line 644: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

640:
641: EXCEPTION
642: WHEN OTHERS THEN
643: if l_debug_level > 0 then
644: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
645: end if;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647:
648: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 673: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- Bug 8816026

669: l_msg_data varchar2(2000);
670: l_header_id number;
671: l_line_id number;
672: l_blanket_lock_control number;
673: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- Bug 8816026
674: l_item_type varchar2(10) := 'OEBH';
675: l_sales_doc_type_code varchar2(1) := 'B';
676: l_blanket_number number;
677: Blanket_Complete_Negotiation exception;

Line 688: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL'||l_return_status);

684:
685: Begin
686: l_header_id := p_header_id;
687: if l_debug_level > 0 then
688: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL'||l_return_status);
689: end if;
690: IF l_header_id is not null then
691:
692: SAVEPOINT Save_Blanket_Changes;

Line 743: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL HDR ID'

739:
740: -- end fix for bug 3559904
741:
742: if l_debug_level > 0 then
743: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL HDR ID'
744: ||l_header_id);
745: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL BLKT NUM'
746: ||l_blanket_number);
747: end if;

Line 745: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL BLKT NUM'

741:
742: if l_debug_level > 0 then
743: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL HDR ID'
744: ||l_header_id);
745: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation in WF UTIL BLKT NUM'
746: ||l_blanket_number);
747: end if;
748: OE_Blanket_Util.Lock_Row(p_blanket_id=>p_header_id
749: , p_blanket_line_id => null

Line 756: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation after LOCKING HEADER'

752: , x_msg_count => l_msg_count
753: , x_msg_data => l_msg_data);
754:
755: if l_debug_level > 0 then
756: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation after LOCKING HEADER'
757: ||l_return_status);
758: end if;
759: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: x_return_status := l_return_status;

Line 819: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation after UPDATE'

815: Last_Updated_By = l_Last_Updated_By,
816: LAST_UPDATE_DATE = sysdate
817: where header_id = l_header_id and line_id = l_line_id;
818: if l_debug_level > 0 then
819: oe_debug_pub.ADD('Entering OE_BLANKET_WF_UTIL.Complete_Negotiation after UPDATE'
820: ||l_return_status);
821: end if;
822: END LOOP;
823: CLOSE c_get_lines;

Line 842: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Complete_Negotiation return status'||l_return_status);

838: END IF;
839:
840: END IF;
841: if l_debug_level > 0 then
842: oe_debug_pub.ADD('End OE_BLANKET_WF_UTIL.Complete_Negotiation return status'||l_return_status);
843: end if;
844: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
845: , p_data => x_msg_data);
846: */

Line 858: oe_debug_pub.ADD('In Blanket Workflow Execution error ', 1);

854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: OE_Quote_Util.G_COMPLETE_NEG := 'N';
857: if l_debug_level > 0 then
858: oe_debug_pub.ADD('In Blanket Workflow Execution error ', 1);
859: end if;
860:
861: x_return_status := l_return_status;
862:

Line 867: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);

863: WHEN OTHERS THEN
864: OE_Quote_Util.G_COMPLETE_NEG := 'N';
865:
866: if l_debug_level > 0 then
867: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
868: oe_debug_pub.ADD('In Blanket Workflow Exception Complete Negotiation return Status'
869: ||l_return_Status);
870: end if;
871:

Line 868: oe_debug_pub.ADD('In Blanket Workflow Exception Complete Negotiation return Status'

864: OE_Quote_Util.G_COMPLETE_NEG := 'N';
865:
866: if l_debug_level > 0 then
867: oe_debug_pub.ADD('In Blanket Workflow Exception ', 1);
868: oe_debug_pub.ADD('In Blanket Workflow Exception Complete Negotiation return Status'
869: ||l_return_Status);
870: end if;
871:
872: x_return_status := l_return_status;