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

Line 20: G_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

16: /* R12 Srl reservation changes, end */
17:
18:
19: -- Global variable for storing the debug level
20: G_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
21:
22: /*-------------------------------------------------------------------------------------*/
23: /* Function name: DEBUG */
24: /* Description : Logs the debug message */

Line 44: -- Variables used in FND Log

40: PROCEDURE DEBUG(p_message IN VARCHAR2,
41: p_mod_name IN VARCHAR2,
42: p_severity_level IN NUMBER) IS
43:
44: -- Variables used in FND Log
45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;

Line 45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

41: p_mod_name IN VARCHAR2,
42: p_severity_level IN NUMBER) IS
43:
44: -- Variables used in FND Log
45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

Line 46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

42: p_severity_level IN NUMBER) IS
43:
44: -- Variables used in FND Log
45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
50: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

Line 47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;

43:
44: -- Variables used in FND Log
45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
50: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
51:

Line 48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;

44: -- Variables used in FND Log
45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
50: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
51:
52: BEGIN

Line 49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

45: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
50: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
51:
52: BEGIN
53:

Line 50: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;

46: l_proc_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;
47: l_event_level NUMBER := Fnd_Log.LEVEL_EVENT;
48: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
49: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
50: l_unexp_level NUMBER := Fnd_Log.LEVEL_UNEXPECTED;
51:
52: BEGIN
53:
54: IF p_severity_level = 1

Line 58: Fnd_Log.STRING(l_stat_level, p_mod_name, p_message);

54: IF p_severity_level = 1
55: THEN
56: IF (l_stat_level >= G_debug_level)
57: THEN
58: Fnd_Log.STRING(l_stat_level, p_mod_name, p_message);
59: END IF;
60: ELSIF p_severity_level = 2
61: THEN
62: IF (l_proc_level >= G_debug_level)

Line 64: Fnd_Log.STRING(l_proc_level, p_mod_name, p_message);

60: ELSIF p_severity_level = 2
61: THEN
62: IF (l_proc_level >= G_debug_level)
63: THEN
64: Fnd_Log.STRING(l_proc_level, p_mod_name, p_message);
65: END IF;
66: ELSIF p_severity_level = 3
67: THEN
68: IF (l_event_level >= G_debug_level)

Line 70: Fnd_Log.STRING(l_event_level, p_mod_name, p_message);

66: ELSIF p_severity_level = 3
67: THEN
68: IF (l_event_level >= G_debug_level)
69: THEN
70: Fnd_Log.STRING(l_event_level, p_mod_name, p_message);
71: END IF;
72: ELSIF p_severity_level = 4
73: THEN
74: IF (l_excep_level >= G_debug_level)

Line 76: Fnd_Log.STRING(l_excep_level, p_mod_name, p_message);

72: ELSIF p_severity_level = 4
73: THEN
74: IF (l_excep_level >= G_debug_level)
75: THEN
76: Fnd_Log.STRING(l_excep_level, p_mod_name, p_message);
77: END IF;
78: ELSIF p_severity_level = 5
79: THEN
80: IF (l_error_level >= G_debug_level)

Line 82: Fnd_Log.STRING(l_error_level, p_mod_name, p_message);

78: ELSIF p_severity_level = 5
79: THEN
80: IF (l_error_level >= G_debug_level)
81: THEN
82: Fnd_Log.STRING(l_error_level, p_mod_name, p_message);
83: END IF;
84: ELSIF p_severity_level = 6
85: THEN
86: IF (l_unexp_level >= G_debug_level)

Line 88: Fnd_Log.STRING(l_unexp_level, p_mod_name, p_message);

84: ELSIF p_severity_level = 6
85: THEN
86: IF (l_unexp_level >= G_debug_level)
87: THEN
88: Fnd_Log.STRING(l_unexp_level, p_mod_name, p_message);
89: END IF;
90: END IF;
91:
92: Csd_Gen_Utility_Pvt.add(p_message);

Line 426: -- Variables used in FND Log

422: l_invoice_to_org_id NUMBER; -- nnadig: bug 9395568
423: l_ship_to_org_id NUMBER; -- nnadig: bug 9395568
424:
425:
426: -- Variables used in FND Log
427: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
428: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_charge_lines';
429:
430: BEGIN

Line 427: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

423: l_ship_to_org_id NUMBER; -- nnadig: bug 9395568
424:
425:
426: -- Variables used in FND Log
427: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
428: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_charge_lines';
429:
430: BEGIN
431: Debug('At the Beginning of process_charge_lines', l_mod_name, 1);

Line 1204: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

1200:
1201: /********************************************************
1202: procedure dbg_print_stack(p_msg_count number, p_mod_name varchar2) is
1203: l_msg varchar2(2000);
1204: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
1205:
1206: begin
1207: IF p_MSG_COUNT > 1 THEN
1208: FOR i IN 1..p_MSG_COUNT LOOP

Line 1210: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);

1206: begin
1207: IF p_MSG_COUNT > 1 THEN
1208: FOR i IN 1..p_MSG_COUNT LOOP
1209: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;
1210: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);
1211: END LOOP ;
1212: ELSE
1213: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;
1214: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);

Line 1214: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);

1210: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);
1211: END LOOP ;
1212: ELSE
1213: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;
1214: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);
1215: END IF ;
1216:
1217: end dbg_print_stack;
1218: ************************************************************/

Line 1390: -- Variables used in FND Log

1386: SELECT org_id
1387: FROM oe_order_headers_all
1388: WHERE header_id = p_header_id;
1389:
1390: -- Variables used in FND Log
1391: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
1392: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1393:
1394: /* pick release rule api changes/srl reservations changes *

Line 1391: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

1387: FROM oe_order_headers_all
1388: WHERE header_id = p_header_id;
1389:
1390: -- Variables used in FND Log
1391: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
1392: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1393:
1394: /* pick release rule api changes/srl reservations changes *
1395: */

Line 2440: -- Variables used in FND Log

2436: AND SYSDATE BETWEEN NVL(start_Date_Active, SYSDATE) AND
2437: NVL(end_Date_active, SYSDATE + 1);
2438: --R12 Development Changes End
2439:
2440: -- Variables used in FND Log
2441: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2442: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2443: l_tmp_char VARCHAR2(1); --R12 Development Changes
2444: /* R12 SN reservations integration change Begin */

Line 2441: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

2437: NVL(end_Date_active, SYSDATE + 1);
2438: --R12 Development Changes End
2439:
2440: -- Variables used in FND Log
2441: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2442: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2443: l_tmp_char VARCHAR2(1); --R12 Development Changes
2444: /* R12 SN reservations integration change Begin */
2445: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

Line 4697: -- Variables used in FND Log

4693: AND order_header_id IS NULL
4694: AND order_line_id IS NULL;
4695:
4696:
4697: -- Variables used in FND Log
4698: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4699: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4700: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4701:

Line 4698: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

4694: AND order_line_id IS NULL;
4695:
4696:
4697: -- Variables used in FND Log
4698: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4699: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4700: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4701:
4702: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';

Line 4699: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;

4695:
4696:
4697: -- Variables used in FND Log
4698: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4699: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4700: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4701:
4702: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';
4703:

Line 4700: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

4696:
4697: -- Variables used in FND Log
4698: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4699: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4700: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4701:
4702: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';
4703:
4704: BEGIN

Line 8224: -- define variables to define fnd_log debug levels

8220: C_Yes CONSTANT VARCHAR2(1) := 'Y';
8221: C_No CONSTANT VARCHAR2(1) := 'N';
8222: C_Zero CONSTANT NUMBER := 0;
8223:
8224: -- define variables to define fnd_log debug levels
8225: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8226: -- examples : 1- copying buffer x to y : low level detailed messages
8227: l_statement_level NUMBER := Fnd_Log.level_statement;
8228: -- examples : 2- key progress events : starting business transactions

Line 8225: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;

8221: C_No CONSTANT VARCHAR2(1) := 'N';
8222: C_Zero CONSTANT NUMBER := 0;
8223:
8224: -- define variables to define fnd_log debug levels
8225: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8226: -- examples : 1- copying buffer x to y : low level detailed messages
8227: l_statement_level NUMBER := Fnd_Log.level_statement;
8228: -- examples : 2- key progress events : starting business transactions
8229: l_procedure_level NUMBER := Fnd_Log.level_procedure;

Line 8227: l_statement_level NUMBER := Fnd_Log.level_statement;

8223:
8224: -- define variables to define fnd_log debug levels
8225: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8226: -- examples : 1- copying buffer x to y : low level detailed messages
8227: l_statement_level NUMBER := Fnd_Log.level_statement;
8228: -- examples : 2- key progress events : starting business transactions
8229: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8230: -- examples : 3- event : calling an api, key progress events
8231: l_event_level NUMBER := Fnd_Log.level_event;

Line 8229: l_procedure_level NUMBER := Fnd_Log.level_procedure;

8225: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8226: -- examples : 1- copying buffer x to y : low level detailed messages
8227: l_statement_level NUMBER := Fnd_Log.level_statement;
8228: -- examples : 2- key progress events : starting business transactions
8229: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8230: -- examples : 3- event : calling an api, key progress events
8231: l_event_level NUMBER := Fnd_Log.level_event;
8232: -- examples : 4- exception internal software failure condition
8233: l_exception_level NUMBER := Fnd_Log.level_exception;

Line 8231: l_event_level NUMBER := Fnd_Log.level_event;

8227: l_statement_level NUMBER := Fnd_Log.level_statement;
8228: -- examples : 2- key progress events : starting business transactions
8229: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8230: -- examples : 3- event : calling an api, key progress events
8231: l_event_level NUMBER := Fnd_Log.level_event;
8232: -- examples : 4- exception internal software failure condition
8233: l_exception_level NUMBER := Fnd_Log.level_exception;
8234: -- examples : 5- error end user erros
8235: l_error_level NUMBER := Fnd_Log.level_error;

Line 8233: l_exception_level NUMBER := Fnd_Log.level_exception;

8229: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8230: -- examples : 3- event : calling an api, key progress events
8231: l_event_level NUMBER := Fnd_Log.level_event;
8232: -- examples : 4- exception internal software failure condition
8233: l_exception_level NUMBER := Fnd_Log.level_exception;
8234: -- examples : 5- error end user erros
8235: l_error_level NUMBER := Fnd_Log.level_error;
8236: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_iro_product_txn';
8237:

Line 8235: l_error_level NUMBER := Fnd_Log.level_error;

8231: l_event_level NUMBER := Fnd_Log.level_event;
8232: -- examples : 4- exception internal software failure condition
8233: l_exception_level NUMBER := Fnd_Log.level_exception;
8234: -- examples : 5- error end user erros
8235: l_error_level NUMBER := Fnd_Log.level_error;
8236: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_iro_product_txn';
8237:
8238: -- a variable whose value tells us whether order header can be pick released or not.
8239: l_order_to_be_pickreleased VARCHAR2(1) := C_NO;

Line 8302: Fnd_Log.string(l_statement_level, l_module_name, 'begin');

8298:
8299: BEGIN
8300: IF l_statement_level >= l_debug_level
8301: THEN
8302: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
8303: END IF;
8304: -- standard start of api savepoint
8305: SAVEPOINT update_iro_product_txn;
8306: IF l_statement_level >= l_debug_level

Line 8308: Fnd_Log.string(l_statement_level,

8304: -- standard start of api savepoint
8305: SAVEPOINT update_iro_product_txn;
8306: IF l_statement_level >= l_debug_level
8307: THEN
8308: Fnd_Log.string(l_statement_level,
8309: l_module_name,
8310: 'checking api compatibility');
8311: END IF;
8312: -- standard call to check for call compatibility.

Line 8320: Fnd_Log.string(l_exception_level,

8316: g_pkg_name)
8317: THEN
8318: IF l_exception_level >= l_debug_level
8319: THEN
8320: Fnd_Log.string(l_exception_level,
8321: l_module_name,
8322: 'checking api compatibility, was unsuccessful');
8323: END IF;
8324: RAISE Fnd_Api.g_exc_unexpected_error;

Line 8328: Fnd_Log.string(l_statement_level,

8324: RAISE Fnd_Api.g_exc_unexpected_error;
8325: END IF;
8326: IF l_statement_level >= l_debug_level
8327: THEN
8328: Fnd_Log.string(l_statement_level,
8329: l_module_name,
8330: 'checking api compatibility, was successful');
8331: END IF;
8332:

Line 8344: Fnd_Log.String(l_Statement_Level,

8340: x_return_status := Fnd_Api.g_ret_sts_success;
8341:
8342: IF l_statement_level >= l_debug_level
8343: THEN
8344: Fnd_Log.String(l_Statement_Level,
8345: l_Module_Name,
8346: 'Product Transaction Record Values:');
8347: Fnd_Log.String(l_Statement_Level,
8348: l_Module_Name,

Line 8347: Fnd_Log.String(l_Statement_Level,

8343: THEN
8344: Fnd_Log.String(l_Statement_Level,
8345: l_Module_Name,
8346: 'Product Transaction Record Values:');
8347: Fnd_Log.String(l_Statement_Level,
8348: l_Module_Name,
8349: 'Product Transaction Id :' ||
8350: x_product_txn_rec.Product_Transaction_Id);
8351: Fnd_Log.String(l_Statement_Level,

Line 8351: Fnd_Log.String(l_Statement_Level,

8347: Fnd_Log.String(l_Statement_Level,
8348: l_Module_Name,
8349: 'Product Transaction Id :' ||
8350: x_product_txn_rec.Product_Transaction_Id);
8351: Fnd_Log.String(l_Statement_Level,
8352: l_Module_Name,
8353: 'Repair_line_id :' ||
8354: x_product_txn_rec.repair_line_id);
8355: Fnd_Log.String(l_Statement_Level,

Line 8355: Fnd_Log.String(l_Statement_Level,

8351: Fnd_Log.String(l_Statement_Level,
8352: l_Module_Name,
8353: 'Repair_line_id :' ||
8354: x_product_txn_rec.repair_line_id);
8355: Fnd_Log.String(l_Statement_Level,
8356: l_Module_Name,
8357: 'Action_type :' ||
8358: x_product_txn_rec.action_type);
8359: Fnd_Log.String(l_Statement_Level,

Line 8359: Fnd_Log.String(l_Statement_Level,

8355: Fnd_Log.String(l_Statement_Level,
8356: l_Module_Name,
8357: 'Action_type :' ||
8358: x_product_txn_rec.action_type);
8359: Fnd_Log.String(l_Statement_Level,
8360: l_Module_Name,
8361: 'Action_code :' ||
8362: x_product_txn_rec.action_code);
8363: Fnd_Log.String(l_Statement_Level,

Line 8363: Fnd_Log.String(l_Statement_Level,

8359: Fnd_Log.String(l_Statement_Level,
8360: l_Module_Name,
8361: 'Action_code :' ||
8362: x_product_txn_rec.action_code);
8363: Fnd_Log.String(l_Statement_Level,
8364: l_Module_Name,
8365: 'Incident_id :' ||
8366: x_product_txn_rec.incident_id);
8367: Fnd_Log.String(l_Statement_Level,

Line 8367: Fnd_Log.String(l_Statement_Level,

8363: Fnd_Log.String(l_Statement_Level,
8364: l_Module_Name,
8365: 'Incident_id :' ||
8366: x_product_txn_rec.incident_id);
8367: Fnd_Log.String(l_Statement_Level,
8368: l_Module_Name,
8369: 'line_type_id :' ||
8370: x_product_txn_rec.line_type_id);
8371: Fnd_Log.String(l_Statement_Level,

Line 8371: Fnd_Log.String(l_Statement_Level,

8367: Fnd_Log.String(l_Statement_Level,
8368: l_Module_Name,
8369: 'line_type_id :' ||
8370: x_product_txn_rec.line_type_id);
8371: Fnd_Log.String(l_Statement_Level,
8372: l_Module_Name,
8373: 'Order_number :' ||
8374: x_product_txn_rec.order_number);
8375: Fnd_Log.String(l_Statement_Level,

Line 8375: Fnd_Log.String(l_Statement_Level,

8371: Fnd_Log.String(l_Statement_Level,
8372: l_Module_Name,
8373: 'Order_number :' ||
8374: x_product_txn_rec.order_number);
8375: Fnd_Log.String(l_Statement_Level,
8376: l_Module_Name,
8377: 'Status :' ||
8378: x_product_txn_rec.status);
8379: Fnd_Log.String(l_Statement_Level,

Line 8379: Fnd_Log.String(l_Statement_Level,

8375: Fnd_Log.String(l_Statement_Level,
8376: l_Module_Name,
8377: 'Status :' ||
8378: x_product_txn_rec.status);
8379: Fnd_Log.String(l_Statement_Level,
8380: l_Module_Name,
8381: 'Currency_code :' ||
8382: x_product_txn_rec.currency_code);
8383: Fnd_Log.String(l_Statement_Level,

Line 8383: Fnd_Log.String(l_Statement_Level,

8379: Fnd_Log.String(l_Statement_Level,
8380: l_Module_Name,
8381: 'Currency_code :' ||
8382: x_product_txn_rec.currency_code);
8383: Fnd_Log.String(l_Statement_Level,
8384: l_Module_Name,
8385: 'Unit_of_measure_code :' ||
8386: x_product_txn_rec.unit_of_measure_code);
8387: Fnd_Log.String(l_Statement_Level,

Line 8387: Fnd_Log.String(l_Statement_Level,

8383: Fnd_Log.String(l_Statement_Level,
8384: l_Module_Name,
8385: 'Unit_of_measure_code :' ||
8386: x_product_txn_rec.unit_of_measure_code);
8387: Fnd_Log.String(l_Statement_Level,
8388: l_Module_Name,
8389: 'Inventory_item_id :' ||
8390: x_product_txn_rec.inventory_item_id);
8391: Fnd_Log.String(l_Statement_Level,

Line 8391: Fnd_Log.String(l_Statement_Level,

8387: Fnd_Log.String(l_Statement_Level,
8388: l_Module_Name,
8389: 'Inventory_item_id :' ||
8390: x_product_txn_rec.inventory_item_id);
8391: Fnd_Log.String(l_Statement_Level,
8392: l_Module_Name,
8393: 'Revision :' ||
8394: x_product_txn_rec.revision);
8395: Fnd_Log.String(l_Statement_Level,

Line 8395: Fnd_Log.String(l_Statement_Level,

8391: Fnd_Log.String(l_Statement_Level,
8392: l_Module_Name,
8393: 'Revision :' ||
8394: x_product_txn_rec.revision);
8395: Fnd_Log.String(l_Statement_Level,
8396: l_Module_Name,
8397: 'Quantity :' ||
8398: x_product_txn_rec.quantity);
8399: Fnd_Log.String(l_Statement_Level,

Line 8399: Fnd_Log.String(l_Statement_Level,

8395: Fnd_Log.String(l_Statement_Level,
8396: l_Module_Name,
8397: 'Quantity :' ||
8398: x_product_txn_rec.quantity);
8399: Fnd_Log.String(l_Statement_Level,
8400: l_Module_Name,
8401: 'Price_list_id :' ||
8402: x_product_txn_rec.price_list_id);
8403: Fnd_Log.String(l_Statement_Level,

Line 8403: Fnd_Log.String(l_Statement_Level,

8399: Fnd_Log.String(l_Statement_Level,
8400: l_Module_Name,
8401: 'Price_list_id :' ||
8402: x_product_txn_rec.price_list_id);
8403: Fnd_Log.String(l_Statement_Level,
8404: l_Module_Name,
8405: 'Source Organization_id :' ||
8406: x_product_txn_rec.organization_id);
8407: Fnd_Log.String(l_Statement_Level,

Line 8407: Fnd_Log.String(l_Statement_Level,

8403: Fnd_Log.String(l_Statement_Level,
8404: l_Module_Name,
8405: 'Source Organization_id :' ||
8406: x_product_txn_rec.organization_id);
8407: Fnd_Log.String(l_Statement_Level,
8408: l_Module_Name,
8409: 'Interface_to_om_flag :' ||
8410: x_product_txn_rec.interface_to_om_flag);
8411: Fnd_Log.String(l_Statement_Level,

Line 8411: Fnd_Log.String(l_Statement_Level,

8407: Fnd_Log.String(l_Statement_Level,
8408: l_Module_Name,
8409: 'Interface_to_om_flag :' ||
8410: x_product_txn_rec.interface_to_om_flag);
8411: Fnd_Log.String(l_Statement_Level,
8412: l_Module_Name,
8413: 'Book_sales_order_flag :' ||
8414: x_product_txn_rec.book_sales_order_flag);
8415: Fnd_Log.String(l_Statement_Level,

Line 8415: Fnd_Log.String(l_Statement_Level,

8411: Fnd_Log.String(l_Statement_Level,
8412: l_Module_Name,
8413: 'Book_sales_order_flag :' ||
8414: x_product_txn_rec.book_sales_order_flag);
8415: Fnd_Log.String(l_Statement_Level,
8416: l_Module_Name,
8417: 'Release_sales_order_flag :' ||
8418: x_product_txn_rec.release_sales_order_flag);
8419: Fnd_Log.String(l_Statement_Level,

Line 8419: Fnd_Log.String(l_Statement_Level,

8415: Fnd_Log.String(l_Statement_Level,
8416: l_Module_Name,
8417: 'Release_sales_order_flag :' ||
8418: x_product_txn_rec.release_sales_order_flag);
8419: Fnd_Log.String(l_Statement_Level,
8420: l_Module_Name,
8421: 'Ship_sales_order_flag :' ||
8422: x_product_txn_rec.ship_sales_order_flag);
8423: Fnd_Log.String(l_Statement_Level,

Line 8423: Fnd_Log.String(l_Statement_Level,

8419: Fnd_Log.String(l_Statement_Level,
8420: l_Module_Name,
8421: 'Ship_sales_order_flag :' ||
8422: x_product_txn_rec.ship_sales_order_flag);
8423: Fnd_Log.String(l_Statement_Level,
8424: l_Module_Name,
8425: 'Process_txn_flag :' ||
8426: x_product_txn_rec.process_txn_flag);
8427: Fnd_Log.String(l_Statement_Level,

Line 8427: Fnd_Log.String(l_Statement_Level,

8423: Fnd_Log.String(l_Statement_Level,
8424: l_Module_Name,
8425: 'Process_txn_flag :' ||
8426: x_product_txn_rec.process_txn_flag);
8427: Fnd_Log.String(l_Statement_Level,
8428: l_Module_Name,
8429: 'Object_version_number :' ||
8430: x_product_txn_rec.object_version_number);
8431: END IF;

Line 8435: Fnd_Log.string(l_statement_level,

8431: END IF;
8432:
8433: IF l_statement_level >= l_debug_level
8434: THEN
8435: Fnd_Log.string(l_statement_level,
8436: l_module_name || '.check_in_parameters',
8437: 'product txn id is:' ||
8438: x_product_txn_rec.product_transaction_id);
8439: END IF;

Line 8448: Fnd_Log.string(l_statement_level,

8444: p_api_name => l_api_name);
8445:
8446: IF l_statement_level >= l_debug_level
8447: THEN
8448: Fnd_Log.string(l_statement_level,
8449: l_module_name || '.check_in_parameters',
8450: 'product txn id is valid');
8451: END IF;
8452:

Line 8459: Fnd_Log.string(l_exception_level,

8455: (Csd_Process_Util.validate_prod_txn_id(p_prod_txn_id => x_product_txn_rec.product_transaction_id))
8456: THEN
8457: IF l_exception_level >= l_debug_level
8458: THEN
8459: Fnd_Log.string(l_exception_level,
8460: l_module_name || '.check_in_parameters',
8461: 'product txn id is not valid ');
8462: END IF;
8463: RAISE Fnd_Api.g_exc_error;

Line 8467: Fnd_Log.string(l_statement_level,

8463: RAISE Fnd_Api.g_exc_error;
8464: END IF;
8465: IF l_statement_level >= l_debug_level
8466: THEN
8467: Fnd_Log.string(l_statement_level,
8468: l_module_name || '.check_in_parameters',
8469: 'product txn id is valid ');
8470: END IF;
8471:

Line 8484: Fnd_Log.string(l_statement_level,

8480: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
8481: AND lookup_code = x_product_txn_rec.prod_txn_status;
8482: IF l_statement_level >= l_debug_level
8483: THEN
8484: Fnd_Log.string(l_statement_level,
8485: l_module_name || '.check_in_parameters',
8486: 'Product txn status is valid : ' ||
8487: x_product_txn_rec.prod_txn_status);
8488: END IF;

Line 8494: Fnd_Log.string(l_exception_level,

8490: WHEN NO_DATA_FOUND THEN
8491: Fnd_Message.set_name('CSD', 'CSD_ERR_PROD_TXN_STATUS');
8492: IF l_exception_level >= l_debug_level
8493: THEN
8494: Fnd_Log.string(l_exception_level,
8495: l_module_name ||
8496: '.check_in_parameters',
8497: 'Product txn status is invalid : ' ||
8498: x_product_txn_rec.prod_txn_status);

Line 8514: Fnd_Log.string(l_exception_level,

8510: (Csd_Process_Util.validate_action_type(p_action_type => x_product_txn_rec.action_type))
8511: THEN
8512: IF l_exception_level >= l_debug_level
8513: THEN
8514: Fnd_Log.string(l_exception_level,
8515: l_module_name || '.check_in_parameters',
8516: 'Action Type s invalid : ' ||
8517: x_product_txn_rec.Action_Type);
8518: END IF;

Line 8532: Fnd_Log.string(l_exception_level,

8528: (Csd_Process_Util.validate_action_code(p_action_code => x_product_txn_rec.action_code))
8529: THEN
8530: IF l_exception_level >= l_debug_level
8531: THEN
8532: Fnd_Log.string(l_exception_level,
8533: l_module_name || '.check_in_parameters',
8534: 'Action Code is invalid : ' ||
8535: x_product_txn_rec.Action_Code);
8536: END IF;

Line 8558: Fnd_Log.string(l_exception_level,

8554: IF x_product_txn_rec.repair_line_id <> l_repair_line_id
8555: THEN
8556: IF l_exception_level >= l_debug_level
8557: THEN
8558: Fnd_Log.string(l_exception_level,
8559: l_module_name || '.check_in_parameters',
8560: 'Repair Line id can not be changed');
8561: END IF;
8562: RAISE Fnd_Api.g_exc_error;

Line 8585: Fnd_Log.string(l_statement_level,

8581: l_repair_line_id);
8582: Fnd_Msg_Pub.ADD;
8583: IF l_statement_level >= l_debug_level
8584: THEN
8585: Fnd_Log.string(l_statement_level,
8586: l_module_name ||
8587: '.check_in_parameters',
8588: 'Invalid repair line id ' ||
8589: x_product_txn_rec.repair_line_id);

Line 8657: Fnd_Log.string(l_Statement_level,

8653: END IF;
8654: -- fnd_profile.get('csd_def_pick_release_rule',l_picking_rule_id);
8655: IF l_Statement_level >= l_debug_level
8656: THEN
8657: Fnd_Log.string(l_Statement_level,
8658: l_module_name,
8659: 'Default picking rule id :' ||
8660: l_Picking_Rule_Id);
8661: END IF;

Line 8680: Fnd_Log.string(l_exception_level,

8676: l_picking_rule_id);
8677: Fnd_Msg_Pub.ADD;
8678: IF l_exception_level >= l_debug_level
8679: THEN
8680: Fnd_Log.string(l_exception_level,
8681: l_module_name,
8682: ' Default picking rule id not found');
8683: END IF;
8684: RAISE release_order_excep;

Line 8701: Fnd_Log.string(l_statement_level,

8697: (c_ready_for_release, c_backordered)
8698: AND ROWNUM < 2;
8699: IF l_statement_level >= l_debug_level
8700: THEN
8701: Fnd_Log.string(l_statement_level,
8702: l_module_name,
8703: 'There are lines eligible for pick release');
8704: END IF;
8705: EXCEPTION

Line 8711: Fnd_Log.string(l_statement_level,

8707: -- there are no records to be pick released using public api
8708: l_order_to_be_pickreleased := C_No;
8709: IF l_statement_level >= l_debug_level
8710: THEN
8711: Fnd_Log.string(l_statement_level,
8712: l_module_name,
8713: 'There are no lines eligible for pick releas');
8714: END IF;
8715: END;

Line 8721: Fnd_Log.string(l_statement_level,

8717: IF l_order_to_be_pickreleased = C_Yes
8718: THEN
8719: IF l_statement_level >= l_debug_level
8720: THEN
8721: Fnd_Log.string(l_statement_level,
8722: l_module_name,
8723: 'Calling process_sales_order to release so');
8724: END IF;
8725: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,

Line 8738: Fnd_Log.string(l_exception_level,

8734: IF (x_return_status = Fnd_Api.g_ret_sts_error)
8735: THEN
8736: IF l_exception_level >= l_debug_level
8737: THEN
8738: Fnd_Log.string(l_exception_level,
8739: l_module_name,
8740: 'csd_process_pvt.process_sales_order failed');
8741: END IF;
8742: RAISE release_order_excep;

Line 8746: Fnd_Log.string(l_statement_level,

8742: RAISE release_order_excep;
8743: ELSE
8744: IF l_statement_level >= l_debug_level
8745: THEN
8746: Fnd_Log.string(l_statement_level,
8747: l_module_name,
8748: 'process_sales_order was successful');
8749: END IF;
8750: END IF; -- X_Return_Status is Error

Line 8769: Fnd_Log.string(l_statement_level,

8765: (c_ready_for_release, c_backordered,
8766: c_release_to_warehouse);
8767: IF l_statement_level >= l_debug_level
8768: THEN
8769: Fnd_Log.string(l_statement_level,
8770: l_module_name,
8771: 'Still there are some lines to be pick released');
8772: END IF;
8773: EXCEPTION

Line 8778: Fnd_Log.string(l_statement_level,

8774: WHEN NO_DATA_FOUND THEN
8775: l_order_to_Be_PickReleased := 'N';
8776: IF l_statement_level >= l_debug_level
8777: THEN
8778: Fnd_Log.string(l_statement_level,
8779: l_module_name,
8780: 'There are no lines to be pick released');
8781: END IF;
8782: WHEN TOO_MANY_ROWS THEN

Line 8785: Fnd_Log.string(l_statement_level,

8781: END IF;
8782: WHEN TOO_MANY_ROWS THEN
8783: IF l_statement_level >= l_debug_level
8784: THEN
8785: Fnd_Log.string(l_statement_level,
8786: l_module_name,
8787: 'More then one line to be pick released');
8788: END IF;
8789: l_order_to_Be_PickReleased := 'Y';

Line 8816: Fnd_Log.string(l_statement_level,

8812: THEN
8813: -- Product Transaction records are updated.
8814: IF l_statement_level >= l_debug_level
8815: THEN
8816: Fnd_Log.string(l_statement_level,
8817: l_module_name,
8818: 'Product transaction records are updated with Released Status');
8819: Fnd_Log.string(l_statement_level,
8820: l_module_name,

Line 8819: Fnd_Log.string(l_statement_level,

8815: THEN
8816: Fnd_Log.string(l_statement_level,
8817: l_module_name,
8818: 'Product transaction records are updated with Released Status');
8819: Fnd_Log.string(l_statement_level,
8820: l_module_name,
8821: 'Internal Order header id :' ||
8822: x_product_txn_rec.order_header_id);
8823: Fnd_Log.string(l_statement_level,

Line 8823: Fnd_Log.string(l_statement_level,

8819: Fnd_Log.string(l_statement_level,
8820: l_module_name,
8821: 'Internal Order header id :' ||
8822: x_product_txn_rec.order_header_id);
8823: Fnd_Log.string(l_statement_level,
8824: l_module_name,
8825: 'Internal Order Line id :' ||
8826: x_product_txn_rec.order_Line_id);
8827: END IF;

Line 8849: Fnd_Log.string(l_statement_level,

8845: ELSE
8846: -- No Product Transaction records are updated.
8847: IF l_statement_level >= l_debug_level
8848: THEN
8849: Fnd_Log.string(l_statement_level,
8850: l_module_name,
8851: 'No valid product transaction record found to update release status');
8852: Fnd_Log.string(l_statement_level,
8853: l_module_name,

Line 8852: Fnd_Log.string(l_statement_level,

8848: THEN
8849: Fnd_Log.string(l_statement_level,
8850: l_module_name,
8851: 'No valid product transaction record found to update release status');
8852: Fnd_Log.string(l_statement_level,
8853: l_module_name,
8854: 'Internal Order header id :' ||
8855: x_product_txn_rec.order_header_id);
8856: Fnd_Log.string(l_statement_level,

Line 8856: Fnd_Log.string(l_statement_level,

8852: Fnd_Log.string(l_statement_level,
8853: l_module_name,
8854: 'Internal Order header id :' ||
8855: x_product_txn_rec.order_header_id);
8856: Fnd_Log.string(l_statement_level,
8857: l_module_name,
8858: 'Internal Order Line id :' ||
8859: x_product_txn_rec.order_Line_id);
8860: END IF;

Line 8905: Fnd_Log.string(l_statement_level,

8901: l_order_rec.order_line_id);
8902: Fnd_Msg_Pub.ADD;
8903: IF l_statement_level >= l_debug_level
8904: THEN
8905: Fnd_Log.string(l_statement_level,
8906: l_module_name,
8907: 'Order line id ' ||
8908: l_Order_rec.Order_Line_id ||
8909: ' is not eligible for shipping.');

Line 8920: Fnd_Log.string(l_statement_level,

8916: l_order_rec.order_line_id);
8917: Fnd_Msg_Pub.ADD;
8918: IF l_statement_level >= l_debug_level
8919: THEN
8920: Fnd_Log.string(l_statement_level,
8921: l_module_name,
8922: 'Order line id ' ||
8923: l_Order_rec.Order_Line_id ||
8924: ' has more then one delivery lines.');

Line 8932: Fnd_Log.string(l_statement_level,

8928: IF l_Released_Status = C_Staged_PickConfirmed
8929: THEN
8930: IF l_statement_level >= l_debug_level
8931: THEN
8932: Fnd_Log.string(l_statement_level,
8933: l_module_name,
8934: 'Calling Process Sales Order API');
8935: END IF;
8936: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,

Line 8949: Fnd_Log.string(l_statement_level,

8945: IF NOT (x_return_status = Fnd_Api.g_ret_sts_success)
8946: THEN
8947: IF l_statement_level >= l_debug_level
8948: THEN
8949: Fnd_Log.string(l_statement_level,
8950: l_module_name,
8951: ' process sales order failed');
8952: END IF;
8953: RAISE ship_order_excep;

Line 9004: Fnd_Log.string(l_statement_level,

9000: THEN
9001: -- Product Transaction records are updated.
9002: IF l_statement_level >= l_debug_level
9003: THEN
9004: Fnd_Log.string(l_statement_level,
9005: l_module_name,
9006: 'Product transaction records are updated with Shipped Status');
9007: Fnd_Log.string(l_statement_level,
9008: l_module_name,

Line 9007: Fnd_Log.string(l_statement_level,

9003: THEN
9004: Fnd_Log.string(l_statement_level,
9005: l_module_name,
9006: 'Product transaction records are updated with Shipped Status');
9007: Fnd_Log.string(l_statement_level,
9008: l_module_name,
9009: 'Internal Order header id :' ||
9010: x_product_txn_rec.order_header_id);
9011: Fnd_Log.string(l_statement_level,

Line 9011: Fnd_Log.string(l_statement_level,

9007: Fnd_Log.string(l_statement_level,
9008: l_module_name,
9009: 'Internal Order header id :' ||
9010: x_product_txn_rec.order_header_id);
9011: Fnd_Log.string(l_statement_level,
9012: l_module_name,
9013: 'Internal Order Line id :' ||
9014: x_product_txn_rec.order_Line_id);
9015: END IF;

Line 9039: Fnd_Log.string(l_statement_level,

9035: ELSE
9036: -- No Product Transaction records are updated.
9037: IF l_statement_level >= l_debug_level
9038: THEN
9039: Fnd_Log.string(l_statement_level,
9040: l_module_name,
9041: 'No valid product transaction record found to update to shipped status');
9042: Fnd_Log.string(l_statement_level,
9043: l_module_name,

Line 9042: Fnd_Log.string(l_statement_level,

9038: THEN
9039: Fnd_Log.string(l_statement_level,
9040: l_module_name,
9041: 'No valid product transaction record found to update to shipped status');
9042: Fnd_Log.string(l_statement_level,
9043: l_module_name,
9044: 'Internal Order header id :' ||
9045: x_product_txn_rec.order_header_id);
9046: Fnd_Log.string(l_statement_level,

Line 9046: Fnd_Log.string(l_statement_level,

9042: Fnd_Log.string(l_statement_level,
9043: l_module_name,
9044: 'Internal Order header id :' ||
9045: x_product_txn_rec.order_header_id);
9046: Fnd_Log.string(l_statement_level,
9047: l_module_name,
9048: 'Internal Order Line id :' ||
9049: x_product_txn_rec.order_Line_id);
9050: END IF;

Line 9424: -- define variables to define fnd_log debug levels

9420: l_applicable_qa_plans VARCHAR2(1);
9421: l_plan_txn_ids VARCHAR2(5000);
9422: l_dummy_char VARCHAR2(32000);
9423:
9424: -- define variables to define fnd_log debug levels
9425: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9426: -- examples : 1- copying buffer x to y : low level detailed messages
9427: l_statement_level NUMBER := Fnd_Log.level_statement;
9428: -- examples : 2- key progress events : starting business transactions

Line 9425: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;

9421: l_plan_txn_ids VARCHAR2(5000);
9422: l_dummy_char VARCHAR2(32000);
9423:
9424: -- define variables to define fnd_log debug levels
9425: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9426: -- examples : 1- copying buffer x to y : low level detailed messages
9427: l_statement_level NUMBER := Fnd_Log.level_statement;
9428: -- examples : 2- key progress events : starting business transactions
9429: l_procedure_level NUMBER := Fnd_Log.level_procedure;

Line 9427: l_statement_level NUMBER := Fnd_Log.level_statement;

9423:
9424: -- define variables to define fnd_log debug levels
9425: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9426: -- examples : 1- copying buffer x to y : low level detailed messages
9427: l_statement_level NUMBER := Fnd_Log.level_statement;
9428: -- examples : 2- key progress events : starting business transactions
9429: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9430: -- examples : 3- event : calling an api, key progress events
9431: l_event_level NUMBER := Fnd_Log.level_event;

Line 9429: l_procedure_level NUMBER := Fnd_Log.level_procedure;

9425: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9426: -- examples : 1- copying buffer x to y : low level detailed messages
9427: l_statement_level NUMBER := Fnd_Log.level_statement;
9428: -- examples : 2- key progress events : starting business transactions
9429: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9430: -- examples : 3- event : calling an api, key progress events
9431: l_event_level NUMBER := Fnd_Log.level_event;
9432: -- examples : 4- exception internal software failure condition
9433: l_exception_level NUMBER := Fnd_Log.level_exception;

Line 9431: l_event_level NUMBER := Fnd_Log.level_event;

9427: l_statement_level NUMBER := Fnd_Log.level_statement;
9428: -- examples : 2- key progress events : starting business transactions
9429: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9430: -- examples : 3- event : calling an api, key progress events
9431: l_event_level NUMBER := Fnd_Log.level_event;
9432: -- examples : 4- exception internal software failure condition
9433: l_exception_level NUMBER := Fnd_Log.level_exception;
9434: -- examples : 5- error end user erros
9435: l_error_level NUMBER := Fnd_Log.level_error;

Line 9433: l_exception_level NUMBER := Fnd_Log.level_exception;

9429: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9430: -- examples : 3- event : calling an api, key progress events
9431: l_event_level NUMBER := Fnd_Log.level_event;
9432: -- examples : 4- exception internal software failure condition
9433: l_exception_level NUMBER := Fnd_Log.level_exception;
9434: -- examples : 5- error end user erros
9435: l_error_level NUMBER := Fnd_Log.level_error;
9436: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.create_repair_task';
9437:

Line 9435: l_error_level NUMBER := Fnd_Log.level_error;

9431: l_event_level NUMBER := Fnd_Log.level_event;
9432: -- examples : 4- exception internal software failure condition
9433: l_exception_level NUMBER := Fnd_Log.level_exception;
9434: -- examples : 5- error end user erros
9435: l_error_level NUMBER := Fnd_Log.level_error;
9436: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.create_repair_task';
9437:
9438: BEGIN
9439: -- -----------------

Line 9446: Fnd_Log.string(l_statement_level, l_module_name, 'begin');

9442:
9443: -- Standard Start of API savepoint
9444: IF l_statement_level >= l_debug_level
9445: THEN
9446: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9447: END IF;
9448: SAVEPOINT create_repair_task;
9449:
9450: -- Standard call to check for call compatibility.

Line 9453: Fnd_Log.string(l_statement_level,

9449:
9450: -- Standard call to check for call compatibility.
9451: IF l_statement_level >= l_debug_level
9452: THEN
9453: Fnd_Log.string(l_statement_level,
9454: l_module_name,
9455: 'checking api compatibility');
9456: END IF;
9457: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,

Line 9464: Fnd_Log.string(l_exception_level,

9460: G_PKG_NAME)
9461: THEN
9462: IF l_exception_level >= l_debug_level
9463: THEN
9464: Fnd_Log.string(l_exception_level,
9465: l_module_name,
9466: 'checking api compatibility, was unsuccessful');
9467: END IF;
9468: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 9473: Fnd_Log.string(l_statement_level,

9469: END IF;
9470:
9471: IF l_statement_level >= l_debug_level
9472: THEN
9473: Fnd_Log.string(l_statement_level,
9474: l_module_name,
9475: 'checking api compatibility, was successful');
9476: END IF;
9477:

Line 9490: Fnd_Log.String(l_Statement_Level,

9486: -- Api body starts
9487: -- ---------------
9488: IF l_statement_level >= l_debug_level
9489: THEN
9490: Fnd_Log.String(l_Statement_Level,
9491: l_Module_Name,
9492: 'Task Record Values:');
9493: Fnd_Log.String(l_Statement_Level,
9494: l_Module_Name,

Line 9493: Fnd_Log.String(l_Statement_Level,

9489: THEN
9490: Fnd_Log.String(l_Statement_Level,
9491: l_Module_Name,
9492: 'Task Record Values:');
9493: Fnd_Log.String(l_Statement_Level,
9494: l_Module_Name,
9495: 'Task Id :' ||
9496: p_create_repair_task_rec.task_Id);
9497: Fnd_Log.String(l_Statement_Level,

Line 9497: Fnd_Log.String(l_Statement_Level,

9493: Fnd_Log.String(l_Statement_Level,
9494: l_Module_Name,
9495: 'Task Id :' ||
9496: p_create_repair_task_rec.task_Id);
9497: Fnd_Log.String(l_Statement_Level,
9498: l_Module_Name,
9499: 'Repair_line_id :' ||
9500: p_create_repair_task_rec.repair_line_id);
9501: Fnd_Log.String(l_Statement_Level,

Line 9501: Fnd_Log.String(l_Statement_Level,

9497: Fnd_Log.String(l_Statement_Level,
9498: l_Module_Name,
9499: 'Repair_line_id :' ||
9500: p_create_repair_task_rec.repair_line_id);
9501: Fnd_Log.String(l_Statement_Level,
9502: l_Module_Name,
9503: 'context values :' ||
9504: p_create_repair_task_rec.context_values);
9505: END IF;

Line 9515: Fnd_Log.string(l_statement_level,

9511: p_api_name => l_api_name);
9512:
9513: IF l_statement_level >= l_debug_level
9514: THEN
9515: Fnd_Log.string(l_statement_level,
9516: l_module_name || '.check_in_parameters',
9517: 'Task id is valid');
9518: END IF;
9519:

Line 9526: Fnd_Log.string(l_statement_level,

9522: p_api_name => l_api_name);
9523:
9524: IF l_statement_level >= l_debug_level
9525: THEN
9526: Fnd_Log.string(l_statement_level,
9527: l_module_name || '.check_in_parameters',
9528: 'Repair Line id is valid');
9529: END IF;
9530:

Line 9634: -- define variables to define fnd_log debug levels

9630: l_applicable_qa_plans VARCHAR2(1);
9631: l_dummy_char VARCHAR2(32000);
9632: l_plan_txn_ids VARCHAR2(5000);
9633:
9634: -- define variables to define fnd_log debug levels
9635: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9636: -- examples : 1- copying buffer x to y : low level detailed messages
9637: l_statement_level NUMBER := Fnd_Log.level_statement;
9638: -- examples : 2- key progress events : starting business transactions

Line 9635: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;

9631: l_dummy_char VARCHAR2(32000);
9632: l_plan_txn_ids VARCHAR2(5000);
9633:
9634: -- define variables to define fnd_log debug levels
9635: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9636: -- examples : 1- copying buffer x to y : low level detailed messages
9637: l_statement_level NUMBER := Fnd_Log.level_statement;
9638: -- examples : 2- key progress events : starting business transactions
9639: l_procedure_level NUMBER := Fnd_Log.level_procedure;

Line 9637: l_statement_level NUMBER := Fnd_Log.level_statement;

9633:
9634: -- define variables to define fnd_log debug levels
9635: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9636: -- examples : 1- copying buffer x to y : low level detailed messages
9637: l_statement_level NUMBER := Fnd_Log.level_statement;
9638: -- examples : 2- key progress events : starting business transactions
9639: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9640: -- examples : 3- event : calling an api, key progress events
9641: l_event_level NUMBER := Fnd_Log.level_event;

Line 9639: l_procedure_level NUMBER := Fnd_Log.level_procedure;

9635: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9636: -- examples : 1- copying buffer x to y : low level detailed messages
9637: l_statement_level NUMBER := Fnd_Log.level_statement;
9638: -- examples : 2- key progress events : starting business transactions
9639: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9640: -- examples : 3- event : calling an api, key progress events
9641: l_event_level NUMBER := Fnd_Log.level_event;
9642: -- examples : 4- exception internal software failure condition
9643: l_exception_level NUMBER := Fnd_Log.level_exception;

Line 9641: l_event_level NUMBER := Fnd_Log.level_event;

9637: l_statement_level NUMBER := Fnd_Log.level_statement;
9638: -- examples : 2- key progress events : starting business transactions
9639: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9640: -- examples : 3- event : calling an api, key progress events
9641: l_event_level NUMBER := Fnd_Log.level_event;
9642: -- examples : 4- exception internal software failure condition
9643: l_exception_level NUMBER := Fnd_Log.level_exception;
9644: -- examples : 5- error end user erros
9645: l_error_level NUMBER := Fnd_Log.level_error;

Line 9643: l_exception_level NUMBER := Fnd_Log.level_exception;

9639: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9640: -- examples : 3- event : calling an api, key progress events
9641: l_event_level NUMBER := Fnd_Log.level_event;
9642: -- examples : 4- exception internal software failure condition
9643: l_exception_level NUMBER := Fnd_Log.level_exception;
9644: -- examples : 5- error end user erros
9645: l_error_level NUMBER := Fnd_Log.level_error;
9646: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_repair_task';
9647:

Line 9645: l_error_level NUMBER := Fnd_Log.level_error;

9641: l_event_level NUMBER := Fnd_Log.level_event;
9642: -- examples : 4- exception internal software failure condition
9643: l_exception_level NUMBER := Fnd_Log.level_exception;
9644: -- examples : 5- error end user erros
9645: l_error_level NUMBER := Fnd_Log.level_error;
9646: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_repair_task';
9647:
9648: BEGIN
9649: -- -----------------

Line 9656: Fnd_Log.string(l_statement_level, l_module_name, 'begin');

9652:
9653: -- Standard Start of API savepoint
9654: IF l_statement_level >= l_debug_level
9655: THEN
9656: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9657: END IF;
9658: SAVEPOINT update_repair_task;
9659:
9660: -- Standard call to check for call compatibility.

Line 9663: Fnd_Log.string(l_statement_level,

9659:
9660: -- Standard call to check for call compatibility.
9661: IF l_statement_level >= l_debug_level
9662: THEN
9663: Fnd_Log.string(l_statement_level,
9664: l_module_name,
9665: 'checking api compatibility');
9666: END IF;
9667: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,

Line 9674: Fnd_Log.string(l_exception_level,

9670: G_PKG_NAME)
9671: THEN
9672: IF l_exception_level >= l_debug_level
9673: THEN
9674: Fnd_Log.string(l_exception_level,
9675: l_module_name,
9676: 'checking api compatibility, was unsuccessful');
9677: END IF;
9678: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 9683: Fnd_Log.string(l_statement_level,

9679: END IF;
9680:
9681: IF l_statement_level >= l_debug_level
9682: THEN
9683: Fnd_Log.string(l_statement_level,
9684: l_module_name,
9685: 'checking api compatibility, was successful');
9686: END IF;
9687:

Line 9700: Fnd_Log.String(l_Statement_Level,

9696: -- Api body starts
9697: -- ---------------
9698: IF l_statement_level >= l_debug_level
9699: THEN
9700: Fnd_Log.String(l_Statement_Level,
9701: l_Module_Name,
9702: 'Task Record Values:');
9703: Fnd_Log.String(l_Statement_Level,
9704: l_Module_Name,

Line 9703: Fnd_Log.String(l_Statement_Level,

9699: THEN
9700: Fnd_Log.String(l_Statement_Level,
9701: l_Module_Name,
9702: 'Task Record Values:');
9703: Fnd_Log.String(l_Statement_Level,
9704: l_Module_Name,
9705: 'Task Id :' ||
9706: p_update_repair_task_rec.task_Id);
9707: Fnd_Log.String(l_Statement_Level,

Line 9707: Fnd_Log.String(l_Statement_Level,

9703: Fnd_Log.String(l_Statement_Level,
9704: l_Module_Name,
9705: 'Task Id :' ||
9706: p_update_repair_task_rec.task_Id);
9707: Fnd_Log.String(l_Statement_Level,
9708: l_Module_Name,
9709: 'Repair_line_id :' ||
9710: p_update_repair_task_rec.repair_line_id);
9711: -- fnd_log.String(l_Statement_Level,l_Module_Name,'Applicable QA Plans :'|| p_update_repair_task_rec.applicable_qa_plans );

Line 9711: -- fnd_log.String(l_Statement_Level,l_Module_Name,'Applicable QA Plans :'|| p_update_repair_task_rec.applicable_qa_plans );

9707: Fnd_Log.String(l_Statement_Level,
9708: l_Module_Name,
9709: 'Repair_line_id :' ||
9710: p_update_repair_task_rec.repair_line_id);
9711: -- fnd_log.String(l_Statement_Level,l_Module_Name,'Applicable QA Plans :'|| p_update_repair_task_rec.applicable_qa_plans );
9712: END IF;
9713:
9714: -- check the required parameter
9715: Csd_Process_Util.check_reqd_param(p_param_value => p_update_repair_task_rec.repair_task_Id,

Line 9721: Fnd_Log.string(l_statement_level,

9717: p_api_name => l_api_name);
9718:
9719: IF l_statement_level >= l_debug_level
9720: THEN
9721: Fnd_Log.string(l_statement_level,
9722: l_module_name || '.check_in_parameters',
9723: 'Repair Task id is valid');
9724: END IF;
9725:

Line 9732: Fnd_Log.string(l_statement_level,

9728: p_api_name => l_api_name);
9729:
9730: IF l_statement_level >= l_debug_level
9731: THEN
9732: Fnd_Log.string(l_statement_level,
9733: l_module_name || '.check_in_parameters',
9734: 'Task id is valid');
9735: END IF;
9736:

Line 9743: Fnd_Log.string(l_statement_level,

9739: p_api_name => l_api_name);
9740:
9741: IF l_statement_level >= l_debug_level
9742: THEN
9743: Fnd_Log.string(l_statement_level,
9744: l_module_name || '.check_in_parameters',
9745: 'Repair Line id is valid');
9746: END IF;
9747: