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.XNB_ITEM_BATCH_PVT dependencies on XNB_DEBUG

Line 107: xnb_debug.log('gen_item_batch_file','Constructing the l_sql');

103: --Construct the SQL for the REF CURSOR based on the parameters passed
104: --Append additional WHERE clauses to the SQL using the parameters passed
105: l_rec_count := 0;
106: --debug
107: xnb_debug.log('gen_item_batch_file','Constructing the l_sql');
108:
109: l_sql_string := 'SELECT inventory_item_id, '||
110: 'item_name, '||
111: 'bom_item_type, '||

Line 141: xnb_debug.log('gen_item_batch_file','Before construct_sql function '||p_from_date);

137: 'FROM xnb_itemmst_cats_v '||
138: 'WHERE organization_id = ''' || p_org_id || '''';
139:
140: --debug
141: xnb_debug.log('gen_item_batch_file','Before construct_sql function '||p_from_date);
142:
143: construct_sql( l_sql_string, p_cat_set_id, p_cat_id, p_from_date);
144: --debug
145: xnb_debug.log('gen_item_batch_file','After construct_sql function returns');

Line 145: xnb_debug.log('gen_item_batch_file','After construct_sql function returns');

141: xnb_debug.log('gen_item_batch_file','Before construct_sql function '||p_from_date);
142:
143: construct_sql( l_sql_string, p_cat_set_id, p_cat_id, p_from_date);
144: --debug
145: xnb_debug.log('gen_item_batch_file','After construct_sql function returns');
146:
147: --The location of the Output File is set in the profile.
148: fnd_profile.get('XNB_ITEM_FILE_LOCATION', l_output_loc);
149: --debug

Line 150: xnb_debug.log('gen_item_batch_file','After getting File Location'||l_output_loc);

146:
147: --The location of the Output File is set in the profile.
148: fnd_profile.get('XNB_ITEM_FILE_LOCATION', l_output_loc);
149: --debug
150: xnb_debug.log('gen_item_batch_file','After getting File Location'||l_output_loc);
151:
152: IF l_output_loc is null then
153: RETURN -2;
154: END IF;

Line 168: xnb_debug.log('gen_item_batch_file','Inside IF output_format is CSV');

164: l_out_file_name := 'XNB_ITEMS_BATCH_'||p_bill_app_code||'_'|| to_char(sysdate,'DDMMYYYY_HH24MISS');
165:
166: IF (p_output_format = 'CSV') THEN --CSV
167: --debug
168: xnb_debug.log('gen_item_batch_file','Inside IF output_format is CSV');
169:
170: l_out_file_name := l_out_file_name || '.csv';
171:
172: l_handle := UTL_FILE.FOPEN( l_output_loc, l_out_file_name, 'W');

Line 175: xnb_debug.log('gen_item_batch_file','After opening the file'||l_output_loc);

171:
172: l_handle := UTL_FILE.FOPEN( l_output_loc, l_out_file_name, 'W');
173:
174: --debug
175: xnb_debug.log('gen_item_batch_file','After opening the file'||l_output_loc);
176:
177: --Date:19-Apr-05 Author: DPUTHIYE Bug:4314879
178: --Change: Removing spaces after commas in the CSV header. CSV files are machine read.
179: --Other files impacted: None.

Line 185: xnb_debug.log('gen_item_batch_file','After writing the first Line');

181: UTL_FILE.PUTF(l_handle,'ITEM_STATUS,ITEM_STATUS_DESC,ITEM_TYPE,ITEM_TYPE_DESC,ITEM_CLASS,START_DATE,END_DATE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,');
182: UTL_FILE.PUTF(l_handle,'ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15\n');
183:
184: --debug
185: xnb_debug.log('gen_item_batch_file','After writing the first Line');
186:
187: ----------------------------------------------------------------------------------------------
188: --Retrieve the items to be exported. Iterate through the row set.
189: --

Line 195: xnb_debug.log('gen_item_batch_file','Inside Cursor');

191:
192: OPEN l_items_cur_R FOR l_sql_string;
193:
194: --debug
195: xnb_debug.log('gen_item_batch_file','Inside Cursor');
196: FETCH l_items_cur_R INTO l_item_rec;
197:
198: l_rec_count := 0;
199: WHILE (l_items_cur_R%FOUND) LOOP

Line 215: xnb_debug.log('gen_item_batch_file','Checking for Doc status'||l_item_rec.item_id);

211: p_collab_type => 'XNB_ITEM',
212: p_tp_loc_code => p_bill_app_code);
213:
214: --debug
215: xnb_debug.log('gen_item_batch_file','Checking for Doc status'||l_item_rec.item_id);
216: -- The item has not been successfully published. Set indicator 'I' - Insert.
217:
218: IF (l_cln_stat = 0 ) then
219: l_indicator := 'I';

Line 235: xnb_debug.log('gen_item_batch_file','Assigning the Item Id to Global Array');

231: ----------------------------------------------------------------------------------------------
232: l_item_id(l_rec_count) := l_item_rec.item_id;
233:
234: --debug
235: xnb_debug.log('gen_item_batch_file','Assigning the Item Id to Global Array');
236: ----------------------------------------------------------------------------------------------
237: --Write current item record with the Indicator to the export file
238: --A comma separated row of values will be written to the CSV file
239: ----------------------------------------------------------------------------------------------

Line 253: xnb_debug.log('gen_item_batch_file','After writing it into the File');

249: UTL_FILE.PUTF(l_handle, '%s,%s,%s,%s,%s,', l_item_rec.attribute6, l_item_rec.attribute7, l_item_rec.attribute8, l_item_rec.attribute9, l_item_rec.attribute10);
250: UTL_FILE.PUTF(l_handle, '%s,%s,%s,%s,%s\n', l_item_rec.attribute11, l_item_rec.attribute12, l_item_rec.attribute13, l_item_rec.attribute14, l_item_rec.attribute15);
251:
252: --debug
253: xnb_debug.log('gen_item_batch_file','After writing it into the File');
254:
255: --Next record
256: FETCH l_items_cur_R INTO l_item_rec;
257:

Line 262: xnb_debug.log('gen_item_batch_file','End of Cursor');

258: --End of while Loop for Cursor
259: END LOOP;
260:
261: --debug
262: xnb_debug.log('gen_item_batch_file','End of Cursor');
263:
264: UTL_FILE.PUTF(l_handle,'##ENDOFBATCH: %s Records##', l_rec_count);
265: CLOSE l_items_cur_R;
266: --debug

Line 267: xnb_debug.log('gen_item_batch_file','Cusor closed');

263:
264: UTL_FILE.PUTF(l_handle,'##ENDOFBATCH: %s Records##', l_rec_count);
265: CLOSE l_items_cur_R;
266: --debug
267: xnb_debug.log('gen_item_batch_file','Cusor closed');
268:
269: ELSIF (p_output_format = 'XML') THEN --XML
270:
271: l_out_file_name := l_out_file_name || '.xml';

Line 288: xnb_debug.log('gen_item_batch_file','After Opening the Cursor in XML Batch');

284: ----------------------------------------------------------------------------------------------
285:
286: OPEN l_items_cur_R FOR l_sql_string;
287: --debug
288: xnb_debug.log('gen_item_batch_file','After Opening the Cursor in XML Batch');
289:
290: FETCH l_items_cur_R INTO l_item_rec;
291:
292: --debug

Line 293: xnb_debug.log('gen_item_batch_file','After Fetching the Cursor in XML Batch');

289:
290: FETCH l_items_cur_R INTO l_item_rec;
291:
292: --debug
293: xnb_debug.log('gen_item_batch_file','After Fetching the Cursor in XML Batch');
294:
295: l_rec_count := 0;
296: WHILE (l_items_cur_R%FOUND) LOOP
297:

Line 363: xnb_debug.log('gen_item_batch_file','File Handler Closed');

359: /* End of IF p_output_format = 'CSV'*/
360: END IF;
361:
362: --debug
363: xnb_debug.log('gen_item_batch_file','File Handler Closed');
364: UTL_FILE.FCLOSE(l_handle);
365:
366:
367:

Line 370: xnb_debug.log('gen_item_batch_file','Record Count Returned '||l_rec_count);

366:
367:
368: --Return the count of records to the caller.
369: --debug
370: xnb_debug.log('gen_item_batch_file','Record Count Returned '||l_rec_count);
371:
372: RETURN l_rec_count;
373:
374: EXCEPTION

Line 467: xnb_debug.log('create_cln_items','Begining Value of i_ '|| i);

463:
464: END;
465:
466: --debug
467: xnb_debug.log('create_cln_items','Begining Value of i_ '|| i);
468:
469:
470: wf_event.AddParameterToList (
471: p_name =>'DOCUMENT_NO',

Line 516: xnb_debug.log('create_cln_items','Collaboration created for Doc no '|| l_item_id(i));

512: p_event_key => l_key_create,
513: p_parameters => l_parameter_list_create);
514: commit;
515: --debug
516: xnb_debug.log('create_cln_items','Collaboration created for Doc no '|| l_item_id(i));
517:
518: -----------------------------------------------------------------------------------------
519: --Update the collaboration for all items and make the status to be success
520: --for the trading partner.

Line 526: xnb_debug.log('create_cln_items','After creating the key for update');

522:
523: l_key_update := 'XNB'||'COLL_UPDATE_'||i||'_'||to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
524:
525: --debug
526: xnb_debug.log('create_cln_items','After creating the key for update');
527:
528:
529:
530: wf_event.addparametertolist (

Line 536: xnb_debug.log('create_cln_items','Document Status update done');

532: p_value => 'SUCCESS',
533: p_parameterlist => l_parameter_list_update
534: );
535: --debug
536: xnb_debug.log('create_cln_items','Document Status update done');
537:
538: wf_event.addparametertolist (
539: p_name =>'ORIGINATOR_REFERENCE',
540: p_value => p_bill_app_code,

Line 544: xnb_debug.log('create_cln_items','Orig Reference update done');

540: p_value => p_bill_app_code,
541: p_parameterlist => l_parameter_list_update
542: );
543: --debug
544: xnb_debug.log('create_cln_items','Orig Reference update done');
545: xnb_debug.log('create_cln_items','Reference Id Passed is '||l_key_create);
546:
547: wf_event.addparametertolist (
548: p_name =>'REFERENCE_ID',

Line 545: xnb_debug.log('create_cln_items','Reference Id Passed is '||l_key_create);

541: p_parameterlist => l_parameter_list_update
542: );
543: --debug
544: xnb_debug.log('create_cln_items','Orig Reference update done');
545: xnb_debug.log('create_cln_items','Reference Id Passed is '||l_key_create);
546:
547: wf_event.addparametertolist (
548: p_name =>'REFERENCE_ID',
549: p_value => l_key_create,

Line 554: xnb_debug.log('create_cln_items','Reference Id update done');

550: p_parameterlist => l_parameter_list_update
551: );
552:
553: --debug
554: xnb_debug.log('create_cln_items','Reference Id update done');
555:
556: wf_event.addparametertolist (
557: p_name =>'MESSAGE_TEXT',
558: p_value => 'XNB_CLN_MSG_ACCEPTED',

Line 562: xnb_debug.log('create_cln_items','Message Text update done');

558: p_value => 'XNB_CLN_MSG_ACCEPTED',
559: p_parameterlist => l_parameter_list_update
560: );
561: --debug
562: xnb_debug.log('create_cln_items','Message Text update done');
563:
564:
565: wf_event.AddParameterToList (
566: p_name =>'XMLG_TRANSACTION_TYPE',

Line 571: xnb_debug.log('create_cln_items','Transaction Type update done');

567: p_value => g_cln_ext_txn_type,
568: p_parameterlist => l_parameter_list_update);
569:
570: --debug
571: xnb_debug.log('create_cln_items','Transaction Type update done');
572:
573: wf_event.AddParameterToList (
574: p_name =>'XMLG_TRANSACTION_SUBTYPE',
575: p_value =>g_cln_ext_txn_subtype,

Line 579: xnb_debug.log('create_cln_items','Transaction SubType update done');

575: p_value =>g_cln_ext_txn_subtype,
576: p_parameterlist => l_parameter_list_update);
577:
578: --debug
579: xnb_debug.log('create_cln_items','Transaction SubType update done');
580:
581: wf_event.AddParameterToList (
582: p_name =>'DOCUMENT_DIRECTION',
583: p_value => 'IN',

Line 586: xnb_debug.log('create_cln_items','After Setting all parameters');

582: p_name =>'DOCUMENT_DIRECTION',
583: p_value => 'IN',
584: p_parameterlist => l_parameter_list_update);
585: --debug
586: xnb_debug.log('create_cln_items','After Setting all parameters');
587:
588:
589: wf_event.raise ( p_event_name => 'oracle.apps.cln.ch.collaboration.update',
590: p_event_key => l_key_update,

Line 594: xnb_debug.log('create_cln_items','Collaboration Updated for Doc no '|| l_item_id(i));

590: p_event_key => l_key_update,
591: p_parameters => l_parameter_list_update);
592:
593: --debug
594: xnb_debug.log('create_cln_items','Collaboration Updated for Doc no '|| l_item_id(i));
595:
596:
597: commit;
598:

Line 606: -- xnb_debug.log('create_cln_items','Item Id when Exception Occured_ '|| l_item_id(i));

602: EXCEPTION
603:
604: WHEN OTHERS THEN
605: --debug
606: -- xnb_debug.log('create_cln_items','Item Id when Exception Occured_ '|| l_item_id(i));
607: -- xnb_debug.log('create_cln_items','Value of i when Exception Occured_ '|| i);
608: cln_result := -2;
609:
610: END create_cln_items;

Line 607: -- xnb_debug.log('create_cln_items','Value of i when Exception Occured_ '|| i);

603:
604: WHEN OTHERS THEN
605: --debug
606: -- xnb_debug.log('create_cln_items','Item Id when Exception Occured_ '|| l_item_id(i));
607: -- xnb_debug.log('create_cln_items','Value of i when Exception Occured_ '|| i);
608: cln_result := -2;
609:
610: END create_cln_items;
611:

Line 747: xnb_debug.log('publish_item_xml',' Event raised for item'||p_item_id);

743: p_value => p_org_id ,
744: p_parameterlist => l_wf_parameter_list);
745:
746: --debug
747: xnb_debug.log('publish_item_xml',' Event raised for item'||p_item_id);
748:
749: wf_event.raise (
750: p_event_name => 'oracle.apps.xnb.item.create',
751: p_event_key => l_wf_key,

Line 856: xnb_debug.log('publish_item','Value of Message Type '||l_msg_type);

852:
853: fnd_profile.get('XNB_MSG_TYPE',l_msg_type);
854:
855: --debug
856: xnb_debug.log('publish_item','Value of Message Type '||l_msg_type);
857:
858: -----------------------------------------------------------------------
859: -- If the Profile value is CSV generate the Batch File
860: --

Line 907: xnb_debug.log('publish_item',' Before CLN Items Creation');

903: --Create new collaboration for all items and update the status to be success
904: --for the trading partner.
905: -----------------------------------------------------------------------------------------
906: --debug
907: xnb_debug.log('publish_item',' Before CLN Items Creation');
908:
909: FOR i IN 1..l_rec_cnt LOOP
910: create_cln_items (p_bill_app_code, i, cln_result);
911:

Line 930: xnb_debug.log('publish_item',' Collaboration Successfully Created');

926: --END of FOR LOOP
927: END LOOP;
928:
929: --debug
930: xnb_debug.log('publish_item',' Collaboration Successfully Created');
931:
932:
933: ELSIF l_msg_type = 'XML_BATCH' THEN
934:

Line 983: xnb_debug.log('publish_item',' Collaboration Successfully Created for XML');

979: --END of FOR LOOP
980: END LOOP;
981:
982: --debug
983: xnb_debug.log('publish_item',' Collaboration Successfully Created for XML');
984:
985:
986: ELSIF l_msg_type = 'XML_PUBLISH' THEN
987:

Line 993: xnb_debug.log('publish_item',' Inside Else If-'||p_from_date);

989: --If the Profile value is XML invoke the workflow by raising event to
990: --generate the XML file
991: -----------------------------------------------------------------------------------------
992: --debug
993: xnb_debug.log('publish_item',' Inside Else If-'||p_from_date);
994:
995: OPEN l_ItemCur_R for l_sql_string;
996: FETCH l_ItemCur_R INTO l_item_info;
997:

Line 999: xnb_debug.log('publish_item',' After Opening the Cursor');

995: OPEN l_ItemCur_R for l_sql_string;
996: FETCH l_ItemCur_R INTO l_item_info;
997:
998: --debug
999: xnb_debug.log('publish_item',' After Opening the Cursor');
1000:
1001:
1002: WHILE (l_ItemCur_R%FOUND) LOOP
1003:

Line 1005: xnb_debug.log('publish_item',' Calling publsih_item_xml for item '||l_item_info.item_id);

1001:
1002: WHILE (l_ItemCur_R%FOUND) LOOP
1003:
1004: --debug
1005: xnb_debug.log('publish_item',' Calling publsih_item_xml for item '||l_item_info.item_id);
1006:
1007:
1008: l_rec_cnt := l_rec_cnt + 1;
1009: publish_item_xml(p_item_id => l_item_info.item_id,

Line 1036: xnb_debug.log('publish_item',' Before End of PROC');

1032: --Return Success
1033: -------------------------------------------------------------------
1034:
1035: --debug
1036: xnb_debug.log('publish_item',' Before End of PROC');
1037:
1038:
1039:
1040: END IF;