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_DEBUG_PUB

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

36: ,x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2)
37: IS
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: --
42: BEGIN
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add('ENTERING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);

Line 44: oe_debug_pub.add('ENTERING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);

40: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
41: --
42: BEGIN
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add('ENTERING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);
45: END IF;
46:
47: FOR i IN p_index..p_request_tbl.COUNT
48: LOOP

Line 61: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Header_Acceptance_table:'||p_request_tbl(i).return_status , 3);

57: Build_Header_Acceptance_table(p_request_rec =>p_request_tbl(i)
58: ,x_return_status => l_return_status);
59:
60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Header_Acceptance_table:'||p_request_tbl(i).return_status , 3);
62: END IF;
63:
64: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 76: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Line_Acceptance_table:'||p_request_tbl(i).return_status , 3);

72: Build_Line_Acceptance_table(p_request_rec => p_request_tbl(i)
73: , x_return_status => l_return_status);
74:
75: IF l_debug_level > 0 THEN
76: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Line_Acceptance_table:'||p_request_tbl(i).return_status , 3);
77: END IF;
78:
79: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 93: oe_debug_pub.add('NO ROWS to process' , 2 );

89:
90: IF G_LINE_ID_TBL.count = 0 THEN
91:
92: IF l_debug_level > 0 THEN
93: oe_debug_pub.add('NO ROWS to process' , 2 );
94: oe_debug_pub.add('EXITING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);
95: END IF;
96: -- No lines are eligible for acceptance
97: FND_MESSAGE.set_name('ONT', 'ONT_ACCEPTANCE_NA');

Line 94: oe_debug_pub.add('EXITING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);

90: IF G_LINE_ID_TBL.count = 0 THEN
91:
92: IF l_debug_level > 0 THEN
93: oe_debug_pub.add('NO ROWS to process' , 2 );
94: oe_debug_pub.add('EXITING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);
95: END IF;
96: -- No lines are eligible for acceptance
97: FND_MESSAGE.set_name('ONT', 'ONT_ACCEPTANCE_NA');
98: RETURN;

Line 102: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - before bulk update' , 1);

98: RETURN;
99: END IF;
100:
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - before bulk update' , 1);
103: END IF;
104:
105: FORALL i in g_line_id_tbl.FIRST .. g_line_id_tbl.LAST
106: UPDATE oe_order_lines_all

Line 117: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - after bulk update' , 1);

113: Accepted_quantity = g_accepted_quantity_tbl(i)
114: WHERE line_id = g_line_id_tbl(i);
115:
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - after bulk update' , 1);
118: END IF;
119:
120: -- Progress workflow for each processed lines in a loop.
121: OE_ACCEPTANCE_PVT.Progress_Accepted_lines(l_return_status);

Line 124: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance-progress_accepted_lines return status:'|| l_return_status , 1);

120: -- Progress workflow for each processed lines in a loop.
121: OE_ACCEPTANCE_PVT.Progress_Accepted_lines(l_return_status);
122:
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance-progress_accepted_lines return status:'|| l_return_status , 1);
125: END IF;
126:
127: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

160: WHERE header_id = l_header_id
161: AND open_flag = 'Y'
162: AND flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE');
163: --
164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
165: --
166: BEGIN
167:
168: OPEN order_lines ;

Line 187: oe_debug_pub.add(' Build_Header_Acceptance_table '|| SQLERRM , 1);

183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: IF l_debug_level > 0 THEN
187: oe_debug_pub.add(' Build_Header_Acceptance_table '|| SQLERRM , 1);
188: END IF;
189: x_return_status := l_return_status;
190:
191: END Build_Header_Acceptance_table;

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

222: AND service_reference_line_id = l_line_id;
223:
224:
225: --
226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
227: --
228:
229: BEGIN
230: IF l_line_id IS NOT NULL THEN

Line 502: OE_DEBUG_PUB.Add('Acceptance not allowed for this line. setting retun status of request_rec to E:'||l_line_id);

498: CLOSE c_service_lines;
499: END IF;
500: ELSE
501: IF l_debug_level > 0 THEN
502: OE_DEBUG_PUB.Add('Acceptance not allowed for this line. setting retun status of request_rec to E:'||l_line_id);
503: END IF;
504: p_request_rec.return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506: END IF; -- sys param check

Line 511: oe_debug_pub.add('Build_Line_Acceptance_table '|| SQLERRM , 1);

507: END IF;
508: EXCEPTION
509: WHEN OTHERS THEN
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add('Build_Line_Acceptance_table '|| SQLERRM , 1);
512: END IF;
513: x_return_status := l_return_status;
514:
515: END Build_Line_Acceptance_table;

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

521: l_msg_count NUMBER;
522: l_msg_data VARCHAR2(2000);
523: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
524: --
525: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
526: --
527: BEGIN
528:
529: IF l_debug_level > 0 THEN

Line 530: oe_debug_pub.add('ENTERING Progress_ Accepted_Lines' , 1);

526: --
527: BEGIN
528:
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add('ENTERING Progress_ Accepted_Lines' , 1);
531: END IF;
532:
533: FOR i IN 1..g_line_id_tbl.count LOOP
534: IF l_debug_level > 0 THEN

Line 535: oe_debug_pub.add('Processing line_id:'||g_line_id_tbl(i));

531: END IF;
532:
533: FOR i IN 1..g_line_id_tbl.count LOOP
534: IF l_debug_level > 0 THEN
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');

Line 543: oe_debug_pub.add('error progressing INVOICE_PENDING_ACCEPTANCE for line_id='||g_line_id_tbl(i)||sqlerrm, 1);

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);
544: END IF;
545: null;
546: END;
547: ELSIF g_flow_status_tbl(i) = 'POST-BILLING_ACCEPTANCE' THEN -- pending at close line'

Line 553: oe_debug_pub.add('error progressing CLOSE_PENDING_ACCEPTANCE for line_id='||g_line_id_tbl(i)||sqlerrm, 1);

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);
554: END IF;
555: null;
556: END;
557: END IF;

Line 577: oe_debug_pub.add('Calling ar_deferral_reasons_grp.record_acceptance');

573: END IF;
574:
575: IF l_line_flex_rec.interface_line_attribute6 IS NOT NULL THEN
576: IF l_debug_level > 0 THEN
577: oe_debug_pub.add('Calling ar_deferral_reasons_grp.record_acceptance');
578: END IF;
579: ar_deferral_reasons_grp.record_acceptance (
580: p_api_version => 1.0,
581: p_order_line => l_line_flex_rec,

Line 587: oe_debug_pub.add('return status from AR api '||l_return_status);

583: x_msg_count =>l_msg_count,
584: x_msg_data => l_msg_data );
585:
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add('return status from AR api '||l_return_status);
588: END IF;
589:
590: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 602: oe_debug_pub.add('Progress_ Accepted_Lines '|| SQLERRM , 1);

598: END LOOP;
599: EXCEPTION
600: WHEN OTHERS THEN
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add('Progress_ Accepted_Lines '|| SQLERRM , 1);
603: END IF;
604: x_return_status := l_return_status;
605: END Progress_Accepted_lines;
606: