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_REPAIR_MANAGER_UTIL dependencies on FND_LOG

Line 295: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
292: l_index NUMBER := 0;
293:
294: BEGIN
295: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
297: 'Begin');
298: END IF;
299:

Line 296: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

292: l_index NUMBER := 0;
293:
294: BEGIN
295: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
297: 'Begin');
298: END IF;
299:
300: -- standard check for API compatibility.

Line 317: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

313: END IF;
314:
315: --
316: x_return_status := fnd_api.g_ret_sts_success;
317: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
318: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
319: 'Looping through repair line tbl: Count = '||p_repln_tbl.COUNT);
320: END IF;
321: FOR i IN 1 ..p_repln_tbl.COUNT

Line 318: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

314:
315: --
316: x_return_status := fnd_api.g_ret_sts_success;
317: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
318: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
319: 'Looping through repair line tbl: Count = '||p_repln_tbl.COUNT);
320: END IF;
321: FOR i IN 1 ..p_repln_tbl.COUNT
322: LOOP

Line 329: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

325: + p_repln_tbl(i).quantity;
326: ELSE
327: int_org_item_qty_tbl(p_repln_tbl(i).inventory_item_id) := p_repln_tbl(i).quantity;
328: END IF;
329: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
330: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
331: 'Checking for destination org and location');
332: END IF;
333:

Line 330: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

326: ELSE
327: int_org_item_qty_tbl(p_repln_tbl(i).inventory_item_id) := p_repln_tbl(i).quantity;
328: END IF;
329: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
330: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
331: 'Checking for destination org and location');
332: END IF;
333:
334: IF NOT l_destn_org_tbl.EXISTS(p_repln_tbl(i).inventory_item_id)

Line 351: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

347: x_return_status => x_return_status,
348: x_msg_count => x_msg_count,
349: x_msg_data => x_msg_data
350: );
351: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
352: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
353: 'Derived destination org = '||l_dest_org);
354: END IF;
355: IF l_dest_org IS NULL

Line 352: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

348: x_msg_count => x_msg_count,
349: x_msg_data => x_msg_data
350: );
351: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
352: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
353: 'Derived destination org = '||l_dest_org);
354: END IF;
355: IF l_dest_org IS NULL
356: THEN

Line 365: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

361: l_destn_org_tbl(p_repln_tbl(i).inventory_item_id) := l_dest_org;
362: END IF;
363:
364: -- get the default internal location for the destination organization.
365: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
366: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
367: 'Deriving dest location for = '||l_dest_org||' OU = '||l_dest_ou);
368: END IF;
369:

Line 366: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

362: END IF;
363:
364: -- get the default internal location for the destination organization.
365: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
366: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
367: 'Deriving dest location for = '||l_dest_org||' OU = '||l_dest_ou);
368: END IF;
369:
370: SELECT loc.location_id

Line 383: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

379: AND ploc.customer_id = cust.cust_account_id -- cust.customer_id, bug#12610896, subhat
380: AND cust.customer_type = 'I'
381: AND rownum = 1;
382:
383: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
384: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
385: 'Derived destination location = '||l_destn_loc_tbl(l_dest_org));
386: END IF;
387: END IF;

Line 384: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

380: AND cust.customer_type = 'I'
381: AND rownum = 1;
382:
383: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
384: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
385: 'Derived destination location = '||l_destn_loc_tbl(l_dest_org));
386: END IF;
387: END IF;
388:

Line 399: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

395:
396: END LOOP;
397:
398: -- need to populate the expected quantity on the product transaction table.
399: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
400: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
401: 'Updating the expected quantity');
402: END IF;
403: FOR i IN 1 ..l_prod_txn_tbl.COUNT

Line 400: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

396: END LOOP;
397:
398: -- need to populate the expected quantity on the product transaction table.
399: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
400: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
401: 'Updating the expected quantity');
402: END IF;
403: FOR i IN 1 ..l_prod_txn_tbl.COUNT
404: LOOP

Line 409: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

405: l_prod_txn_tbl(i).exp_quantity := int_org_item_qty_tbl(l_prod_txn_tbl(i).inventory_item_id);
406: END LOOP;
407:
408: -- insert the records into the product transactions table.
409: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
410: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
411: 'Forall insert into csd_product_transactions. Number of product txn lines = '||l_prod_txn_tbl.COUNT);
412: END IF;
413:

Line 410: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

406: END LOOP;
407:
408: -- insert the records into the product transactions table.
409: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
410: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
411: 'Forall insert into csd_product_transactions. Number of product txn lines = '||l_prod_txn_tbl.COUNT);
412: END IF;
413:
414: FORALL i IN 1 ..l_prod_txn_tbl.COUNT

Line 449: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

445: 1
446: )
447: RETURNING product_transaction_id BULK COLLECT INTO l_product_txn_ids;
448:
449: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
450: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
451: 'Creating one internal order for the entire batch.');
452: END IF;
453: -- We will pick up the distinct items from the product transaction table

Line 450: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

446: )
447: RETURNING product_transaction_id BULK COLLECT INTO l_product_txn_ids;
448:
449: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
450: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
451: 'Creating one internal order for the entire batch.');
452: END IF;
453: -- We will pick up the distinct items from the product transaction table
454: -- and put them under same internal requisition, sales order.

Line 749: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

745: BEGIN
746:
747: savepoint mass_update_repair_orders;
748:
749: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
750: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
751: 'Begin mass update API');
752: END IF;
753: -- standard check for API compatibility.

Line 750: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

746:
747: savepoint mass_update_repair_orders;
748:
749: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
750: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
751: 'Begin mass update API');
752: END IF;
753: -- standard check for API compatibility.
754: IF NOT Fnd_Api.Compatible_API_Call

Line 770: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

766: END IF;
767:
768: -- dump the API params for debug purpose.
769:
770: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
771: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
772: 'Dump all the input params');
773: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
774: 'p_to_ro_status = '||p_to_ro_status);

Line 771: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

767:
768: -- dump the API params for debug purpose.
769:
770: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
771: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
772: 'Dump all the input params');
773: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
774: 'p_to_ro_status = '||p_to_ro_status);
775: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 773: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

769:
770: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
771: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
772: 'Dump all the input params');
773: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
774: 'p_to_ro_status = '||p_to_ro_status);
775: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
776: 'p_ro_type_id = '||p_ro_type_id);
777: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 775: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

771: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
772: 'Dump all the input params');
773: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
774: 'p_to_ro_status = '||p_to_ro_status);
775: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
776: 'p_ro_type_id = '||p_ro_type_id);
777: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
778: 'p_ro_owner_id = '||p_ro_owner_id);
779: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 777: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

773: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
774: 'p_to_ro_status = '||p_to_ro_status);
775: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
776: 'p_ro_type_id = '||p_ro_type_id);
777: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
778: 'p_ro_owner_id = '||p_ro_owner_id);
779: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
780: 'p_ro_org_id = '||p_ro_org_id);
781: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 779: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

775: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
776: 'p_ro_type_id = '||p_ro_type_id);
777: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
778: 'p_ro_owner_id = '||p_ro_owner_id);
779: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
780: 'p_ro_org_id = '||p_ro_org_id);
781: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
782: 'p_ro_priority_id = '||p_ro_priority_id);
783: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 781: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

777: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
778: 'p_ro_owner_id = '||p_ro_owner_id);
779: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
780: 'p_ro_org_id = '||p_ro_org_id);
781: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
782: 'p_ro_priority_id = '||p_ro_priority_id);
783: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
784: 'p_ro_escalation_code = '||p_ro_escalation_code);
785: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 783: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

779: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
780: 'p_ro_org_id = '||p_ro_org_id);
781: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
782: 'p_ro_priority_id = '||p_ro_priority_id);
783: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
784: 'p_ro_escalation_code = '||p_ro_escalation_code);
785: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
786: 'p_note_type = '||p_note_type);
787: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 785: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

781: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
782: 'p_ro_priority_id = '||p_ro_priority_id);
783: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
784: 'p_ro_escalation_code = '||p_ro_escalation_code);
785: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
786: 'p_note_type = '||p_note_type);
787: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
788: 'p_note_visibility = '||p_note_visibility);
789: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 787: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

783: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
784: 'p_ro_escalation_code = '||p_ro_escalation_code);
785: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
786: 'p_note_type = '||p_note_type);
787: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
788: 'p_note_visibility = '||p_note_visibility);
789: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
790: 'p_attach_title = '||p_attach_title);
791: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 789: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

785: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
786: 'p_note_type = '||p_note_type);
787: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
788: 'p_note_visibility = '||p_note_visibility);
789: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
790: 'p_attach_title = '||p_attach_title);
791: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
792: 'p_attach_descr = '||p_attach_descr);
793: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 791: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

787: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
788: 'p_note_visibility = '||p_note_visibility);
789: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
790: 'p_attach_title = '||p_attach_title);
791: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
792: 'p_attach_descr = '||p_attach_descr);
793: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
794: 'p_attach_cat_id = '||p_attach_cat_id);
795: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 793: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

789: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
790: 'p_attach_title = '||p_attach_title);
791: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
792: 'p_attach_descr = '||p_attach_descr);
793: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
794: 'p_attach_cat_id = '||p_attach_cat_id);
795: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
796: 'p_attach_cat_id = '||p_attach_cat_id);
797: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 795: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

791: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
792: 'p_attach_descr = '||p_attach_descr);
793: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
794: 'p_attach_cat_id = '||p_attach_cat_id);
795: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
796: 'p_attach_cat_id = '||p_attach_cat_id);
797: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
798: 'p_attach_type = '||p_attach_type);
799: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 797: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

793: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
794: 'p_attach_cat_id = '||p_attach_cat_id);
795: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
796: 'p_attach_cat_id = '||p_attach_cat_id);
797: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
798: 'p_attach_type = '||p_attach_type);
799: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
800: 'p_attach_url = '||p_attach_url);
801: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

Line 799: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

795: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
796: 'p_attach_cat_id = '||p_attach_cat_id);
797: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
798: 'p_attach_type = '||p_attach_type);
799: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
800: 'p_attach_url = '||p_attach_url);
801: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
802: 'p_attach_text = '||p_attach_text);
803:

Line 801: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

797: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
798: 'p_attach_type = '||p_attach_type);
799: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
800: 'p_attach_url = '||p_attach_url);
801: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
802: 'p_attach_text = '||p_attach_text);
803:
804: FOR i in 1 ..p_repair_line_ids.COUNT
805: LOOP

Line 806: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

802: 'p_attach_text = '||p_attach_text);
803:
804: FOR i in 1 ..p_repair_line_ids.COUNT
805: LOOP
806: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
807: 'p_repair_line_id('||i||') = '||p_repair_line_ids(i));
808: END LOOP;
809: END IF;
810: -- initialize the error messages table.

Line 845: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

841: else
842: -- update the flow status.
843: begin
844: savepoint update_flow_status;
845: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
846: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
847: 'Call update flow status API to update the status');
848: END IF;
849: csd_repairs_pvt.update_flow_status

Line 846: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

842: -- update the flow status.
843: begin
844: savepoint update_flow_status;
845: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
846: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
847: 'Call update flow status API to update the status');
848: END IF;
849: csd_repairs_pvt.update_flow_status
850: ( p_api_version => 1.0,

Line 880: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

876:
877: l_repobj_ver(j) := x_object_version_number;
878: exception
879: when fnd_api.g_exc_error then
880: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
881: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
882: 'Error in update flow status API:'||x_msg_data);
883: END IF;
884: rollback to update_flow_status;

Line 881: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

877: l_repobj_ver(j) := x_object_version_number;
878: exception
879: when fnd_api.g_exc_error then
880: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
881: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
882: 'Error in update flow status API:'||x_msg_data);
883: END IF;
884: rollback to update_flow_status;
885: when others then

Line 886: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

882: 'Error in update flow status API:'||x_msg_data);
883: END IF;
884: rollback to update_flow_status;
885: when others then
886: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
887: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
888: 'When others exception:'||SQLERRM);
889: END IF;
890: rollback to update_flow_status;

Line 887: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

883: END IF;
884: rollback to update_flow_status;
885: when others then
886: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
887: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
888: 'When others exception:'||SQLERRM);
889: END IF;
890: rollback to update_flow_status;
891: raise;

Line 918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

914: -- update the repair type.
915: begin
916: savepoint update_repair_type;
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
919: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
920: 'Call update repair type API to update the status');
921: END IF;
922:

Line 919: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

915: begin
916: savepoint update_repair_type;
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
919: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
920: 'Call update repair type API to update the status');
921: END IF;
922:
923: csd_repairs_pvt.update_repair_type

Line 951: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

947:
948: l_repobj_ver(j) := x_object_version_number;
949: exception
950: when fnd_api.g_exc_error then
951: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
952: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
953: 'Error in update repair type API:'||x_msg_data||' message count'||x_msg_count);
954: END IF;
955: rollback to update_repair_type;

Line 952: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

948: l_repobj_ver(j) := x_object_version_number;
949: exception
950: when fnd_api.g_exc_error then
951: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
952: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
953: 'Error in update repair type API:'||x_msg_data||' message count'||x_msg_count);
954: END IF;
955: rollback to update_repair_type;
956:

Line 958: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

954: END IF;
955: rollback to update_repair_type;
956:
957: when others then
958: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
959: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
960: 'When others exception:'||SQLERRM);
961: END IF;
962: rollback to update_flow_status;

Line 959: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

955: rollback to update_repair_type;
956:
957: when others then
958: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
959: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
960: 'When others exception:'||SQLERRM);
961: END IF;
962: rollback to update_flow_status;
963: raise;

Line 1010: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1006: for k in 1 ..l_repln_rec_tbl.count
1007: loop
1008: begin
1009: savepoint update_repair_order;
1010: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1011: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1012: 'Call update repair order API');
1013: END IF;
1014: csd_repairs_pvt.update_repair_order

Line 1011: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1007: loop
1008: begin
1009: savepoint update_repair_order;
1010: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1011: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1012: 'Call update repair order API');
1013: END IF;
1014: csd_repairs_pvt.update_repair_order
1015: (p_api_version_number => 1.0,

Line 1026: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1022: x_msg_count => x_msg_count,
1023: x_msg_data => x_msg_data);
1024:
1025: if x_return_status <> fnd_api.g_ret_sts_success then
1026: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1027: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1028: 'Return status from update_repair_order '||x_return_status);
1029: END IF;
1030: prepare_error_message_table(l_error_messages_tbl,

Line 1027: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1023: x_msg_data => x_msg_data);
1024:
1025: if x_return_status <> fnd_api.g_ret_sts_success then
1026: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1027: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1028: 'Return status from update_repair_order '||x_return_status);
1029: END IF;
1030: prepare_error_message_table(l_error_messages_tbl,
1031: x_msg_count,

Line 1046: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1042: end if;
1043:
1044: -- add attachments to the repair orders.
1045: if p_attach_type = 'File' and p_attach_file is not null then
1046: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1047: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1048: 'Adding file type attachment');
1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1047: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1043:
1044: -- add attachments to the repair orders.
1045: if p_attach_type = 'File' and p_attach_file is not null then
1046: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1047: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1048: 'Adding file type attachment');
1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_SUCCESS;
1051:

Line 1076: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1072: p_repair_line_ids(1));
1073: end if;
1074:
1075: elsif p_attach_type = 'Url' and p_attach_url is not null then
1076: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1077: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1078: 'Adding URL type attachment');
1079: END IF;
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1077: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1073: end if;
1074:
1075: elsif p_attach_type = 'Url' and p_attach_url is not null then
1076: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1077: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1078: 'Adding URL type attachment');
1079: END IF;
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:

Line 1103: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1099: 'ATTACHMENT',
1100: p_repair_line_ids(1));
1101: end if;
1102: elsif p_attach_type = 'Text' and p_attach_text is not null then
1103: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1104: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1105: 'Adding Text type attachment');
1106: END IF;
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1104: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1100: p_repair_line_ids(1));
1101: end if;
1102: elsif p_attach_type = 'Text' and p_attach_text is not null then
1103: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1104: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1105: 'Adding Text type attachment');
1106: END IF;
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108:

Line 1133: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1129: end if;
1130:
1131: -- last step. Create the note.
1132: if p_note_text is not null then
1133: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1134: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1135: 'Creating the notes for the selected repair orders');
1136: END IF;
1137: for l in 1 ..p_repair_line_ids.count

Line 1134: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1130:
1131: -- last step. Create the note.
1132: if p_note_text is not null then
1133: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1134: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1135: 'Creating the notes for the selected repair orders');
1136: END IF;
1137: for l in 1 ..p_repair_line_ids.count
1138: loop

Line 1169: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1165: raise fnd_api.g_exc_error;
1166: end if;
1167: exception
1168: when fnd_api.g_exc_error then
1169: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1170: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1171: 'Error while trying to create the note:'||x_msg_data);
1172: END IF;
1173: rollback to add_notes_to_ros;

Line 1170: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1166: end if;
1167: exception
1168: when fnd_api.g_exc_error then
1169: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1170: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1171: 'Error while trying to create the note:'||x_msg_data);
1172: END IF;
1173: rollback to add_notes_to_ros;
1174: end;

Line 1181: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1177: end if;
1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1182: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1183: 'Exc Error '||x_msg_data);
1184: END IF;
1185: rollback to mass_update_repair_orders;

Line 1182: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1182: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1183: 'Exc Error '||x_msg_data);
1184: END IF;
1185: rollback to mass_update_repair_orders;
1186: WHEN OTHERS THEN

Line 1187: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1183: 'Exc Error '||x_msg_data);
1184: END IF;
1185: rollback to mass_update_repair_orders;
1186: WHEN OTHERS THEN
1187: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1188: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1189: 'In when others :'||SQLERRM);
1190: END IF;
1191: rollback to mass_update_repair_orders;

Line 1188: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,

1184: END IF;
1185: rollback to mass_update_repair_orders;
1186: WHEN OTHERS THEN
1187: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1188: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, l_api_name,
1189: 'In when others :'||SQLERRM);
1190: END IF;
1191: rollback to mass_update_repair_orders;
1192: raise;

Line 1238: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1234:
1235: BEGIN
1236: savepoint mass_create_attachments;
1237: -- standard stuff.
1238: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1239: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1240: 'Begin mass create API');
1241: END IF;
1242: -- standard check for API compatibility.

Line 1239: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1235: BEGIN
1236: savepoint mass_create_attachments;
1237: -- standard stuff.
1238: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1239: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1240: 'Begin mass create API');
1241: END IF;
1242: -- standard check for API compatibility.
1243: IF NOT Fnd_Api.Compatible_API_Call

Line 1263: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1259: when 'URL' then lc_data_type_url
1260: when 'TEXT' then lc_data_type_short_text
1261: END;
1262: -- common stuff. need to insert a record into fnd_documents table.
1263: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1264: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1265: 'Before calling Fnd_Documents_Pkg.Insert_Row');
1266: END IF;
1267:

Line 1264: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1260: when 'TEXT' then lc_data_type_short_text
1261: END;
1262: -- common stuff. need to insert a record into fnd_documents table.
1263: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1264: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1265: 'Before calling Fnd_Documents_Pkg.Insert_Row');
1266: END IF;
1267:
1268: Fnd_Documents_Pkg.Insert_Row

Line 1289: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1285: x_media_id => x_media_id,
1286: x_file_name => p_file_name);
1287:
1288: -- create the corresponding record in the document tables.
1289: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1290: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1291: 'Inserting attachments of type short text');
1292: END IF;
1293:

Line 1290: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1286: x_file_name => p_file_name);
1287:
1288: -- create the corresponding record in the document tables.
1289: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1290: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1291: 'Inserting attachments of type short text');
1292: END IF;
1293:
1294: if l_data_type = 1 then

Line 1318: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1314: select value into l_oracle_charset
1315: from nls_database_parameters
1316: where parameter = 'NLS_CHARACTERSET';
1317:
1318: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1319: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1320: 'Inserting attachments of type file into fnd_lobs table');
1321: END IF;
1322:

Line 1319: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1315: from nls_database_parameters
1316: where parameter = 'NLS_CHARACTERSET';
1317:
1318: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1319: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1320: 'Inserting attachments of type file into fnd_lobs table');
1321: END IF;
1322:
1323: insert into fnd_lobs

Line 1352: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1348: );
1349: end if;
1350:
1351: -- create the records in the fnd_attached_documents for all the repair_line_ids.
1352: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1353: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1354: 'Creating records in the fnd_attached_documents for all the passed repair orders');
1355: END IF;
1356: forall i in 1 ..p_repair_line_ids.count

Line 1353: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1349: end if;
1350:
1351: -- create the records in the fnd_attached_documents for all the repair_line_ids.
1352: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1353: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1354: 'Creating records in the fnd_attached_documents for all the passed repair orders');
1355: END IF;
1356: forall i in 1 ..p_repair_line_ids.count
1357:

Line 1425: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1421: p_attach_cat_id
1422: from dual);
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1426: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1427: 'In when others exception: SQLERRM '||SQLERRM);
1428: END IF;
1429: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1426: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1422: from dual);
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1426: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1427: 'In when others exception: SQLERRM '||SQLERRM);
1428: END IF;
1429: x_return_status := FND_API.G_RET_STS_ERROR;
1430: x_msg_count := 1;

Line 1475: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1471:
1472: BEGIN
1473:
1474: -- standard stuff.
1475: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1476: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1477: 'Begin mass create repair orders API');
1478: END IF;
1479: -- standard check for API compatibility.

Line 1476: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1472: BEGIN
1473:
1474: -- standard stuff.
1475: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1476: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1477: 'Begin mass create repair orders API');
1478: END IF;
1479: -- standard check for API compatibility.
1480: IF NOT Fnd_Api.Compatible_API_Call

Line 1587: -- Error logging. All the errors will be recorded in the FND_LOG_MESSAGES now.

1583: -- step 3. Prepare the service request record.
1584: -- step 4. Prepare the repair order table type.
1585: -- step 5. Call the helper API's to create the repair orders and product transaction lines.
1586:
1587: -- Error logging. All the errors will be recorded in the FND_LOG_MESSAGES now.
1588: -- @to do. An interface errors table to log all the error messages.
1589: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1590: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1591: 'Begin processing for group_id ='||p_group_id||' p_one_sr_per_group '||p_one_sr_per_group);

Line 1589: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1585: -- step 5. Call the helper API's to create the repair orders and product transaction lines.
1586:
1587: -- Error logging. All the errors will be recorded in the FND_LOG_MESSAGES now.
1588: -- @to do. An interface errors table to log all the error messages.
1589: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1590: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1591: 'Begin processing for group_id ='||p_group_id||' p_one_sr_per_group '||p_one_sr_per_group);
1592: END IF;
1593:

Line 1590: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1586:
1587: -- Error logging. All the errors will be recorded in the FND_LOG_MESSAGES now.
1588: -- @to do. An interface errors table to log all the error messages.
1589: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1590: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1591: 'Begin processing for group_id ='||p_group_id||' p_one_sr_per_group '||p_one_sr_per_group);
1592: END IF;
1593:
1594: -- we will generate the transaction ids to identify each row.

Line 1612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1608:
1609: -- we will commit the changes here. So that any subsequent reads will not pick up these records.
1610: commit;
1611:
1612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1614: 'Found '||l_interface_tbl.count||' records to process');
1615: END IF;
1616: for i in 1 ..l_interface_tbl.count

Line 1613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1609: -- we will commit the changes here. So that any subsequent reads will not pick up these records.
1610: commit;
1611:
1612: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1613: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1614: 'Found '||l_interface_tbl.count||' records to process');
1615: END IF;
1616: for i in 1 ..l_interface_tbl.count
1617: loop

Line 1620: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1616: for i in 1 ..l_interface_tbl.count
1617: loop
1618: -- step 1.
1619: -- check if there is minimum information required to create the Service request.
1620: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1621: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1622: 'Checking for SR account and party id');
1623: END IF;
1624: if l_interface_tbl(i).sr_incident_id is not null then

Line 1621: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1617: loop
1618: -- step 1.
1619: -- check if there is minimum information required to create the Service request.
1620: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1621: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1622: 'Checking for SR account and party id');
1623: END IF;
1624: if l_interface_tbl(i).sr_incident_id is not null then
1625: -- user has passed incident id. Lets check if it exists in the system.

Line 1805: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1801: -- get the party type.
1802: savepoint create_sr_repair_order;
1803:
1804: -- standard stuff.
1805: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1806: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1807: 'Begin mass create repair orders API');
1808: END IF;
1809: -- standard check for API compatibility.

Line 1806: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1802: savepoint create_sr_repair_order;
1803:
1804: -- standard stuff.
1805: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1806: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1807: 'Begin mass create repair orders API');
1808: END IF;
1809: -- standard check for API compatibility.
1810: IF NOT Fnd_Api.Compatible_API_Call

Line 1960: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

1956: end if;
1957:
1958: -- create RO
1959: -- case1. revision controlled item.
1960: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1961: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1962: 'Try to default in the Revision if its not entered');
1963: END IF;
1964: if p_rev_ctrl_flag <> 1 then

Line 1961: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

1957:
1958: -- create RO
1959: -- case1. revision controlled item.
1960: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1961: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
1962: 'Try to default in the Revision if its not entered');
1963: END IF;
1964: if p_rev_ctrl_flag <> 1 then
1965: if p_repln_rec.item_revision is null and p_repln_rec.serial_number is not null then

Line 2044: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2040: from cs_incidents_all_b
2041: where incident_id = x_incident_id;
2042: end if;
2043:
2044: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2045: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2046: 'Calling Create a new instance API');
2047: END IF;
2048: l_instance_rec.party_site_use_id := g_install_site_use_id;

Line 2045: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2041: where incident_id = x_incident_id;
2042: end if;
2043:
2044: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2045: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2046: 'Calling Create a new instance API');
2047: END IF;
2048: l_instance_rec.party_site_use_id := g_install_site_use_id;
2049: l_instance_rec.inventory_item_id := p_repln_rec.inventory_item_id;

Line 2074: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2070: px_instance_rec => l_instance_rec,
2071: x_instance_id => l_instance_id );
2072:
2073: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2074: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2075: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2076: 'Error during instance creation '||x_msg_data);
2077: END IF;
2078:

Line 2075: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2071: x_instance_id => l_instance_id );
2072:
2073: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2074: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2075: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2076: 'Error during instance creation '||x_msg_data);
2077: END IF;
2078:
2079: end if;

Line 2087: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2083: IF l_instance_id IS NOT NULL AND NOT l_create_instance
2084: THEN
2085: -- need to check if the instance is owned by the customer and whether we need to
2086: -- create an instance association.
2087: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2088: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2089: 'Checking for instance relation/ownership.');
2090: END IF;
2091:

Line 2088: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2084: THEN
2085: -- need to check if the instance is owned by the customer and whether we need to
2086: -- create an instance association.
2087: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2088: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2089: 'Checking for instance relation/ownership.');
2090: END IF;
2091:
2092: BEGIN

Line 2106: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2102: WHEN NO_DATA_FOUND THEN
2103: l_relationship := NULL;
2104: END;
2105:
2106: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2107: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2108: 'l_crt_inst_party_relation is '||l_crt_inst_party_relation||' and l_relationship is '||l_relationship);
2109: END IF;
2110:

Line 2107: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2103: l_relationship := NULL;
2104: END;
2105:
2106: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2107: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2108: 'l_crt_inst_party_relation is '||l_crt_inst_party_relation||' and l_relationship is '||l_relationship);
2109: END IF;
2110:
2111: IF l_crt_inst_party_relation IS NOT NULL AND l_relationship IS NULL

Line 2114: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2110:
2111: IF l_crt_inst_party_relation IS NOT NULL AND l_relationship IS NULL
2112: THEN
2113: -- need to create a new association.
2114: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2115: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2116: 'Calling csd_repairs_util.create_inst_party_relation');
2117: END IF;
2118:

Line 2115: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2111: IF l_crt_inst_party_relation IS NOT NULL AND l_relationship IS NULL
2112: THEN
2113: -- need to create a new association.
2114: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2115: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2116: 'Calling csd_repairs_util.create_inst_party_relation');
2117: END IF;
2118:
2119: csd_repairs_util.create_inst_party_relation

Line 2141: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2137:
2138: ELSIF l_crt_inst_party_relation IS NULL AND l_relationship IS NULL
2139: THEN
2140: -- need to change the ownership if the owners differ.
2141: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2142: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2143: 'Checking if the change ownership can be carried out.');
2144: END IF;
2145: -- we use bulk receive change IB owner profile here too. We cannot just go with the

Line 2142: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2138: ELSIF l_crt_inst_party_relation IS NULL AND l_relationship IS NULL
2139: THEN
2140: -- need to change the ownership if the owners differ.
2141: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2142: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2143: 'Checking if the change ownership can be carried out.');
2144: END IF;
2145: -- we use bulk receive change IB owner profile here too. We cannot just go with the
2146: -- function security because in forms there are two popups before the ownership is actually carried out.

Line 2153: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2149: IF l_owner_party_id <> p_sr_rec.sr_party_id
2150: THEN
2151: IF fnd_function.test('CSDREPLN_CHOWN_IB') AND fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'Y'
2152: THEN
2153: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2154: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2155: 'All conditions for change ownership met. Trying to change the instance ownership. Instance id:'||l_instance_id);
2156: END IF;
2157: -- change the ib ownership.

Line 2154: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2150: THEN
2151: IF fnd_function.test('CSDREPLN_CHOWN_IB') AND fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'Y'
2152: THEN
2153: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2154: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2155: 'All conditions for change ownership met. Trying to change the instance ownership. Instance id:'||l_instance_id);
2156: END IF;
2157: -- change the ib ownership.
2158: l_create_tca_rel_in.instance_id := l_instance_id;

Line 2186: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2182: END IF;
2183:
2184: ELSE
2185: -- the change ownership condition not met. exiting.
2186: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2187: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2188: 'Change ownership criteria not met. Make sure the change ownerhsip function is granted and profile CSD_ALWAYS_CREATE_IB_INSTANCE is set to Always create instance');
2189: END IF;
2190:

Line 2187: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2183:
2184: ELSE
2185: -- the change ownership condition not met. exiting.
2186: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2187: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2188: 'Change ownership criteria not met. Make sure the change ownerhsip function is granted and profile CSD_ALWAYS_CREATE_IB_INSTANCE is set to Always create instance');
2189: END IF;
2190:
2191: fnd_message.set_name('CSD', 'CSD_INVALID_CUST_PROD');

Line 2231: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2227: -- if the user hasnt passed the repair type then only default it.
2228: if p_repln_rec.repair_type_id is null then
2229:
2230: l_repair_type_id := null;
2231: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2232: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2233: 'Calling CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE to get default repair type');
2234: END IF;
2235:

Line 2232: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2228: if p_repln_rec.repair_type_id is null then
2229:
2230: l_repair_type_id := null;
2231: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2232: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2233: 'Calling CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE to get default repair type');
2234: END IF;
2235:
2236: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(

Line 2252: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2248: x_msg_data => x_msg_data
2249: );
2250:
2251: if l_default_rule_id is null then
2252: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2253: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2254: 'No Default rules set up for repair type. Fetching it from profile');
2255: END IF;
2256: l_repair_type_id := FND_PROFILE.VALUE('CSD_DEFAULT_REPAIR_TYPE');

Line 2253: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2249: );
2250:
2251: if l_default_rule_id is null then
2252: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2253: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2254: 'No Default rules set up for repair type. Fetching it from profile');
2255: END IF;
2256: l_repair_type_id := FND_PROFILE.VALUE('CSD_DEFAULT_REPAIR_TYPE');
2257: end if;

Line 2291: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2287: end if;
2288: -- get the contract information.
2289: -- we can possibly cache the information here.
2290: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
2291: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2292: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2293: 'Calling CSD_REPAIRS_UTIL.GET_ENTITLEMENTS to get contracts if any.');
2294: END IF;
2295: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(

Line 2292: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2288: -- get the contract information.
2289: -- we can possibly cache the information here.
2290: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
2291: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2292: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2293: 'Calling CSD_REPAIRS_UTIL.GET_ENTITLEMENTS to get contracts if any.');
2294: END IF;
2295: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
2296: p_api_version_number => 1.0,

Line 2340: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2336: End if;
2337: end if;
2338:
2339: -- get the ro pl,currency.
2340: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2341: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2342: 'Calling csd_process_util.get_ro_default_curr_pl for defaulting pricelist and currency');
2343: END IF;
2344:

Line 2341: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2337: end if;
2338:
2339: -- get the ro pl,currency.
2340: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2341: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2342: 'Calling csd_process_util.get_ro_default_curr_pl for defaulting pricelist and currency');
2343: END IF;
2344:
2345: csd_process_util.get_ro_default_curr_pl

Line 2401: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2397: p_repln_rec.repair_mode := l_repair_mode;
2398: p_repln_rec.incident_id := x_incident_id;
2399:
2400: -- call the create repair orders API.
2401: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2402: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2403: 'Just before calling CSD_REPAIRS_PVT.Create_Repair_Order to create repair order');
2404: END IF;
2405: x_repair_line_id := null;

Line 2402: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2398: p_repln_rec.incident_id := x_incident_id;
2399:
2400: -- call the create repair orders API.
2401: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2402: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2403: 'Just before calling CSD_REPAIRS_PVT.Create_Repair_Order to create repair order');
2404: END IF;
2405: x_repair_line_id := null;
2406:

Line 2422: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2418: x_msg_data => x_msg_data
2419: );
2420:
2421: if x_return_status <> fnd_api.g_ret_sts_success then
2422: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2423: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2424: 'Error in creation of repair order for item = '||p_repln_rec.inventory_item_id);
2425: END IF;
2426: raise fnd_api.g_exc_error;

Line 2423: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2419: );
2420:
2421: if x_return_status <> fnd_api.g_ret_sts_success then
2422: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2423: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2424: 'Error in creation of repair order for item = '||p_repln_rec.inventory_item_id);
2425: END IF;
2426: raise fnd_api.g_exc_error;
2427: end if;

Line 2441: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2437: x_msg_count => x_msg_count,
2438: x_msg_data => x_msg_data);
2439:
2440: if x_return_status <> fnd_api.g_ret_sts_success then
2441: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2442: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2443: 'Error in creation of product transaction lines '||x_msg_data);
2444: END IF;
2445: raise fnd_api.g_exc_error;

Line 2442: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2438: x_msg_data => x_msg_data);
2439:
2440: if x_return_status <> fnd_api.g_ret_sts_success then
2441: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2442: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2443: 'Error in creation of product transaction lines '||x_msg_data);
2444: END IF;
2445: raise fnd_api.g_exc_error;
2446: end if;

Line 2453: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2449: commit work;
2450: end if;
2451: exception
2452: when fnd_api.g_exc_error then
2453: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2454: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2455: 'In exec error exception '||x_msg_data);
2456: END IF;
2457: x_return_status := fnd_api.g_ret_sts_error;

Line 2454: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2450: end if;
2451: exception
2452: when fnd_api.g_exc_error then
2453: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2454: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2455: 'In exec error exception '||x_msg_data);
2456: END IF;
2457: x_return_status := fnd_api.g_ret_sts_error;
2458: rollback to create_sr_repair_order;

Line 2460: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2456: END IF;
2457: x_return_status := fnd_api.g_ret_sts_error;
2458: rollback to create_sr_repair_order;
2459: when no_data_found then
2460: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2461: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2462: 'In No data found exception ');
2463: END IF;
2464: x_return_status := fnd_api.g_ret_sts_error;

Line 2461: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2457: x_return_status := fnd_api.g_ret_sts_error;
2458: rollback to create_sr_repair_order;
2459: when no_data_found then
2460: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2461: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2462: 'In No data found exception ');
2463: END IF;
2464: x_return_status := fnd_api.g_ret_sts_error;
2465: rollback to create_sr_repair_order;

Line 2467: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

2463: END IF;
2464: x_return_status := fnd_api.g_ret_sts_error;
2465: rollback to create_sr_repair_order;
2466: when others then
2467: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2468: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2469: 'In when others exception.'||SQLERRM);
2470: END IF;
2471: rollback to create_sr_repair_order;

Line 2468: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,

2464: x_return_status := fnd_api.g_ret_sts_error;
2465: rollback to create_sr_repair_order;
2466: when others then
2467: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2468: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_api_name,
2469: 'In when others exception.'||SQLERRM);
2470: END IF;
2471: rollback to create_sr_repair_order;
2472: raise;

Line 2496: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

2492: x_instance_id_lst csi_datastructures_pub.id_tbl;
2493: x_msg_index_out number;
2494: begin
2495:
2496: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2497: fnd_log.STRING (fnd_log.level_procedure,
2498: lc_api_name,
2499: 'begin');
2500: End if;

Line 2497: fnd_log.STRING (fnd_log.level_procedure,

2493: x_msg_index_out number;
2494: begin
2495:
2496: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2497: fnd_log.STRING (fnd_log.level_procedure,
2498: lc_api_name,
2499: 'begin');
2500: End if;
2501:

Line 2515: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

2511: l_txn_rec.transaction_date := sysdate;
2512: l_txn_rec.source_transaction_date := sysdate;
2513: l_txn_rec.transaction_type_id := 1;
2514: -- call the update item instance API.
2515: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2516: fnd_log.STRING (fnd_log.level_procedure,
2517: lc_api_name,
2518: 'Before calling csi_item_instance_pub.update_item_instance');
2519: End if;

Line 2516: fnd_log.STRING (fnd_log.level_procedure,

2512: l_txn_rec.source_transaction_date := sysdate;
2513: l_txn_rec.transaction_type_id := 1;
2514: -- call the update item instance API.
2515: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2516: fnd_log.STRING (fnd_log.level_procedure,
2517: lc_api_name,
2518: 'Before calling csi_item_instance_pub.update_item_instance');
2519: End if;
2520: csi_item_instance_pub.update_item_instance

Line 2554: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

2550: p_msg_index => j,
2551: p_encoded => 'F',
2552: p_data => x_msg_data,
2553: p_msg_index_out => x_msg_index_out);
2554: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2555: fnd_log.STRING (fnd_log.level_procedure,
2556: lc_api_name,
2557: 'Update external ref err '||x_msg_count||' Message '||x_msg_data);
2558: End if;

Line 2555: fnd_log.STRING (fnd_log.level_procedure,

2551: p_encoded => 'F',
2552: p_data => x_msg_data,
2553: p_msg_index_out => x_msg_index_out);
2554: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2555: fnd_log.STRING (fnd_log.level_procedure,
2556: lc_api_name,
2557: 'Update external ref err '||x_msg_count||' Message '||x_msg_data);
2558: End if;
2559:

Line 2562: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

2558: End if;
2559:
2560: END LOOP;
2561: when no_data_found then
2562: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2563: fnd_log.STRING (fnd_log.level_procedure,
2564: lc_api_name,
2565: 'Cannot get the object version number.Invalid Instance Id passed');
2566: End if;

Line 2563: fnd_log.STRING (fnd_log.level_procedure,

2559:
2560: END LOOP;
2561: when no_data_found then
2562: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2563: fnd_log.STRING (fnd_log.level_procedure,
2564: lc_api_name,
2565: 'Cannot get the object version number.Invalid Instance Id passed');
2566: End if;
2567: end update_external_reference;