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 50: p_request_tbl(i).request_type NOT IN (OE_GLOBALS.G_ACCEPT_FULFILLMENT,OE_GLOBALS.G_REJECT_FULFILLMENT) THEN

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

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

241: WHERE line_id=l_line_id;
242:
243: l_line_count := l_line_count + 1;
244: G_LINE_ID_TBL(l_line_count) := l_line_id;
245: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
246: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
247: ELSE
248: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;
249: END IF;

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

255: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
256: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
257: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
258:
259: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
260: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
261: p_line_id => l_line_id,
262: x_index => l_notify_index,
263: x_return_status => l_notify_status);

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

267: END IF;
268:
269: IF l_notify_index IS NOT NULL THEN
270: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
271: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
272: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
273: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity, nvl(l_ordered_quantity,0)));
274: ELSE
275: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

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

305: l_ordered_quantity, l_header_id, l_flow_status_code;
306: EXIT when model_children%NOTFOUND;
307: l_line_count := l_line_count+1;
308: G_LINE_ID_TBL(l_line_count) := l_line_id;
309: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
310: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
311: nvl(l_ordered_quantity,0)));
312: ELSE
313: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;

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

320: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
321: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
322: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
323:
324: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
325: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
326: p_line_id => l_line_id,
327: x_index => l_notify_index,
328: x_return_status => l_notify_status);

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

332: END IF;
333:
334: IF l_notify_index IS NOT NULL THEN
335: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
336: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
337: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
338: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
339: ELSE
340: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

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

355: EXIT when c_service_lines%NOTFOUND;
356:
357: l_line_count := l_line_count + 1;
358: G_LINE_ID_TBL(l_line_count) := l_line_id;
359: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
360: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
361: ELSE
362: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;
363: END IF;

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

369: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
370: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
371: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
372:
373: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
374: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
375: p_line_id => l_line_id,
376: x_index => l_notify_index,
377: x_return_status => l_notify_status);

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

381: END IF;
382:
383: IF l_notify_index IS NOT NULL THEN
384: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
385: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
386: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
387: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
388: ELSE
389: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

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

401: END LOOP;
402: ELSE --standard lines
403: l_line_count := l_line_count + 1;
404: G_LINE_ID_TBL(l_line_count) := l_line_id;
405: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
406: G_ACCEPTED_QUANTITY_TBL(l_line_count) := nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
407: nvl(l_ordered_quantity,0)));
408: ELSE
409: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;

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

416: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
417: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
418: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
419:
420: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
421: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
422: p_line_id => l_line_id,
423: x_index => l_notify_index,
424: x_return_status => l_notify_status);

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

428: END IF;
429:
430: IF l_notify_index IS NOT NULL THEN
431: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
432: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
433: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
434: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,
435: nvl(l_ordered_quantity,0)));
436: ELSE

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

452: l_header_id, l_flow_status_code;
453: EXIT when c_service_lines%NOTFOUND;
454: l_line_count := l_line_count + 1;
455: G_LINE_ID_TBL(l_line_count) := l_line_id;
456: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
457: G_ACCEPTED_QUANTITY_TBL(l_line_count):= nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
458: ELSE
459: G_ACCEPTED_QUANTITY_TBL(l_line_count) := 0;
460: END IF;

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

466: G_REVREC_SIGNATURE_DATE_TBL(l_line_count) := nvl(p_request_rec.date_param1,sysdate);
467: G_ACCEPTED_BY_TBL(l_line_count) := FND_GLOBAL.USER_ID;
468: G_FLOW_STATUS_TBL(l_line_count) := l_flow_status_code;
469:
470: IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
471: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
472: p_line_id => l_line_id,
473: x_index => l_notify_index,
474: x_return_status => l_notify_status);

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

478: END IF;
479:
480: IF l_notify_index IS NOT NULL THEN
481: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
482: IF p_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT THEN
483: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=
484: nvl(l_fulfilled_quantity,nvl(l_shipped_quantity,nvl(l_ordered_quantity,0)));
485: ELSE
486: OE_ORDER_UTIL.g_line_tbl(l_notify_index).accepted_quantity :=0;

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

535: oe_debug_pub.add('Processing line_id:'||g_line_id_tbl(i));
536: END IF;
537: IF g_flow_status_tbl(i) = 'PRE-BILLING_ACCEPTANCE' THEN
538: BEGIN
539: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, g_line_id_tbl(i), 'INVOICE_PENDING_ACCEPTANCE' , 'COMPLETE');
540: EXCEPTION
541: WHEN OTHERS THEN
542: IF l_debug_level > 0 THEN
543: oe_debug_pub.add('error progressing INVOICE_PENDING_ACCEPTANCE for line_id='||g_line_id_tbl(i)||sqlerrm, 1);

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

545: null;
546: END;
547: ELSIF g_flow_status_tbl(i) = 'POST-BILLING_ACCEPTANCE' THEN -- pending at close line'
548: BEGIN
549: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, g_line_id_tbl(i), 'CLOSE_PENDING_ACCEPTANCE', 'COMPLETE');
550: EXCEPTION
551: WHEN OTHERS THEN
552: IF l_debug_level > 0 THEN
553: oe_debug_pub.add('error progressing CLOSE_PENDING_ACCEPTANCE for line_id='||g_line_id_tbl(i)||sqlerrm, 1);