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

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

22: l_top_model_line_id NUMBER;
23: l_dummy VARCHAR2(2);
24:
25: --
26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
27: --
28: BEGIN
29:
30: --

Line 41: oe_debug_pub.add( 'WITHIN DENIED PARTY WORKFLOW COVER ' ) ;

37: ,p_entity_id => to_number(itemkey)
38: ,p_line_id => to_number(itemkey));
39:
40: IF l_debug_level > 0 THEN
41: oe_debug_pub.add( 'WITHIN DENIED PARTY WORKFLOW COVER ' ) ;
42: END IF;
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
45: END IF;

Line 44: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;

40: IF l_debug_level > 0 THEN
41: oe_debug_pub.add( 'WITHIN DENIED PARTY WORKFLOW COVER ' ) ;
42: END IF;
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
45: END IF;
46: OE_STANDARD_WF.Set_Msg_Context(actid);
47:
48: SAVEPOINT Before_Lock;

Line 65: oe_debug_pub.add('OEXWECSB.pls: unable to lock the line:'||l_top_model_line_id,1);

61: END IF;
62: EXCEPTION
63: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
64: IF l_debug_level > 0 THEN
65: oe_debug_pub.add('OEXWECSB.pls: unable to lock the line:'||l_top_model_line_id,1);
66: END IF;
67: resultout := 'COMPLETE:INCOMPLETE';
68: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
69: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');

Line 84: oe_debug_pub.add( 'LOCK ROW RETURNED WITH ERROR' , 1 ) ;

80: x_return_status => l_return_status);
81:
82: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'LOCK ROW RETURNED WITH ERROR' , 1 ) ;
85: END IF;
86: resultout := 'COMPLETE:INCOMPLETE';
87: OE_STANDARD_WF.Save_Messages;
88: OE_STANDARD_WF.Clear_Msg_Context;

Line 133: oe_debug_pub.add( 'AFTER PROCESSING THE REQUEST :'||L_RETURN_STATUS ) ;

129: ,x_result_out => l_result_out);
130:
131:
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add( 'AFTER PROCESSING THE REQUEST :'||L_RETURN_STATUS ) ;
134: END IF;
135:
136:
137: -- If error is generated by the Insert Procedure then we need to

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

278: l_dummy VARCHAR2(10);
279: l_org_id NUMBER;
280: l_serv INTEGER;
281: --
282: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
283: --
284: BEGIN
285:
286: --

Line 296: OE_DEBUG_PUB.Add('Entering Update_screening_results...');

292: p_entity_code => 'LINE'
293: ,p_entity_id => to_number(itemkey)
294: ,p_line_id => to_number(itemkey));
295:
296: OE_DEBUG_PUB.Add('Entering Update_screening_results...');
297:
298: SAVEPOINT UPDATE_API;
299:
300: -- MOAC change DBMS_APPLICATION_INFO.Set_Client_Info(l_org_id);

Line 315: Oe_debug_pub.add('Calling shipping API to get request status...');

311:
312: l_line_id := l_line_rec.line_id;
313: l_header_id := l_line_rec.header_id;
314:
315: Oe_debug_pub.add('Calling shipping API to get request status...');
316:
317: wsh_itm_util.get_compliance_status (
318: p_appliciation_id => 660,
319: p_original_sys_reference => l_line_rec.header_id,

Line 327: Oe_debug_pub.add('request_control_id : ' || l_request_control_id);

323: x_request_set_id => l_request_set_id,
324: x_return_status => l_return_status
325: );
326:
327: Oe_debug_pub.add('request_control_id : ' || l_request_control_id);
328: Oe_debug_pub.add('request_set_id : ' || l_request_set_id);
329: Oe_debug_pub.add('process_flag : ' || l_process_flag);
330: Oe_debug_pub.add('return status : ' || l_return_status);
331:

Line 328: Oe_debug_pub.add('request_set_id : ' || l_request_set_id);

324: x_return_status => l_return_status
325: );
326:
327: Oe_debug_pub.add('request_control_id : ' || l_request_control_id);
328: Oe_debug_pub.add('request_set_id : ' || l_request_set_id);
329: Oe_debug_pub.add('process_flag : ' || l_process_flag);
330: Oe_debug_pub.add('return status : ' || l_return_status);
331:
332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 329: Oe_debug_pub.add('process_flag : ' || l_process_flag);

325: );
326:
327: Oe_debug_pub.add('request_control_id : ' || l_request_control_id);
328: Oe_debug_pub.add('request_set_id : ' || l_request_set_id);
329: Oe_debug_pub.add('process_flag : ' || l_process_flag);
330: Oe_debug_pub.add('return status : ' || l_return_status);
331:
332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
333: Oe_debug_pub.add('get_compliance_status API returned error.!');

Line 330: Oe_debug_pub.add('return status : ' || l_return_status);

326:
327: Oe_debug_pub.add('request_control_id : ' || l_request_control_id);
328: Oe_debug_pub.add('request_set_id : ' || l_request_set_id);
329: Oe_debug_pub.add('process_flag : ' || l_process_flag);
330: Oe_debug_pub.add('return status : ' || l_return_status);
331:
332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
333: Oe_debug_pub.add('get_compliance_status API returned error.!');
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 333: Oe_debug_pub.add('get_compliance_status API returned error.!');

329: Oe_debug_pub.add('process_flag : ' || l_process_flag);
330: Oe_debug_pub.add('return status : ' || l_return_status);
331:
332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
333: Oe_debug_pub.add('get_compliance_status API returned error.!');
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: -- This select statement is used to lock the Top Model Line.

Line 376: Oe_debug_pub.ADD('Lock on lines taken.');

372: FOR UPDATE
373: --Commented for bug 6415831
374: NOWAIT; -- Uncommented for 8762350
375:
376: Oe_debug_pub.ADD('Lock on lines taken.');
377:
378: BEGIN --9853045
379:
380: SELECT 'Y'

Line 388: Oe_debug_pub.ADD('SKIPPING NO DATA FOUND from DBI Table Query');

384: FOR UPDATE NOWAIT;
385:
386: EXCEPTION -- Exception added as part of 9853045
387: WHEN NO_DATA_FOUND THEN
388: Oe_debug_pub.ADD('SKIPPING NO DATA FOUND from DBI Table Query');
389: NULL;
390: WHEN TOO_MANY_ROWS THEN
391: Oe_debug_pub.ADD('SKIPPING TOO MANY ROWS from DBI Table Query');
392: NULL;

Line 391: Oe_debug_pub.ADD('SKIPPING TOO MANY ROWS from DBI Table Query');

387: WHEN NO_DATA_FOUND THEN
388: Oe_debug_pub.ADD('SKIPPING NO DATA FOUND from DBI Table Query');
389: NULL;
390: WHEN TOO_MANY_ROWS THEN
391: Oe_debug_pub.ADD('SKIPPING TOO MANY ROWS from DBI Table Query');
392: NULL;
393: END; --9853045
394:
395:

Line 397: Oe_debug_pub.ADD('Lock on dbi taken.');

393: END; --9853045
394:
395:
396:
397: Oe_debug_pub.ADD('Lock on dbi taken.');
398:
399: EXCEPTION
400: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
401: IF l_debug_level > 0 THEN

Line 402: oe_debug_pub.add('OEXWECSB.pls: unable to lock the line', 1);

398:
399: EXCEPTION
400: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
401: IF l_debug_level > 0 THEN
402: oe_debug_pub.add('OEXWECSB.pls: unable to lock the line', 1);
403: END IF;
404: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
405: OE_MSG_PUB.set_msg_context(
406: p_entity_code => 'LINE'

Line 428: oe_debug_pub.add('The line ' || to_char(l_line_id) || 'is already cancelled.', 1);

424: -- Check whether the Line is cancelled
425:
426: IF l_line_rec.cancelled_flag = 'Y' THEN
427: IF l_debug_level > 0 THEN
428: oe_debug_pub.add('The line ' || to_char(l_line_id) || 'is already cancelled.', 1);
429: END IF;
430: RETURN;
431: END IF;
432:

Line 454: oe_debug_pub.add('Override screening for line id:' || l_line_id, 3);

450:
451: IF l_process_flag = 3 THEN
452:
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('Override screening for line id:' || l_line_id, 3);
455: END IF;
456:
457: -- Update Work flow Status Code
458:

Line 498: OE_DEBUG_PUB.Add('Response analyser return status :' || l_return_status, 1);

494:
495:
496:
497: IF l_debug_level > 0 THEN
498: OE_DEBUG_PUB.Add('Response analyser return status :' || l_return_status, 1);
499: END IF;
500:
501: -- Check for System or Data errors.
502:

Line 554: OE_DEBUG_PUB.Add('Party Name:' || c_resplines.party_name || ',denied');

550: FND_MESSAGE.SET_TOKEN('DENIEDPARTY',
551: c_resplines.party_name);
552: OE_MSG_PUB.Add;
553: IF l_debug_level > 0 THEN
554: OE_DEBUG_PUB.Add('Party Name:' || c_resplines.party_name || ',denied');
555: END IF;
556: END IF;
557: END;
558: END LOOP;

Line 566: OE_DEBUG_PUB.Add('Service Result' || l_services(l_serv).Service_Result, 1);

562:
563: FOR l_serv IN 1..l_services.COUNT
564: LOOP
565: IF l_debug_level > 0 THEN
566: OE_DEBUG_PUB.Add('Service Result' || l_services(l_serv).Service_Result, 1);
567: END IF;
568:
569: IF l_services(l_serv).Service_Type = 'DP' THEN
570: l_dp_hold_flag := l_services(l_serv).Service_Result;

Line 589: oe_debug_pub.add('Progress Work Flow to Next Stage...', 1);

585:
586: -- Progress Work Flow to Next Stage
587:
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.add('Progress Work Flow to Next Stage...', 1);
590: END IF;
591:
592:
593: -- If one response has system error and other has data error we

Line 623: OE_DEBUG_PUB.Add('Generic Hold!!!');

619:
620: ELSIF l_gen_hold_flag = 'Y' AND
621: OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
622:
623: OE_DEBUG_PUB.Add('Generic Hold!!!');
624:
625: -- The Hold_Id of the Generic Hold has been
626: -- seeded as 23.
627:

Line 649: oe_debug_pub.add('Applied Generic hold on line:' || l_line_rec.line_id, 1);

645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add('Applied Generic hold on line:' || l_line_rec.line_id, 1);
650: END IF;
651: END IF;
652:
653: OE_Order_WF_Util.Update_Flow_Status_Code

Line 698: oe_debug_pub.add('Applied denied party hold on line:' || l_line_rec.line_id, 1);

694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('Applied denied party hold on line:' || l_line_rec.line_id, 1);
699: END IF;
700: END IF;
701:
702: OE_Order_WF_Util.Update_Flow_Status_Code

Line 744: oe_debug_pub.add('Exiting response api', 1);

740:
741: OE_MSG_PUB.SAVE_MESSAGES(l_line_rec.line_id);
742:
743: IF l_debug_level > 0 THEN
744: oe_debug_pub.add('Exiting response api', 1);
745: END IF;
746: END IF;
747:
748: -- End for 'RUN' mode