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

Line 12: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_OM_INTERFACE_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'csdvomtb.pls';
10:
11: -- Global variable for storing the debug level
12: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13:
14: /*-------------------------------------------------------------------------------------*/
15: /* Function name: DEBUG */
16: /* Description : Logs the debug message */

Line 38: -- Variables used in FND Log

34: p_mod_name in varchar2,
35: p_severity_level in number
36: ) IS
37:
38: -- Variables used in FND Log
39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;

35: p_severity_level in number
36: ) IS
37:
38: -- Variables used in FND Log
39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
43: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

36: ) IS
37:
38: -- Variables used in FND Log
39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
43: l_error_level number := FND_LOG.LEVEL_ERROR;
44: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 41: l_event_level number := FND_LOG.LEVEL_EVENT;

37:
38: -- Variables used in FND Log
39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
43: l_error_level number := FND_LOG.LEVEL_ERROR;
44: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
45:

Line 42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

38: -- Variables used in FND Log
39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
43: l_error_level number := FND_LOG.LEVEL_ERROR;
44: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
45:
46: BEGIN

Line 43: l_error_level number := FND_LOG.LEVEL_ERROR;

39: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
43: l_error_level number := FND_LOG.LEVEL_ERROR;
44: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
45:
46: BEGIN
47:

Line 44: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

40: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
41: l_event_level number := FND_LOG.LEVEL_EVENT;
42: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
43: l_error_level number := FND_LOG.LEVEL_ERROR;
44: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
45:
46: BEGIN
47:
48: IF p_severity_level = 1 THEN

Line 50: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);

46: BEGIN
47:
48: IF p_severity_level = 1 THEN
49: IF ( l_stat_level >= G_debug_level) THEN
50: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
51: END IF;
52: ELSIF p_severity_level = 2 THEN
53: IF ( l_proc_level >= G_debug_level) THEN
54: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

Line 54: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

50: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
51: END IF;
52: ELSIF p_severity_level = 2 THEN
53: IF ( l_proc_level >= G_debug_level) THEN
54: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
55: END IF;
56: ELSIF p_severity_level = 3 THEN
57: IF ( l_event_level >= G_debug_level) THEN
58: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

Line 58: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

54: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
55: END IF;
56: ELSIF p_severity_level = 3 THEN
57: IF ( l_event_level >= G_debug_level) THEN
58: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
59: END IF;
60: ELSIF p_severity_level = 4 THEN
61: IF ( l_excep_level >= G_debug_level) THEN
62: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

Line 62: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

58: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
59: END IF;
60: ELSIF p_severity_level = 4 THEN
61: IF ( l_excep_level >= G_debug_level) THEN
62: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
63: END IF;
64: ELSIF p_severity_level = 5 THEN
65: IF ( l_error_level >= G_debug_level) THEN
66: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

Line 66: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

62: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
63: END IF;
64: ELSIF p_severity_level = 5 THEN
65: IF ( l_error_level >= G_debug_level) THEN
66: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
67: END IF;
68: ELSIF p_severity_level = 6 THEN
69: IF ( l_unexp_level >= G_debug_level) THEN
70: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

Line 70: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

66: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
67: END IF;
68: ELSIF p_severity_level = 6 THEN
69: IF ( l_unexp_level >= G_debug_level) THEN
70: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);
71: END IF;
72: END IF;
73:
74: END DEBUG;

Line 108: -- Variables used in FND Log

104:
105: l_party_site_id NUMBER;
106: l_party_site_use_id NUMBER;
107:
108: -- Variables used in FND Log
109: l_error_level number := FND_LOG.LEVEL_ERROR;
110: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.get_party_site_id';
111:
112: BEGIN

Line 109: l_error_level number := FND_LOG.LEVEL_ERROR;

105: l_party_site_id NUMBER;
106: l_party_site_use_id NUMBER;
107:
108: -- Variables used in FND Log
109: l_error_level number := FND_LOG.LEVEL_ERROR;
110: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.get_party_site_id';
111:
112: BEGIN
113: -- Initialize the return status

Line 132: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

128: When No_Data_found then
129: IF ( l_error_level >= G_debug_level) THEN
130: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
131: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
132: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
133: ELSE
134: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_USE_ID');
135: fnd_message.set_token('CUST_SITE_USE_ID',p_cust_site_use_id );
136: fnd_msg_pub.add;

Line 159: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

155: When No_Data_found then
156: IF ( l_error_level >= G_debug_level) THEN
157: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
158: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
159: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
160: ELSE
161: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
162: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
163: fnd_msg_pub.add;

Line 171: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

167: When TOO_MANY_ROWS then
168: IF ( l_error_level >= G_debug_level) THEN
169: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
170: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
171: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
172: ELSE
173: fnd_message.set_name('CSD','CSD_INV_PTY_SITE_ID');
174: fnd_message.set_token('PTY_SITE_ID',l_party_site_id);
175: fnd_msg_pub.add;

Line 335: -- Variables used in FND Log

331: SELECT serial_num
332: from rcv_serial_transactions
333: where transaction_id = p_txn_id;
334:
335: -- Variables used in FND Log
336: l_error_level number := FND_LOG.LEVEL_ERROR;
337: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.process_rma';
338:
339: BEGIN

Line 336: l_error_level number := FND_LOG.LEVEL_ERROR;

332: from rcv_serial_transactions
333: where transaction_id = p_txn_id;
334:
335: -- Variables used in FND Log
336: l_error_level number := FND_LOG.LEVEL_ERROR;
337: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.process_rma';
338:
339: BEGIN
340:

Line 363: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

359: IF p_inventory_org_id is NULL OR
360: p_subinventory_name is NULL then
361: IF ( l_error_level >= G_debug_level) THEN
362: fnd_message.set_name('CSD','CSD_PARAMETERS_MISSING');
363: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
364: ELSE
365: fnd_message.set_name('CSD','CSD_PARAMETERS_MISSING');
366: fnd_msg_pub.add;
367: END IF;

Line 400: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

396: l_inc_urgency_id is NULL OR
397: l_inc_work_summary is NULL THEN
398: IF ( l_error_level >= G_debug_level) THEN
399: fnd_message.set_name('CSD','CSD_PROF_SETUP_MISSING');
400: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
401: ELSE
402: fnd_message.set_name('CSD','CSD_PROF_SETUP_MISSING');
403: fnd_msg_pub.add;
404: END IF;

Line 425: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

421: Exception
422: When No_Data_found then
423: IF ( l_error_level >= G_debug_level) THEN
424: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
425: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
426: ELSE
427: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
428: fnd_msg_pub.add;
429: END IF;

Line 435: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

431: Raise FND_API.G_EXC_ERROR ;
432: When TOO_MANY_ROWS then
433: IF ( l_error_level >= G_debug_level) THEN
434: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
435: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
436: ELSE
437: fnd_message.set_name('CSD','CSD_STD_REP_TYPE_MISSING');
438: fnd_msg_pub.add;
439: END IF;

Line 456: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

452: When No_Data_found then
453: IF ( l_error_level >= G_debug_level) THEN
454: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
455: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
456: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
457: ELSE
458: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
459: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
460: fnd_msg_pub.add;

Line 468: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

464: When TOO_MANY_ROWS then
465: IF ( l_error_level >= G_debug_level) THEN
466: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
467: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
468: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
469: ELSE
470: fnd_message.set_name('CSD','CSD_INVALID_INV_ORG_ID');
471: fnd_message.set_token('INV_ORG_ID',p_inventory_org_id);
472: fnd_msg_pub.add;

Line 491: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

487: When No_Data_found then
488: IF ( l_error_level >= G_debug_level) THEN
489: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
490: fnd_message.set_token('SUB_INV',p_subinventory_name );
491: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
492: ELSE
493: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
494: fnd_message.set_token('SUB_INV',p_subinventory_name );
495: fnd_msg_pub.add;

Line 503: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

499: When TOO_MANY_ROWS then
500: IF ( l_error_level >= G_debug_level) THEN
501: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
502: fnd_message.set_token('SUB_INV',p_subinventory_name );
503: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
504: ELSE
505: fnd_message.set_name('CSD','CSD_INVALID_SUB_INV');
506: fnd_message.set_token('SUB_INV',p_subinventory_name );
507: fnd_msg_pub.add;

Line 734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

730: When No_Data_Found then
731: IF ( l_error_level >= G_debug_level) THEN
732: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
733: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
734: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
735: ELSE
736: fnd_message.set_name('CSD','CSD_INV_ITEM_ID');
737: fnd_message.set_token('ITEM_ID',c1.inventory_item_id);
738: fnd_msg_pub.add;

Line 798: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);

794: When No_Data_Found then
795: IF ( l_error_level >= G_debug_level) THEN
796: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
797: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
798: FND_LOG.MESSAGE(l_error_level,l_mod_name, FALSE);
799: ELSE
800: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
801: fnd_message.set_token('SERIAL_NUM', C2.serial_num);
802: fnd_msg_pub.add;

Line 1114: -- Variables used in FND Log

1110:
1111: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
1112: i NUMBER;
1113:
1114: -- Variables used in FND Log
1115: l_error_level number := FND_LOG.LEVEL_ERROR;
1116: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.get_sr_contacts';
1117:
1118: BEGIN

Line 1115: l_error_level number := FND_LOG.LEVEL_ERROR;

1111: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
1112: i NUMBER;
1113:
1114: -- Variables used in FND Log
1115: l_error_level number := FND_LOG.LEVEL_ERROR;
1116: l_mod_name varchar2(2000) := 'csd.plsql.csd_om_interface_pvt.get_sr_contacts';
1117:
1118: BEGIN
1119: Debug( 'At the Beginning of GET_SR_CONTACTS',l_mod_name,1);