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.CS_CIC_ATTRIBUTE_PUB dependencies on FND_LOG

Line 55: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

51: p_note_status => l_note_status,
52: p_jtf_note_contexts_tab => l_note_context_tab_dflt );
53:
54: IF ( l_return_status ) <> 'S' THEN
55: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
56: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,
57: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
58: message => 'Address Notes Creation Failed with errors: '||l_msg_data);
59: END IF;

Line 56: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,

52: p_jtf_note_contexts_tab => l_note_context_tab_dflt );
53:
54: IF ( l_return_status ) <> 'S' THEN
55: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
56: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,
57: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
58: message => 'Address Notes Creation Failed with errors: '||l_msg_data);
59: END IF;
60: ELSE

Line 61: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

57: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
58: message => 'Address Notes Creation Failed with errors: '||l_msg_data);
59: END IF;
60: ELSE
61: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
62: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
63: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
64: message => 'Address Notes Created Successfully');
65: END IF;

Line 62: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,

58: message => 'Address Notes Creation Failed with errors: '||l_msg_data);
59: END IF;
60: ELSE
61: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
62: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
63: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
64: message => 'Address Notes Created Successfully');
65: END IF;
66: END IF;

Line 105: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

101: x_msg_count => l_msg_count,
102: x_msg_data => l_msg_data );
103:
104: IF ( l_return_status ) <> 'S' THEN
105: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
106: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,
107: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
108: message => 'Attributes Notes Creation Failed with errors: '||l_msg_data);
109: END IF;

Line 106: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,

102: x_msg_data => l_msg_data );
103:
104: IF ( l_return_status ) <> 'S' THEN
105: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
106: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,
107: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
108: message => 'Attributes Notes Creation Failed with errors: '||l_msg_data);
109: END IF;
110: ELSE

Line 111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

107: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
108: message => 'Attributes Notes Creation Failed with errors: '||l_msg_data);
109: END IF;
110: ELSE
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
112: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
113: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
114: message => 'Attributes Notes Created Successfully');
115: END IF;

Line 112: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,

108: message => 'Attributes Notes Creation Failed with errors: '||l_msg_data);
109: END IF;
110: ELSE
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
112: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
113: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
114: message => 'Attributes Notes Created Successfully');
115: END IF;
116: END IF;

Line 122: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

118: END IF;
119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
123: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
124: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
125: message => 'SQL Exception: '||SQLERRM);
126: END IF;

Line 123: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
123: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
124: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',
125: message => 'SQL Exception: '||SQLERRM);
126: END IF;
127: END CREATE_CIC_ATTRIBUTE_NOTE;

Line 253: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

249: IF ( l_return_status ) <> 'S' THEN
250: ROLLBACK TO AUTO_TASK;
251:
252: x_return_status := 'F';
253: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
254: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,
255: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',
256: message => 'Auto Task Creation Failed with errors: '||l_msg_data);
257: END IF;

Line 254: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,

250: ROLLBACK TO AUTO_TASK;
251:
252: x_return_status := 'F';
253: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
254: FND_LOG.STRING(log_level => FND_LOG.LEVEL_ERROR,
255: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',
256: message => 'Auto Task Creation Failed with errors: '||l_msg_data);
257: END IF;
258: ELSE

Line 260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

256: message => 'Auto Task Creation Failed with errors: '||l_msg_data);
257: END IF;
258: ELSE
259: x_return_status := 'S';
260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
261: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
262: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',
263: message => 'Auto Task Creation Successfully');
264: END IF;

Line 261: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,

257: END IF;
258: ELSE
259: x_return_status := 'S';
260: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
261: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
262: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',
263: message => 'Auto Task Creation Successfully');
264: END IF;
265: END IF;

Line 272: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

268: WHEN OTHERS THEN
269: ROLLBACK TO AUTO_TASK;
270:
271: x_return_status := 'F';
272: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
273: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
274: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',
275: message => 'SQL Exception: '||SQLERRM);
276: END IF;

Line 273: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

269: ROLLBACK TO AUTO_TASK;
270:
271: x_return_status := 'F';
272: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
273: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
274: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',
275: message => 'SQL Exception: '||SQLERRM);
276: END IF;
277:

Line 435: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

431: X_LAST_UPDATE_LOGIN => p_last_update_login,
432: X_CREATION_DATE => l_creation_date,
433: X_LAST_UPDATE_DATE => l_creation_date );
434:
435: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
436: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
437: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTR_RECORD',
438: message => 'Attribute Code = '||p_cic_attribute_code(i)||'; Value ='||p_cic_attr_value(i));
439: END IF;

Line 436: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,

432: X_CREATION_DATE => l_creation_date,
433: X_LAST_UPDATE_DATE => l_creation_date );
434:
435: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
436: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
437: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTR_RECORD',
438: message => 'Attribute Code = '||p_cic_attribute_code(i)||'; Value ='||p_cic_attr_value(i));
439: END IF;
440: END LOOP;

Line 466: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

462: l_values_exist :='N';
463: -- End fix for 12.2.2 CIC changes
464: EXCEPTION
465: WHEN OTHERS THEN
466: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
467: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
468: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTR_RECORD',
469: message => 'SQL Exception: '||SQLERRM);
470: END IF;

Line 467: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

463: -- End fix for 12.2.2 CIC changes
464: EXCEPTION
465: WHEN OTHERS THEN
466: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
467: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
468: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTR_RECORD',
469: message => 'SQL Exception: '||SQLERRM);
470: END IF;
471:

Line 651: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

647: X_LAST_UPDATE_DATE => l_last_update_date,
648: X_LAST_UPDATED_BY => p_updated_by,
649: X_LAST_UPDATE_LOGIN => p_last_update_login);
650:
651: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
652: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
653: module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',
654: message => 'Attribute ID = '||p_incident_attr_val_id(i)||'; Attribute Code = '||p_cic_attribute_code(i)||'; Value ='||p_cic_attr_value(i));
655: END IF;

Line 652: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,

648: X_LAST_UPDATED_BY => p_updated_by,
649: X_LAST_UPDATE_LOGIN => p_last_update_login);
650:
651: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
652: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
653: module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',
654: message => 'Attribute ID = '||p_incident_attr_val_id(i)||'; Attribute Code = '||p_cic_attribute_code(i)||'; Value ='||p_cic_attr_value(i));
655: END IF;
656:

Line 686: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

682: END IF;
683: -- End fix for 12.2.2 CIC changes
684: EXCEPTION
685: WHEN OTHERS THEN
686: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
687: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
688: module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',
689: message => 'SQL Exception: '||SQLERRM);
690: END IF;

Line 687: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

683: -- End fix for 12.2.2 CIC changes
684: EXCEPTION
685: WHEN OTHERS THEN
686: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
687: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
688: module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',
689: message => 'SQL Exception: '||SQLERRM);
690: END IF;
691:

Line 705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

701: BEGIN
702: FOR i IN p_incident_attr_val_id.FIRST .. p_incident_attr_val_id.LAST
703: LOOP
704: CUG_INCIDNT_ATTR_VALS_PKG.DELETE_ROW ( p_incident_attr_val_id(i) );
705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
706: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
707: module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',
708: message => 'Deleted Attribute ID: '||p_incident_attr_val_id(i));
709: END IF;

Line 706: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,

702: FOR i IN p_incident_attr_val_id.FIRST .. p_incident_attr_val_id.LAST
703: LOOP
704: CUG_INCIDNT_ATTR_VALS_PKG.DELETE_ROW ( p_incident_attr_val_id(i) );
705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
706: FND_LOG.STRING(log_level => FND_LOG.LEVEL_STATEMENT,
707: module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',
708: message => 'Deleted Attribute ID: '||p_incident_attr_val_id(i));
709: END IF;
710: END LOOP;

Line 716: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

712:
713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
717: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
718: module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',
719: message => 'SQL Exception: '||SQLERRM);
720: END IF;

Line 717: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
717: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
718: module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',
719: message => 'SQL Exception: '||SQLERRM);
720: END IF;
721: