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 83: if ( Length(l_error_msg || fnd_global.local_chr(10)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

245: p_pk1_name ||', '|| p_pk2_name || ') ' ||
246: 'VALUES ('
247: || p_seq_name || '.NEXTVAL, SYSDATE, 1, SYSDATE, 1, 1, 1, :1, ' ||
248: l_pk1_string || ', ' || l_pk2_string || ' ) RETURNING '|| 'ACCESS_ID INTO :3';
249: if ( Length(l_error_msg || fnd_global.local_chr(10)
250: || ' :4 = ' || l_pk2_value) < 4000) then
251: l_error_msg := l_error_msg || fnd_global.local_chr(10)
252: || ' :4 = ' || l_pk2_value;
253: elsif (Length(l_error_msg || ' ...') < 4000) then

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

247: || p_seq_name || '.NEXTVAL, SYSDATE, 1, SYSDATE, 1, 1, 1, :1, ' ||
248: l_pk1_string || ', ' || l_pk2_string || ' ) RETURNING '|| 'ACCESS_ID INTO :3';
249: if ( Length(l_error_msg || fnd_global.local_chr(10)
250: || ' :4 = ' || l_pk2_value) < 4000) then
251: l_error_msg := l_error_msg || fnd_global.local_chr(10)
252: || ' :4 = ' || l_pk2_value;
253: elsif (Length(l_error_msg || ' ...') < 4000) then
254: l_error_msg := l_error_msg || ' ...';
255: end if;

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

274: 'VALUES ('
275: || p_seq_name || '.NEXTVAL, SYSDATE, 1, SYSDATE, 1, 1, 1, :1, ' ||
276: l_pk1_string || ', ' || l_pk2_string || ', ' || l_pk3_string || ' ) RETURNING '||
277: 'ACCESS_ID INTO :3';
278: if ( Length(l_error_msg || fnd_global.local_chr(10)
279: || ' :5 = ' || l_pk3_value) < 4000) then
280: l_error_msg := l_error_msg || fnd_global.local_chr(10)
281: || ' :5 = ' || l_pk3_value;
282: elsif (Length(l_error_msg || ' ...') < 4000) then

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

276: l_pk1_string || ', ' || l_pk2_string || ', ' || l_pk3_string || ' ) RETURNING '||
277: 'ACCESS_ID INTO :3';
278: if ( Length(l_error_msg || fnd_global.local_chr(10)
279: || ' :5 = ' || l_pk3_value) < 4000) then
280: l_error_msg := l_error_msg || fnd_global.local_chr(10)
281: || ' :5 = ' || l_pk3_value;
282: elsif (Length(l_error_msg || ' ...') < 4000) then
283: l_error_msg := l_error_msg || ' ...';
284: end if;

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

290: end if;
291: END IF;
292: END IF;
293:
294: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
295: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_user_id
296: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
297:
298:

Line 295: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_user_id

291: END IF;
292: END IF;
293:
294: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
295: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_user_id
296: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
297:
298:
299: /*We have at least one PK so get the value*/

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

292: END IF;
293:
294: CSM_UTIL_PKG.LOG( 'executing:' || fnd_global.local_chr(10) ||
295: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_user_id
296: || fnd_global.local_chr(10) || l_error_msg, 'CSM_ACC_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
297:
298:
299: /*We have at least one PK so get the value*/
300: IF l_pk2_value IS NULL THEN

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

435: dbms_sql.define_array( l_cursor, 1, l_tab_mobile_user_id, 10, l_index);
436: dbms_sql.define_array( l_cursor, 2, l_tab_access_id, 10, l_index);
437:
438:
439: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
440: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
441: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
442: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
443: ':P4 = ' || p_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

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

436: dbms_sql.define_array( l_cursor, 2, l_tab_access_id, 10, l_index);
437:
438:
439: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
440: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
441: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
442: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
443: ':P4 = ' || p_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
444:

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

437:
438:
439: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
440: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
441: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
442: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
443: ':P4 = ' || p_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
444:
445:

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

438:
439: CSM_UTIL_PKG.LOG( 'executing:' || l_stmt || fnd_global.local_chr(10) ||
440: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
441: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
442: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
443: ':P4 = ' || p_user_id, 'CSM_ACC_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
444:
445:
446: l_count := dbms_sql.execute( l_cursor );