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.WSH_ITM_OVERRIDE dependencies on WSH_UTIL_CORE

Line 55: WSH_UTIL_CORE.println(' Inside procedure CALL_CUSTOM_API');

51:
52:
53: BEGIN
54:
55: WSH_UTIL_CORE.println(' Inside procedure CALL_CUSTOM_API');
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: ----------------------------------------------------------

Line 68: WSH_UTIL_CORE.println('Application Short Name :' || l_appl_short_name);

64: OPEN Get_Application_Short_name(p_appl_id);
65: FETCH Get_Application_Short_Name INTO l_appl_short_name;
66: CLOSE Get_Application_Short_Name;
67:
68: WSH_UTIL_CORE.println('Application Short Name :' || l_appl_short_name);
69: WSH_UTIL_CORE.println(' ');
70:
71: -- 9172419
72: -- ONLY 2 parameters for WSH, 3 FOR ONT

Line 69: WSH_UTIL_CORE.println(' ');

65: FETCH Get_Application_Short_Name INTO l_appl_short_name;
66: CLOSE Get_Application_Short_Name;
67:
68: WSH_UTIL_CORE.println('Application Short Name :' || l_appl_short_name);
69: WSH_UTIL_CORE.println(' ');
70:
71: -- 9172419
72: -- ONLY 2 parameters for WSH, 3 FOR ONT
73: IF l_appl_short_name = 'ONT' THEN

Line 83: WSH_UTIL_CORE.println('Request Set Id is Null..');

79: END IF;
80:
81: IF p_request_set_id IS NULL THEN
82:
83: WSH_UTIL_CORE.println('Request Set Id is Null..');
84: WSH_UTIL_CORE.println('Building the procedure name dynamically');
85:
86: ------------------------------------------------------
87: -- The Procedure Name is getting built dynamiclly here.

Line 84: WSH_UTIL_CORE.println('Building the procedure name dynamically');

80:
81: IF p_request_set_id IS NULL THEN
82:
83: WSH_UTIL_CORE.println('Request Set Id is Null..');
84: WSH_UTIL_CORE.println('Building the procedure name dynamically');
85:
86: ------------------------------------------------------
87: -- The Procedure Name is getting built dynamiclly here.
88: -- The generic syntax is :

Line 94: WSH_UTIL_CORE.println('Calling Application specific API');

90: -- It then gets executed by the EXECUTE IMMEDIATE
91: -- command.
92: ------------------------------------------------------
93: --
94: WSH_UTIL_CORE.println('Calling Application specific API');
95: WSH_UTIL_CORE.println(l_procedure_name);
96: WSH_UTIL_CORE.println(' ');
97:
98: -- 9172419

Line 95: WSH_UTIL_CORE.println(l_procedure_name);

91: -- command.
92: ------------------------------------------------------
93: --
94: WSH_UTIL_CORE.println('Calling Application specific API');
95: WSH_UTIL_CORE.println(l_procedure_name);
96: WSH_UTIL_CORE.println(' ');
97:
98: -- 9172419
99: IF l_appl_short_name = 'ONT' THEN

Line 96: WSH_UTIL_CORE.println(' ');

92: ------------------------------------------------------
93: --
94: WSH_UTIL_CORE.println('Calling Application specific API');
95: WSH_UTIL_CORE.println(l_procedure_name);
96: WSH_UTIL_CORE.println(' ');
97:
98: -- 9172419
99: IF l_appl_short_name = 'ONT' THEN
100: EXECUTE IMMEDIATE l_procedure_name

Line 110: WSH_UTIL_CORE.println('Out of the Application Specific Procedure');

106: USING p_request_control_id,
107: p_request_set_id;
108: END IF;
109:
110: WSH_UTIL_CORE.println('Out of the Application Specific Procedure');
111:
112: ELSE -- if request_set_id is not null
113:
114: WSH_UTIL_CORE.println('Request Set Id is not Null..');

Line 114: WSH_UTIL_CORE.println('Request Set Id is not Null..');

110: WSH_UTIL_CORE.println('Out of the Application Specific Procedure');
111:
112: ELSE -- if request_set_id is not null
113:
114: WSH_UTIL_CORE.println('Request Set Id is not Null..');
115: WSH_UTIL_CORE.println('Request Set Id is :' || p_request_set_id);
116:
117: ----------------------------------------------------
118: -- All other requests with the same request_set_id

Line 115: WSH_UTIL_CORE.println('Request Set Id is :' || p_request_set_id);

111:
112: ELSE -- if request_set_id is not null
113:
114: WSH_UTIL_CORE.println('Request Set Id is not Null..');
115: WSH_UTIL_CORE.println('Request Set Id is :' || p_request_set_id);
116:
117: ----------------------------------------------------
118: -- All other requests with the same request_set_id
119: -- must have process flag as 1 or 3. Only then call

Line 128: WSH_UTIL_CORE.println('Calling Application specific API');

124: FETCH Get_Process_Flag INTO l_exists;
125:
126: IF Get_Process_Flag%NOTFOUND THEN
127:
128: WSH_UTIL_CORE.println('Calling Application specific API');
129: WSH_UTIL_CORE.println(l_procedure_name);
130: WSH_UTIL_CORE.println(' ');
131:
132: -- 9172419

Line 129: WSH_UTIL_CORE.println(l_procedure_name);

125:
126: IF Get_Process_Flag%NOTFOUND THEN
127:
128: WSH_UTIL_CORE.println('Calling Application specific API');
129: WSH_UTIL_CORE.println(l_procedure_name);
130: WSH_UTIL_CORE.println(' ');
131:
132: -- 9172419
133: IF l_appl_short_name = 'ONT' THEN

Line 130: WSH_UTIL_CORE.println(' ');

126: IF Get_Process_Flag%NOTFOUND THEN
127:
128: WSH_UTIL_CORE.println('Calling Application specific API');
129: WSH_UTIL_CORE.println(l_procedure_name);
130: WSH_UTIL_CORE.println(' ');
131:
132: -- 9172419
133: IF l_appl_short_name = 'ONT' THEN
134: EXECUTE IMMEDIATE l_procedure_name

Line 157: WSH_UTIL_CORE.PrintMsg('Failed in Procedure Call_Custom_API');

153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: l_error_code := SQLCODE;
155: l_error_text := SQLERRM;
156:
157: WSH_UTIL_CORE.PrintMsg('Failed in Procedure Call_Custom_API');
158: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
159:
160: END Call_Custom_API;
161:

Line 158: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);

154: l_error_code := SQLCODE;
155: l_error_text := SQLERRM;
156:
157: WSH_UTIL_CORE.PrintMsg('Failed in Procedure Call_Custom_API');
158: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
159:
160: END Call_Custom_API;
161:
162: -- Procedure Name

Line 192: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;

188: l_old_status VARCHAR2(30);
189: l_new_status VARCHAR2(30);
190: l_default_status VARCHAR2(100);
191: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
192: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
193: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
194:
195: l_logged_at_location_id number ;
196: l_exception_location_id number;

Line 193: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;

189: l_new_status VARCHAR2(30);
190: l_default_status VARCHAR2(100);
191: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
192: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
193: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
194:
195: l_logged_at_location_id number ;
196: l_exception_location_id number;
197: L_EXCEPTION_MESSAGE VARCHAR2(200);

Line 221: WSH_UTIL_CORE.println('Call to shipping to log close the previous exception and log a new skip exception');

217: l_msg_count :=NULL;
218: l_msg_data := NULL;
219: l_new_status := 'CLOSED';
220:
221: WSH_UTIL_CORE.println('Call to shipping to log close the previous exception and log a new skip exception');
222: WSH_UTIL_CORE.println('Request Control Id is'||p_request_control_id);
223:
224:
225:

Line 222: WSH_UTIL_CORE.println('Request Control Id is'||p_request_control_id);

218: l_msg_data := NULL;
219: l_new_status := 'CLOSED';
220:
221: WSH_UTIL_CORE.println('Call to shipping to log close the previous exception and log a new skip exception');
222: WSH_UTIL_CORE.println('Request Control Id is'||p_request_control_id);
223:
224:
225:
226: OPEN DELIVERY_SKIP(p_request_control_id);

Line 231: WSH_UTIL_CORE.println('The exception name is '||l_exception_name);

227: LOOP
228: FETCH delivery_skip INTO
229: l_exception_name,l_exception_id,l_status,l_logged_at_location_id,l_exception_location_id,l_delivery_id,l_delivery_name;
230:
231: WSH_UTIL_CORE.println('The exception name is '||l_exception_name);
232: WSH_UTIL_CORE.println('The exception is is '||l_exception_id);
233:
234:
235: EXIT WHEN DELIVERY_SKIP%NOTFOUND;

Line 232: WSH_UTIL_CORE.println('The exception is is '||l_exception_id);

228: FETCH delivery_skip INTO
229: l_exception_name,l_exception_id,l_status,l_logged_at_location_id,l_exception_location_id,l_delivery_id,l_delivery_name;
230:
231: WSH_UTIL_CORE.println('The exception name is '||l_exception_name);
232: WSH_UTIL_CORE.println('The exception is is '||l_exception_id);
233:
234:
235: EXIT WHEN DELIVERY_SKIP%NOTFOUND;
236:

Line 288: WSH_UTIL_CORE.println('End of call to shipping ');

284: p_delivery_id => l_delivery_id,
285: p_delivery_name => l_delivery_name
286: );
287:
288: WSH_UTIL_CORE.println('End of call to shipping ');
289:
290:
291: END LOOP;
292: CLOSE delivery_skip;

Line 428: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

424:
425: l_completion_status := 'NORMAL';
426: l_log_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
427:
428: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
429:
430: IF l_log_level IS NOT NULL THEN
431: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
432: END IF;

Line 431: WSH_UTIL_CORE.Set_Log_Level(l_log_level);

427:
428: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
429:
430: IF l_log_level IS NOT NULL THEN
431: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
432: END IF;
433:
434:
435: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Launch_Override ***');

Line 435: WSH_UTIL_CORE.println('* Inside PROCEDURE ITM_Launch_Override *');

431: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
432: END IF;
433:
434:
435: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Launch_Override ***');
436: WSH_UTIL_CORE.println(' ');
437:
438: ------------------------------------------
439: -- Print the values of all the parameters.

Line 436: WSH_UTIL_CORE.println(' ');

432: END IF;
433:
434:
435: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Launch_Override ***');
436: WSH_UTIL_CORE.println(' ');
437:
438: ------------------------------------------
439: -- Print the values of all the parameters.
440: ------------------------------------------

Line 442: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);

438: ------------------------------------------
439: -- Print the values of all the parameters.
440: ------------------------------------------
441:
442: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);

Line 443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);

439: -- Print the values of all the parameters.
440: ------------------------------------------
441:
442: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);

Line 444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);

440: ------------------------------------------
441:
442: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);

Line 445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);

441:
442: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);

Line 446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);

442: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);

Line 447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);

443: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
451: WSH_UTIL_CORE.println(' ');

Line 448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);

444: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
451: WSH_UTIL_CORE.println(' ');
452:

Line 449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);

445: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
451: WSH_UTIL_CORE.println(' ');
452:
453: --Issue a Savepoint

Line 450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);

446: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
451: WSH_UTIL_CORE.println(' ');
452:
453: --Issue a Savepoint
454: SAVEPOINT WSH_ITM_OVERRIDE;

Line 451: WSH_UTIL_CORE.println(' ');

447: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
448: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
449: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
450: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
451: WSH_UTIL_CORE.println(' ');
452:
453: --Issue a Savepoint
454: SAVEPOINT WSH_ITM_OVERRIDE;
455: IF p_override_type = 'UNPROCESSED' OR

Line 458: WSH_UTIL_CORE.println('Override type is UNPROCESSED');

454: SAVEPOINT WSH_ITM_OVERRIDE;
455: IF p_override_type = 'UNPROCESSED' OR
456: p_override_type IS NULL THEN
457:
458: WSH_UTIL_CORE.println('Override type is UNPROCESSED');
459:
460: If p_vendor_id is NULL THEN
461: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');
462: if p_application_id=660 then

Line 461: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');

457:
458: WSH_UTIL_CORE.println('Override type is UNPROCESSED');
459:
460: If p_vendor_id is NULL THEN
461: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');
462: if p_application_id=660 then
463: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
464: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc ';
465:

Line 499: WSH_UTIL_CORE.println(l_sub_str);

495: IF i > length(l_sql_string) THEN
496: EXIT;
497: END IF;
498: l_sub_str := SUBSTR(l_sql_string, i , 80);
499: WSH_UTIL_CORE.println(l_sub_str);
500: i := i + 80;
501: END LOOP;
502:
503: l_CursorID := DBMS_SQL.Open_Cursor;

Line 528: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');

524: l_ignore := DBMS_SQL.Execute(l_CursorID);
525: --}
526: else
527: open Get_Unprocessed_Records_1_ship;
528: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');
529: if p_override_type= null and p_reference_id is not null then
530: WSH_UTIL_CORE.println('The delivery contains errored request ' );
531: l_flag := 1;
532: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);

Line 530: WSH_UTIL_CORE.println('The delivery contains errored request ' );

526: else
527: open Get_Unprocessed_Records_1_ship;
528: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');
529: if p_override_type= null and p_reference_id is not null then
530: WSH_UTIL_CORE.println('The delivery contains errored request ' );
531: l_flag := 1;
532: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
533: end if;
534: end if;

Line 532: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);

528: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');
529: if p_override_type= null and p_reference_id is not null then
530: WSH_UTIL_CORE.println('The delivery contains errored request ' );
531: l_flag := 1;
532: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
533: end if;
534: end if;
535: ELSE
536: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');

Line 536: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');

532: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
533: end if;
534: end if;
535: ELSE
536: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');
537: if p_application_id=660 then
538: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
539: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
540: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';

Line 582: WSH_UTIL_CORE.println(l_sub_str);

578: IF i > length(l_sql_string) THEN
579: EXIT;
580: END IF;
581: l_sub_str := SUBSTR(l_sql_string, i , 80);
582: WSH_UTIL_CORE.println(l_sub_str);
583: i := i + 80;
584: END LOOP;
585:
586: l_CursorID := DBMS_SQL.Open_Cursor;

Line 631: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);

627: END IF;
628: else
629:
630: EXIT WHEN l_flag=1;
631: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
632:
633: Fetch Get_Unprocessed_Records_1_ship into
634: l_request_control_id,
635: l_request_set_id;

Line 636: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);

632:
633: Fetch Get_Unprocessed_Records_1_ship into
634: l_request_control_id,
635: l_request_set_id;
636: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);
637: EXIT WHEN Get_Unprocessed_Records_1_ship%NOTFOUND;
638:
639: end if;
640: Else

Line 658: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);

654: EXIT WHEN Get_Unprocessed_Records_2_ship%NOTFOUND;
655: end if;
656:
657: End If;
658: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);
659:
660:
661: WSH_UTIL_CORE.println('Updating Process Flag');
662:

Line 661: WSH_UTIL_CORE.println('Updating Process Flag');

657: End If;
658: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);
659:
660:
661: WSH_UTIL_CORE.println('Updating Process Flag');
662:
663: update wsh_itm_request_control
664: SET process_flag = 3
665: WHERE request_control_id = l_request_control_id;

Line 671: WSH_UTIL_CORE.println('Calling Procedure Call_Custom_API');

667: if p_application_id=665 then
668: Handle_Exception(l_request_control_id);
669: end if;
670: BEGIN
671: WSH_UTIL_CORE.println('Calling Procedure Call_Custom_API');
672: Call_Custom_API
673: (
674: p_request_control_id => l_request_control_id,
675: p_request_set_id => l_request_set_id,

Line 680: WSH_UTIL_CORE.println('After Call to Call_Custom_API');

676: p_appl_id => p_application_id,
677: x_return_status => l_return_status
678: );
679:
680: WSH_UTIL_CORE.println('After Call to Call_Custom_API');
681: WSH_UTIL_CORE.println('Return Status from Call_Custom_API:' || l_return_status);
682:
683: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
684: RAISE Call_Custom_API_Failed;

Line 681: WSH_UTIL_CORE.println('Return Status from Call_Custom_API:' || l_return_status);

677: x_return_status => l_return_status
678: );
679:
680: WSH_UTIL_CORE.println('After Call to Call_Custom_API');
681: WSH_UTIL_CORE.println('Return Status from Call_Custom_API:' || l_return_status);
682:
683: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
684: RAISE Call_Custom_API_Failed;
685: END IF;

Line 691: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);

687:
688: EXCEPTION
689: WHEN Call_Custom_API_Failed THEN
690: ROLLBACK TO WSH_ITM_OVERRIDE;
691: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);
692:
693: END;
694:
695: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);

Line 695: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);

691: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);
692:
693: END;
694:
695: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);
696:
697: END LOOP;
698:
699: If p_vendor_id is NULL THEN

Line 723: WSH_UTIL_CORE.println('p_override_type is not unprocessed');

719: p_override_type = 'DATA' OR
720: p_override_type IS NULL THEN
721:
722:
723: WSH_UTIL_CORE.println('p_override_type is not unprocessed');
724: if p_application_id =660 THEN
725: -- {
726: -- Using Dynamic Cursor instead of static cursor for performance.
727: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';

Line 828: WSH_UTIL_CORE.println(l_sub_str);

824: IF i > length(l_sql_string) THEN
825: EXIT;
826: END IF;
827: l_sub_str := SUBSTR(l_sql_string, i , 80);
828: WSH_UTIL_CORE.println(l_sub_str);
829: i := i + 80;
830: END LOOP;
831:
832: l_CursorID := DBMS_SQL.Open_Cursor;

Line 887: WSH_UTIL_CORE.println('Start of Processing for Request Control : ' || l_request_control_id);

883: fetch Get_Request_Control_ship into l_request_control_id,l_request_set_id;
884: EXIT WHEN Get_Request_Control_ship%NOTFOUND;
885: END IF;
886:
887: WSH_UTIL_CORE.println('Start of Processing for Request Control : ' || l_request_control_id);
888:
889: ----------------------------------------------------------
890: -- Call the Response Analyser API
891: ----------------------------------------------------------

Line 893: WSH_UTIL_CORE.println(' Calling the Response Analyser');

889: ----------------------------------------------------------
890: -- Call the Response Analyser API
891: ----------------------------------------------------------
892:
893: WSH_UTIL_CORE.println(' Calling the Response Analyser');
894:
895: WSH_ITM_RESPONSE_PKG.ONT_RESPONSE_ANALYSER
896: (
897: p_request_control_id => l_request_control_id,

Line 904: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');

900: x_return_status => l_return_status
901: );
902: IF l_interpreted_value = 'DATA' AND p_application_id =660 THEN
903: IF p_override_type ='SYSTEM' THEN
904: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
905: ELSE
906: WSH_UTIL_CORE.println('Cannot process data errors');
907: END IF;
908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 906: WSH_UTIL_CORE.println('Cannot process data errors');

902: IF l_interpreted_value = 'DATA' AND p_application_id =660 THEN
903: IF p_override_type ='SYSTEM' THEN
904: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
905: ELSE
906: WSH_UTIL_CORE.println('Cannot process data errors');
907: END IF;
908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
909: RAISE Response_Analyser_Failed;
910: END IF;

Line 914: WSH_UTIL_CORE.println('After Calling the Response Analyser');

910: END IF;
911:
912: ELSE
913:
914: WSH_UTIL_CORE.println('After Calling the Response Analyser');
915: WSH_UTIL_CORE.println(' ');
916:
917:
918: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);

Line 915: WSH_UTIL_CORE.println(' ');

911:
912: ELSE
913:
914: WSH_UTIL_CORE.println('After Calling the Response Analyser');
915: WSH_UTIL_CORE.println(' ');
916:
917:
918: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
919: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);

Line 918: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);

914: WSH_UTIL_CORE.println('After Calling the Response Analyser');
915: WSH_UTIL_CORE.println(' ');
916:
917:
918: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
919: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);
920: WSH_UTIL_CORE.println(' ');
921:
922: BEGIN

Line 919: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);

915: WSH_UTIL_CORE.println(' ');
916:
917:
918: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
919: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);
920: WSH_UTIL_CORE.println(' ');
921:
922: BEGIN
923:

Line 920: WSH_UTIL_CORE.println(' ');

916:
917:
918: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
919: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);
920: WSH_UTIL_CORE.println(' ');
921:
922: BEGIN
923:
924: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 932: WSH_UTIL_CORE.println('Updating process_flag to 3');

928: IF l_interpreted_value = p_override_type OR
929: p_override_type IS NULL THEN
930:
931:
932: WSH_UTIL_CORE.println('Updating process_flag to 3');
933:
934: UPDATE wsh_itm_request_control
935: SET process_flag = 3
936: WHERE request_control_id = l_request_control_id;

Line 949: WSH_UTIL_CORE.println('AFter Call_Custom_API');

945: p_appl_id => p_application_id,
946: x_return_status => l_return_status
947: );
948:
949: WSH_UTIL_CORE.println('AFter Call_Custom_API');
950:
951: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
952: RAISE Call_Custom_API_Failed;
953: END IF;

Line 957: WSH_UTIL_CORE.println('Finished Processing for Request Control :' || l_request_control_id);

953: END IF;
954:
955: END IF;
956:
957: WSH_UTIL_CORE.println('Finished Processing for Request Control :' || l_request_control_id);
958: commit;
959: ELSE
960: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
961: END IF;

Line 960: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');

956:
957: WSH_UTIL_CORE.println('Finished Processing for Request Control :' || l_request_control_id);
958: commit;
959: ELSE
960: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
961: END IF;
962:
963: EXCEPTION
964: WHEN Response_Analyser_Failed THEN

Line 966: WSH_UTIL_CORE.println('Processing failed in Response Analyser');

962:
963: EXCEPTION
964: WHEN Response_Analyser_Failed THEN
965: ROLLBACK TO WSH_ITM_OVERRIDE;
966: WSH_UTIL_CORE.println('Processing failed in Response Analyser');
967:
968: WHEN Call_Custom_API_Failed THEN
969: ROLLBACK TO WSH_ITM_OVERRIDE;
970: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);

Line 970: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);

966: WSH_UTIL_CORE.println('Processing failed in Response Analyser');
967:
968: WHEN Call_Custom_API_Failed THEN
969: ROLLBACK TO WSH_ITM_OVERRIDE;
970: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);
971:
972: END;
973: END IF ;
974: END LOOP;

Line 984: WSH_UTIL_CORE.println('The Processing - Completed..');

980: close Get_Request_Control_ship;
981: END IF;
982: END IF;
983:
984: WSH_UTIL_CORE.println('The Processing - Completed..');
985: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
986:
987:
988: EXCEPTION

Line 997: WSH_UTIL_CORE.PrintMsg('Failed in Procedure ITM_Launch_Override');

993: ROLLBACK TO WSH_ITM_OVERRIDE;
994: l_completion_status := 'ERROR';
995: l_error_code := SQLCODE;
996: l_error_text := SQLERRM;
997: WSH_UTIL_CORE.PrintMsg('Failed in Procedure ITM_Launch_Override');
998: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
999: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
1000:
1001:

Line 998: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);

994: l_completion_status := 'ERROR';
995: l_error_code := SQLCODE;
996: l_error_text := SQLERRM;
997: WSH_UTIL_CORE.PrintMsg('Failed in Procedure ITM_Launch_Override');
998: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
999: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
1000:
1001:
1002: END ITM_Launch_Override;