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_GLOBALS

Line 54: p_request_tbl(i).request_type NOT IN (OE_GLOBALS.G_ACCEPT_FULFILLMENT,OE_GLOBALS.G_REJECT_FULFILLMENT) THEN

50:
51: FOR i IN p_index..p_request_tbl.COUNT
52: LOOP
53: IF (p_request_tbl(i).processed = 'Y') OR
54: p_request_tbl(i).request_type NOT IN (OE_GLOBALS.G_ACCEPT_FULFILLMENT,OE_GLOBALS.G_REJECT_FULFILLMENT) THEN
55: GOTO END_LOOP;
56: END IF;
57: -- Initialize each request's return_status as 'S'. It will be set to 'E' when required.
58: p_request_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;

Line 301: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

297: WHERE line_id=l_line_id;
298:
299: l_line_count := l_line_count + 1;
300: G_LINE_ID_TBL(l_line_count) := l_line_id;
301: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
302: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
303: ELSE
304: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;
305: END IF;

Line 315: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN

311: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
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);

Line 327: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

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
331: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

Line 365: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

361: l_ordered_quantity, l_header_id, l_flow_status_code;
362: EXIT when model_children%NOTFOUND;
363: l_line_count := l_line_count+1;
364: G_LINE_ID_TBL(l_line_count) := l_line_id;
365: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
366: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
367: nvl(l_ordered_quantity,0)));
368: ELSE
369: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;

Line 380: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN

376: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
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);

Line 392: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

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
396: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

Line 415: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

411: EXIT when c_service_lines%NOTFOUND;
412:
413: l_line_count := l_line_count + 1;
414: G_LINE_ID_TBL(l_line_count) := l_line_id;
415: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
416: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
417: ELSE
418: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;
419: END IF;

Line 429: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN

425: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
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);

Line 441: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

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
445: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

Line 461: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

457: END LOOP;
458: ELSE --standard lines
459: l_line_count := l_line_count + 1;
460: G_LINE_ID_TBL(l_line_count) := l_line_id;
461: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
462: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
463: nvl(l_ordered_quantity,0)));
464: ELSE
465: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;

Line 476: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN

472: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
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);

Line 488: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

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)));
492: ELSE

Line 512: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

508: l_header_id, l_flow_status_code;
509: EXIT when c_service_lines%NOTFOUND;
510: l_line_count := l_line_count + 1;
511: G_LINE_ID_TBL(l_line_count) := l_line_id;
512: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
513: G_ACCEPTED_QUANTITY_TBL(l_line_count):= nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
514: ELSE
515: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;
516: END IF;

Line 526: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN

522: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
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);

Line 538: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN

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
542: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

Line 597: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, g_line_id_tbl(i), 'INVOICE_PENDING_ACCEPTANCE' , 'COMPLETE');

593: oe_debug_pub.add('Processing line_id:'||g_line_id_tbl(i));
594: END IF;
595: IF g_flow_status_tbl(i) = 'PRE-BILLING_ACCEPTANCE' THEN
596: BEGIN
597: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, g_line_id_tbl(i), 'INVOICE_PENDING_ACCEPTANCE' , 'COMPLETE');
598: EXCEPTION
599: WHEN OTHERS THEN
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add('error progressing INVOICE_PENDING_ACCEPTANCE for line_id='||g_line_id_tbl(i)||sqlerrm, 1);

Line 607: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, g_line_id_tbl(i), 'CLOSE_PENDING_ACCEPTANCE', 'COMPLETE');

603: null;
604: END;
605: ELSIF g_flow_status_tbl(i) = 'POST-BILLING_ACCEPTANCE' THEN -- pending at close line'
606: BEGIN
607: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, g_line_id_tbl(i), 'CLOSE_PENDING_ACCEPTANCE', 'COMPLETE');
608: EXCEPTION
609: WHEN OTHERS THEN
610: IF l_debug_level > 0 THEN
611: oe_debug_pub.add('error progressing CLOSE_PENDING_ACCEPTANCE for line_id='||g_line_id_tbl(i)||sqlerrm, 1);