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_BLANKET_WF

Line 1: PACKAGE BODY OE_Blanket_wf_util AS

1: PACKAGE BODY OE_Blanket_wf_util AS
2: /* $Header: OEXUBWFB.pls 120.1.12010000.2 2009/08/21 08:28:23 nitagarw ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_wf_Util';
4:
5: PROCEDURE create_and_start_flow ( p_header_id IN NUMBER,

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_wf_Util';

1: PACKAGE BODY OE_Blanket_wf_util AS
2: /* $Header: OEXUBWFB.pls 120.1.12010000.2 2009/08/21 08:28:23 nitagarw ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Blanket_wf_Util';
4:
5: PROCEDURE create_and_start_flow ( p_header_id IN NUMBER,
6: p_transaction_phase_code IN VARCHAR2,
7: p_blanket_number IN 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 193: oe_blanket_wf.submit_draft(p_header_id => p_header_id,

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,
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);

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 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 268: oe_blanket_wf.Extend(p_header_id => p_header_id,

264: from oe_blanket_headers
265: where header_id = p_header_id;
266:
267: IF l_status = 'EXPIRED' THEN
268: oe_blanket_wf.Extend(p_header_id => p_header_id,
269: x_return_status => x_return_status);
270: ELSE
271: oe_blanket_wf.Blanket_Date_Changed(p_header_id => p_header_id,
272: x_return_status => x_return_status);

Line 271: oe_blanket_wf.Blanket_Date_Changed(p_header_id => p_header_id,

267: IF l_status = 'EXPIRED' THEN
268: oe_blanket_wf.Extend(p_header_id => p_header_id,
269: x_return_status => x_return_status);
270: ELSE
271: oe_blanket_wf.Blanket_Date_Changed(p_header_id => p_header_id,
272: x_return_status => x_return_status);
273: END IF;
274: /* OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count
275: , p_data => x_msg_data); */

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 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 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 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 486: OE_BLANKET_WF.Extend(p_header_id => p_header_id,

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:
489: EXCEPTION
490: WHEN OTHERS THEN

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 518: OE_BLANKET_WF.Close(p_header_id => p_header_id,

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
521: , p_data => x_msg_data);
522:

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 562: OE_BLANKET_WF.Terminate(p_header_id => l_header_id,

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,
565: p_reason_type => l_reason_type,
566: p_reason_code => l_reason_code,

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 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 881: end oe_blanket_wf_util;

877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878:
879: end Complete_Negotiation;
880:
881: end oe_blanket_wf_util;