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.CSD_DEPOT_REPAIR_CNTR dependencies on CSD_GEN_UTILITY_PVT

Line 10: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

6: -- ---------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_DEPOT_REPAIR_CNTR';
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'csddrclb.pls';
10: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
11: -------------------------------------------
12: -- Get txn billing type
13: -------------------------------------------
14: PROCEDURE get_txn_billing_type

Line 64: csd_gen_utility_pvt.add('Could not find the split_from_line_id for line_id ='||TO_CHAR(p_line_id));

60: x_txn_billing_type_id := -1;
61: x_repair_number := '';
62: x_repair_line_id := -1;
63: IF (g_debug > 0 ) THEN
64: csd_gen_utility_pvt.add('Could not find the split_from_line_id for line_id ='||TO_CHAR(p_line_id));
65: END IF;
66:
67: l_quit_flag := TRUE;
68: END;

Line 72: csd_gen_utility_pvt.add('Found more than one row in cs_estimate_details for line_id ='||TO_CHAR(p_line_id));

68: END;
69:
70: WHEN OTHERS THEN
71: IF (g_debug > 0 ) THEN
72: csd_gen_utility_pvt.add('Found more than one row in cs_estimate_details for line_id ='||TO_CHAR(p_line_id));
73: END IF;
74:
75: l_quit_flag := TRUE;
76: END;

Line 104: csd_gen_utility_pvt.add('no_data_found error for unit_of_measure ='||p_from_uom);

100: where unit_of_measure = p_from_uom;
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: IF (g_debug > 0 ) THEN
104: csd_gen_utility_pvt.add('no_data_found error for unit_of_measure ='||p_from_uom);
105: END IF;
106:
107: WHEN OTHERS THEN
108: IF (g_debug > 0 ) THEN

Line 109: csd_gen_utility_pvt.add('More than one row found for unit_of_measure ='||p_from_uom);

105: END IF;
106:
107: WHEN OTHERS THEN
108: IF (g_debug > 0 ) THEN
109: csd_gen_utility_pvt.add('More than one row found for unit_of_measure ='||p_from_uom);
110: END IF;
111:
112: End;
113:

Line 123: csd_gen_utility_pvt.add('no_data_found error(primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));

119: and inventory_item_id = p_item_id;
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: IF (g_debug > 0 ) THEN
123: csd_gen_utility_pvt.add('no_data_found error(primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));
124: END IF;
125:
126: WHEN OTHERS THEN
127: IF (g_debug > 0 ) THEN

Line 128: csd_gen_utility_pvt.add('More than one row found(Primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));

124: END IF;
125:
126: WHEN OTHERS THEN
127: IF (g_debug > 0 ) THEN
128: csd_gen_utility_pvt.add('More than one row found(Primary UOM) for inventory_item_id ='||TO_CHAR(p_item_id));
129: END IF;
130:
131: End;
132:

Line 140: csd_gen_utility_pvt.add('inv_convert returned with error message');

136: p_from_quantity,p_from_uom_code,v_primary_uom_code,null,null);
137: EXCEPTION
138: WHEN OTHERS THEN
139: IF (g_debug > 0 ) THEN
140: csd_gen_utility_pvt.add('inv_convert returned with error message');
141: END IF;
142:
143: END;
144:

Line 262: csd_gen_utility_pvt.add('At the Begin of Depot RMA receipt update');

258: Begin
259:
260: v_total_records := 0;
261: IF (g_debug > 0 ) THEN
262: csd_gen_utility_pvt.add('At the Begin of Depot RMA receipt update');
263: END IF;
264:
265:
266: For I in rma_receipt_lines( p_repair_line_id )

Line 277: csd_gen_utility_pvt.add('----------------------------------------------' );

273: l_repair_line_id := NULL ;
274: l_txn_billing_type_id := NULL;
275:
276: IF (g_debug > 0 ) THEN
277: csd_gen_utility_pvt.add('----------------------------------------------' );
278: csd_gen_utility_pvt.add('Rma Number ='||I.rma_number );
279: END IF;
280: -- travi comment to concurrent log
281: fnd_file.put_line(fnd_file.log, 'Selecting RMA Number : '||I.rma_number );

Line 278: csd_gen_utility_pvt.add('Rma Number ='||I.rma_number );

274: l_txn_billing_type_id := NULL;
275:
276: IF (g_debug > 0 ) THEN
277: csd_gen_utility_pvt.add('----------------------------------------------' );
278: csd_gen_utility_pvt.add('Rma Number ='||I.rma_number );
279: END IF;
280: -- travi comment to concurrent log
281: fnd_file.put_line(fnd_file.log, 'Selecting RMA Number : '||I.rma_number );
282:

Line 284: csd_gen_utility_pvt.add('Rma Header Id ='||TO_CHAR(I.rma_header_id) );

280: -- travi comment to concurrent log
281: fnd_file.put_line(fnd_file.log, 'Selecting RMA Number : '||I.rma_number );
282:
283: IF (g_debug > 0 ) THEN
284: csd_gen_utility_pvt.add('Rma Header Id ='||TO_CHAR(I.rma_header_id) );
285: csd_gen_utility_pvt.add('Rma Line Id ='||TO_CHAR(I.Line_id ));
286: csd_gen_utility_pvt.add('Split from Line Id ='||TO_CHAR(I.split_from_line_id));
287: END IF;
288:

Line 285: csd_gen_utility_pvt.add('Rma Line Id ='||TO_CHAR(I.Line_id ));

281: fnd_file.put_line(fnd_file.log, 'Selecting RMA Number : '||I.rma_number );
282:
283: IF (g_debug > 0 ) THEN
284: csd_gen_utility_pvt.add('Rma Header Id ='||TO_CHAR(I.rma_header_id) );
285: csd_gen_utility_pvt.add('Rma Line Id ='||TO_CHAR(I.Line_id ));
286: csd_gen_utility_pvt.add('Split from Line Id ='||TO_CHAR(I.split_from_line_id));
287: END IF;
288:
289:

Line 286: csd_gen_utility_pvt.add('Split from Line Id ='||TO_CHAR(I.split_from_line_id));

282:
283: IF (g_debug > 0 ) THEN
284: csd_gen_utility_pvt.add('Rma Header Id ='||TO_CHAR(I.rma_header_id) );
285: csd_gen_utility_pvt.add('Rma Line Id ='||TO_CHAR(I.Line_id ));
286: csd_gen_utility_pvt.add('Split from Line Id ='||TO_CHAR(I.split_from_line_id));
287: END IF;
288:
289:
290: get_txn_billing_type

Line 299: csd_gen_utility_pvt.add('l_txn_billing_type_id='||TO_CHAR(l_txn_billing_type_id));

295: x_txn_billing_type_id => l_txn_billing_type_id,
296: x_quantity => l_quantity);
297:
298: IF (g_debug > 0 ) THEN
299: csd_gen_utility_pvt.add('l_txn_billing_type_id='||TO_CHAR(l_txn_billing_type_id));
300: csd_gen_utility_pvt.add('l_repair_number='||l_repair_number);
301: csd_gen_utility_pvt.add('l_repair_line_id='||TO_CHAR(l_repair_line_id));
302: END IF;
303:

Line 300: csd_gen_utility_pvt.add('l_repair_number='||l_repair_number);

296: x_quantity => l_quantity);
297:
298: IF (g_debug > 0 ) THEN
299: csd_gen_utility_pvt.add('l_txn_billing_type_id='||TO_CHAR(l_txn_billing_type_id));
300: csd_gen_utility_pvt.add('l_repair_number='||l_repair_number);
301: csd_gen_utility_pvt.add('l_repair_line_id='||TO_CHAR(l_repair_line_id));
302: END IF;
303:
304:

Line 301: csd_gen_utility_pvt.add('l_repair_line_id='||TO_CHAR(l_repair_line_id));

297:
298: IF (g_debug > 0 ) THEN
299: csd_gen_utility_pvt.add('l_txn_billing_type_id='||TO_CHAR(l_txn_billing_type_id));
300: csd_gen_utility_pvt.add('l_repair_number='||l_repair_number);
301: csd_gen_utility_pvt.add('l_repair_line_id='||TO_CHAR(l_repair_line_id));
302: END IF;
303:
304:
305:

Line 316: csd_gen_utility_pvt.add('No Row found for the txn_billing_type_id='||TO_CHAR(l_txn_billing_type_id));

312: When no_data_found then
313: v_transaction_type_id := null;
314: v_skip_record := true;
315: IF (g_debug > 0 ) THEN
316: csd_gen_utility_pvt.add('No Row found for the txn_billing_type_id='||TO_CHAR(l_txn_billing_type_id));
317: END IF;
318:
319: when others then
320: IF (g_debug > 0 ) THEN

Line 321: csd_gen_utility_pvt.add('When others exception at - Transaction type id');

317: END IF;
318:
319: when others then
320: IF (g_debug > 0 ) THEN
321: csd_gen_utility_pvt.add('When others exception at - Transaction type id');
322: END IF;
323:
324: End;
325:

Line 337: csd_gen_utility_pvt.add('No row found for the transaction_type_id ='||TO_CHAR(v_transaction_type_id));

333: Exception
334: when no_Data_found then
335: V_skip_record := true;
336: IF (g_debug > 0 ) THEN
337: csd_gen_utility_pvt.add('No row found for the transaction_type_id ='||TO_CHAR(v_transaction_type_id));
338: END IF;
339:
340: End;
341: End if;

Line 356: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : repair_line_id '||to_char(l_repair_line_id));

352:
353: BEGIN
354:
355: IF (g_debug > 0 ) THEN
356: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : repair_line_id '||to_char(l_repair_line_id));
357: END IF;
358:
359:
360: if (l_quantity = 1) then

Line 362: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : qty '||to_char(l_quantity));

358:
359:
360: if (l_quantity = 1) then
361: IF (g_debug > 0 ) THEN
362: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : qty '||to_char(l_quantity));
363: END IF;
364:
365:
366: open c_prd_txn_serial_num ( l_repair_line_id );

Line 373: csd_gen_utility_pvt.add('pt_serial_num '||l_dr_serial_num);

369:
370: if (c_prd_txn_serial_num%FOUND) then
371:
372: IF (g_debug > 0 ) THEN
373: csd_gen_utility_pvt.add('pt_serial_num '||l_dr_serial_num);
374: csd_gen_utility_pvt.add('pt_Item_id '||to_char(l_dr_item_id));
375: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : pt_serial_num '||l_pt_serial_num||' dr_serial_num '||l_dr_serial_num);
376: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_item_id : pt_item_id '||to_char(l_pt_item_id)||' dr_item_id '||to_char(l_dr_item_id));
377: END IF;

Line 374: csd_gen_utility_pvt.add('pt_Item_id '||to_char(l_dr_item_id));

370: if (c_prd_txn_serial_num%FOUND) then
371:
372: IF (g_debug > 0 ) THEN
373: csd_gen_utility_pvt.add('pt_serial_num '||l_dr_serial_num);
374: csd_gen_utility_pvt.add('pt_Item_id '||to_char(l_dr_item_id));
375: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : pt_serial_num '||l_pt_serial_num||' dr_serial_num '||l_dr_serial_num);
376: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_item_id : pt_item_id '||to_char(l_pt_item_id)||' dr_item_id '||to_char(l_dr_item_id));
377: END IF;
378:

Line 375: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : pt_serial_num '||l_pt_serial_num||' dr_serial_num '||l_dr_serial_num);

371:
372: IF (g_debug > 0 ) THEN
373: csd_gen_utility_pvt.add('pt_serial_num '||l_dr_serial_num);
374: csd_gen_utility_pvt.add('pt_Item_id '||to_char(l_dr_item_id));
375: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : pt_serial_num '||l_pt_serial_num||' dr_serial_num '||l_dr_serial_num);
376: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_item_id : pt_item_id '||to_char(l_pt_item_id)||' dr_item_id '||to_char(l_dr_item_id));
377: END IF;
378:
379:

Line 376: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_item_id : pt_item_id '||to_char(l_pt_item_id)||' dr_item_id '||to_char(l_dr_item_id));

372: IF (g_debug > 0 ) THEN
373: csd_gen_utility_pvt.add('pt_serial_num '||l_dr_serial_num);
374: csd_gen_utility_pvt.add('pt_Item_id '||to_char(l_dr_item_id));
375: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_serial_num : pt_serial_num '||l_pt_serial_num||' dr_serial_num '||l_dr_serial_num);
376: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - prd_txn_item_id : pt_item_id '||to_char(l_pt_item_id)||' dr_item_id '||to_char(l_dr_item_id));
377: END IF;
378:
379:
380: if (l_pt_item_id <> l_dr_item_id) then

Line 383: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - l_pt_item_id <> l_dr_item_id ');

379:
380: if (l_pt_item_id <> l_dr_item_id) then
381:
382: IF (g_debug > 0 ) THEN
383: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - l_pt_item_id <> l_dr_item_id ');
384: END IF;
385:
386: l_pt_serial_num := l_dr_serial_num;
387:

Line 391: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - transaction_id '||to_char(i.transaction_id));

387:
388: end if;
389:
390: IF (g_debug > 0 ) THEN
391: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - transaction_id '||to_char(i.transaction_id));
392: END IF;
393:
394:
395: open c_rcv_slnum_txn ( i.transaction_id );

Line 400: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - parent_transaction_id '||to_char(l_sl_txn_id));

396:
397: fetch c_rcv_slnum_txn into l_sl_txn_id;
398:
399: IF (g_debug > 0 ) THEN
400: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - parent_transaction_id '||to_char(l_sl_txn_id));
401: END IF;
402:
403:
404: if (l_sl_txn_id is not null) then

Line 411: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - rcv_txn_serial_num'||l_st_serial_num);

407: fetch c_rcv_txn_serial_num into l_st_serial_num;
408:
409: if (c_rcv_txn_serial_num%FOUND) then
410: IF (g_debug > 0 ) THEN
411: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - rcv_txn_serial_num'||l_st_serial_num);
412: END IF;
413:
414:
415: IF (g_debug > 0 ) THEN

Line 416: csd_gen_utility_pvt.add('l_st_serial_num '||l_st_serial_num);

412: END IF;
413:
414:
415: IF (g_debug > 0 ) THEN
416: csd_gen_utility_pvt.add('l_st_serial_num '||l_st_serial_num);
417: csd_gen_utility_pvt.add('l_pt_serial_num '||l_pt_serial_num);
418: END IF;
419:
420:

Line 417: csd_gen_utility_pvt.add('l_pt_serial_num '||l_pt_serial_num);

413:
414:
415: IF (g_debug > 0 ) THEN
416: csd_gen_utility_pvt.add('l_st_serial_num '||l_st_serial_num);
417: csd_gen_utility_pvt.add('l_pt_serial_num '||l_pt_serial_num);
418: END IF;
419:
420:
421:

Line 424: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - l_pt_serial_num <> l_st_serial_num ');

420:
421:
422: if(l_pt_serial_num <> l_st_serial_num) then
423: IF (g_debug > 0 ) THEN
424: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - l_pt_serial_num <> l_st_serial_num ');
425: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for RSC event');
426: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');
427: END IF;
428:

Line 425: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for RSC event');

421:
422: if(l_pt_serial_num <> l_st_serial_num) then
423: IF (g_debug > 0 ) THEN
424: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - l_pt_serial_num <> l_st_serial_num ');
425: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for RSC event');
426: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');
427: END IF;
428:
429:

Line 426: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');

422: if(l_pt_serial_num <> l_st_serial_num) then
423: IF (g_debug > 0 ) THEN
424: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - l_pt_serial_num <> l_st_serial_num ');
425: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for RSC event');
426: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');
427: END IF;
428:
429:
430: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 503: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

499: X_Msg_Data => l_msg_data
500: );
501:
502: IF (g_debug > 0 ) THEN
503: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
504: END IF;
505:
506: v_total_records := v_total_records + 1;
507:

Line 509: csd_gen_utility_pvt.add('Successfully updated the history');

505:
506: v_total_records := v_total_records + 1;
507:
508: IF (g_debug > 0 ) THEN
509: csd_gen_utility_pvt.add('Successfully updated the history');
510: END IF;
511:
512: -- travi comment to concurrent log
513: fnd_file.put_line(fnd_file.log, 'Successfully updated the history');

Line 516: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - Repair Line ID : '||to_char(l_repair_line_id));

512: -- travi comment to concurrent log
513: fnd_file.put_line(fnd_file.log, 'Successfully updated the history');
514:
515: IF (g_debug > 0 ) THEN
516: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - Repair Line ID : '||to_char(l_repair_line_id));
517: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');
518: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Recv Ser Txn Serial number : '||l_st_serial_num);
519: END IF;
520:

Line 517: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');

513: fnd_file.put_line(fnd_file.log, 'Successfully updated the history');
514:
515: IF (g_debug > 0 ) THEN
516: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - Repair Line ID : '||to_char(l_repair_line_id));
517: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');
518: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Recv Ser Txn Serial number : '||l_st_serial_num);
519: END IF;
520:
521:

Line 518: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Recv Ser Txn Serial number : '||l_st_serial_num);

514:
515: IF (g_debug > 0 ) THEN
516: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS - Repair Line ID : '||to_char(l_repair_line_id));
517: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');
518: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Recv Ser Txn Serial number : '||l_st_serial_num);
519: END IF;
520:
521:
522: end if;

Line 535: csd_gen_utility_pvt.add('No data found exception,in check for serial number change');

531:
532: Exception
533: When no_data_found then
534: IF (g_debug > 0 ) THEN
535: csd_gen_utility_pvt.add('No data found exception,in check for serial number change');
536: END IF;
537:
538: When others then
539: IF (g_debug > 0 ) THEN

Line 540: csd_gen_utility_pvt.add('When others exception,in check for serial number change');

536: END IF;
537:
538: When others then
539: IF (g_debug > 0 ) THEN
540: csd_gen_utility_pvt.add('When others exception,in check for serial number change');
541: END IF;
542:
543: END;
544:

Line 559: csd_gen_utility_pvt.add('p_result_quantity='|| TO_CHAR(p_result_quantity));

555: i.received_quantity,
556: p_result_quantity);
557:
558: IF (g_debug > 0 ) THEN
559: csd_gen_utility_pvt.add('p_result_quantity='|| TO_CHAR(p_result_quantity));
560: END IF;
561:
562:
563: update csd_repairs

Line 581: csd_gen_utility_pvt.add(fnd_message.get);

577: fnd_message.set_token('RMA_NO',i.rma_number);
578: fnd_message.set_token('REP_NO',l_repair_number);
579: fnd_message.set_token('QTY_RCVD',to_char(i.received_quantity));
580: IF (g_debug > 0 ) THEN
581: csd_gen_utility_pvt.add(fnd_message.get);
582: END IF;
583:
584:
585: IF (g_debug > 0 ) THEN

Line 586: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for RR event');

582: END IF;
583:
584:
585: IF (g_debug > 0 ) THEN
586: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for RR event');
587: END IF;
588:
589:
590: IF (g_debug > 0 ) THEN

Line 591: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');

587: END IF;
588:
589:
590: IF (g_debug > 0 ) THEN
591: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');
592: END IF;
593:
594:
595: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 669: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

665: );
666:
667:
668: IF (g_debug > 0 ) THEN
669: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
670: END IF;
671:
672:
673: IF (g_debug > 0 ) THEN

Line 674: csd_gen_utility_pvt.add('Successfully completed Depot RMA receipt update ');

670: END IF;
671:
672:
673: IF (g_debug > 0 ) THEN
674: csd_gen_utility_pvt.add('Successfully completed Depot RMA receipt update ');
675: END IF;
676:
677: -- travi comment to concurrent log
678: fnd_file.put_line(fnd_file.log, 'Successfully completed Depot RMA receipt update');

Line 691: csd_gen_utility_pvt.add(fnd_message.get);

687:
688: fnd_message.set_name('CSD','CSD_DRC_WIP_TOT_REC_PROC');
689: fnd_message.set_token('TOT_REC',to_char(v_total_records));
690: IF (g_debug > 0 ) THEN
691: csd_gen_utility_pvt.add(fnd_message.get);
692: END IF;
693:
694:
695: -- travi check for call from tools

Line 698: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS : Call from Depot Repair Form Tools Menu');

694:
695: -- travi check for call from tools
696: if ( p_repair_line_id is not null ) then
697: IF (g_debug > 0 ) THEN
698: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS : Call from Depot Repair Form Tools Menu');
699: END IF;
700:
701: IF (g_debug > 0 ) THEN
702: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

Line 702: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

698: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_RMA_RECEIPTS : Call from Depot Repair Form Tools Menu');
699: END IF;
700:
701: IF (g_debug > 0 ) THEN
702: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
703: END IF;
704:
705: IF (g_debug > 0 ) THEN
706: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));

Line 706: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));

702: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
703: END IF;
704:
705: IF (g_debug > 0 ) THEN
706: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));
707: END IF;
708:
709: end if;
710:

Line 754: csd_gen_utility_pvt.add('No WIP Job found for the wip_entity_id '||TO_CHAR(p_WIP_ENTITY_ID));

750: where WIP_ENTITY_ID=p_WIP_ENTITY_ID;
751: Exception
752: When no_data_found then
753: IF (g_debug > 0 ) THEN
754: csd_gen_utility_pvt.add('No WIP Job found for the wip_entity_id '||TO_CHAR(p_WIP_ENTITY_ID));
755: END IF;
756:
757: when others then
758: IF (g_debug > 0 ) THEN

Line 759: csd_gen_utility_pvt.add('when other exception at - get_wip_job_completed_quantity');

755: END IF;
756:
757: when others then
758: IF (g_debug > 0 ) THEN
759: csd_gen_utility_pvt.add('when other exception at - get_wip_job_completed_quantity');
760: END IF;
761:
762: End;
763:

Line 832: csd_gen_utility_pvt.add('At the begin of Depot Repair WIP Job update');

828: v_total_rec := 0;
829: v_old_wip_entity_id := -1000;
830:
831: IF (g_debug > 0 ) THEN
832: csd_gen_utility_pvt.add('At the begin of Depot Repair WIP Job update');
833: END IF;
834:
835:
836: -- travi code to update wip_entity_id for the repair_job_xref

Line 854: csd_gen_utility_pvt.add('Invalid WIP_ENTITY_NAME : '||v_wen);

850: Exception
851: When no_data_found then
852: v_wei := NULL;
853: IF (g_debug > 0 ) THEN
854: csd_gen_utility_pvt.add('Invalid WIP_ENTITY_NAME : '||v_wen);
855: END IF;
856:
857: when others then
858: IF (g_debug > 0 ) THEN

Line 859: csd_gen_utility_pvt.add('Others exception WIP_ENTITY_NAME : '||v_wen);

855: END IF;
856:
857: when others then
858: IF (g_debug > 0 ) THEN
859: csd_gen_utility_pvt.add('Others exception WIP_ENTITY_NAME : '||v_wen);
860: END IF;
861:
862: End;
863:

Line 865: csd_gen_utility_pvt.add('Updating csd_repair_job_xref for wip_entity_name : '||v_wen);

861:
862: End;
863:
864: IF (g_debug > 0 ) THEN
865: csd_gen_utility_pvt.add('Updating csd_repair_job_xref for wip_entity_name : '||v_wen);
866: END IF;
867:
868: IF (g_debug > 0 ) THEN
869: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(K.wip_entity_id));

Line 869: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(K.wip_entity_id));

865: csd_gen_utility_pvt.add('Updating csd_repair_job_xref for wip_entity_name : '||v_wen);
866: END IF;
867:
868: IF (g_debug > 0 ) THEN
869: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(K.wip_entity_id));
870: END IF;
871:
872: -- Updating Null Value for v_wei when WIP Mass load program is not completed
873: -- so should not update when v_wei is null bug# 2770713 saupadhy

Line 894: csd_gen_utility_pvt.add('-------------------------------------------');

890: For I in Repair_Jobs( p_repair_line_id )
891: loop
892:
893: IF (g_debug > 0 ) THEN
894: csd_gen_utility_pvt.add('-------------------------------------------');
895: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(i.wip_entity_id));
896: csd_gen_utility_pvt.add('repair_line_id ='||TO_CHAR(i.repair_line_id));
897: csd_gen_utility_pvt.add('quantity_completed ='||TO_CHAR(i.quantity_completed));
898: csd_gen_utility_pvt.add('quantity ='||TO_CHAR(i.quantity));

Line 895: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(i.wip_entity_id));

891: loop
892:
893: IF (g_debug > 0 ) THEN
894: csd_gen_utility_pvt.add('-------------------------------------------');
895: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(i.wip_entity_id));
896: csd_gen_utility_pvt.add('repair_line_id ='||TO_CHAR(i.repair_line_id));
897: csd_gen_utility_pvt.add('quantity_completed ='||TO_CHAR(i.quantity_completed));
898: csd_gen_utility_pvt.add('quantity ='||TO_CHAR(i.quantity));
899: END IF;

Line 896: csd_gen_utility_pvt.add('repair_line_id ='||TO_CHAR(i.repair_line_id));

892:
893: IF (g_debug > 0 ) THEN
894: csd_gen_utility_pvt.add('-------------------------------------------');
895: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(i.wip_entity_id));
896: csd_gen_utility_pvt.add('repair_line_id ='||TO_CHAR(i.repair_line_id));
897: csd_gen_utility_pvt.add('quantity_completed ='||TO_CHAR(i.quantity_completed));
898: csd_gen_utility_pvt.add('quantity ='||TO_CHAR(i.quantity));
899: END IF;
900:

Line 897: csd_gen_utility_pvt.add('quantity_completed ='||TO_CHAR(i.quantity_completed));

893: IF (g_debug > 0 ) THEN
894: csd_gen_utility_pvt.add('-------------------------------------------');
895: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(i.wip_entity_id));
896: csd_gen_utility_pvt.add('repair_line_id ='||TO_CHAR(i.repair_line_id));
897: csd_gen_utility_pvt.add('quantity_completed ='||TO_CHAR(i.quantity_completed));
898: csd_gen_utility_pvt.add('quantity ='||TO_CHAR(i.quantity));
899: END IF;
900:
901: if i.wip_entity_id <> v_old_wip_entity_id then

Line 898: csd_gen_utility_pvt.add('quantity ='||TO_CHAR(i.quantity));

894: csd_gen_utility_pvt.add('-------------------------------------------');
895: csd_gen_utility_pvt.add('wip_entity_id ='||TO_CHAR(i.wip_entity_id));
896: csd_gen_utility_pvt.add('repair_line_id ='||TO_CHAR(i.repair_line_id));
897: csd_gen_utility_pvt.add('quantity_completed ='||TO_CHAR(i.quantity_completed));
898: csd_gen_utility_pvt.add('quantity ='||TO_CHAR(i.quantity));
899: END IF;
900:
901: if i.wip_entity_id <> v_old_wip_entity_id then
902: -- get wip_comp_qty for the wip_entity_id

Line 908: csd_gen_utility_pvt.add('x_wip_completed_qty ='||TO_CHAR(x_wip_completed_qty));

904: x_date_completed,x_organization_id,x_routing_reference_id,x_last_updated_by);
905:
906:
907: IF (g_debug > 0 ) THEN
908: csd_gen_utility_pvt.add('x_wip_completed_qty ='||TO_CHAR(x_wip_completed_qty));
909: END IF;
910:
911: -- get SIGMA ro_completed_qty
912: Select nvl(sum(quantity_completed),0) into SumOfROCompQty from csd_repair_job_xref where wip_entity_id = i.wip_entity_id;

Line 919: csd_gen_utility_pvt.add(' i.quantity_complted ='||TO_CHAR( i.quantity_completed));

915: if (v_transaction_quantity + nvl(i.quantity_completed,0)) > nvl(i.quantity,0) then
916: v_transaction_quantity := nvl(i.quantity,0) - nvl(i.quantity_completed,0);
917: end if;
918: IF (g_debug > 0 ) THEN
919: csd_gen_utility_pvt.add(' i.quantity_complted ='||TO_CHAR( i.quantity_completed));
920: END IF;
921: IF (g_debug > 0 ) THEN
922: csd_gen_utility_pvt.add(' v_transaction_quantity ='||TO_CHAR( v_transaction_quantity));
923: END IF;

Line 922: csd_gen_utility_pvt.add(' v_transaction_quantity ='||TO_CHAR( v_transaction_quantity));

918: IF (g_debug > 0 ) THEN
919: csd_gen_utility_pvt.add(' i.quantity_complted ='||TO_CHAR( i.quantity_completed));
920: END IF;
921: IF (g_debug > 0 ) THEN
922: csd_gen_utility_pvt.add(' v_transaction_quantity ='||TO_CHAR( v_transaction_quantity));
923: END IF;
924: v_completed_qty := nvl(i.quantity_completed,0) + v_transaction_quantity;
925: if (v_completed_qty > i.quantity) then
926: v_completed_qty := i.quantity;

Line 940: csd_gen_utility_pvt.add(fnd_message.get);

936: fnd_message.set_name('CSD','CSD_INVALID_WIP_ENTITY');
937: fnd_message.set_token('REP_NO',i.repair_number);
938: fnd_message.set_token('WIP_JOB_ID',i.wip_entity_id);
939: if (g_debug > 0) then
940: csd_gen_utility_pvt.add(fnd_message.get);
941: end if;
942: v_completed_qty := 0;
943: when others then
944: if (g_debug > 0) then

Line 945: csd_gen_utility_pvt.add('When others exception at - Wip entity name');

941: end if;
942: v_completed_qty := 0;
943: when others then
944: if (g_debug > 0) then
945: csd_gen_utility_pvt.add('When others exception at - Wip entity name');
946: end if;
947: End;
948: end if;
949: /*

Line 958: csd_gen_utility_pvt.add(' i.quantity_complted ='||TO_CHAR( i.quantity_completed));

954: if (v_transaction_quantity + nvl(i.quantity_completed,0)) > nvl(i.quantity,0) then
955: v_transaction_quantity := nvl(i.quantity,0) - nvl(i.quantity_completed,0);
956: end if;
957: IF (g_debug > 0 ) THEN
958: csd_gen_utility_pvt.add(' i.quantity_complted ='||TO_CHAR( i.quantity_completed));
959:
960: END IF;
961: IF (g_debug > 0 ) THEN
962: csd_gen_utility_pvt.add(' v_transaction_quantity ='||TO_CHAR( v_transaction_quantity));

Line 962: csd_gen_utility_pvt.add(' v_transaction_quantity ='||TO_CHAR( v_transaction_quantity));

958: csd_gen_utility_pvt.add(' i.quantity_complted ='||TO_CHAR( i.quantity_completed));
959:
960: END IF;
961: IF (g_debug > 0 ) THEN
962: csd_gen_utility_pvt.add(' v_transaction_quantity ='||TO_CHAR( v_transaction_quantity));
963: END IF;
964: v_completed_qty := nvl(i.quantity_completed,0) + v_transaction_quantity;
965: if (v_completed_qty > i.quantity) then
966: v_completed_qty := i.quantity;

Line 980: csd_gen_utility_pvt.add(fnd_message.get);

976: fnd_message.set_token('REP_NO',i.repair_number);
977: fnd_message.set_token('WIP_JOB',v_wip_entity_name);
978: fnd_message.set_token('QTY_COMPLETE',to_char(v_transaction_quantity));
979: IF (g_debug > 0 ) THEN
980: csd_gen_utility_pvt.add(fnd_message.get);
981: END IF;
982:
983:
984: v_total_rec := v_total_rec + 1;

Line 987: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');

983:
984: v_total_rec := v_total_rec + 1;
985:
986: IF (g_debug > 0 ) THEN
987: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
988: END IF;
989:
990:
991: IF (g_debug > 0 ) THEN

Line 992: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_wip_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for JC event');

988: END IF;
989:
990:
991: IF (g_debug > 0 ) THEN
992: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_wip_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for JC event');
993: END IF;
994:
995:
996: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 1069: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_wip_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

1065: X_Msg_Data => l_msg_data
1066: );
1067:
1068: IF (g_debug > 0 ) THEN
1069: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_wip_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1070: END IF;
1071:
1072:
1073:

Line 1075: csd_gen_utility_pvt.add('Successfully completed Depot Repair WIP Job Update');

1071:
1072:
1073:
1074: IF (g_debug > 0 ) THEN
1075: csd_gen_utility_pvt.add('Successfully completed Depot Repair WIP Job Update');
1076: END IF;
1077:
1078:
1079: End if;

Line 1091: csd_gen_utility_pvt.add(fnd_message.get);

1087:
1088: fnd_message.set_name('CSD','CSD_DRC_WIP_REC_PROC');
1089: fnd_message.set_token('TOT_REC',to_char(v_total_rec));
1090: IF (g_debug > 0 ) THEN
1091: csd_gen_utility_pvt.add(fnd_message.get);
1092: END IF;
1093:
1094:
1095: if ( p_repair_line_id is not null ) then

Line 1097: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_WIP_UPDATE : Call from Depot Repair Form Tools Menu');

1093:
1094:
1095: if ( p_repair_line_id is not null ) then
1096: IF (g_debug > 0 ) THEN
1097: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_WIP_UPDATE : Call from Depot Repair Form Tools Menu');
1098: END IF;
1099:
1100: IF (g_debug > 0 ) THEN
1101: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

Line 1101: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

1097: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_WIP_UPDATE : Call from Depot Repair Form Tools Menu');
1098: END IF;
1099:
1100: IF (g_debug > 0 ) THEN
1101: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1102: END IF;
1103:
1104: IF (g_debug > 0 ) THEN
1105: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_rec));

Line 1105: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_rec));

1101: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1102: END IF;
1103:
1104: IF (g_debug > 0 ) THEN
1105: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_rec));
1106: END IF;
1107:
1108: end if;
1109:

Line 1204: csd_gen_utility_pvt.add('At the begin of Depot repair Shipping Update');

1200:
1201: v_total_records := 0;
1202:
1203: IF (g_debug > 0 ) THEN
1204: csd_gen_utility_pvt.add('At the begin of Depot repair Shipping Update');
1205: END IF;
1206:
1207:
1208: For I in depot_shipment_lines(p_repair_line_id)

Line 1213: csd_gen_utility_pvt.add('-------------------------------------------');

1209: loop
1210:
1211:
1212: IF (g_debug > 0 ) THEN
1213: csd_gen_utility_pvt.add('-------------------------------------------');
1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));
1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));

Line 1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));

1210:
1211:
1212: IF (g_debug > 0 ) THEN
1213: csd_gen_utility_pvt.add('-------------------------------------------');
1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));
1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));
1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));

Line 1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);

1211:
1212: IF (g_debug > 0 ) THEN
1213: csd_gen_utility_pvt.add('-------------------------------------------');
1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));
1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));
1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));
1219: csd_gen_utility_pvt.add('Organization id ='||TO_CHAR(I.Organization_id));

Line 1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));

1212: IF (g_debug > 0 ) THEN
1213: csd_gen_utility_pvt.add('-------------------------------------------');
1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));
1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));
1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));
1219: csd_gen_utility_pvt.add('Organization id ='||TO_CHAR(I.Organization_id));
1220: END IF;

Line 1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));

1213: csd_gen_utility_pvt.add('-------------------------------------------');
1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));
1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));
1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));
1219: csd_gen_utility_pvt.add('Organization id ='||TO_CHAR(I.Organization_id));
1220: END IF;
1221:

Line 1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));

1214: csd_gen_utility_pvt.add('Order number ='||TO_CHAR(I.order_number));
1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));
1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));
1219: csd_gen_utility_pvt.add('Organization id ='||TO_CHAR(I.Organization_id));
1220: END IF;
1221:
1222:

Line 1219: csd_gen_utility_pvt.add('Organization id ='||TO_CHAR(I.Organization_id));

1215: csd_gen_utility_pvt.add('Repair number ='||I.repair_number);
1216: csd_gen_utility_pvt.add('Txn billing type id ='||TO_CHAR(I.txn_billing_type_id));
1217: csd_gen_utility_pvt.add('Shipped quantity ='||TO_CHAR(I.shipped_quantity));
1218: csd_gen_utility_pvt.add('Inventory item id ='||TO_CHAR(I.inventory_item_id));
1219: csd_gen_utility_pvt.add('Organization id ='||TO_CHAR(I.Organization_id));
1220: END IF;
1221:
1222:
1223: v_skip_record := false;

Line 1239: csd_gen_utility_pvt.add('Transaction type id not found for billing type id ='||TO_CHAR(i.txn_billing_type_id));

1235: When no_data_found then
1236: v_transaction_type_id := null;
1237: v_skip_record := true;
1238: IF (g_debug > 0 ) THEN
1239: csd_gen_utility_pvt.add('Transaction type id not found for billing type id ='||TO_CHAR(i.txn_billing_type_id));
1240: END IF;
1241:
1242: when others then
1243: IF (g_debug > 0 ) THEN

Line 1244: csd_gen_utility_pvt.add('When others exception at - Transaction type id');

1240: END IF;
1241:
1242: when others then
1243: IF (g_debug > 0 ) THEN
1244: csd_gen_utility_pvt.add('When others exception at - Transaction type id');
1245: END IF;
1246:
1247: End;
1248:

Line 1260: csd_gen_utility_pvt.add('Depot repair flag is not Y ');

1256: Exception
1257: when no_Data_found then
1258: V_skip_record := true;
1259: IF (g_debug > 0 ) THEN
1260: csd_gen_utility_pvt.add('Depot repair flag is not Y ');
1261: END IF;
1262:
1263: when others then
1264: IF (g_debug > 0 ) THEN

Line 1265: csd_gen_utility_pvt.add('When others exception at - depot repair flag');

1261: END IF;
1262:
1263: when others then
1264: IF (g_debug > 0 ) THEN
1265: csd_gen_utility_pvt.add('When others exception at - depot repair flag');
1266: END IF;
1267:
1268: End;
1269: End if;

Line 1285: csd_gen_utility_pvt.add(fnd_message.get);

1281: fnd_message.set_token('REP_NO',I.repair_number);
1282: fnd_message.set_token('QTY_SHIP',to_char(I.shipped_quantity));
1283: fnd_message.set_token('DT_SHIP',to_char(I.date_shipped));
1284: IF (g_debug > 0 ) THEN
1285: csd_gen_utility_pvt.add(fnd_message.get);
1286: END IF;
1287:
1288: fnd_message.clear;
1289: v_skip_record := true;

Line 1306: csd_gen_utility_pvt.add('Checking whether serial numbers are changed');

1302: if (c_prd_txn_serial_num%FOUND) then
1303:
1304: -- check if serial numbers are different
1305: IF (g_debug > 0 ) THEN
1306: csd_gen_utility_pvt.add('Checking whether serial numbers are changed');
1307: END IF;
1308:
1309:
1310: if(l_pt_serial_num <> i.sl_number) then

Line 1314: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for SSC event');

1310: if(l_pt_serial_num <> i.sl_number) then
1311:
1312:
1313: IF (g_debug > 0 ) THEN
1314: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for SSC event');
1315: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY');
1316: END IF;
1317:
1318:

Line 1315: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY');

1311:
1312:
1313: IF (g_debug > 0 ) THEN
1314: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for SSC event');
1315: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY');
1316: END IF;
1317:
1318:
1319: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 1392: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

1388: X_Msg_Data => l_msg_data
1389: );
1390:
1391: IF (g_debug > 0 ) THEN
1392: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1393: END IF;
1394:
1395: v_total_records := v_total_records + 1;
1396:

Line 1398: csd_gen_utility_pvt.add('Successfully updated the history');

1394:
1395: v_total_records := v_total_records + 1;
1396:
1397: IF (g_debug > 0 ) THEN
1398: csd_gen_utility_pvt.add('Successfully updated the history');
1399: END IF;
1400:
1401:
1402: IF (g_debug > 0 ) THEN

Line 1403: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE - Repair Line ID : '||to_char(i.repair_line_id));

1399: END IF;
1400:
1401:
1402: IF (g_debug > 0 ) THEN
1403: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE - Repair Line ID : '||to_char(i.repair_line_id));
1404: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');
1405: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Ship Serial number : '||i.sl_number);
1406: END IF;
1407:

Line 1404: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');

1400:
1401:
1402: IF (g_debug > 0 ) THEN
1403: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE - Repair Line ID : '||to_char(i.repair_line_id));
1404: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');
1405: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Ship Serial number : '||i.sl_number);
1406: END IF;
1407:
1408:

Line 1405: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Ship Serial number : '||i.sl_number);

1401:
1402: IF (g_debug > 0 ) THEN
1403: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE - Repair Line ID : '||to_char(i.repair_line_id));
1404: csd_gen_utility_pvt.add('Inserted into Repairs History Table for Serial number Change');
1405: csd_gen_utility_pvt.add('Product Txn Serial number : '||l_pt_serial_num||' Ship Serial number : '||i.sl_number);
1406: END IF;
1407:
1408:
1409: end if;

Line 1416: csd_gen_utility_pvt.add('No data found exception,in check for serial number change');

1412:
1413: Exception
1414: When no_data_found then
1415: IF (g_debug > 0 ) THEN
1416: csd_gen_utility_pvt.add('No data found exception,in check for serial number change');
1417: END IF;
1418:
1419: When others then
1420: IF (g_debug > 0 ) THEN

Line 1421: csd_gen_utility_pvt.add('When others exception,in check for serial number change');

1417: END IF;
1418:
1419: When others then
1420: IF (g_debug > 0 ) THEN
1421: csd_gen_utility_pvt.add('When others exception,in check for serial number change');
1422: END IF;
1423:
1424: END;
1425:

Line 1432: csd_gen_utility_pvt.add('Calling the convert to primary uom ');

1428:
1429: if not v_skip_record then
1430:
1431: IF (g_debug > 0 ) THEN
1432: csd_gen_utility_pvt.add('Calling the convert to primary uom ');
1433: END IF;
1434:
1435:
1436: csd_depot_repair_cntr.convert_to_primary_uom

Line 1457: csd_gen_utility_pvt.add('Updated csd_repairs table');

1453:
1454: --Vijay 2/3/03 End
1455:
1456: IF (g_debug > 0 ) THEN
1457: csd_gen_utility_pvt.add('Updated csd_repairs table');
1458: END IF;
1459:
1460:
1461: fnd_message.set_name('CSD','CSD_DRC_QTY_SHIPPED');

Line 1466: csd_gen_utility_pvt.add(fnd_message.get);

1462: fnd_message.set_token('ORDER_NO',i.order_number);
1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');
1468: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
1469: END IF;
1470:

Line 1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');

1463: fnd_message.set_token('REP_NO',i.repair_number);
1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');
1468: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
1469: END IF;
1470:
1471:

Line 1468: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');

1464: fnd_message.set_token('QTY_SHIP',to_char(p_result_ship_quantity));
1465: IF (g_debug > 0 ) THEN
1466: csd_gen_utility_pvt.add(fnd_message.get);
1467: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for PS event');
1468: csd_gen_utility_pvt.add('Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
1469: END IF;
1470:
1471:
1472: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write (

Line 1545: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);

1541: X_Msg_Data => l_msg_data
1542: );
1543:
1544: IF (g_debug > 0 ) THEN
1545: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1546: csd_gen_utility_pvt.add('Successfully completed Depot repair Shipping Update');
1547: END IF;
1548:
1549: commit;

Line 1546: csd_gen_utility_pvt.add('Successfully completed Depot repair Shipping Update');

1542: );
1543:
1544: IF (g_debug > 0 ) THEN
1545: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_shipment_update after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write l_return_status'||l_return_status);
1546: csd_gen_utility_pvt.add('Successfully completed Depot repair Shipping Update');
1547: END IF;
1548:
1549: commit;
1550:

Line 1560: csd_gen_utility_pvt.add(fnd_message.get);

1556:
1557: fnd_message.set_name('CSD','CSD_DRC_SHIP_TOTAL_REC_PROC');
1558: fnd_message.set_token('TOT_REC',to_char(v_total_records));
1559: IF (g_debug > 0 ) THEN
1560: csd_gen_utility_pvt.add(fnd_message.get);
1561: END IF;
1562:
1563:
1564: if ( p_repair_line_id is not null ) then

Line 1566: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE : Call from Depot Repair Form Tools Menu');

1562:
1563:
1564: if ( p_repair_line_id is not null ) then
1565: IF (g_debug > 0 ) THEN
1566: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE : Call from Depot Repair Form Tools Menu');
1567: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1568: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));
1569: END IF;
1570:

Line 1567: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

1563:
1564: if ( p_repair_line_id is not null ) then
1565: IF (g_debug > 0 ) THEN
1566: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE : Call from Depot Repair Form Tools Menu');
1567: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1568: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));
1569: END IF;
1570:
1571: end if;

Line 1568: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));

1564: if ( p_repair_line_id is not null ) then
1565: IF (g_debug > 0 ) THEN
1566: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_SHIPMENT_UPDATE : Call from Depot Repair Form Tools Menu');
1567: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1568: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));
1569: END IF;
1570:
1571: end if;
1572:

Line 1761: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_update_task_hist before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for TOC or TSC event');

1757: -- ---------------
1758: -- Api body starts
1759: -- ---------------
1760: IF (g_debug > 0 ) THEN
1761: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_update_task_hist before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call for TOC or TSC event');
1762: END IF;
1763:
1764:
1765: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write

Line 1838: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_update_task_hist after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write x_return_status'||x_return_status);

1834: X_Msg_Data => x_msg_data
1835: );
1836: --
1837: IF (g_debug > 0 ) THEN
1838: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.depot_update_task_hist after CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write x_return_status'||x_return_status);
1839: END IF;
1840:
1841: -- -------------------
1842: -- Api body ends here

Line 1866: csd_gen_utility_pvt.add('Completed depot_update_task_hist with Success..');

1862:
1863: end loop;
1864:
1865: IF (g_debug > 0 ) THEN
1866: csd_gen_utility_pvt.add('Completed depot_update_task_hist with Success..');
1867: END IF;
1868:
1869: IF (g_debug > 0 ) THEN
1870: csd_gen_utility_pvt.add('Inserted into CSD_REPAIR_HISTORY table '||to_char(v_total_records)||' Records');

Line 1870: csd_gen_utility_pvt.add('Inserted into CSD_REPAIR_HISTORY table '||to_char(v_total_records)||' Records');

1866: csd_gen_utility_pvt.add('Completed depot_update_task_hist with Success..');
1867: END IF;
1868:
1869: IF (g_debug > 0 ) THEN
1870: csd_gen_utility_pvt.add('Inserted into CSD_REPAIR_HISTORY table '||to_char(v_total_records)||' Records');
1871: END IF;
1872:
1873:
1874: -- travi check for call from tools

Line 1877: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_UPDATE_TASK_HIST : Call from Depot Repair Form Tools Menu');

1873:
1874: -- travi check for call from tools
1875: if ( p_repair_line_id is not null ) then
1876: IF (g_debug > 0 ) THEN
1877: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_UPDATE_TASK_HIST : Call from Depot Repair Form Tools Menu');
1878: END IF;
1879:
1880: IF (g_debug > 0 ) THEN
1881: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

Line 1881: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));

1877: csd_gen_utility_pvt.add('CSD_DEPOT_REPAIR_CNTR.DEPOT_UPDATE_TASK_HIST : Call from Depot Repair Form Tools Menu');
1878: END IF;
1879:
1880: IF (g_debug > 0 ) THEN
1881: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1882: END IF;
1883:
1884: IF (g_debug > 0 ) THEN
1885: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));

Line 1885: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));

1881: csd_gen_utility_pvt.add('Repair Line ID ='||to_char(p_repair_line_id));
1882: END IF;
1883:
1884: IF (g_debug > 0 ) THEN
1885: csd_gen_utility_pvt.add('Total Records inserted into Repairs History Table ='||to_char(v_total_records));
1886: END IF;
1887:
1888: end if;
1889:

Line 1907: csd_gen_utility_pvt.add('ndf');

1903: p_data => x_msg_data
1904: );
1905: when no_data_found then
1906: IF (g_debug > 0 ) THEN
1907: csd_gen_utility_pvt.add('ndf');
1908: END IF;
1909:
1910: when too_many_rows then
1911: IF (g_debug > 0 ) THEN

Line 1912: csd_gen_utility_pvt.add('tmf');

1908: END IF;
1909:
1910: when too_many_rows then
1911: IF (g_debug > 0 ) THEN
1912: csd_gen_utility_pvt.add('tmf');
1913: END IF;
1914:
1915: when value_error then
1916: IF (g_debug > 0 ) THEN

Line 1917: csd_gen_utility_pvt.add('ve');

1913: END IF;
1914:
1915: when value_error then
1916: IF (g_debug > 0 ) THEN
1917: csd_gen_utility_pvt.add('ve');
1918: END IF;
1919:
1920:
1921: WHEN OTHERS THEN

Line 1935: csd_gen_utility_pvt.add('others '||sqlerrm||to_char(sqlcode));

1931: FND_MSG_PUB.Count_And_Get
1932: (p_count => x_msg_count,
1933: p_data => x_msg_data );
1934: IF (g_debug > 0 ) THEN
1935: csd_gen_utility_pvt.add('others '||sqlerrm||to_char(sqlcode));
1936: END IF;
1937:
1938:
1939: END depot_update_task_hist;