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: --Start of bug 16085063
42: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type;
43: l_count NUMBER;
44: --End of bug 16085063

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

44: --End of bug 16085063
45: --
46: BEGIN
47: IF l_debug_level > 0 THEN
48: oe_debug_pub.add('ENTERING OE_ACCEPTANCE_UTIL.Process_Acceptance' , 1);
49: END IF;
50:
51: FOR i IN p_index..p_request_tbl.COUNT
52: LOOP

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

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

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

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

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

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

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

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

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

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

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

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

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

124: -- Progress workflow for each processed lines in a loop.
125: OE_ACCEPTANCE_PVT.Progress_Accepted_lines(l_return_status);
126:
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance-progress_accepted_lines return status:'|| l_return_status , 1);
129: END IF;
130: --Start of bug 16085063
131: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N') = 'Y' THEN
132: IF l_debug_level > 0 then

Line 133: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Raise Integration event for Customer Acceptance');

129: END IF;
130: --Start of bug 16085063
131: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N') = 'Y' THEN
132: IF l_debug_level > 0 then
133: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Raise Integration event for Customer Acceptance');
134: oe_debug_pub.add( 'g_line_id_tbl count: '|| g_line_id_tbl.count);
135: END IF;
136:
137: FOR i IN 1..g_line_id_tbl.count LOOP

Line 134: oe_debug_pub.add( 'g_line_id_tbl count: '|| g_line_id_tbl.count);

130: --Start of bug 16085063
131: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N') = 'Y' THEN
132: IF l_debug_level > 0 then
133: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Raise Integration event for Customer Acceptance');
134: oe_debug_pub.add( 'g_line_id_tbl count: '|| g_line_id_tbl.count);
135: END IF;
136:
137: FOR i IN 1..g_line_id_tbl.count LOOP
138:

Line 140: oe_debug_pub.add( 'g_accepted_quantity: '|| g_accepted_quantity_tbl(i));

136:
137: FOR i IN 1..g_line_id_tbl.count LOOP
138:
139: IF l_debug_level > 0 then
140: oe_debug_pub.add( 'g_accepted_quantity: '|| g_accepted_quantity_tbl(i));
141: END IF;
142:
143: IF g_accepted_quantity_tbl(i) <> 0 THEN
144: IF l_debug_level > 0 THEN

Line 145: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Preparing paramters to pass to Integration event for Customer Acceptance');

141: END IF;
142:
143: IF g_accepted_quantity_tbl(i) <> 0 THEN
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Preparing paramters to pass to Integration event for Customer Acceptance');
146: END IF;
147: l_count := 1;
148: l_nameVal_tbl(l_count).name := 'ACCEPTANCE_STATUS';
149: l_nameVal_tbl(l_count).value := 'ACCEPTED';

Line 154: oe_debug_pub.add('....line_id = ' || g_line_id_tbl(i));

150: l_nameVal_tbl(l_count+1).name := 'ACCEPTED_BY';
151: l_nameVal_tbl(l_count+1).value := g_accepted_by_tbl(i);
152:
153: IF l_debug_level > 0 then
154: oe_debug_pub.add('....line_id = ' || g_line_id_tbl(i));
155: END IF;
156:
157: ELSE --For Rejection
158: IF l_debug_level > 0 THEN

Line 159: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Preparing paramters to pass to Integration event for Customer Rejection');

155: END IF;
156:
157: ELSE --For Rejection
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Preparing paramters to pass to Integration event for Customer Rejection');
160: END IF;
161: l_count := 1;
162: l_nameVal_tbl(l_count).name := 'ACCEPTANCE_STATUS';
163: l_nameVal_tbl(l_count).value := 'REJECTED';

Line 170: oe_debug_pub.add('....line_id = ' || g_line_id_tbl(i));

166: l_nameVal_tbl(l_count+2).name := 'REJECTION_REASON';
167: l_nameVal_tbl(l_count+2).value := g_revrec_comments_tbl(i);
168:
169: IF l_debug_level > 0 then
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');

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 220: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

216: WHERE header_id = l_header_id
217: AND open_flag = 'Y'
218: AND flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE');
219: --
220: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
221: --
222: BEGIN
223:
224: OPEN order_lines ;

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

239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add(' Build_Header_Acceptance_table '|| SQLERRM , 1);
244: END IF;
245: x_return_status := l_return_status;
246:
247: END Build_Header_Acceptance_table;

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

278: AND service_reference_line_id = l_line_id;
279:
280:
281: --
282: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
283: --
284:
285: BEGIN
286: IF l_line_id IS NOT NULL THEN

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

554: CLOSE c_service_lines;
555: END IF;
556: ELSE
557: IF l_debug_level > 0 THEN
558: OE_DEBUG_PUB.Add('Acceptance not allowed for this line. setting retun status of request_rec to E:'||l_line_id);
559: END IF;
560: p_request_rec.return_status := FND_API.G_RET_STS_ERROR;
561: END IF;
562: END IF; -- sys param check

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

563: END IF;
564: EXCEPTION
565: WHEN OTHERS THEN
566: IF l_debug_level > 0 THEN
567: oe_debug_pub.add('Build_Line_Acceptance_table '|| SQLERRM , 1);
568: END IF;
569: x_return_status := l_return_status;
570:
571: END Build_Line_Acceptance_table;

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

577: l_msg_count NUMBER;
578: l_msg_data VARCHAR2(2000);
579: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
580: --
581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
582: --
583: l_org_id oe_order_lines_all.org_id%TYPE; -- Bug 8859412
584: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
585: BEGIN

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

584: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
585: BEGIN
586:
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add('ENTERING Progress_ Accepted_Lines' , 1);
589: END IF;
590:
591: FOR i IN 1..g_line_id_tbl.count LOOP
592: IF l_debug_level > 0 THEN

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

589: END IF;
590:
591: FOR i IN 1..g_line_id_tbl.count LOOP
592: IF l_debug_level > 0 THEN
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');

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

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);
602: END IF;
603: null;
604: END;
605: ELSIF g_flow_status_tbl(i) = 'POST-BILLING_ACCEPTANCE' THEN -- pending at close line'

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

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);
612: END IF;
613: null;
614: END;
615: END IF;

Line 621: oe_debug_pub.add('Customer is Rejected');

617:
618:
619: IF g_accepted_quantity_tbl(i) = 0 THEN -- For rejection, Accepted Quantity = 0
620:
621: oe_debug_pub.add('Customer is Rejected');
622:
623: SELECT inventory_item_id, org_id
624: INTO l_inventory_item_id, l_org_id
625: FROM oe_order_lines_all

Line 646: oe_debug_pub.add('return status from cst_revenuecogsmatch_grp.receive_closelineevent : '||l_return_status);

642:
643: -- Start of bug 16085063
644: x_return_status := l_return_status;
645: IF l_debug_level > 0 THEN
646: oe_debug_pub.add('return status from cst_revenuecogsmatch_grp.receive_closelineevent : '||l_return_status);
647: END IF;
648: -- End of bug 16085063
649:
650:

Line 676: oe_debug_pub.add('return status from OE_AR_Acceptance_GRP.Get_interface_attributes : '||l_return_status); --added for bug 16085063

672: , x_msg_data => l_msg_data
673: );
674:
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.add('return status from OE_AR_Acceptance_GRP.Get_interface_attributes : '||l_return_status); --added for bug 16085063
677: END IF;
678:
679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

685: END IF;
686:
687: IF l_line_flex_rec.interface_line_attribute6 IS NOT NULL THEN
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add('Calling ar_deferral_reasons_grp.record_acceptance');
690: END IF;
691: ar_deferral_reasons_grp.record_acceptance (
692: p_api_version => 1.0,
693: p_order_line => l_line_flex_rec,

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

696: x_msg_data => l_msg_data );
697:
698: x_return_status := l_return_status; --Added for bug 16085063
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add('return status from AR api '||l_return_status);
701: END IF;
702:
703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

711: END LOOP;
712: EXCEPTION
713: WHEN OTHERS THEN
714: IF l_debug_level > 0 THEN
715: oe_debug_pub.add('Progress_ Accepted_Lines '|| SQLERRM , 1);
716: END IF;
717: x_return_status := l_return_status;
718: END Progress_Accepted_lines;
719: