APPS.IRC_NOTIFICATION_DATA_PKG dependencies on FND_MESSAGE

Line 284: return l_communicationTopicDetails||'...'||l_new_line||fnd_message.get_string('PER','IRC_403036_COMM_LONG_MSG')||';';

280: fetch csrMessageBodyContent into l_messageBodyContent;
281: close csrMessageBodyContent;
282:
283: if l_messageBodyContent > 1000 then
284: return l_communicationTopicDetails||'...'||l_new_line||fnd_message.get_string('PER','IRC_403036_COMM_LONG_MSG')||';';
285: else
286: return l_communicationTopicDetails||';';
287: end if;
288:

Line 398: fnd_message.set_name('PER','IRC_412699_INTVLOC_ADDR_BODY');

394: context_code => loc_rec.style),
395: segments,
396: TRUE);
397:
398: fnd_message.set_name('PER','IRC_412699_INTVLOC_ADDR_BODY');
399: FOR i IN 1 .. segments.nsegments LOOP
400: v_segment_name1 := segments.segment_name(i);
401: v_segment_name := segments.application_column_name(i);
402: l_sqlbuf := 'select '||v_segment_name|| ' from ' || l_table_name||' where location_id= '||l_location_id;

Line 406: fnd_message.set_token('TOKEN'|| i,null || v_segment_val || ',',false);

402: l_sqlbuf := 'select '||v_segment_name|| ' from ' || l_table_name||' where location_id= '||l_location_id;
403: OPEN item_cursor FOR l_sqlbuf ;
404: fetch item_cursor into v_segment_val;
405: if v_segment_val is not null then
406: fnd_message.set_token('TOKEN'|| i,null || v_segment_val || ',',false);
407: else
408: fnd_message.set_token('TOKEN'||i,null,false);
409: end if;
410: close item_cursor;

Line 408: fnd_message.set_token('TOKEN'||i,null,false);

404: fetch item_cursor into v_segment_val;
405: if v_segment_val is not null then
406: fnd_message.set_token('TOKEN'|| i,null || v_segment_val || ',',false);
407: else
408: fnd_message.set_token('TOKEN'||i,null,false);
409: end if;
410: close item_cursor;
411: IF i = segments.nsegments then
412: exit;

Line 419: fnd_message.set_token('TOKEN'||i,null,false);

415:
416: v_no_of_segments := segments.nsegments ;
417: if v_no_of_segments < 22 then
418: for i in v_no_of_segments+1 .. 22 loop
419: fnd_message.set_token('TOKEN'||i,null,false);
420: end loop;
421: end if;
422: v_message := fnd_message.get;
423: v_message1 := replace(v_message,'
',null);

Line 422: v_message := fnd_message.get;

418: for i in v_no_of_segments+1 .. 22 loop
419: fnd_message.set_token('TOKEN'||i,null,false);
420: end loop;
421: end if;
422: v_message := fnd_message.get;
423: v_message1 := replace(v_message,'
',null);
424: v_message := substr(trim(v_message1),0,length(trim(v_message1))-1);
425: v_message1 := replace(v_message,' ',null);
426: return l_interviewDetails||'IRC_INTVW_LOC_ADDRESS:'|| v_message1||';';