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.AP_WEB_CC_NOTIFICATIONS_PKG dependencies on FND_MESSAGE

Line 271: title := fnd_message.get_string('SQLAP', 'OIE_CC_INACTIVE_TITLE');

267: 'ap.pls.AP_WEB_CC_NOTIFICATIONS_PKG.GET_NEW_CARD_NOTIFICATION',
268: 'Document = '||display_type||','||document_id);
269: end if;
270:
271: title := fnd_message.get_string('SQLAP', 'OIE_CC_INACTIVE_TITLE');
272:
273: colon := instr(document_id, ':');
274: l_request_id := to_number(substr(document_id, 1, colon-1));
275: l_card_program_id := to_number(substr(document_id, colon+1));

Line 291: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_STATUS');

287:
288: l_unassigned_count := l_registered_count - l_inactive_count;
289:
290: cellcnt := 0;
291: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_STATUS');
292: cells(cellcnt+2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');
293: cellcnt := cellcnt + 2;
294:
295: -- Unassigned Credit Cards

Line 292: cells(cellcnt+2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');

288: l_unassigned_count := l_registered_count - l_inactive_count;
289:
290: cellcnt := 0;
291: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_STATUS');
292: cells(cellcnt+2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');
293: cellcnt := cellcnt + 2;
294:
295: -- Unassigned Credit Cards
296: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_UNASSIGNED_CARDS');

Line 296: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_UNASSIGNED_CARDS');

292: cells(cellcnt+2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');
293: cellcnt := cellcnt + 2;
294:
295: -- Unassigned Credit Cards
296: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_UNASSIGNED_CARDS');
297: cells(cellcnt+2) := align_right||':'||to_char(l_unassigned_count);
298: cellcnt := cellcnt + 2;
299:
300: -- Inactive Credit Cards

Line 301: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_INACTIVE_CARDS');

297: cells(cellcnt+2) := align_right||':'||to_char(l_unassigned_count);
298: cellcnt := cellcnt + 2;
299:
300: -- Inactive Credit Cards
301: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_INACTIVE_CARDS');
302: cells(cellcnt+2) := align_right||':'||to_char(l_inactive_count);
303: cellcnt := cellcnt + 2;
304:
305: -- Credit Cards Activated

Line 306: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_ACTIVATED_CARDS');

302: cells(cellcnt+2) := align_right||':'||to_char(l_inactive_count);
303: cellcnt := cellcnt + 2;
304:
305: -- Credit Cards Activated
306: cells(cellcnt+1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_ACTIVATED_CARDS');
307: cells(cellcnt+2) := align_right||':'||to_char(l_active_count);
308: cellcnt := cellcnt + 2;
309:
310: -- New Credit Cards Registered

Line 311: cells(cellcnt+1) := align_total||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_TOTAL_PROMPT');

307: cells(cellcnt+2) := align_right||':'||to_char(l_active_count);
308: cellcnt := cellcnt + 2;
309:
310: -- New Credit Cards Registered
311: cells(cellcnt+1) := align_total||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_TOTAL_PROMPT');
312: cells(cellcnt+2) := align_right||':'||to_char(l_new_count);
313: cellcnt := cellcnt + 2;
314:
315: IF display_type = WF_NOTIFICATION.doc_text THEN

Line 365: title := fnd_message.get_string('SQLAP', 'OIE_CC_INVALID_TITLE');

361: 'ap.pls.AP_WEB_CC_NOTIFICATIONS_PKG.GET_VAL_ERROR_NOTIFICATION',
362: 'Document = '||display_type||','||document_id);
363: end if;
364:
365: title := fnd_message.get_string('SQLAP', 'OIE_CC_INVALID_TITLE');
366:
367: colon := instr(document_id, ':');
368: l_request_id := to_number(substr(document_id, 1, colon-1));
369: l_card_program_id := to_number(substr(document_id, colon+1));

Line 372: cells(1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_VALIDATION_PROMPT');

368: l_request_id := to_number(substr(document_id, 1, colon-1));
369: l_card_program_id := to_number(substr(document_id, colon+1));
370:
371:
372: cells(1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_VALIDATION_PROMPT');
373: cells(2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');
374: cellcnt := 2;
375:
376: totcnt := 0;

Line 373: cells(2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');

369: l_card_program_id := to_number(substr(document_id, colon+1));
370:
371:
372: cells(1) := align_start||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_VALIDATION_PROMPT');
373: cells(2) := align_right||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_COUNT');
374: cellcnt := 2;
375:
376: totcnt := 0;
377: FOR cvalrec IN cvalidation LOOP

Line 392: cells(cellcnt+1) := align_total||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_TOTAL_PROMPT');

388: totcnt := totcnt + valcnt;
389: END IF;
390: END LOOP;
391:
392: cells(cellcnt+1) := align_total||':'||FND_MESSAGE.get_string('SQLAP', 'OIE_CC_TOTAL_PROMPT');
393: cells(cellcnt+2) := align_right||':'||to_char(totcnt);
394: cellcnt := cellcnt + 2;
395:
396: IF display_type = WF_NOTIFICATION.doc_text THEN