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.CSM_ACC_PKG dependencies on FND_GLOBAL

Line 84: if ( Length(l_error_msg || fnd_global.local_chr(10)

80: l_pk2_string:= 'to_date(:4,''j'')';
81: END IF;
82: /* Create Execute statement and log strings */
83: l_stmt := l_stmt || ' AND ' || p_pk2_name || ' = ' || l_pk2_string;
84: if ( Length(l_error_msg || fnd_global.local_chr(10)
85: || ' :4 = ' || l_pk2_value) < 4000) then
86: l_error_msg := l_error_msg || fnd_global.local_chr(10)
87: || ' :4 = ' || l_pk2_value;
88: elsif (Length(l_error_msg || ' ...') < 4000) then

Line 86: l_error_msg := l_error_msg || fnd_global.local_chr(10)

82: /* Create Execute statement and log strings */
83: l_stmt := l_stmt || ' AND ' || p_pk2_name || ' = ' || l_pk2_string;
84: if ( Length(l_error_msg || fnd_global.local_chr(10)
85: || ' :4 = ' || l_pk2_value) < 4000) then
86: l_error_msg := l_error_msg || fnd_global.local_chr(10)
87: || ' :4 = ' || l_pk2_value;
88: elsif (Length(l_error_msg || ' ...') < 4000) then
89: l_error_msg := l_error_msg || ' ...';
90: end if;

Line 108: if ( Length(l_error_msg || fnd_global.local_chr(10)

104: l_pk3_string:= 'to_date(:5,''j'')';
105: END IF;
106: /* Create Execute statement and log strings */
107: l_stmt := l_stmt || ' AND ' || p_pk3_name || ' = ' || l_pk3_string;
108: if ( Length(l_error_msg || fnd_global.local_chr(10)
109: || ' :5 = ' || l_pk3_value) < 4000) then
110: l_error_msg := l_error_msg || fnd_global.local_chr(10)
111: || ' :5 = ' || l_pk3_value;
112: elsif (Length(l_error_msg || ' ...') < 4000) then

Line 110: l_error_msg := l_error_msg || fnd_global.local_chr(10)

106: /* Create Execute statement and log strings */
107: l_stmt := l_stmt || ' AND ' || p_pk3_name || ' = ' || l_pk3_string;
108: if ( Length(l_error_msg || fnd_global.local_chr(10)
109: || ' :5 = ' || l_pk3_value) < 4000) then
110: l_error_msg := l_error_msg || fnd_global.local_chr(10)
111: || ' :5 = ' || l_pk3_value;
112: elsif (Length(l_error_msg || ' ...') < 4000) then
113: l_error_msg := l_error_msg || ' ...';
114: end if;

Line 123: CSM_UTIL_PKG.LOG( l_stmt || fnd_global.local_chr(10) ||

119: end if;
120: END IF;
121: END IF;
122:
123: CSM_UTIL_PKG.LOG( l_stmt || fnd_global.local_chr(10) ||
124: ':1 = ' || p_user_id || fnd_global.local_chr(10) || l_error_msg,
125: 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_PROCEDURE);
126:
127:

Line 124: ':1 = ' || p_user_id || fnd_global.local_chr(10) || l_error_msg,

120: END IF;
121: END IF;
122:
123: CSM_UTIL_PKG.LOG( l_stmt || fnd_global.local_chr(10) ||
124: ':1 = ' || p_user_id || fnd_global.local_chr(10) || l_error_msg,
125: 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_PROCEDURE);
126:
127:
128: IF p_pk2_name IS NULL THEN

Line 140: CSM_UTIL_PKG.LOG( 'No Access_ID found for Statement:' || l_stmt || fnd_global.local_chr(10) ||

136: RETURN l_access_id;
137:
138: EXCEPTION
139: WHEN NO_DATA_FOUND THEN
140: CSM_UTIL_PKG.LOG( 'No Access_ID found for Statement:' || l_stmt || fnd_global.local_chr(10) ||
141: ':1 = ' || p_user_id, 'CSM_ACC_PKG.GET_ACC_ID',FND_LOG.LEVEL_EXCEPTION);
142: /*** Record doesn't exist ***/
143: RETURN -1;
144: WHEN OTHERS THEN

Line 256: if ( Length(l_error_msg || fnd_global.local_chr(10)

252: p_pk1_name ||', '|| p_pk2_name || ') ' ||
253: 'VALUES ('
254: || p_seq_name || '.NEXTVAL, SYSDATE, 1, SYSDATE, 1, 1, 1, :1, ' ||
255: l_pk1_string || ', ' || l_pk2_string || ' ) RETURNING '|| 'ACCESS_ID INTO :3';
256: if ( Length(l_error_msg || fnd_global.local_chr(10)
257: || ' :4 = ' || l_pk2_value) < 4000) then
258: l_error_msg := l_error_msg || fnd_global.local_chr(10)
259: || ' :4 = ' || l_pk2_value;
260: elsif (Length(l_error_msg || ' ...') < 4000) then

Line 258: l_error_msg := l_error_msg || fnd_global.local_chr(10)

254: || p_seq_name || '.NEXTVAL, SYSDATE, 1, SYSDATE, 1, 1, 1, :1, ' ||
255: l_pk1_string || ', ' || l_pk2_string || ' ) RETURNING '|| 'ACCESS_ID INTO :3';
256: if ( Length(l_error_msg || fnd_global.local_chr(10)
257: || ' :4 = ' || l_pk2_value) < 4000) then
258: l_error_msg := l_error_msg || fnd_global.local_chr(10)
259: || ' :4 = ' || l_pk2_value;
260: elsif (Length(l_error_msg || ' ...') < 4000) then
261: l_error_msg := l_error_msg || ' ...';
262: end if;

Line 285: if ( Length(l_error_msg || fnd_global.local_chr(10)

281: 'VALUES ('
282: || p_seq_name || '.NEXTVAL, SYSDATE, 1, SYSDATE, 1, 1, 1, :1, ' ||
283: l_pk1_string || ', ' || l_pk2_string || ', ' || l_pk3_string || ' ) RETURNING '||
284: 'ACCESS_ID INTO :3';
285: if ( Length(l_error_msg || fnd_global.local_chr(10)
286: || ' :5 = ' || l_pk3_value) < 4000) then
287: l_error_msg := l_error_msg || fnd_global.local_chr(10)
288: || ' :5 = ' || l_pk3_value;
289: elsif (Length(l_error_msg || ' ...') < 4000) then

Line 287: l_error_msg := l_error_msg || fnd_global.local_chr(10)

283: l_pk1_string || ', ' || l_pk2_string || ', ' || l_pk3_string || ' ) RETURNING '||
284: 'ACCESS_ID INTO :3';
285: if ( Length(l_error_msg || fnd_global.local_chr(10)
286: || ' :5 = ' || l_pk3_value) < 4000) then
287: l_error_msg := l_error_msg || fnd_global.local_chr(10)
288: || ' :5 = ' || l_pk3_value;
289: elsif (Length(l_error_msg || ' ...') < 4000) then
290: l_error_msg := l_error_msg || ' ...';
291: end if;

Line 301: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||

297: end if;
298: END IF;
299: END IF;
300:
301: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
302: l_stmt || fnd_global.local_chr(10) || ':1 = ' || l_user_id
303: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
304:
305:

Line 302: l_stmt || fnd_global.local_chr(10) || ':1 = ' || l_user_id

298: END IF;
299: END IF;
300:
301: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
302: l_stmt || fnd_global.local_chr(10) || ':1 = ' || l_user_id
303: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
304:
305:
306: /*We have at least one PK so get the value*/

Line 303: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

299: END IF;
300:
301: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
302: l_stmt || fnd_global.local_chr(10) || ':1 = ' || l_user_id
303: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
304:
305:
306: /*We have at least one PK so get the value*/
307: IF l_pk2_value IS NULL THEN

Line 451: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||

447: dbms_sql.define_array( l_cursor, 1, l_tab_mobile_user_id, 10, l_index);
448: dbms_sql.define_array( l_cursor, 2, l_tab_access_id, 10, l_index);
449:
450:
451: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
452: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
453: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
454: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
455: ':P4 = ' || l_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

Line 452: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||

448: dbms_sql.define_array( l_cursor, 2, l_tab_access_id, 10, l_index);
449:
450:
451: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
452: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
453: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
454: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
455: ':P4 = ' || l_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
456:

Line 453: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||

449:
450:
451: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
452: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
453: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
454: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
455: ':P4 = ' || l_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
456:
457:

Line 454: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||

450:
451: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
452: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
453: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
454: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
455: ':P4 = ' || l_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
456:
457:
458: l_count := dbms_sql.execute( l_cursor );