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 CS_CIC_ATTRIBUTE_PUB

Line 1: PACKAGE BODY CS_CIC_ATTRIBUTE_PUB AS

1: PACKAGE BODY CS_CIC_ATTRIBUTE_PUB AS
2: /* $Header: cscicatb.pls 120.12.12020000.3 2013/03/01 20:04:26 spamujul ship $ */
3:
4:
5: PROCEDURE CREATE_CIC_ATTRIBUTE_NOTE

Line 57: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',

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
61: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 63: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',

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;
67:

Line 107: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',

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
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 113: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',

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;
117:

Line 124: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTRIBUTE_NOTE',

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;
128:

Line 255: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',

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
259: x_return_status := 'S';

Line 262: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',

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;
266:

Line 274: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CIC_AUTO_GENERATE_TASKS',

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:
278: END CIC_AUTO_GENERATE_TASKS;

Line 437: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTR_RECORD',

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;
441: CREATE_CIC_ATTRIBUTE_NOTE ( p_incident_id,

Line 468: module => 'CS.CS_CIC_ATTRIBUTE_PUB.CREATE_CIC_ATTR_RECORD',

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:
472: END CREATE_CIC_ATTR_RECORD;

Line 653: module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',

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:
657: END IF;

Line 688: module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',

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:
692: END UPDATE_CIC_ATTR_RECORD;

Line 707: module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',

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;
711: -- commit;

Line 718: module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',

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:
722: END DELETE_CIC_ATTR_RECORD;

Line 725: END CS_CIC_ATTRIBUTE_PUB;

721:
722: END DELETE_CIC_ATTR_RECORD;
723:
724:
725: END CS_CIC_ATTRIBUTE_PUB;