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 423: -- Variables used in FND Log

419: l_charges_rec Cs_Charge_Details_Pub.Charges_Rec_Type;
420: x_object_version_number NUMBER;
421: x_line_number NUMBER;
422:
423: -- Variables used in FND Log
424: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
425: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_charge_lines';
426:
427: BEGIN

Line 424: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

420: x_object_version_number NUMBER;
421: x_line_number NUMBER;
422:
423: -- Variables used in FND Log
424: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
425: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_charge_lines';
426:
427: BEGIN
428: Debug('At the Beginning of process_charge_lines', l_mod_name, 1);

Line 1176: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

1172:
1173: /********************************************************
1174: procedure dbg_print_stack(p_msg_count number, p_mod_name varchar2) is
1175: l_msg varchar2(2000);
1176: l_stat_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
1177:
1178: begin
1179: IF p_MSG_COUNT > 1 THEN
1180: FOR i IN 1..p_MSG_COUNT LOOP

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

1178: begin
1179: IF p_MSG_COUNT > 1 THEN
1180: FOR i IN 1..p_MSG_COUNT LOOP
1181: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;
1182: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);
1183: END LOOP ;
1184: ELSE
1185: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;
1186: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);

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

1182: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);
1183: END LOOP ;
1184: ELSE
1185: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;
1186: Fnd_Log.STRING(l_stat_level, p_mod_name, l_msg);
1187: END IF ;
1188:
1189: end dbg_print_stack;
1190: ************************************************************/

Line 1353: -- Variables used in FND Log

1349: SELECT org_id
1350: FROM oe_order_headers_all
1351: WHERE header_id = p_header_id;
1352:
1353: -- Variables used in FND Log
1354: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
1355: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1356:
1357: /* pick release rule api changes/srl reservations changes *

Line 1354: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

1350: FROM oe_order_headers_all
1351: WHERE header_id = p_header_id;
1352:
1353: -- Variables used in FND Log
1354: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
1355: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1356:
1357: /* pick release rule api changes/srl reservations changes *
1358: */

Line 2357: -- Variables used in FND Log

2353: AND SYSDATE BETWEEN NVL(start_Date_Active, SYSDATE) AND
2354: NVL(end_Date_active, SYSDATE + 1);
2355: --R12 Development Changes End
2356:
2357: -- Variables used in FND Log
2358: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2359: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2360: l_tmp_char VARCHAR2(1); --R12 Development Changes
2361: /* R12 SN reservations integration change Begin */

Line 2358: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

2354: NVL(end_Date_active, SYSDATE + 1);
2355: --R12 Development Changes End
2356:
2357: -- Variables used in FND Log
2358: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2359: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2360: l_tmp_char VARCHAR2(1); --R12 Development Changes
2361: /* R12 SN reservations integration change Begin */
2362: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

Line 4599: -- Variables used in FND Log

4595: AND order_header_id IS NULL
4596: AND order_line_id IS NULL;
4597:
4598:
4599: -- Variables used in FND Log
4600: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4601: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4602: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4603:

Line 4600: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

4596: AND order_line_id IS NULL;
4597:
4598:
4599: -- Variables used in FND Log
4600: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4601: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4602: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4603:
4604:

Line 4601: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;

4597:
4598:
4599: -- Variables used in FND Log
4600: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4601: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4602: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4603:
4604:
4605: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';

Line 4602: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;

4598:
4599: -- Variables used in FND Log
4600: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4601: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4602: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4603:
4604:
4605: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';
4606:

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

8065: C_Yes CONSTANT VARCHAR2(1) := 'Y';
8066: C_No CONSTANT VARCHAR2(1) := 'N';
8067: C_Zero CONSTANT NUMBER := 0;
8068:
8069: -- define variables to define fnd_log debug levels
8070: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8071: -- examples : 1- copying buffer x to y : low level detailed messages
8072: l_statement_level NUMBER := Fnd_Log.level_statement;
8073: -- examples : 2- key progress events : starting business transactions

Line 8070: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;

8066: C_No CONSTANT VARCHAR2(1) := 'N';
8067: C_Zero CONSTANT NUMBER := 0;
8068:
8069: -- define variables to define fnd_log debug levels
8070: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8071: -- examples : 1- copying buffer x to y : low level detailed messages
8072: l_statement_level NUMBER := Fnd_Log.level_statement;
8073: -- examples : 2- key progress events : starting business transactions
8074: l_procedure_level NUMBER := Fnd_Log.level_procedure;

Line 8072: l_statement_level NUMBER := Fnd_Log.level_statement;

8068:
8069: -- define variables to define fnd_log debug levels
8070: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8071: -- examples : 1- copying buffer x to y : low level detailed messages
8072: l_statement_level NUMBER := Fnd_Log.level_statement;
8073: -- examples : 2- key progress events : starting business transactions
8074: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8075: -- examples : 3- event : calling an api, key progress events
8076: l_event_level NUMBER := Fnd_Log.level_event;

Line 8074: l_procedure_level NUMBER := Fnd_Log.level_procedure;

8070: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
8071: -- examples : 1- copying buffer x to y : low level detailed messages
8072: l_statement_level NUMBER := Fnd_Log.level_statement;
8073: -- examples : 2- key progress events : starting business transactions
8074: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8075: -- examples : 3- event : calling an api, key progress events
8076: l_event_level NUMBER := Fnd_Log.level_event;
8077: -- examples : 4- exception internal software failure condition
8078: l_exception_level NUMBER := Fnd_Log.level_exception;

Line 8076: l_event_level NUMBER := Fnd_Log.level_event;

8072: l_statement_level NUMBER := Fnd_Log.level_statement;
8073: -- examples : 2- key progress events : starting business transactions
8074: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8075: -- examples : 3- event : calling an api, key progress events
8076: l_event_level NUMBER := Fnd_Log.level_event;
8077: -- examples : 4- exception internal software failure condition
8078: l_exception_level NUMBER := Fnd_Log.level_exception;
8079: -- examples : 5- error end user erros
8080: l_error_level NUMBER := Fnd_Log.level_error;

Line 8078: l_exception_level NUMBER := Fnd_Log.level_exception;

8074: l_procedure_level NUMBER := Fnd_Log.level_procedure;
8075: -- examples : 3- event : calling an api, key progress events
8076: l_event_level NUMBER := Fnd_Log.level_event;
8077: -- examples : 4- exception internal software failure condition
8078: l_exception_level NUMBER := Fnd_Log.level_exception;
8079: -- examples : 5- error end user erros
8080: l_error_level NUMBER := Fnd_Log.level_error;
8081: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_iro_product_txn';
8082:

Line 8080: l_error_level NUMBER := Fnd_Log.level_error;

8076: l_event_level NUMBER := Fnd_Log.level_event;
8077: -- examples : 4- exception internal software failure condition
8078: l_exception_level NUMBER := Fnd_Log.level_exception;
8079: -- examples : 5- error end user erros
8080: l_error_level NUMBER := Fnd_Log.level_error;
8081: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_iro_product_txn';
8082:
8083: -- a variable whose value tells us whether order header can be pick released or not.
8084: l_order_to_be_pickreleased VARCHAR2(1) := C_NO;

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

8143:
8144: BEGIN
8145: IF l_statement_level >= l_debug_level
8146: THEN
8147: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
8148: END IF;
8149: -- standard start of api savepoint
8150: SAVEPOINT update_iro_product_txn;
8151: IF l_statement_level >= l_debug_level

Line 8153: Fnd_Log.string(l_statement_level,

8149: -- standard start of api savepoint
8150: SAVEPOINT update_iro_product_txn;
8151: IF l_statement_level >= l_debug_level
8152: THEN
8153: Fnd_Log.string(l_statement_level,
8154: l_module_name,
8155: 'checking api compatibility');
8156: END IF;
8157: -- standard call to check for call compatibility.

Line 8165: Fnd_Log.string(l_exception_level,

8161: g_pkg_name)
8162: THEN
8163: IF l_exception_level >= l_debug_level
8164: THEN
8165: Fnd_Log.string(l_exception_level,
8166: l_module_name,
8167: 'checking api compatibility, was unsuccessful');
8168: END IF;
8169: RAISE Fnd_Api.g_exc_unexpected_error;

Line 8173: Fnd_Log.string(l_statement_level,

8169: RAISE Fnd_Api.g_exc_unexpected_error;
8170: END IF;
8171: IF l_statement_level >= l_debug_level
8172: THEN
8173: Fnd_Log.string(l_statement_level,
8174: l_module_name,
8175: 'checking api compatibility, was successful');
8176: END IF;
8177:

Line 8189: Fnd_Log.String(l_Statement_Level,

8185: x_return_status := Fnd_Api.g_ret_sts_success;
8186:
8187: IF l_statement_level >= l_debug_level
8188: THEN
8189: Fnd_Log.String(l_Statement_Level,
8190: l_Module_Name,
8191: 'Product Transaction Record Values:');
8192: Fnd_Log.String(l_Statement_Level,
8193: l_Module_Name,

Line 8192: Fnd_Log.String(l_Statement_Level,

8188: THEN
8189: Fnd_Log.String(l_Statement_Level,
8190: l_Module_Name,
8191: 'Product Transaction Record Values:');
8192: Fnd_Log.String(l_Statement_Level,
8193: l_Module_Name,
8194: 'Product Transaction Id :' ||
8195: x_product_txn_rec.Product_Transaction_Id);
8196: Fnd_Log.String(l_Statement_Level,

Line 8196: Fnd_Log.String(l_Statement_Level,

8192: Fnd_Log.String(l_Statement_Level,
8193: l_Module_Name,
8194: 'Product Transaction Id :' ||
8195: x_product_txn_rec.Product_Transaction_Id);
8196: Fnd_Log.String(l_Statement_Level,
8197: l_Module_Name,
8198: 'Repair_line_id :' ||
8199: x_product_txn_rec.repair_line_id);
8200: Fnd_Log.String(l_Statement_Level,

Line 8200: Fnd_Log.String(l_Statement_Level,

8196: Fnd_Log.String(l_Statement_Level,
8197: l_Module_Name,
8198: 'Repair_line_id :' ||
8199: x_product_txn_rec.repair_line_id);
8200: Fnd_Log.String(l_Statement_Level,
8201: l_Module_Name,
8202: 'Action_type :' ||
8203: x_product_txn_rec.action_type);
8204: Fnd_Log.String(l_Statement_Level,

Line 8204: Fnd_Log.String(l_Statement_Level,

8200: Fnd_Log.String(l_Statement_Level,
8201: l_Module_Name,
8202: 'Action_type :' ||
8203: x_product_txn_rec.action_type);
8204: Fnd_Log.String(l_Statement_Level,
8205: l_Module_Name,
8206: 'Action_code :' ||
8207: x_product_txn_rec.action_code);
8208: Fnd_Log.String(l_Statement_Level,

Line 8208: Fnd_Log.String(l_Statement_Level,

8204: Fnd_Log.String(l_Statement_Level,
8205: l_Module_Name,
8206: 'Action_code :' ||
8207: x_product_txn_rec.action_code);
8208: Fnd_Log.String(l_Statement_Level,
8209: l_Module_Name,
8210: 'Incident_id :' ||
8211: x_product_txn_rec.incident_id);
8212: Fnd_Log.String(l_Statement_Level,

Line 8212: Fnd_Log.String(l_Statement_Level,

8208: Fnd_Log.String(l_Statement_Level,
8209: l_Module_Name,
8210: 'Incident_id :' ||
8211: x_product_txn_rec.incident_id);
8212: Fnd_Log.String(l_Statement_Level,
8213: l_Module_Name,
8214: 'line_type_id :' ||
8215: x_product_txn_rec.line_type_id);
8216: Fnd_Log.String(l_Statement_Level,

Line 8216: Fnd_Log.String(l_Statement_Level,

8212: Fnd_Log.String(l_Statement_Level,
8213: l_Module_Name,
8214: 'line_type_id :' ||
8215: x_product_txn_rec.line_type_id);
8216: Fnd_Log.String(l_Statement_Level,
8217: l_Module_Name,
8218: 'Order_number :' ||
8219: x_product_txn_rec.order_number);
8220: Fnd_Log.String(l_Statement_Level,

Line 8220: Fnd_Log.String(l_Statement_Level,

8216: Fnd_Log.String(l_Statement_Level,
8217: l_Module_Name,
8218: 'Order_number :' ||
8219: x_product_txn_rec.order_number);
8220: Fnd_Log.String(l_Statement_Level,
8221: l_Module_Name,
8222: 'Status :' ||
8223: x_product_txn_rec.status);
8224: Fnd_Log.String(l_Statement_Level,

Line 8224: Fnd_Log.String(l_Statement_Level,

8220: Fnd_Log.String(l_Statement_Level,
8221: l_Module_Name,
8222: 'Status :' ||
8223: x_product_txn_rec.status);
8224: Fnd_Log.String(l_Statement_Level,
8225: l_Module_Name,
8226: 'Currency_code :' ||
8227: x_product_txn_rec.currency_code);
8228: Fnd_Log.String(l_Statement_Level,

Line 8228: Fnd_Log.String(l_Statement_Level,

8224: Fnd_Log.String(l_Statement_Level,
8225: l_Module_Name,
8226: 'Currency_code :' ||
8227: x_product_txn_rec.currency_code);
8228: Fnd_Log.String(l_Statement_Level,
8229: l_Module_Name,
8230: 'Unit_of_measure_code :' ||
8231: x_product_txn_rec.unit_of_measure_code);
8232: Fnd_Log.String(l_Statement_Level,

Line 8232: Fnd_Log.String(l_Statement_Level,

8228: Fnd_Log.String(l_Statement_Level,
8229: l_Module_Name,
8230: 'Unit_of_measure_code :' ||
8231: x_product_txn_rec.unit_of_measure_code);
8232: Fnd_Log.String(l_Statement_Level,
8233: l_Module_Name,
8234: 'Inventory_item_id :' ||
8235: x_product_txn_rec.inventory_item_id);
8236: Fnd_Log.String(l_Statement_Level,

Line 8236: Fnd_Log.String(l_Statement_Level,

8232: Fnd_Log.String(l_Statement_Level,
8233: l_Module_Name,
8234: 'Inventory_item_id :' ||
8235: x_product_txn_rec.inventory_item_id);
8236: Fnd_Log.String(l_Statement_Level,
8237: l_Module_Name,
8238: 'Revision :' ||
8239: x_product_txn_rec.revision);
8240: Fnd_Log.String(l_Statement_Level,

Line 8240: Fnd_Log.String(l_Statement_Level,

8236: Fnd_Log.String(l_Statement_Level,
8237: l_Module_Name,
8238: 'Revision :' ||
8239: x_product_txn_rec.revision);
8240: Fnd_Log.String(l_Statement_Level,
8241: l_Module_Name,
8242: 'Quantity :' ||
8243: x_product_txn_rec.quantity);
8244: Fnd_Log.String(l_Statement_Level,

Line 8244: Fnd_Log.String(l_Statement_Level,

8240: Fnd_Log.String(l_Statement_Level,
8241: l_Module_Name,
8242: 'Quantity :' ||
8243: x_product_txn_rec.quantity);
8244: Fnd_Log.String(l_Statement_Level,
8245: l_Module_Name,
8246: 'Price_list_id :' ||
8247: x_product_txn_rec.price_list_id);
8248: Fnd_Log.String(l_Statement_Level,

Line 8248: Fnd_Log.String(l_Statement_Level,

8244: Fnd_Log.String(l_Statement_Level,
8245: l_Module_Name,
8246: 'Price_list_id :' ||
8247: x_product_txn_rec.price_list_id);
8248: Fnd_Log.String(l_Statement_Level,
8249: l_Module_Name,
8250: 'Source Organization_id :' ||
8251: x_product_txn_rec.organization_id);
8252: Fnd_Log.String(l_Statement_Level,

Line 8252: Fnd_Log.String(l_Statement_Level,

8248: Fnd_Log.String(l_Statement_Level,
8249: l_Module_Name,
8250: 'Source Organization_id :' ||
8251: x_product_txn_rec.organization_id);
8252: Fnd_Log.String(l_Statement_Level,
8253: l_Module_Name,
8254: 'Interface_to_om_flag :' ||
8255: x_product_txn_rec.interface_to_om_flag);
8256: Fnd_Log.String(l_Statement_Level,

Line 8256: Fnd_Log.String(l_Statement_Level,

8252: Fnd_Log.String(l_Statement_Level,
8253: l_Module_Name,
8254: 'Interface_to_om_flag :' ||
8255: x_product_txn_rec.interface_to_om_flag);
8256: Fnd_Log.String(l_Statement_Level,
8257: l_Module_Name,
8258: 'Book_sales_order_flag :' ||
8259: x_product_txn_rec.book_sales_order_flag);
8260: Fnd_Log.String(l_Statement_Level,

Line 8260: Fnd_Log.String(l_Statement_Level,

8256: Fnd_Log.String(l_Statement_Level,
8257: l_Module_Name,
8258: 'Book_sales_order_flag :' ||
8259: x_product_txn_rec.book_sales_order_flag);
8260: Fnd_Log.String(l_Statement_Level,
8261: l_Module_Name,
8262: 'Release_sales_order_flag :' ||
8263: x_product_txn_rec.release_sales_order_flag);
8264: Fnd_Log.String(l_Statement_Level,

Line 8264: Fnd_Log.String(l_Statement_Level,

8260: Fnd_Log.String(l_Statement_Level,
8261: l_Module_Name,
8262: 'Release_sales_order_flag :' ||
8263: x_product_txn_rec.release_sales_order_flag);
8264: Fnd_Log.String(l_Statement_Level,
8265: l_Module_Name,
8266: 'Ship_sales_order_flag :' ||
8267: x_product_txn_rec.ship_sales_order_flag);
8268: Fnd_Log.String(l_Statement_Level,

Line 8268: Fnd_Log.String(l_Statement_Level,

8264: Fnd_Log.String(l_Statement_Level,
8265: l_Module_Name,
8266: 'Ship_sales_order_flag :' ||
8267: x_product_txn_rec.ship_sales_order_flag);
8268: Fnd_Log.String(l_Statement_Level,
8269: l_Module_Name,
8270: 'Process_txn_flag :' ||
8271: x_product_txn_rec.process_txn_flag);
8272: Fnd_Log.String(l_Statement_Level,

Line 8272: Fnd_Log.String(l_Statement_Level,

8268: Fnd_Log.String(l_Statement_Level,
8269: l_Module_Name,
8270: 'Process_txn_flag :' ||
8271: x_product_txn_rec.process_txn_flag);
8272: Fnd_Log.String(l_Statement_Level,
8273: l_Module_Name,
8274: 'Object_version_number :' ||
8275: x_product_txn_rec.object_version_number);
8276: END IF;

Line 8280: Fnd_Log.string(l_statement_level,

8276: END IF;
8277:
8278: IF l_statement_level >= l_debug_level
8279: THEN
8280: Fnd_Log.string(l_statement_level,
8281: l_module_name || '.check_in_parameters',
8282: 'product txn id is:' ||
8283: x_product_txn_rec.product_transaction_id);
8284: END IF;

Line 8293: Fnd_Log.string(l_statement_level,

8289: p_api_name => l_api_name);
8290:
8291: IF l_statement_level >= l_debug_level
8292: THEN
8293: Fnd_Log.string(l_statement_level,
8294: l_module_name || '.check_in_parameters',
8295: 'product txn id is valid');
8296: END IF;
8297:

Line 8304: Fnd_Log.string(l_exception_level,

8300: (Csd_Process_Util.validate_prod_txn_id(p_prod_txn_id => x_product_txn_rec.product_transaction_id))
8301: THEN
8302: IF l_exception_level >= l_debug_level
8303: THEN
8304: Fnd_Log.string(l_exception_level,
8305: l_module_name || '.check_in_parameters',
8306: 'product txn id is not valid ');
8307: END IF;
8308: RAISE Fnd_Api.g_exc_error;

Line 8312: Fnd_Log.string(l_statement_level,

8308: RAISE Fnd_Api.g_exc_error;
8309: END IF;
8310: IF l_statement_level >= l_debug_level
8311: THEN
8312: Fnd_Log.string(l_statement_level,
8313: l_module_name || '.check_in_parameters',
8314: 'product txn id is valid ');
8315: END IF;
8316:

Line 8329: Fnd_Log.string(l_statement_level,

8325: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
8326: AND lookup_code = x_product_txn_rec.prod_txn_status;
8327: IF l_statement_level >= l_debug_level
8328: THEN
8329: Fnd_Log.string(l_statement_level,
8330: l_module_name || '.check_in_parameters',
8331: 'Product txn status is valid : ' ||
8332: x_product_txn_rec.prod_txn_status);
8333: END IF;

Line 8339: Fnd_Log.string(l_exception_level,

8335: WHEN NO_DATA_FOUND THEN
8336: Fnd_Message.set_name('CSD', 'CSD_ERR_PROD_TXN_STATUS');
8337: IF l_exception_level >= l_debug_level
8338: THEN
8339: Fnd_Log.string(l_exception_level,
8340: l_module_name ||
8341: '.check_in_parameters',
8342: 'Product txn status is invalid : ' ||
8343: x_product_txn_rec.prod_txn_status);

Line 8359: Fnd_Log.string(l_exception_level,

8355: (Csd_Process_Util.validate_action_type(p_action_type => x_product_txn_rec.action_type))
8356: THEN
8357: IF l_exception_level >= l_debug_level
8358: THEN
8359: Fnd_Log.string(l_exception_level,
8360: l_module_name || '.check_in_parameters',
8361: 'Action Type s invalid : ' ||
8362: x_product_txn_rec.Action_Type);
8363: END IF;

Line 8377: Fnd_Log.string(l_exception_level,

8373: (Csd_Process_Util.validate_action_code(p_action_code => x_product_txn_rec.action_code))
8374: THEN
8375: IF l_exception_level >= l_debug_level
8376: THEN
8377: Fnd_Log.string(l_exception_level,
8378: l_module_name || '.check_in_parameters',
8379: 'Action Code is invalid : ' ||
8380: x_product_txn_rec.Action_Code);
8381: END IF;

Line 8403: Fnd_Log.string(l_exception_level,

8399: IF x_product_txn_rec.repair_line_id <> l_repair_line_id
8400: THEN
8401: IF l_exception_level >= l_debug_level
8402: THEN
8403: Fnd_Log.string(l_exception_level,
8404: l_module_name || '.check_in_parameters',
8405: 'Repair Line id can not be changed');
8406: END IF;
8407: RAISE Fnd_Api.g_exc_error;

Line 8430: Fnd_Log.string(l_statement_level,

8426: l_repair_line_id);
8427: Fnd_Msg_Pub.ADD;
8428: IF l_statement_level >= l_debug_level
8429: THEN
8430: Fnd_Log.string(l_statement_level,
8431: l_module_name ||
8432: '.check_in_parameters',
8433: 'Invalid repair line id ' ||
8434: x_product_txn_rec.repair_line_id);

Line 8502: Fnd_Log.string(l_Statement_level,

8498: END IF;
8499: -- fnd_profile.get('csd_def_pick_release_rule',l_picking_rule_id);
8500: IF l_Statement_level >= l_debug_level
8501: THEN
8502: Fnd_Log.string(l_Statement_level,
8503: l_module_name,
8504: 'Default picking rule id :' ||
8505: l_Picking_Rule_Id);
8506: END IF;

Line 8525: Fnd_Log.string(l_exception_level,

8521: l_picking_rule_id);
8522: Fnd_Msg_Pub.ADD;
8523: IF l_exception_level >= l_debug_level
8524: THEN
8525: Fnd_Log.string(l_exception_level,
8526: l_module_name,
8527: ' Default picking rule id not found');
8528: END IF;
8529: RAISE release_order_excep;

Line 8546: Fnd_Log.string(l_statement_level,

8542: (c_ready_for_release, c_backordered)
8543: AND ROWNUM < 2;
8544: IF l_statement_level >= l_debug_level
8545: THEN
8546: Fnd_Log.string(l_statement_level,
8547: l_module_name,
8548: 'There are lines eligible for pick release');
8549: END IF;
8550: EXCEPTION

Line 8556: Fnd_Log.string(l_statement_level,

8552: -- there are no records to be pick released using public api
8553: l_order_to_be_pickreleased := C_No;
8554: IF l_statement_level >= l_debug_level
8555: THEN
8556: Fnd_Log.string(l_statement_level,
8557: l_module_name,
8558: 'There are no lines eligible for pick releas');
8559: END IF;
8560: END;

Line 8566: Fnd_Log.string(l_statement_level,

8562: IF l_order_to_be_pickreleased = C_Yes
8563: THEN
8564: IF l_statement_level >= l_debug_level
8565: THEN
8566: Fnd_Log.string(l_statement_level,
8567: l_module_name,
8568: 'Calling process_sales_order to release so');
8569: END IF;
8570: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,

Line 8583: Fnd_Log.string(l_exception_level,

8579: IF (x_return_status = Fnd_Api.g_ret_sts_error)
8580: THEN
8581: IF l_exception_level >= l_debug_level
8582: THEN
8583: Fnd_Log.string(l_exception_level,
8584: l_module_name,
8585: 'csd_process_pvt.process_sales_order failed');
8586: END IF;
8587: RAISE release_order_excep;

Line 8591: Fnd_Log.string(l_statement_level,

8587: RAISE release_order_excep;
8588: ELSE
8589: IF l_statement_level >= l_debug_level
8590: THEN
8591: Fnd_Log.string(l_statement_level,
8592: l_module_name,
8593: 'process_sales_order was successful');
8594: END IF;
8595: END IF; -- X_Return_Status is Error

Line 8614: Fnd_Log.string(l_statement_level,

8610: (c_ready_for_release, c_backordered,
8611: c_release_to_warehouse);
8612: IF l_statement_level >= l_debug_level
8613: THEN
8614: Fnd_Log.string(l_statement_level,
8615: l_module_name,
8616: 'Still there are some lines to be pick released');
8617: END IF;
8618: EXCEPTION

Line 8623: Fnd_Log.string(l_statement_level,

8619: WHEN NO_DATA_FOUND THEN
8620: l_order_to_Be_PickReleased := 'N';
8621: IF l_statement_level >= l_debug_level
8622: THEN
8623: Fnd_Log.string(l_statement_level,
8624: l_module_name,
8625: 'There are no lines to be pick released');
8626: END IF;
8627: WHEN TOO_MANY_ROWS THEN

Line 8630: Fnd_Log.string(l_statement_level,

8626: END IF;
8627: WHEN TOO_MANY_ROWS THEN
8628: IF l_statement_level >= l_debug_level
8629: THEN
8630: Fnd_Log.string(l_statement_level,
8631: l_module_name,
8632: 'More then one line to be pick released');
8633: END IF;
8634: l_order_to_Be_PickReleased := 'Y';

Line 8661: Fnd_Log.string(l_statement_level,

8657: THEN
8658: -- Product Transaction records are updated.
8659: IF l_statement_level >= l_debug_level
8660: THEN
8661: Fnd_Log.string(l_statement_level,
8662: l_module_name,
8663: 'Product transaction records are updated with Released Status');
8664: Fnd_Log.string(l_statement_level,
8665: l_module_name,

Line 8664: Fnd_Log.string(l_statement_level,

8660: THEN
8661: Fnd_Log.string(l_statement_level,
8662: l_module_name,
8663: 'Product transaction records are updated with Released Status');
8664: Fnd_Log.string(l_statement_level,
8665: l_module_name,
8666: 'Internal Order header id :' ||
8667: x_product_txn_rec.order_header_id);
8668: Fnd_Log.string(l_statement_level,

Line 8668: Fnd_Log.string(l_statement_level,

8664: Fnd_Log.string(l_statement_level,
8665: l_module_name,
8666: 'Internal Order header id :' ||
8667: x_product_txn_rec.order_header_id);
8668: Fnd_Log.string(l_statement_level,
8669: l_module_name,
8670: 'Internal Order Line id :' ||
8671: x_product_txn_rec.order_Line_id);
8672: END IF;

Line 8694: Fnd_Log.string(l_statement_level,

8690: ELSE
8691: -- No Product Transaction records are updated.
8692: IF l_statement_level >= l_debug_level
8693: THEN
8694: Fnd_Log.string(l_statement_level,
8695: l_module_name,
8696: 'No valid product transaction record found to update release status');
8697: Fnd_Log.string(l_statement_level,
8698: l_module_name,

Line 8697: Fnd_Log.string(l_statement_level,

8693: THEN
8694: Fnd_Log.string(l_statement_level,
8695: l_module_name,
8696: 'No valid product transaction record found to update release status');
8697: Fnd_Log.string(l_statement_level,
8698: l_module_name,
8699: 'Internal Order header id :' ||
8700: x_product_txn_rec.order_header_id);
8701: Fnd_Log.string(l_statement_level,

Line 8701: Fnd_Log.string(l_statement_level,

8697: Fnd_Log.string(l_statement_level,
8698: l_module_name,
8699: 'Internal Order header id :' ||
8700: x_product_txn_rec.order_header_id);
8701: Fnd_Log.string(l_statement_level,
8702: l_module_name,
8703: 'Internal Order Line id :' ||
8704: x_product_txn_rec.order_Line_id);
8705: END IF;

Line 8750: Fnd_Log.string(l_statement_level,

8746: l_order_rec.order_line_id);
8747: Fnd_Msg_Pub.ADD;
8748: IF l_statement_level >= l_debug_level
8749: THEN
8750: Fnd_Log.string(l_statement_level,
8751: l_module_name,
8752: 'Order line id ' ||
8753: l_Order_rec.Order_Line_id ||
8754: ' is not eligible for shipping.');

Line 8765: Fnd_Log.string(l_statement_level,

8761: l_order_rec.order_line_id);
8762: Fnd_Msg_Pub.ADD;
8763: IF l_statement_level >= l_debug_level
8764: THEN
8765: Fnd_Log.string(l_statement_level,
8766: l_module_name,
8767: 'Order line id ' ||
8768: l_Order_rec.Order_Line_id ||
8769: ' has more then one delivery lines.');

Line 8777: Fnd_Log.string(l_statement_level,

8773: IF l_Released_Status = C_Staged_PickConfirmed
8774: THEN
8775: IF l_statement_level >= l_debug_level
8776: THEN
8777: Fnd_Log.string(l_statement_level,
8778: l_module_name,
8779: 'Calling Process Sales Order API');
8780: END IF;
8781: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,

Line 8794: Fnd_Log.string(l_statement_level,

8790: IF NOT (x_return_status = Fnd_Api.g_ret_sts_success)
8791: THEN
8792: IF l_statement_level >= l_debug_level
8793: THEN
8794: Fnd_Log.string(l_statement_level,
8795: l_module_name,
8796: ' process sales order failed');
8797: END IF;
8798: RAISE ship_order_excep;

Line 8849: Fnd_Log.string(l_statement_level,

8845: THEN
8846: -- 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: 'Product transaction records are updated with Shipped 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: 'Product transaction records are updated with Shipped 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 8884: Fnd_Log.string(l_statement_level,

8880: ELSE
8881: -- No Product Transaction records are updated.
8882: IF l_statement_level >= l_debug_level
8883: THEN
8884: Fnd_Log.string(l_statement_level,
8885: l_module_name,
8886: 'No valid product transaction record found to update to shipped status');
8887: Fnd_Log.string(l_statement_level,
8888: l_module_name,

Line 8887: Fnd_Log.string(l_statement_level,

8883: THEN
8884: Fnd_Log.string(l_statement_level,
8885: l_module_name,
8886: 'No valid product transaction record found to update to shipped status');
8887: Fnd_Log.string(l_statement_level,
8888: l_module_name,
8889: 'Internal Order header id :' ||
8890: x_product_txn_rec.order_header_id);
8891: Fnd_Log.string(l_statement_level,

Line 8891: Fnd_Log.string(l_statement_level,

8887: Fnd_Log.string(l_statement_level,
8888: l_module_name,
8889: 'Internal Order header id :' ||
8890: x_product_txn_rec.order_header_id);
8891: Fnd_Log.string(l_statement_level,
8892: l_module_name,
8893: 'Internal Order Line id :' ||
8894: x_product_txn_rec.order_Line_id);
8895: END IF;

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

9261: l_applicable_qa_plans VARCHAR2(1);
9262: l_plan_txn_ids VARCHAR2(5000);
9263: l_dummy_char VARCHAR2(32000);
9264:
9265: -- define variables to define fnd_log debug levels
9266: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9267: -- examples : 1- copying buffer x to y : low level detailed messages
9268: l_statement_level NUMBER := Fnd_Log.level_statement;
9269: -- examples : 2- key progress events : starting business transactions

Line 9266: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;

9262: l_plan_txn_ids VARCHAR2(5000);
9263: l_dummy_char VARCHAR2(32000);
9264:
9265: -- define variables to define fnd_log debug levels
9266: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9267: -- examples : 1- copying buffer x to y : low level detailed messages
9268: l_statement_level NUMBER := Fnd_Log.level_statement;
9269: -- examples : 2- key progress events : starting business transactions
9270: l_procedure_level NUMBER := Fnd_Log.level_procedure;

Line 9268: l_statement_level NUMBER := Fnd_Log.level_statement;

9264:
9265: -- define variables to define fnd_log debug levels
9266: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9267: -- examples : 1- copying buffer x to y : low level detailed messages
9268: l_statement_level NUMBER := Fnd_Log.level_statement;
9269: -- examples : 2- key progress events : starting business transactions
9270: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9271: -- examples : 3- event : calling an api, key progress events
9272: l_event_level NUMBER := Fnd_Log.level_event;

Line 9270: l_procedure_level NUMBER := Fnd_Log.level_procedure;

9266: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9267: -- examples : 1- copying buffer x to y : low level detailed messages
9268: l_statement_level NUMBER := Fnd_Log.level_statement;
9269: -- examples : 2- key progress events : starting business transactions
9270: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9271: -- examples : 3- event : calling an api, key progress events
9272: l_event_level NUMBER := Fnd_Log.level_event;
9273: -- examples : 4- exception internal software failure condition
9274: l_exception_level NUMBER := Fnd_Log.level_exception;

Line 9272: l_event_level NUMBER := Fnd_Log.level_event;

9268: l_statement_level NUMBER := Fnd_Log.level_statement;
9269: -- examples : 2- key progress events : starting business transactions
9270: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9271: -- examples : 3- event : calling an api, key progress events
9272: l_event_level NUMBER := Fnd_Log.level_event;
9273: -- examples : 4- exception internal software failure condition
9274: l_exception_level NUMBER := Fnd_Log.level_exception;
9275: -- examples : 5- error end user erros
9276: l_error_level NUMBER := Fnd_Log.level_error;

Line 9274: l_exception_level NUMBER := Fnd_Log.level_exception;

9270: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9271: -- examples : 3- event : calling an api, key progress events
9272: l_event_level NUMBER := Fnd_Log.level_event;
9273: -- examples : 4- exception internal software failure condition
9274: l_exception_level NUMBER := Fnd_Log.level_exception;
9275: -- examples : 5- error end user erros
9276: l_error_level NUMBER := Fnd_Log.level_error;
9277: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.create_repair_task';
9278:

Line 9276: l_error_level NUMBER := Fnd_Log.level_error;

9272: l_event_level NUMBER := Fnd_Log.level_event;
9273: -- examples : 4- exception internal software failure condition
9274: l_exception_level NUMBER := Fnd_Log.level_exception;
9275: -- examples : 5- error end user erros
9276: l_error_level NUMBER := Fnd_Log.level_error;
9277: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.create_repair_task';
9278:
9279: BEGIN
9280: -- -----------------

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

9283:
9284: -- Standard Start of API savepoint
9285: IF l_statement_level >= l_debug_level
9286: THEN
9287: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9288: END IF;
9289: SAVEPOINT create_repair_task;
9290:
9291: -- Standard call to check for call compatibility.

Line 9294: Fnd_Log.string(l_statement_level,

9290:
9291: -- Standard call to check for call compatibility.
9292: IF l_statement_level >= l_debug_level
9293: THEN
9294: Fnd_Log.string(l_statement_level,
9295: l_module_name,
9296: 'checking api compatibility');
9297: END IF;
9298: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,

Line 9305: Fnd_Log.string(l_exception_level,

9301: G_PKG_NAME)
9302: THEN
9303: IF l_exception_level >= l_debug_level
9304: THEN
9305: Fnd_Log.string(l_exception_level,
9306: l_module_name,
9307: 'checking api compatibility, was unsuccessful');
9308: END IF;
9309: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 9314: Fnd_Log.string(l_statement_level,

9310: END IF;
9311:
9312: IF l_statement_level >= l_debug_level
9313: THEN
9314: Fnd_Log.string(l_statement_level,
9315: l_module_name,
9316: 'checking api compatibility, was successful');
9317: END IF;
9318:

Line 9331: Fnd_Log.String(l_Statement_Level,

9327: -- Api body starts
9328: -- ---------------
9329: IF l_statement_level >= l_debug_level
9330: THEN
9331: Fnd_Log.String(l_Statement_Level,
9332: l_Module_Name,
9333: 'Task Record Values:');
9334: Fnd_Log.String(l_Statement_Level,
9335: l_Module_Name,

Line 9334: Fnd_Log.String(l_Statement_Level,

9330: THEN
9331: Fnd_Log.String(l_Statement_Level,
9332: l_Module_Name,
9333: 'Task Record Values:');
9334: Fnd_Log.String(l_Statement_Level,
9335: l_Module_Name,
9336: 'Task Id :' ||
9337: p_create_repair_task_rec.task_Id);
9338: Fnd_Log.String(l_Statement_Level,

Line 9338: Fnd_Log.String(l_Statement_Level,

9334: Fnd_Log.String(l_Statement_Level,
9335: l_Module_Name,
9336: 'Task Id :' ||
9337: p_create_repair_task_rec.task_Id);
9338: Fnd_Log.String(l_Statement_Level,
9339: l_Module_Name,
9340: 'Repair_line_id :' ||
9341: p_create_repair_task_rec.repair_line_id);
9342: Fnd_Log.String(l_Statement_Level,

Line 9342: Fnd_Log.String(l_Statement_Level,

9338: Fnd_Log.String(l_Statement_Level,
9339: l_Module_Name,
9340: 'Repair_line_id :' ||
9341: p_create_repair_task_rec.repair_line_id);
9342: Fnd_Log.String(l_Statement_Level,
9343: l_Module_Name,
9344: 'context values :' ||
9345: p_create_repair_task_rec.context_values);
9346: END IF;

Line 9356: Fnd_Log.string(l_statement_level,

9352: p_api_name => l_api_name);
9353:
9354: IF l_statement_level >= l_debug_level
9355: THEN
9356: Fnd_Log.string(l_statement_level,
9357: l_module_name || '.check_in_parameters',
9358: 'Task id is valid');
9359: END IF;
9360:

Line 9367: Fnd_Log.string(l_statement_level,

9363: p_api_name => l_api_name);
9364:
9365: IF l_statement_level >= l_debug_level
9366: THEN
9367: Fnd_Log.string(l_statement_level,
9368: l_module_name || '.check_in_parameters',
9369: 'Repair Line id is valid');
9370: END IF;
9371:

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

9471: l_applicable_qa_plans VARCHAR2(1);
9472: l_dummy_char VARCHAR2(32000);
9473: l_plan_txn_ids VARCHAR2(5000);
9474:
9475: -- define variables to define fnd_log debug levels
9476: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9477: -- examples : 1- copying buffer x to y : low level detailed messages
9478: l_statement_level NUMBER := Fnd_Log.level_statement;
9479: -- examples : 2- key progress events : starting business transactions

Line 9476: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;

9472: l_dummy_char VARCHAR2(32000);
9473: l_plan_txn_ids VARCHAR2(5000);
9474:
9475: -- define variables to define fnd_log debug levels
9476: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9477: -- examples : 1- copying buffer x to y : low level detailed messages
9478: l_statement_level NUMBER := Fnd_Log.level_statement;
9479: -- examples : 2- key progress events : starting business transactions
9480: l_procedure_level NUMBER := Fnd_Log.level_procedure;

Line 9478: l_statement_level NUMBER := Fnd_Log.level_statement;

9474:
9475: -- define variables to define fnd_log debug levels
9476: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9477: -- examples : 1- copying buffer x to y : low level detailed messages
9478: l_statement_level NUMBER := Fnd_Log.level_statement;
9479: -- examples : 2- key progress events : starting business transactions
9480: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9481: -- examples : 3- event : calling an api, key progress events
9482: l_event_level NUMBER := Fnd_Log.level_event;

Line 9480: l_procedure_level NUMBER := Fnd_Log.level_procedure;

9476: l_debug_level NUMBER := Fnd_Log.g_current_runtime_level;
9477: -- examples : 1- copying buffer x to y : low level detailed messages
9478: l_statement_level NUMBER := Fnd_Log.level_statement;
9479: -- examples : 2- key progress events : starting business transactions
9480: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9481: -- examples : 3- event : calling an api, key progress events
9482: l_event_level NUMBER := Fnd_Log.level_event;
9483: -- examples : 4- exception internal software failure condition
9484: l_exception_level NUMBER := Fnd_Log.level_exception;

Line 9482: l_event_level NUMBER := Fnd_Log.level_event;

9478: l_statement_level NUMBER := Fnd_Log.level_statement;
9479: -- examples : 2- key progress events : starting business transactions
9480: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9481: -- examples : 3- event : calling an api, key progress events
9482: l_event_level NUMBER := Fnd_Log.level_event;
9483: -- examples : 4- exception internal software failure condition
9484: l_exception_level NUMBER := Fnd_Log.level_exception;
9485: -- examples : 5- error end user erros
9486: l_error_level NUMBER := Fnd_Log.level_error;

Line 9484: l_exception_level NUMBER := Fnd_Log.level_exception;

9480: l_procedure_level NUMBER := Fnd_Log.level_procedure;
9481: -- examples : 3- event : calling an api, key progress events
9482: l_event_level NUMBER := Fnd_Log.level_event;
9483: -- examples : 4- exception internal software failure condition
9484: l_exception_level NUMBER := Fnd_Log.level_exception;
9485: -- examples : 5- error end user erros
9486: l_error_level NUMBER := Fnd_Log.level_error;
9487: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_repair_task';
9488:

Line 9486: l_error_level NUMBER := Fnd_Log.level_error;

9482: l_event_level NUMBER := Fnd_Log.level_event;
9483: -- examples : 4- exception internal software failure condition
9484: l_exception_level NUMBER := Fnd_Log.level_exception;
9485: -- examples : 5- error end user erros
9486: l_error_level NUMBER := Fnd_Log.level_error;
9487: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_repair_task';
9488:
9489: BEGIN
9490: -- -----------------

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

9493:
9494: -- Standard Start of API savepoint
9495: IF l_statement_level >= l_debug_level
9496: THEN
9497: Fnd_Log.string(l_statement_level, l_module_name, 'begin');
9498: END IF;
9499: SAVEPOINT update_repair_task;
9500:
9501: -- Standard call to check for call compatibility.

Line 9504: Fnd_Log.string(l_statement_level,

9500:
9501: -- Standard call to check for call compatibility.
9502: IF l_statement_level >= l_debug_level
9503: THEN
9504: Fnd_Log.string(l_statement_level,
9505: l_module_name,
9506: 'checking api compatibility');
9507: END IF;
9508: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,

Line 9515: Fnd_Log.string(l_exception_level,

9511: G_PKG_NAME)
9512: THEN
9513: IF l_exception_level >= l_debug_level
9514: THEN
9515: Fnd_Log.string(l_exception_level,
9516: l_module_name,
9517: 'checking api compatibility, was unsuccessful');
9518: END IF;
9519: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 9524: Fnd_Log.string(l_statement_level,

9520: END IF;
9521:
9522: IF l_statement_level >= l_debug_level
9523: THEN
9524: Fnd_Log.string(l_statement_level,
9525: l_module_name,
9526: 'checking api compatibility, was successful');
9527: END IF;
9528:

Line 9541: Fnd_Log.String(l_Statement_Level,

9537: -- Api body starts
9538: -- ---------------
9539: IF l_statement_level >= l_debug_level
9540: THEN
9541: Fnd_Log.String(l_Statement_Level,
9542: l_Module_Name,
9543: 'Task Record Values:');
9544: Fnd_Log.String(l_Statement_Level,
9545: l_Module_Name,

Line 9544: Fnd_Log.String(l_Statement_Level,

9540: THEN
9541: Fnd_Log.String(l_Statement_Level,
9542: l_Module_Name,
9543: 'Task Record Values:');
9544: Fnd_Log.String(l_Statement_Level,
9545: l_Module_Name,
9546: 'Task Id :' ||
9547: p_update_repair_task_rec.task_Id);
9548: Fnd_Log.String(l_Statement_Level,

Line 9548: Fnd_Log.String(l_Statement_Level,

9544: Fnd_Log.String(l_Statement_Level,
9545: l_Module_Name,
9546: 'Task Id :' ||
9547: p_update_repair_task_rec.task_Id);
9548: Fnd_Log.String(l_Statement_Level,
9549: l_Module_Name,
9550: 'Repair_line_id :' ||
9551: p_update_repair_task_rec.repair_line_id);
9552: -- fnd_log.String(l_Statement_Level,l_Module_Name,'Applicable QA Plans :'|| p_update_repair_task_rec.applicable_qa_plans );

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

9548: Fnd_Log.String(l_Statement_Level,
9549: l_Module_Name,
9550: 'Repair_line_id :' ||
9551: p_update_repair_task_rec.repair_line_id);
9552: -- fnd_log.String(l_Statement_Level,l_Module_Name,'Applicable QA Plans :'|| p_update_repair_task_rec.applicable_qa_plans );
9553: END IF;
9554:
9555: -- check the required parameter
9556: Csd_Process_Util.check_reqd_param(p_param_value => p_update_repair_task_rec.repair_task_Id,

Line 9562: Fnd_Log.string(l_statement_level,

9558: p_api_name => l_api_name);
9559:
9560: IF l_statement_level >= l_debug_level
9561: THEN
9562: Fnd_Log.string(l_statement_level,
9563: l_module_name || '.check_in_parameters',
9564: 'Repair Task id is valid');
9565: END IF;
9566:

Line 9573: Fnd_Log.string(l_statement_level,

9569: p_api_name => l_api_name);
9570:
9571: IF l_statement_level >= l_debug_level
9572: THEN
9573: Fnd_Log.string(l_statement_level,
9574: l_module_name || '.check_in_parameters',
9575: 'Task id is valid');
9576: END IF;
9577:

Line 9584: Fnd_Log.string(l_statement_level,

9580: p_api_name => l_api_name);
9581:
9582: IF l_statement_level >= l_debug_level
9583: THEN
9584: Fnd_Log.string(l_statement_level,
9585: l_module_name || '.check_in_parameters',
9586: 'Repair Line id is valid');
9587: END IF;
9588: