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_DEALS_UTIL dependencies on OE_DEBUG_PUB

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

185: l_db_link varchar2(240);
186: l_dynamicSqlString VARCHAR2(2000);
187: l_quote_origin NUMBER := 660;
188: --
189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190:
191: BEGIN
192:
193: l_instance_id := FND_PROFILE.VALUE('QPR_CURRENT_INSTANCE') ;

Line 204: oe_debug_pub.add( 'CALL DEAL API' || l_procedure ) ;

200: x_is_deal_compliant := 'N';
201: ELSE
202:
203: IF l_debug_level > 0 THEN
204: oe_debug_pub.add( 'CALL DEAL API' || l_procedure ) ;
205: END IF;
206: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
207:
208: IF l_db_link is NOT NULL THEN

Line 241: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||x_is_deal_compliant ) ;

237: OUT x_return_status,
238: OUT x_msg_data;
239: END IF;
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||x_is_deal_compliant ) ;
242: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||x_return_status ) ;
243: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
244: oe_debug_pub.add( 'RETURN STATUS FROM x_msg_data: '|| x_msg_data ) ;
245: END IF;

Line 242: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||x_return_status ) ;

238: OUT x_msg_data;
239: END IF;
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||x_is_deal_compliant ) ;
242: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||x_return_status ) ;
243: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
244: oe_debug_pub.add( 'RETURN STATUS FROM x_msg_data: '|| x_msg_data ) ;
245: END IF;
246:

Line 243: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;

239: END IF;
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||x_is_deal_compliant ) ;
242: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||x_return_status ) ;
243: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
244: oe_debug_pub.add( 'RETURN STATUS FROM x_msg_data: '|| x_msg_data ) ;
245: END IF;
246:
247:

Line 244: oe_debug_pub.add( 'RETURN STATUS FROM x_msg_data: '|| x_msg_data ) ;

240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||x_is_deal_compliant ) ;
242: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||x_return_status ) ;
243: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
244: oe_debug_pub.add( 'RETURN STATUS FROM x_msg_data: '|| x_msg_data ) ;
245: END IF;
246:
247:
248: EXCEPTION

Line 251: oe_debug_pub.add( 'Raise Error in CALL_DEALs_API' ) ;

247:
248: EXCEPTION
249: when others then
250: IF l_debug_level > 0 THEN
251: oe_debug_pub.add( 'Raise Error in CALL_DEALs_API' ) ;
252: END IF;
253: x_return_status :='E';
254: x_is_deal_compliant := 'N';
255: END CALL_DEALS_API;

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

293:
294: --Bug 6870738
295: l_non_sim_deal_exists VARCHAR2(1) := 'N';
296: --
297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
298: BEGIN
299: if (funcmode = 'RUN') then
300:
301: l_header_id := to_number(itemkey);

Line 341: oe_debug_pub.add( 'CALL DEAL API' ) ;

337: END IF;
338: --Bug 6870738 ends
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add( 'CALL DEAL API' ) ;
342: END IF;
343:
344: CALL_DEALS_API(
345: p_header_id => l_header_id,

Line 355: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||l_is_deal_compliant ) ;

351: x_msg_data => l_deal_msg_data);
352:
353: END IF;
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||l_is_deal_compliant ) ;
356: oe_debug_pub.add( 'RETURN STATUS FROM l_response_id: '||l_response_id ) ;
357: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||l_deal_return_stat ) ;
358: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
359: END IF;

Line 356: oe_debug_pub.add( 'RETURN STATUS FROM l_response_id: '||l_response_id ) ;

352:
353: END IF;
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||l_is_deal_compliant ) ;
356: oe_debug_pub.add( 'RETURN STATUS FROM l_response_id: '||l_response_id ) ;
357: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||l_deal_return_stat ) ;
358: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
359: END IF;
360:

Line 357: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||l_deal_return_stat ) ;

353: END IF;
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||l_is_deal_compliant ) ;
356: oe_debug_pub.add( 'RETURN STATUS FROM l_response_id: '||l_response_id ) ;
357: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||l_deal_return_stat ) ;
358: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
359: END IF;
360:
361: IF nvl(l_deal_return_stat,'S') = 'E' OR nvl(l_is_deal_compliant,'N') = 'N' THEN

Line 358: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;

354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'RETURN STATUS FROM l_is_deal_compliant: '||l_is_deal_compliant ) ;
356: oe_debug_pub.add( 'RETURN STATUS FROM l_response_id: '||l_response_id ) ;
357: oe_debug_pub.add( 'RETURN STATUS FROM l_deal_return_stat: '||l_deal_return_stat ) ;
358: oe_debug_pub.add( 'RETURN STATUS FROM QUERY: '||l_dynamicSqlString ) ;
359: END IF;
360:
361: IF nvl(l_deal_return_stat,'S') = 'E' OR nvl(l_is_deal_compliant,'N') = 'N' THEN
362: resultout := 'COMPLETE:N';

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

493: AND WIAS.activity_status = 'ERROR'
494: AND WPA.activity_name = 'PRICING_APPROVAL_ELIGIBLE'
495: AND WPA.instance_id = WIAS.process_activity;
496:
497: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
498:
499: BEGIN
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.COMPLETE_COMPLIANCE_ELIGIBLE' , 1 ) ;

Line 501: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.COMPLETE_COMPLIANCE_ELIGIBLE' , 1 ) ;

497: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
498:
499: BEGIN
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.COMPLETE_COMPLIANCE_ELIGIBLE' , 1 ) ;
502: END IF;
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504: -- Initialize message list.
505: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 538: oe_debug_pub.add( 'Compliance Check NOT ELIGIBLE' ) ;

534: FETCH Compliance_eligible INTO l_Compliance_eligible;
535:
536: IF (Compliance_eligible%NOTFOUND) THEN
537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'Compliance Check NOT ELIGIBLE' ) ;
539: END IF;
540: OPEN Compliance_errored;
541: FETCH Compliance_errored INTO l_Compliance_errored_flag;
542: IF (Compliance_errored%FOUND) THEN

Line 581: oe_debug_pub.add( 'AFTER CALLING WF_ENGINE' ) ;

577: , activity => 'PRICING_APPROVAL_ELIGIBLE'
578: , result => p_accept
579: );
580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add( 'AFTER CALLING WF_ENGINE' ) ;
582: END IF;
583:
584: OE_MSG_PUB.set_msg_context(
585: p_entity_code => 'HEADER'

Line 606: oe_debug_pub.add( 'EXIT OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;

602:
603: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
604:
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'EXIT OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;
607: END IF;
608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN

Line 612: oe_debug_pub.add( 'EXC ERROR OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;

608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'EXC ERROR OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;
613: END IF;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: IF (Compliance_eligible%ISOPEN) THEN
616: CLOSE Compliance_eligible;

Line 629: oe_debug_pub.add( 'EXC UNEXPECTED ERROR OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;

625: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
626:
627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( 'EXC UNEXPECTED ERROR OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;
630: END IF;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: IF (Compliance_eligible%ISOPEN) THEN
633: CLOSE Compliance_eligible;

Line 646: oe_debug_pub.add( 'OTHER ERROR OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;

642: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
643:
644: WHEN OTHERS THEN
645: IF l_debug_level > 0 THEN
646: oe_debug_pub.add( 'OTHER ERROR OE_DEALS_UTIL.COMPLETE_Compliance_eligible' , 1 ) ;
647: END IF;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF (Compliance_eligible%ISOPEN) THEN
650: CLOSE Compliance_eligible;

Line 690: --l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

686: l_new_status varchar2(30);
687: l_init_msg_list VARCHAR2(30) ;
688: l_result varchar2(10);
689: l_notified_activity varchar2(30);
690: --l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
691: l_debug_level CONSTANT NUMBER := 5;
692:
693: l_file_val VARCHAR2(100);
694: BEGIN

Line 698: oe_debug_pub.debug_on;

694: BEGIN
695: l_header_id := source_ref_id;
696:
697: --Comment this code to stop debugging
698: oe_debug_pub.debug_on;
699: oe_debug_pub.initialize;
700: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
701: oe_Debug_pub.setdebuglevel(5);
702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;

Line 699: oe_debug_pub.initialize;

695: l_header_id := source_ref_id;
696:
697: --Comment this code to stop debugging
698: oe_debug_pub.debug_on;
699: oe_debug_pub.initialize;
700: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
701: oe_Debug_pub.setdebuglevel(5);
702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;
703:

Line 700: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');

696:
697: --Comment this code to stop debugging
698: oe_debug_pub.debug_on;
699: oe_debug_pub.initialize;
700: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
701: oe_Debug_pub.setdebuglevel(5);
702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;
703:
704: select TRANSACTION_PHASE_CODE , flow_status_code into l_TRANSACTION_PHASE_CODE , l_status FROM

Line 701: oe_Debug_pub.setdebuglevel(5);

697: --Comment this code to stop debugging
698: oe_debug_pub.debug_on;
699: oe_debug_pub.initialize;
700: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
701: oe_Debug_pub.setdebuglevel(5);
702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;
703:
704: select TRANSACTION_PHASE_CODE , flow_status_code into l_TRANSACTION_PHASE_CODE , l_status FROM
705: OE_ORDER_HEADERS_ALL where header_id = l_header_id;

Line 702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;

698: oe_debug_pub.debug_on;
699: oe_debug_pub.initialize;
700: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
701: oe_Debug_pub.setdebuglevel(5);
702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;
703:
704: select TRANSACTION_PHASE_CODE , flow_status_code into l_TRANSACTION_PHASE_CODE , l_status FROM
705: OE_ORDER_HEADERS_ALL where header_id = l_header_id;
706:

Line 714: oe_debug_pub.add( 'Deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;

710: l_item_type := 'OENH';
711: END IF;
712:
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( 'Deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;
715: END IF;
716:
717: OE_ORDER_UTIL.Lock_Order_Object
718: (p_header_id => l_header_id

Line 834: oe_debug_pub.add('x_message_name: '||x_message_name);

830: THEN
831: FND_MESSAGE.SET_NAME('ONT',x_message_name);
832: x_message_name := FND_MESSAGE.GET;
833: END IF;
834: oe_debug_pub.add('x_message_name: '||x_message_name);
835:
836: EXCEPTION
837: WHEN OTHERS THEN
838: x_return_status := FND_API.G_RET_STS_ERROR;

Line 845: oe_debug_pub.add('x_message_name: '||x_message_name);

841: THEN
842: FND_MESSAGE.SET_NAME('ONT',x_message_name);
843: x_message_name := FND_MESSAGE.GET;
844: END IF;
845: oe_debug_pub.add('x_message_name: '||x_message_name);
846: END;
847:
848:
849: /*

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

911: l_continue varchar2(1);
912: i number :=0;
913: l_price_adj_id NUMBER ;
914: l_adjusted_amount NUMBER;
915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
916: cursor lines_cursor is select line_id, unit_selling_price from oe_order_lines_all where header_id=p_header_id
917: and open_flag='Y' and cancelled_flag='N';
918:
919: BEGIN

Line 922: oe_debug_pub.add( 'call Process Order API ' , 1 ) ;

918:
919: BEGIN
920:
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'call Process Order API ' , 1 ) ;
923: END IF;
924:
925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926: x_msg_count := NULL ;

Line 942: oe_debug_pub.add( 'Profile is NULL ' , 1 ) ;

938: FND_MESSAGE.SET_NAME('ONT','OE_PROFILE_INCORRECT');
939: FND_MESSAGE.SET_TOKEN('PROFILE_NAME', 'QPR_DEAL_DIFF_MODIFIER');
940: OE_MSG_PUB.ADD;
941: IF l_debug_level > 0 THEN
942: oe_debug_pub.add( 'Profile is NULL ' , 1 ) ;
943: END IF;
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:

Line 948: oe_debug_pub.add( 'In call Process Order API-Modifier ' || l_list_line_id , 1 ) ;

944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'In call Process Order API-Modifier ' || l_list_line_id , 1 ) ;
949: END IF;
950:
951: select list_header_id INTO l_list_header_id from qp_list_lines where list_line_id=l_list_line_id;
952: --Update the Header,

Line 958: oe_debug_pub.add( 'In call Process Order API before Loop' , 1 ) ;

954: l_header_rec.header_id := p_header_id;
955: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
956: l_header_rec.flow_status_code := 'PRICING_APPROVED';
957: IF l_debug_level > 0 THEN
958: oe_debug_pub.add( 'In call Process Order API before Loop' , 1 ) ;
959: END IF;
960:
961: for l_lines in lines_cursor LOOP
962: l_continue:='Y';

Line 971: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_lines.line_id , 1 ) ;

967: ' AND SOURCE_REF_HEADER_ID = :p_header_id ' ||
968: ' AND SOURCE_REF_LINE_ID = :l_line_id ' ;
969:
970: IF l_debug_level > 0 THEN
971: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_lines.line_id , 1 ) ;
972: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_sqlstmt , 1 ) ;
973: oe_debug_pub.add( 'In call Process Order API before execute immediate' || p_header_id || '-' || l_status , 1 ) ;
974: END IF;
975:

Line 972: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_sqlstmt , 1 ) ;

968: ' AND SOURCE_REF_LINE_ID = :l_line_id ' ;
969:
970: IF l_debug_level > 0 THEN
971: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_lines.line_id , 1 ) ;
972: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_sqlstmt , 1 ) ;
973: oe_debug_pub.add( 'In call Process Order API before execute immediate' || p_header_id || '-' || l_status , 1 ) ;
974: END IF;
975:
976: BEGIN

Line 973: oe_debug_pub.add( 'In call Process Order API before execute immediate' || p_header_id || '-' || l_status , 1 ) ;

969:
970: IF l_debug_level > 0 THEN
971: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_lines.line_id , 1 ) ;
972: oe_debug_pub.add( 'In call Process Order API before execute immediate' || l_sqlstmt , 1 ) ;
973: oe_debug_pub.add( 'In call Process Order API before execute immediate' || p_header_id || '-' || l_status , 1 ) ;
974: END IF;
975:
976: BEGIN
977: EXECUTE IMMEDIATE l_sqlstmt INTO

Line 983: oe_debug_pub.add( 'Exec immediate NO data found-Dont update this Line' , 1 ) ;

979: USING p_header_id, l_lines.line_id;
980: EXCEPTION
981: WHEN NO_DATA_FOUND THEN
982: l_continue:='N';
983: oe_debug_pub.add( 'Exec immediate NO data found-Dont update this Line' , 1 ) ;
984: END;
985: IF l_debug_level > 0 THEN
986: oe_debug_pub.add( 'In call Process Order API execute immediate-' || l_continue, 1 ) ;
987: END IF;

Line 986: oe_debug_pub.add( 'In call Process Order API execute immediate-' || l_continue, 1 ) ;

982: l_continue:='N';
983: oe_debug_pub.add( 'Exec immediate NO data found-Dont update this Line' , 1 ) ;
984: END;
985: IF l_debug_level > 0 THEN
986: oe_debug_pub.add( 'In call Process Order API execute immediate-' || l_continue, 1 ) ;
987: END IF;
988:
989: IF (l_continue='Y') then
990: i := i+1;

Line 1014: oe_debug_pub.add( 'In call Process Order API Adjustment' , 1 ) ;

1010: WHEN OTHERS THEN --Modifier is NOT APPLIED
1011: l_price_adj_id := NULL;
1012: END;
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'In call Process Order API Adjustment' , 1 ) ;
1015: END IF;
1016:
1017: --Order Line Adjustment Information
1018: l_line_adj_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;

Line 1048: oe_debug_pub.add( 'Status Before PO API call ' || l_line_tbl.count, 1 ) ;

1044: l_line_tbl(i).calculate_price_flag := 'P';
1045: END IF;
1046: END LOOP;
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'Status Before PO API call ' || l_line_tbl.count, 1 ) ;
1049: END IF;
1050:
1051: Oe_Order_Pvt.Process_Order(
1052: p_api_version_number => '1.0'

Line 1076: oe_debug_pub.add( 'Status after PO API call from deals ' || x_return_status, 1 ) ;

1072: );
1073:
1074:
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'Status after PO API call from deals ' || x_return_status, 1 ) ;
1077: END IF;
1078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: IF l_debug_level > 0 THEN
1080: oe_debug_pub.add( 'Raising Error', 1 ) ;

Line 1080: oe_debug_pub.add( 'Raising Error', 1 ) ;

1076: oe_debug_pub.add( 'Status after PO API call from deals ' || x_return_status, 1 ) ;
1077: END IF;
1078: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: IF l_debug_level > 0 THEN
1080: oe_debug_pub.add( 'Raising Error', 1 ) ;
1081: END IF;
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084:

Line 1099: oe_debug_pub.add( 'Status other ' || sqlerrm, 1 ) ;

1095:
1096: WHEN OTHERS THEN
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF l_debug_level > 0 THEN
1099: oe_debug_pub.add( 'Status other ' || sqlerrm, 1 ) ;
1100: END IF;
1101:
1102: END Call_Process_Order;
1103:

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

1122: l_dynamicSqlString VARCHAR2(2000);
1123: l_package VARCHAR2(30) := 'QPR_PRICE_NEGOTIATION_PUB';
1124: l_procedure VARCHAR2(30) := 'get_pn_approval_status';
1125: l_db_link varchar2(240);
1126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1127:
1128: BEGIN
1129:
1130: IF l_debug_level > 0 THEN

Line 1131: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.get_Deal' , 1 ) ;

1127:
1128: BEGIN
1129:
1130: IF l_debug_level > 0 THEN
1131: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.get_Deal' , 1 ) ;
1132: END IF;
1133: x_deal_id := NULL;
1134: x_deal_status := NULL;
1135:

Line 1164: oe_debug_pub.add( 'Exit OE_DEALS_UTIL.get_Deal QUERY-' || l_dynamicSqlString, 1 ) ;

1160: OUT x_deal_id,
1161: OUT x_deal_status;
1162:
1163: IF l_debug_level > 0 THEN
1164: oe_debug_pub.add( 'Exit OE_DEALS_UTIL.get_Deal QUERY-' || l_dynamicSqlString, 1 ) ;
1165: oe_debug_pub.add( 'Exit OE_DEALS_UTIL.get_Deal' || x_deal_id || x_deal_status, 1 ) ;
1166: END IF;
1167: EXCEPTION
1168: WHEN OTHERS THEN

Line 1165: oe_debug_pub.add( 'Exit OE_DEALS_UTIL.get_Deal' || x_deal_id || x_deal_status, 1 ) ;

1161: OUT x_deal_status;
1162:
1163: IF l_debug_level > 0 THEN
1164: oe_debug_pub.add( 'Exit OE_DEALS_UTIL.get_Deal QUERY-' || l_dynamicSqlString, 1 ) ;
1165: oe_debug_pub.add( 'Exit OE_DEALS_UTIL.get_Deal' || x_deal_id || x_deal_status, 1 ) ;
1166: END IF;
1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: x_deal_id := NULL;

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

1197:
1198: l_deal_id NUMBER;
1199: l_deal_status VARCHAR2(30);
1200: l_wf_activity VARCHAR2(30);
1201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1202: l_wf_count NUMBER;
1203:
1204: BEGIN
1205:

Line 1207: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.Update_Order_with_Deal' , 1 ) ;

1203:
1204: BEGIN
1205:
1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add( 'ENTER OE_DEALS_UTIL.Update_Order_with_Deal' , 1 ) ;
1208: END IF;
1209:
1210: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id
1211: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id

Line 1233: oe_debug_pub.add( 'Deal Info - ' || l_deal_id || l_deal_status , 1 ) ;

1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1230:
1231:
1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'Deal Info - ' || l_deal_id || l_deal_status , 1 ) ;
1234: END IF;
1235:
1236: -- Approved Deal, Call PO API update the Order
1237: Call_Process_Order (p_header_id => p_header_id

Line 1241: oe_debug_pub.add( 'After PO API from Deal - ' || x_return_status , 1 ) ;

1237: Call_Process_Order (p_header_id => p_header_id
1238: ,x_return_status => x_return_status);
1239:
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'After PO API from Deal - ' || x_return_status , 1 ) ;
1242: END IF;
1243:
1244: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1245:

Line 1268: oe_debug_pub.add( 'After PO API from Deal - ' || l_wf_activity , 1 ) ;

1264: l_wf_activity := NULL;
1265:
1266: END;
1267: IF l_debug_level > 0 THEN
1268: oe_debug_pub.add( 'After PO API from Deal - ' || l_wf_activity , 1 ) ;
1269: END IF;
1270:
1271: if l_wf_activity is NULL then
1272: NULL ;

Line 1291: oe_debug_pub.add( 'After WF Engine call - ' || l_wf_count , 1 ) ;

1287: , result => 'APPROVED'
1288: );
1289:
1290: IF l_debug_level > 0 THEN
1291: oe_debug_pub.add( 'After WF Engine call - ' || l_wf_count , 1 ) ;
1292: END IF;
1293:
1294:
1295: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_DEAL_UPDATED');