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_ACCEPTANCE_PVT dependencies on OE_ORDER_UTIL

Line 42: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type;

38: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
39: --
40: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
41: --Start of bug 16085063
42: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type;
43: l_count NUMBER;
44: --End of bug 16085063
45: --
46: BEGIN

Line 174: oe_debug_pub.add('Calling oe_order_util.raise_business_event to raise event for Customer Acceptance/Rejection');

170: oe_debug_pub.add('....line_id = ' || g_line_id_tbl(i));
171: END IF;
172: END IF;
173: IF l_debug_level > 0 then
174: oe_debug_pub.add('Calling oe_order_util.raise_business_event to raise event for Customer Acceptance/Rejection');
175: END IF;
176: oe_order_util.raise_business_event( p_line_id =>g_line_id_tbl(i),
177: p_event_name => 'oracle.apps.ont.oip.statuschange.update',
178: p_nameVal_tbl => l_nameVal_tbl);

Line 176: oe_order_util.raise_business_event( p_line_id =>g_line_id_tbl(i),

172: END IF;
173: IF l_debug_level > 0 then
174: oe_debug_pub.add('Calling oe_order_util.raise_business_event to raise event for Customer Acceptance/Rejection');
175: END IF;
176: oe_order_util.raise_business_event( p_line_id =>g_line_id_tbl(i),
177: p_event_name => 'oracle.apps.ont.oip.statuschange.update',
178: p_nameVal_tbl => l_nameVal_tbl);
179:
180: END LOOP;

Line 316: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

312: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
313: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
314:
315: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
316: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
317: p_line_id => l_line_id,
318: x_index => l_notify_index,
319: x_return_status => l_notify_status);
320:

Line 326: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF l_notify_index IS NOT NULL THEN
326: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
327: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
328: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
329: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
330: ELSE

Line 328: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

324:
325: IF l_notify_index IS NOT NULL THEN
326: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
327: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
328: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
329: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
330: ELSE
331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
332: END IF;

Line 331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

327: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
328: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
329: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
330: ELSE
331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
332: END IF;
333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

329: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
330: ELSE
331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
332: END IF;
333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

330: ELSE
331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
332: END IF;
333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
338: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
332: END IF;
333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
338: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
339: END IF;

Line 336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

332: END IF;
333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
338: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
339: END IF;
340:

Line 337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

333: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
338: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
339: END IF;
340:
341: END IF;

Line 338: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

334: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
336: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
338: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
339: END IF;
340:
341: END IF;
342: ELSE -- system param on

Line 381: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

377: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
378: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
379:
380: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
381: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
382: p_line_id => l_line_id,
383: x_index => l_notify_index,
384: x_return_status => l_notify_status);
385:

Line 391: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: IF l_notify_index IS NOT NULL THEN
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
392: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
394: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
395: ELSE

Line 393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

389:
390: IF l_notify_index IS NOT NULL THEN
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
392: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
394: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
395: ELSE
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
397: END IF;

Line 396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

392: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
393: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
394: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
395: ELSE
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
397: END IF;
398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

394: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
395: ELSE
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
397: END IF;
398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

395: ELSE
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
397: END IF;
398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
403: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
397: END IF;
398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
403: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
404: END IF;

Line 401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

397: END IF;
398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
403: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
404: END IF;
405: END IF;

Line 402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

398: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
403: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
404: END IF;
405: END IF;
406:

Line 403: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

399: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
400: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
401: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
402: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
403: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
404: END IF;
405: END IF;
406:
407: OPEN c_service_lines ;

Line 430: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

426: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
427: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
428:
429: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
430: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
431: p_line_id => l_line_id,
432: x_index => l_notify_index,
433: x_return_status => l_notify_status);
434:

Line 440: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: IF l_notify_index IS NOT NULL THEN
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
441: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
443: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
444: ELSE

Line 442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

438:
439: IF l_notify_index IS NOT NULL THEN
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
441: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
443: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
444: ELSE
445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
446: END IF;

Line 445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

441: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
442: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
443: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
444: ELSE
445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
446: END IF;
447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

443: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
444: ELSE
445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
446: END IF;
447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

444: ELSE
445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
446: END IF;
447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
452: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
446: END IF;
447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
452: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
453: END IF;

Line 450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

446: END IF;
447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
452: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
453: END IF;
454: END IF;

Line 451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

447: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
452: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
453: END IF;
454: END IF;
455: END LOOP;

Line 452: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

448: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
449: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
450: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
451: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
452: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
453: END IF;
454: END IF;
455: END LOOP;
456: close c_service_lines;

Line 477: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

473: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
474: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
475:
476: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
477: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
478: p_line_id => l_line_id,
479: x_index => l_notify_index,
480: x_return_status => l_notify_status);
481:

Line 487: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: IF l_notify_index IS NOT NULL THEN
487: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
488: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
490: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
491: nvl(l_ordered_quantity,0)));

Line 489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

485:
486: IF l_notify_index IS NOT NULL THEN
487: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
488: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
490: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
491: nvl(l_ordered_quantity,0)));
492: ELSE
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

Line 493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

489: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
490: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
491: nvl(l_ordered_quantity,0)));
492: ELSE
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
494: END IF;
495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

491: nvl(l_ordered_quantity,0)));
492: ELSE
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
494: END IF;
495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

492: ELSE
493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
494: END IF;
495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
500: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

493: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
494: END IF;
495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
500: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
501: END IF;

Line 498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

494: END IF;
495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
500: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
501: END IF;
502:

Line 499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

495: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
500: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
501: END IF;
502:
503: END IF;

Line 500: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

496: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
497: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
498: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
499: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
500: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
501: END IF;
502:
503: END IF;
504: --Entering service lines for parent line

Line 527: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

523: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
524: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
525:
526: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
527: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
528: p_line_id => l_line_id,
529: x_index => l_notify_index,
530: x_return_status => l_notify_status);
531:

Line 537: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;
535:
536: IF l_notify_index IS NOT NULL THEN
537: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
538: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
539: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
540: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
541: ELSE

Line 539: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=

535:
536: IF l_notify_index IS NOT NULL THEN
537: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
538: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
539: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
540: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
541: ELSE
542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
543: END IF;

Line 542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

538: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
539: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
540: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
541: ELSE
542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
543: END IF;
544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

Line 544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;

540: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
541: ELSE
542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
543: END IF;
544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

Line 545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;

541: ELSE
542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
543: END IF;
544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
549: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

Line 546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;

542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;
543: END IF;
544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
549: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
550:

Line 547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;

543: END IF;
544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
549: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
550:
551: END IF;

Line 548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);

544: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_comments := p_request_rec.param1;
545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
549: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
550:
551: END IF;
552: END IF;

Line 549: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;

545: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature := p_request_rec.param2;
546: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_reference_document := p_request_rec.param3;
547: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_implicit_flag := p_request_rec.param4;
548: OE_ORDER_UTIL.g_line_tbl(l_notify_index).revrec_signature_date := nvl(p_request_rec.date_param1,sysdate);
549: OE_ORDER_UTIL.g_line_tbl(l_notify_index).ACCEPTED_BY := FND_GLOBAL.USER_ID;
550:
551: END IF;
552: END IF;
553: END LOOP;