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:
72: IF p_request_set_id IS NULL THEN

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:
72: IF p_request_set_id IS NULL THEN
73:

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

70:
71:
72: IF p_request_set_id IS NULL THEN
73:
74: WSH_UTIL_CORE.println('Request Set Id is Null..');
75: WSH_UTIL_CORE.println('Building the procedure name dynamically');
76:
77: ------------------------------------------------------
78: -- The Procedure Name is getting built dynamiclly here.

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

71:
72: IF p_request_set_id IS NULL THEN
73:
74: WSH_UTIL_CORE.println('Request Set Id is Null..');
75: WSH_UTIL_CORE.println('Building the procedure name dynamically');
76:
77: ------------------------------------------------------
78: -- The Procedure Name is getting built dynamiclly here.
79: -- The generic syntax is :

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

83: ------------------------------------------------------
84:
85: l_procedure_name := ' BEGIN ' || l_appl_short_name || '_ITM_PKG.WSH_ITM_' || l_appl_short_name || '(:p_request_control_id,:p_request_set_id,:p_status_code); END;';
86:
87: WSH_UTIL_CORE.println('Calling Application specific API');
88: WSH_UTIL_CORE.println(l_procedure_name);
89: WSH_UTIL_CORE.println(' ');
90:
91: EXECUTE IMMEDIATE l_procedure_name

Line 88: WSH_UTIL_CORE.println(l_procedure_name);

84:
85: l_procedure_name := ' BEGIN ' || l_appl_short_name || '_ITM_PKG.WSH_ITM_' || l_appl_short_name || '(:p_request_control_id,:p_request_set_id,:p_status_code); END;';
86:
87: WSH_UTIL_CORE.println('Calling Application specific API');
88: WSH_UTIL_CORE.println(l_procedure_name);
89: WSH_UTIL_CORE.println(' ');
90:
91: EXECUTE IMMEDIATE l_procedure_name
92: USING p_request_control_id,

Line 89: WSH_UTIL_CORE.println(' ');

85: l_procedure_name := ' BEGIN ' || l_appl_short_name || '_ITM_PKG.WSH_ITM_' || l_appl_short_name || '(:p_request_control_id,:p_request_set_id,:p_status_code); END;';
86:
87: WSH_UTIL_CORE.println('Calling Application specific API');
88: WSH_UTIL_CORE.println(l_procedure_name);
89: WSH_UTIL_CORE.println(' ');
90:
91: EXECUTE IMMEDIATE l_procedure_name
92: USING p_request_control_id,
93: p_request_set_id,

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

93: p_request_set_id,
94: 'OVERRIDE';
95:
96:
97: WSH_UTIL_CORE.println('Out of the Application Specific Procedure');
98:
99: ELSE -- if request_set_id is not null
100:
101: WSH_UTIL_CORE.println('Request Set Id is not Null..');

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

97: WSH_UTIL_CORE.println('Out of the Application Specific Procedure');
98:
99: ELSE -- if request_set_id is not null
100:
101: WSH_UTIL_CORE.println('Request Set Id is not Null..');
102: WSH_UTIL_CORE.println('Request Set Id is :' || p_request_set_id);
103:
104: ----------------------------------------------------
105: -- All other requests with the same request_set_id

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

98:
99: ELSE -- if request_set_id is not null
100:
101: WSH_UTIL_CORE.println('Request Set Id is not Null..');
102: WSH_UTIL_CORE.println('Request Set Id is :' || p_request_set_id);
103:
104: ----------------------------------------------------
105: -- All other requests with the same request_set_id
106: -- must have process flag as 1 or 3. Only then call

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

113: IF Get_Process_Flag%NOTFOUND THEN
114:
115: l_procedure_name := 'BEGIN ' || l_appl_short_name || '_ITM_PKG.WSH_ITM_' || l_appl_short_name || '( :p_request_control_id, :p_request_set_id, :p_status_code); END;';
116:
117: WSH_UTIL_CORE.println('Calling Application specific API');
118: WSH_UTIL_CORE.println(l_procedure_name);
119: WSH_UTIL_CORE.println(' ');
120:
121:

Line 118: WSH_UTIL_CORE.println(l_procedure_name);

114:
115: l_procedure_name := 'BEGIN ' || l_appl_short_name || '_ITM_PKG.WSH_ITM_' || l_appl_short_name || '( :p_request_control_id, :p_request_set_id, :p_status_code); END;';
116:
117: WSH_UTIL_CORE.println('Calling Application specific API');
118: WSH_UTIL_CORE.println(l_procedure_name);
119: WSH_UTIL_CORE.println(' ');
120:
121:
122: EXECUTE IMMEDIATE l_procedure_name

Line 119: WSH_UTIL_CORE.println(' ');

115: l_procedure_name := 'BEGIN ' || l_appl_short_name || '_ITM_PKG.WSH_ITM_' || l_appl_short_name || '( :p_request_control_id, :p_request_set_id, :p_status_code); END;';
116:
117: WSH_UTIL_CORE.println('Calling Application specific API');
118: WSH_UTIL_CORE.println(l_procedure_name);
119: WSH_UTIL_CORE.println(' ');
120:
121:
122: EXECUTE IMMEDIATE l_procedure_name
123: USING p_request_control_id,

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

136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: l_error_code := SQLCODE;
138: l_error_text := SQLERRM;
139:
140: WSH_UTIL_CORE.PrintMsg('Failed in Procedure Call_Custom_API');
141: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
142:
143: END Call_Custom_API;
144:

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

137: l_error_code := SQLCODE;
138: l_error_text := SQLERRM;
139:
140: WSH_UTIL_CORE.PrintMsg('Failed in Procedure Call_Custom_API');
141: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
142:
143: END Call_Custom_API;
144:
145: -- Procedure Name

Line 175: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;

171: l_old_status VARCHAR2(30);
172: l_new_status VARCHAR2(30);
173: l_default_status VARCHAR2(100);
174: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
175: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
176: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
177:
178: l_logged_at_location_id number ;
179: l_exception_location_id number;

Line 176: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;

172: l_new_status VARCHAR2(30);
173: l_default_status VARCHAR2(100);
174: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
175: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
176: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
177:
178: l_logged_at_location_id number ;
179: l_exception_location_id number;
180: L_EXCEPTION_MESSAGE VARCHAR2(200);

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

200: l_msg_count :=NULL;
201: l_msg_data := NULL;
202: l_new_status := 'CLOSED';
203:
204: WSH_UTIL_CORE.println('Call to shipping to log close the previous exception and log a new skip exception');
205: WSH_UTIL_CORE.println('Request Control Id is'||p_request_control_id);
206:
207:
208:

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

201: l_msg_data := NULL;
202: l_new_status := 'CLOSED';
203:
204: WSH_UTIL_CORE.println('Call to shipping to log close the previous exception and log a new skip exception');
205: WSH_UTIL_CORE.println('Request Control Id is'||p_request_control_id);
206:
207:
208:
209: OPEN DELIVERY_SKIP(p_request_control_id);

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

210: LOOP
211: FETCH delivery_skip INTO
212: l_exception_name,l_exception_id,l_status,l_logged_at_location_id,l_exception_location_id,l_delivery_id,l_delivery_name;
213:
214: WSH_UTIL_CORE.println('The exception name is '||l_exception_name);
215: WSH_UTIL_CORE.println('The exception is is '||l_exception_id);
216:
217:
218: EXIT WHEN DELIVERY_SKIP%NOTFOUND;

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

211: FETCH delivery_skip INTO
212: l_exception_name,l_exception_id,l_status,l_logged_at_location_id,l_exception_location_id,l_delivery_id,l_delivery_name;
213:
214: WSH_UTIL_CORE.println('The exception name is '||l_exception_name);
215: WSH_UTIL_CORE.println('The exception is is '||l_exception_id);
216:
217:
218: EXIT WHEN DELIVERY_SKIP%NOTFOUND;
219:

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

267: p_delivery_id => l_delivery_id,
268: p_delivery_name => l_delivery_name
269: );
270:
271: WSH_UTIL_CORE.println('End of call to shipping ');
272:
273:
274: END LOOP;
275: CLOSE delivery_skip;

Line 411: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

407:
408: l_completion_status := 'NORMAL';
409: l_log_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
410:
411: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
412:
413: IF l_log_level IS NOT NULL THEN
414: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
415: END IF;

Line 414: WSH_UTIL_CORE.Set_Log_Level(l_log_level);

410:
411: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
412:
413: IF l_log_level IS NOT NULL THEN
414: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
415: END IF;
416:
417:
418: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Launch_Override ***');

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

414: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
415: END IF;
416:
417:
418: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Launch_Override ***');
419: WSH_UTIL_CORE.println(' ');
420:
421: ------------------------------------------
422: -- Print the values of all the parameters.

Line 419: WSH_UTIL_CORE.println(' ');

415: END IF;
416:
417:
418: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Launch_Override ***');
419: WSH_UTIL_CORE.println(' ');
420:
421: ------------------------------------------
422: -- Print the values of all the parameters.
423: ------------------------------------------

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

421: ------------------------------------------
422: -- Print the values of all the parameters.
423: ------------------------------------------
424:
425: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
426: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);

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

422: -- Print the values of all the parameters.
423: ------------------------------------------
424:
425: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
426: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);

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

423: ------------------------------------------
424:
425: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
426: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);

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

424:
425: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
426: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);

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

425: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
426: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
433: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);

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

426: WSH_UTIL_CORE.println('Override Type : ' || p_override_type);
427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
433: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
434: WSH_UTIL_CORE.println(' ');

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

427: WSH_UTIL_CORE.println('Reference Id : ' || p_reference_id);
428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
433: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
434: WSH_UTIL_CORE.println(' ');
435:

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

428: WSH_UTIL_CORE.println('Reference Line Id : ' || p_reference_line_id);
429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
433: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
434: WSH_UTIL_CORE.println(' ');
435:
436: --Issue a Savepoint

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

429: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
433: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
434: WSH_UTIL_CORE.println(' ');
435:
436: --Issue a Savepoint
437: SAVEPOINT WSH_ITM_OVERRIDE;

Line 434: WSH_UTIL_CORE.println(' ');

430: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
431: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
432: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
433: WSH_UTIL_CORE.println('Party ID : ' || p_party_id);
434: WSH_UTIL_CORE.println(' ');
435:
436: --Issue a Savepoint
437: SAVEPOINT WSH_ITM_OVERRIDE;
438: IF p_override_type = 'UNPROCESSED' OR

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

437: SAVEPOINT WSH_ITM_OVERRIDE;
438: IF p_override_type = 'UNPROCESSED' OR
439: p_override_type IS NULL THEN
440:
441: WSH_UTIL_CORE.println('Override type is UNPROCESSED');
442:
443: If p_vendor_id is NULL THEN
444: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');
445: if p_application_id=660 then

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

440:
441: WSH_UTIL_CORE.println('Override type is UNPROCESSED');
442:
443: If p_vendor_id is NULL THEN
444: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_1');
445: if p_application_id=660 then
446: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
447: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc ';
448:

Line 482: WSH_UTIL_CORE.println(l_sub_str);

478: IF i > length(l_sql_string) THEN
479: EXIT;
480: END IF;
481: l_sub_str := SUBSTR(l_sql_string, i , 80);
482: WSH_UTIL_CORE.println(l_sub_str);
483: i := i + 80;
484: END LOOP;
485:
486: l_CursorID := DBMS_SQL.Open_Cursor;

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

507: l_ignore := DBMS_SQL.Execute(l_CursorID);
508: --}
509: else
510: open Get_Unprocessed_Records_1_ship;
511: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');
512: if p_override_type= null and p_reference_id is not null then
513: WSH_UTIL_CORE.println('The delivery contains errored request ' );
514: l_flag := 1;
515: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);

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

509: else
510: open Get_Unprocessed_Records_1_ship;
511: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');
512: if p_override_type= null and p_reference_id is not null then
513: WSH_UTIL_CORE.println('The delivery contains errored request ' );
514: l_flag := 1;
515: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
516: end if;
517: end if;

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

511: WSH_UTIL_CORE.println('Start The processing for Shipping Records :');
512: if p_override_type= null and p_reference_id is not null then
513: WSH_UTIL_CORE.println('The delivery contains errored request ' );
514: l_flag := 1;
515: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
516: end if;
517: end if;
518: ELSE
519: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');

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

515: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
516: end if;
517: end if;
518: ELSE
519: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');
520: if p_application_id=660 then
521: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
522: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
523: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';

Line 565: WSH_UTIL_CORE.println(l_sub_str);

561: IF i > length(l_sql_string) THEN
562: EXIT;
563: END IF;
564: l_sub_str := SUBSTR(l_sql_string, i , 80);
565: WSH_UTIL_CORE.println(l_sub_str);
566: i := i + 80;
567: END LOOP;
568:
569: l_CursorID := DBMS_SQL.Open_Cursor;

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

610: END IF;
611: else
612:
613: EXIT WHEN l_flag=1;
614: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_flag);
615:
616: Fetch Get_Unprocessed_Records_1_ship into
617: l_request_control_id,
618: l_request_set_id;

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

615:
616: Fetch Get_Unprocessed_Records_1_ship into
617: l_request_control_id,
618: l_request_set_id;
619: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);
620: EXIT WHEN Get_Unprocessed_Records_1_ship%NOTFOUND;
621:
622: end if;
623: Else

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

637: EXIT WHEN Get_Unprocessed_Records_2_ship%NOTFOUND;
638: end if;
639:
640: End If;
641: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);
642:
643:
644: WSH_UTIL_CORE.println('Updating Process Flag');
645:

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

640: End If;
641: WSH_UTIL_CORE.println('Start Processing for Request Control :' || l_request_control_id);
642:
643:
644: WSH_UTIL_CORE.println('Updating Process Flag');
645:
646: update wsh_itm_request_control
647: SET process_flag = 3
648: WHERE request_control_id = l_request_control_id;

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

650: if p_application_id=665 then
651: Handle_Exception(l_request_control_id);
652: end if;
653: BEGIN
654: WSH_UTIL_CORE.println('Calling Procedure Call_Custom_API');
655: Call_Custom_API
656: (
657: p_request_control_id => l_request_control_id,
658: p_request_set_id => l_request_set_id,

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

659: p_appl_id => p_application_id,
660: x_return_status => l_return_status
661: );
662:
663: WSH_UTIL_CORE.println('After Call to Call_Custom_API');
664: WSH_UTIL_CORE.println('Return Status from Call_Custom_API:' || l_return_status);
665:
666: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
667: RAISE Call_Custom_API_Failed;

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

660: x_return_status => l_return_status
661: );
662:
663: WSH_UTIL_CORE.println('After Call to Call_Custom_API');
664: WSH_UTIL_CORE.println('Return Status from Call_Custom_API:' || l_return_status);
665:
666: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
667: RAISE Call_Custom_API_Failed;
668: END IF;

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

670:
671: EXCEPTION
672: WHEN Call_Custom_API_Failed THEN
673: ROLLBACK TO WSH_ITM_OVERRIDE;
674: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);
675:
676: END;
677:
678: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);

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

674: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);
675:
676: END;
677:
678: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);
679:
680: END LOOP;
681:
682: If p_vendor_id is NULL THEN

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

702: p_override_type = 'DATA' OR
703: p_override_type IS NULL THEN
704:
705:
706: WSH_UTIL_CORE.println('p_override_type is not unprocessed');
707: if p_application_id =660 THEN
708: -- {
709: -- Using Dynamic Cursor instead of static cursor for performance.
710: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';

Line 811: WSH_UTIL_CORE.println(l_sub_str);

807: IF i > length(l_sql_string) THEN
808: EXIT;
809: END IF;
810: l_sub_str := SUBSTR(l_sql_string, i , 80);
811: WSH_UTIL_CORE.println(l_sub_str);
812: i := i + 80;
813: END LOOP;
814:
815: l_CursorID := DBMS_SQL.Open_Cursor;

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

866: fetch Get_Request_Control_ship into l_request_control_id,l_request_set_id;
867: EXIT WHEN Get_Request_Control_ship%NOTFOUND;
868: END IF;
869:
870: WSH_UTIL_CORE.println('Start of Processing for Request Control : ' || l_request_control_id);
871:
872: ----------------------------------------------------------
873: -- Call the Response Analyser API
874: ----------------------------------------------------------

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

872: ----------------------------------------------------------
873: -- Call the Response Analyser API
874: ----------------------------------------------------------
875:
876: WSH_UTIL_CORE.println(' Calling the Response Analyser');
877:
878: WSH_ITM_RESPONSE_PKG.ONT_RESPONSE_ANALYSER
879: (
880: p_request_control_id => l_request_control_id,

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

883: x_return_status => l_return_status
884: );
885: IF l_interpreted_value = 'DATA' AND p_application_id =660 THEN
886: IF p_override_type ='SYSTEM' THEN
887: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
888: ELSE
889: WSH_UTIL_CORE.println('Cannot process data errors');
890: END IF;
891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

885: IF l_interpreted_value = 'DATA' AND p_application_id =660 THEN
886: IF p_override_type ='SYSTEM' THEN
887: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
888: ELSE
889: WSH_UTIL_CORE.println('Cannot process data errors');
890: END IF;
891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
892: RAISE Response_Analyser_Failed;
893: END IF;

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

893: END IF;
894:
895: ELSE
896:
897: WSH_UTIL_CORE.println('After Calling the Response Analyser');
898: WSH_UTIL_CORE.println(' ');
899:
900:
901: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);

Line 898: WSH_UTIL_CORE.println(' ');

894:
895: ELSE
896:
897: WSH_UTIL_CORE.println('After Calling the Response Analyser');
898: WSH_UTIL_CORE.println(' ');
899:
900:
901: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
902: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);

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

897: WSH_UTIL_CORE.println('After Calling the Response Analyser');
898: WSH_UTIL_CORE.println(' ');
899:
900:
901: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
902: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);
903: WSH_UTIL_CORE.println(' ');
904:
905: BEGIN

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

898: WSH_UTIL_CORE.println(' ');
899:
900:
901: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
902: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);
903: WSH_UTIL_CORE.println(' ');
904:
905: BEGIN
906:

Line 903: WSH_UTIL_CORE.println(' ');

899:
900:
901: WSH_UTIL_CORE.println('Response from Response analyser: ' || l_interpreted_value);
902: WSH_UTIL_CORE.println('Return Status from Response analyser :' || l_return_status);
903: WSH_UTIL_CORE.println(' ');
904:
905: BEGIN
906:
907: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

911: IF l_interpreted_value = p_override_type OR
912: p_override_type IS NULL THEN
913:
914:
915: WSH_UTIL_CORE.println('Updating process_flag to 3');
916:
917: UPDATE wsh_itm_request_control
918: SET process_flag = 3
919: WHERE request_control_id = l_request_control_id;

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

928: p_appl_id => p_application_id,
929: x_return_status => l_return_status
930: );
931:
932: WSH_UTIL_CORE.println('AFter Call_Custom_API');
933:
934: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
935: RAISE Call_Custom_API_Failed;
936: END IF;

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

936: END IF;
937:
938: END IF;
939:
940: WSH_UTIL_CORE.println('Finished Processing for Request Control :' || l_request_control_id);
941: commit;
942: ELSE
943: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
944: END IF;

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

939:
940: WSH_UTIL_CORE.println('Finished Processing for Request Control :' || l_request_control_id);
941: commit;
942: ELSE
943: WSH_UTIL_CORE.println('Response from Response analyser is different from the override parameter entered by user.. ignoring this and processing next record');
944: END IF;
945:
946: EXCEPTION
947: WHEN Response_Analyser_Failed THEN

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

945:
946: EXCEPTION
947: WHEN Response_Analyser_Failed THEN
948: ROLLBACK TO WSH_ITM_OVERRIDE;
949: WSH_UTIL_CORE.println('Processing failed in Response Analyser');
950:
951: WHEN Call_Custom_API_Failed THEN
952: ROLLBACK TO WSH_ITM_OVERRIDE;
953: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);

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

949: WSH_UTIL_CORE.println('Processing failed in Response Analyser');
950:
951: WHEN Call_Custom_API_Failed THEN
952: ROLLBACK TO WSH_ITM_OVERRIDE;
953: WSH_UTIL_CORE.println('Failed in Call_Custom_API for request control:' || l_request_control_id);
954:
955: END;
956: END IF ;
957: END LOOP;

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

963: close Get_Request_Control_ship;
964: END IF;
965: END IF;
966:
967: WSH_UTIL_CORE.println('The Processing - Completed..');
968: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
969:
970:
971: EXCEPTION

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

976: ROLLBACK TO WSH_ITM_OVERRIDE;
977: l_completion_status := 'ERROR';
978: l_error_code := SQLCODE;
979: l_error_text := SQLERRM;
980: WSH_UTIL_CORE.PrintMsg('Failed in Procedure ITM_Launch_Override');
981: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
982: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
983:
984:

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

977: l_completion_status := 'ERROR';
978: l_error_code := SQLCODE;
979: l_error_text := SQLERRM;
980: WSH_UTIL_CORE.PrintMsg('Failed in Procedure ITM_Launch_Override');
981: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
982: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
983:
984:
985: END ITM_Launch_Override;