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.JTF_FM_OCM_REND_REQ dependencies on JTF_FM_UTL_V

Line 84: JTF_FM_UTL_V.PRINT_MESSAGE('Creating Batch XML ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: l_message := '' || p_content_xml || '';
83:
84: JTF_FM_UTL_V.PRINT_MESSAGE('Creating Batch XML ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
85: l_index := 0;
86: -- Get the greatest index of the last entry in all the address tables.
87: IF l_index < p_fax.LAST THEN
88: l_index := p_fax.LAST;

Line 96: JTF_FM_UTL_V.PRINT_MESSAGE (to_char(l_index),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

92: END IF;
93: IF l_index < p_printer.LAST THEN
94: l_index := p_printer.LAST;
95: END IF;
96: JTF_FM_UTL_V.PRINT_MESSAGE (to_char(l_index),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
97:
98: IF (l_index = 0) THEN
99: l_Error_Msg := 'Must pass batch address list';
100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 137: JTF_FM_UTL_V.PRINT_MESSAGE('Getting the greatest value ..'||TO_CHAR(l_index),

133: END IF;
134:
135:
136: l_message := l_message||'';
137: JTF_FM_UTL_V.PRINT_MESSAGE('Getting the greatest value ..'||TO_CHAR(l_index),
138: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
139: FOR i IN 1..l_index LOOP
140: -- Check if atleast one destination address has been passed
141: IF( p_email.EXISTS(i) OR p_fax.EXISTS(i) OR p_printer.EXISTS(i)) THEN

Line 138: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

134:
135:
136: l_message := l_message||'';
137: JTF_FM_UTL_V.PRINT_MESSAGE('Getting the greatest value ..'||TO_CHAR(l_index),
138: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
139: FOR i IN 1..l_index LOOP
140: -- Check if atleast one destination address has been passed
141: IF( p_email.EXISTS(i) OR p_fax.EXISTS(i) OR p_printer.EXISTS(i)) THEN
142: -- For each table check if the record exists.

Line 211: JTF_FM_UTL_V.PRINT_MESSAGE('Begin PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

207: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
208:
209:
210: BEGIN
211: JTF_FM_UTL_V.PRINT_MESSAGE('Begin PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
212:
213:
214: INSERT INTO JTF_FM_REQUEST_CONTENTS (
215: REQUEST_ID,

Line 252: JTF_FM_UTL_V.PRINT_MESSAGE('End PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

248: p_content_source ,
249: p_file_id );
250:
251:
252: JTF_FM_UTL_V.PRINT_MESSAGE('End PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
253:
254: EXCEPTION
255: WHEN OTHERS
256: THEN

Line 257: JTF_FM_UTL_V.PRINT_MESSAGE('UNEXPECTED ERROR IN PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

253:
254: EXCEPTION
255: WHEN OTHERS
256: THEN
257: JTF_FM_UTL_V.PRINT_MESSAGE('UNEXPECTED ERROR IN PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
258:
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260:
261: END INSERT_REQUEST_CONTENTS;

Line 277: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

273: l_api_name CONSTANT VARCHAR2(30) := 'GET_FILE_NAME';
274: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
275:
276: BEGIN
277: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
278: JTF_FM_UTL_V.PRINT_MESSAGE('File Id' || p_file_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
279: -- Bug Fix # 3769865 (removed Userenv Lang condition)
280: SELECT FILE_NAME into l_file_name from fnd_lobs where file_id = p_file_id ;
281:

Line 278: JTF_FM_UTL_V.PRINT_MESSAGE('File Id' || p_file_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

274: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME || '.' || l_api_name;
275:
276: BEGIN
277: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
278: JTF_FM_UTL_V.PRINT_MESSAGE('File Id' || p_file_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
279: -- Bug Fix # 3769865 (removed Userenv Lang condition)
280: SELECT FILE_NAME into l_file_name from fnd_lobs where file_id = p_file_id ;
281:
282: JTF_FM_UTL_V.PRINT_MESSAGE('END function ', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

Line 282: JTF_FM_UTL_V.PRINT_MESSAGE('END function ', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

278: JTF_FM_UTL_V.PRINT_MESSAGE('File Id' || p_file_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
279: -- Bug Fix # 3769865 (removed Userenv Lang condition)
280: SELECT FILE_NAME into l_file_name from fnd_lobs where file_id = p_file_id ;
281:
282: JTF_FM_UTL_V.PRINT_MESSAGE('END function ', JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
283:
284: RETURN l_file_name;
285:
286: EXCEPTION

Line 290: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_API_FILENAME_NOTFOUND',to_char(p_file_id));

286: EXCEPTION
287: WHEN NO_DATA_FOUND
288: THEN
289: --l_Error_Msg := 'Could not find queue_names in the database';
290: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_API_FILENAME_NOTFOUND',to_char(p_file_id));
291:
292: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
293:
294:

Line 292: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

288: THEN
289: --l_Error_Msg := 'Could not find queue_names in the database';
290: JTF_FM_UTL_V.Handle_ERROR('JTF_FM_API_FILENAME_NOTFOUND',to_char(p_file_id));
291:
292: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
293:
294:
295: END GET_FILE_NAME;
296:

Line 336: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,

332:
333:
334: BEGIN
335:
336: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,
337: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
338:
339: -- First we need to determine whether this is a test request or a
340: -- normal request, as the rules for determining the file id are different.

Line 337: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

333:
334: BEGIN
335:
336: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,
337: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
338:
339: -- First we need to determine whether this is a test request or a
340: -- normal request, as the rules for determining the file id are different.
341:

Line 406: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_OCM_ATTACH_ABS',

402: END IF;
403:
404: EXCEPTION
405: WHEN NO_DATA_FOUND THEN
406: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_OCM_ATTACH_ABS',
407: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
408: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_ATTACH_ABS', p_citem_ver_id);
409: RAISE FND_API.G_EXC_ERROR;
410: END;

Line 407: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

403:
404: EXCEPTION
405: WHEN NO_DATA_FOUND THEN
406: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_OCM_ATTACH_ABS',
407: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
408: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_ATTACH_ABS', p_citem_ver_id);
409: RAISE FND_API.G_EXC_ERROR;
410: END;
411:

Line 408: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_ATTACH_ABS', p_citem_ver_id);

404: EXCEPTION
405: WHEN NO_DATA_FOUND THEN
406: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_OCM_ATTACH_ABS',
407: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
408: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_ATTACH_ABS', p_citem_ver_id);
409: RAISE FND_API.G_EXC_ERROR;
410: END;
411:
412: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name,

Line 412: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name,

408: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_ATTACH_ABS', p_citem_ver_id);
409: RAISE FND_API.G_EXC_ERROR;
410: END;
411:
412: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name,
413: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
414: RETURN file_id;
415:
416: END GET_FILE_ID;

Line 413: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

409: RAISE FND_API.G_EXC_ERROR;
410: END;
411:
412: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name,
413: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
414: RETURN file_id;
415:
416: END GET_FILE_ID;
417:

Line 500: JTF_FM_UTL_V.PRINT_MESSAGE('GET_AND_INSERT_REQUEST_DETAILS name = ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

496:
497:
498:
499: BEGIN
500: JTF_FM_UTL_V.PRINT_MESSAGE('GET_AND_INSERT_REQUEST_DETAILS name = ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
501: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
502: IF rendition_file_ids IS NOT NULL THEN
503: att_count := rendition_file_ids.COUNT;
504: JTF_FM_UTL_V.PRINT_MESSAGE('att_count size is ' || att_count,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

Line 501: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

497:
498:
499: BEGIN
500: JTF_FM_UTL_V.PRINT_MESSAGE('GET_AND_INSERT_REQUEST_DETAILS name = ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
501: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
502: IF rendition_file_ids IS NOT NULL THEN
503: att_count := rendition_file_ids.COUNT;
504: JTF_FM_UTL_V.PRINT_MESSAGE('att_count size is ' || att_count,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
505: x_html := ' ' || a;

Line 504: JTF_FM_UTL_V.PRINT_MESSAGE('att_count size is ' || att_count,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

500: JTF_FM_UTL_V.PRINT_MESSAGE('GET_AND_INSERT_REQUEST_DETAILS name = ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
501: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
502: IF rendition_file_ids IS NOT NULL THEN
503: att_count := rendition_file_ids.COUNT;
504: JTF_FM_UTL_V.PRINT_MESSAGE('att_count size is ' || att_count,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
505: x_html := ' ' || a;
506:
507: LOOP
508: EXIT WHEN att_count = counter;

Line 515: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File ID = ' || rendition_file_ids(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

511: --DBMS_OUTPUT.PUT_LINE('Rendition Mime Names = ' || rendition_mime_names(counter));
512:
513: --DBMS_OUTPUT.PUT_LINE('------------------------------------------------');
514:
515: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File ID = ' || rendition_file_ids(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
516: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File name = ' || rendition_file_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
517: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Types = ' || rendition_mime_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
518: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Names = ' || rendition_mime_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
519:

Line 516: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File name = ' || rendition_file_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

512:
513: --DBMS_OUTPUT.PUT_LINE('------------------------------------------------');
514:
515: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File ID = ' || rendition_file_ids(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
516: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File name = ' || rendition_file_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
517: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Types = ' || rendition_mime_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
518: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Names = ' || rendition_mime_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
519:
520: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 517: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Types = ' || rendition_mime_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

513: --DBMS_OUTPUT.PUT_LINE('------------------------------------------------');
514:
515: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File ID = ' || rendition_file_ids(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
516: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File name = ' || rendition_file_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
517: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Types = ' || rendition_mime_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
518: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Names = ' || rendition_mime_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
519:
520: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
521: IF UPPER(rendition_mime_types(counter)) = G_MIME_TBL(1) THEN

Line 518: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Names = ' || rendition_mime_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

514:
515: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File ID = ' || rendition_file_ids(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
516: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File name = ' || rendition_file_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
517: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Types = ' || rendition_mime_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
518: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Names = ' || rendition_mime_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
519:
520: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
521: IF UPPER(rendition_mime_types(counter)) = G_MIME_TBL(1) THEN
522: html_file_id := rendition_file_ids(counter);

Line 520: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

516: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition File name = ' || rendition_file_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
517: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Types = ' || rendition_mime_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
518: JTF_FM_UTL_V.PRINT_MESSAGE('Rendition Mime Names = ' || rendition_mime_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
519:
520: JTF_FM_UTL_V.PRINT_MESSAGE('------------------------------------------------',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
521: IF UPPER(rendition_mime_types(counter)) = G_MIME_TBL(1) THEN
522: html_file_id := rendition_file_ids(counter);
523: html_mime_name := rendition_mime_names(counter);
524: IF l_count_total = 0 THEN

Line 696: IF JTF_FM_UTL_V.IS_FLD_VALID(p_email_format) THEN

692: RAISE FND_API.G_EXC_ERROR;
693:
694: END IF;
695:
696: IF JTF_FM_UTL_V.IS_FLD_VALID(p_email_format) THEN
697: IF(upper(p_email_format) = 'BOTH') THEN
698: IF NOT (html_flag) THEN
699: -- add html
700: html_flag := true;

Line 767: ELSE -- ELSE IF JTF_FM_UTL_V.IS_FLD_VALID(p_email_format))

763:
764:
765:
766:
767: ELSE -- ELSE IF JTF_FM_UTL_V.IS_FLD_VALID(p_email_format))
768: -- Get html rendition
769:
770: IF NOT (html_flag) THEN
771: -- add html

Line 820: END IF;--END IF(JTF_FM_UTL_V.IS_FLD_VALID

816: END IF;
817: RAISE FND_API.G_EXC_ERROR;
818:
819: END IF; -- End IF Not(html_flag
820: END IF;--END IF(JTF_FM_UTL_V.IS_FLD_VALID
821:
822: END IF; -- IF (INSTR(p_media_type, 'E') > 0 OR INSTR(p_media_type, 'F') > 0)
823: x_html := x_html || ' content_no = "1" ' ||a;
824: x_html := x_html || '>' ||a; -- End

Line 855: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

851: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
852: p_count => x_msg_count,
853: p_data => x_msg_data
854: );
855: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
856:
857: WHEN FND_API.G_EXC_ERROR
858: THEN
859:

Line 868: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

864: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
865: p_count => x_msg_count,
866: p_data => x_msg_data
867: );
868: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
869:
870: WHEN OTHERS
871: THEN
872:

Line 875: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);

871: THEN
872:
873: --x_citem_name := NULL;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
876:
877: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_OCM_REND_REQ', G_PKG_NAME );

Line 887: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

883: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
888:
889: for i in 0..x_msg_count loop
890: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
891:

Line 890: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');

886: );
887: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
888:
889: for i in 0..x_msg_count loop
890: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
891:
892: end loop;
893:
894:

Line 1031: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,

1027:
1028:
1029: BEGIN
1030:
1031: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,
1032: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1033:
1034: -- Initialize API return status to success
1035: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1032: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1028:
1029: BEGIN
1030:
1031: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,
1032: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1033:
1034: -- Initialize API return status to success
1035: x_return_status := FND_API.G_RET_STS_SUCCESS;
1036:

Line 1049: JTF_FM_UTL_V.PRINT_MESSAGE('IT IS A TEST REQUEST: THE COUNT IS ' ||

1045: BEGIN
1046:
1047: IF l_req_count > 0 THEN
1048:
1049: JTF_FM_UTL_V.PRINT_MESSAGE('IT IS A TEST REQUEST: THE COUNT IS ' ||
1050: l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1051: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
1052:
1053: -- This is a test request, so the next thing to determine is if there

Line 1050: l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

1046:
1047: IF l_req_count > 0 THEN
1048:
1049: JTF_FM_UTL_V.PRINT_MESSAGE('IT IS A TEST REQUEST: THE COUNT IS ' ||
1050: l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1051: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
1052:
1053: -- This is a test request, so the next thing to determine is if there
1054: -- was a version passed into the call. If so, we use it, othewise

Line 1109: JTF_FM_UTL_V.PRINT_MESSAGE(

1105: END IF;
1106:
1107: EXCEPTION
1108: WHEN NO_DATA_FOUND THEN
1109: JTF_FM_UTL_V.PRINT_MESSAGE(
1110: 'Content is either not present in OCM or is not approved' ||
1111: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1112:
1113: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);

Line 1111: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1107: EXCEPTION
1108: WHEN NO_DATA_FOUND THEN
1109: JTF_FM_UTL_V.PRINT_MESSAGE(
1110: 'Content is either not present in OCM or is not approved' ||
1111: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1112:
1113: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
1114: RAISE FND_API.G_EXC_ERROR;
1115: END;

Line 1113: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);

1109: JTF_FM_UTL_V.PRINT_MESSAGE(
1110: 'Content is either not present in OCM or is not approved' ||
1111: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1112:
1113: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
1114: RAISE FND_API.G_EXC_ERROR;
1115: END;
1116:
1117:

Line 1119: JTF_FM_UTL_V.PRINT_MESSAGE('Before calling IBC_CITEM_ADMIN_GRP.get_item',

1115: END;
1116:
1117:
1118:
1119: JTF_FM_UTL_V.PRINT_MESSAGE('Before calling IBC_CITEM_ADMIN_GRP.get_item',
1120: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1121:
1122:
1123: BEGIN

Line 1120: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1116:
1117:
1118:
1119: JTF_FM_UTL_V.PRINT_MESSAGE('Before calling IBC_CITEM_ADMIN_GRP.get_item',
1120: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1121:
1122:
1123: BEGIN
1124:

Line 1182: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_EXCEPTION_IN_GET_ITEM name = '

1178: ,msg_data);
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_EXCEPTION_IN_GET_ITEM name = '
1183: ||x_item_version_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1184:
1185: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_EXCEPTION_IN_GET_ITEM',
1186: x_item_version_id);

Line 1183: ||x_item_version_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_EXCEPTION_IN_GET_ITEM name = '
1183: ||x_item_version_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1184:
1185: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_EXCEPTION_IN_GET_ITEM',
1186: x_item_version_id);
1187:

Line 1185: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_EXCEPTION_IN_GET_ITEM',

1181: WHEN OTHERS THEN
1182: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_EXCEPTION_IN_GET_ITEM name = '
1183: ||x_item_version_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1184:
1185: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_EXCEPTION_IN_GET_ITEM',
1186: x_item_version_id);
1187:
1188: RAISE FND_API.G_EXC_ERROR;
1189:

Line 1194: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_GET_TRANS_ITEM_FAIL name = '||

1190: END;
1191:
1192: if (return_status <> FND_API.G_RET_STS_SUCCESS) then
1193:
1194: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_GET_TRANS_ITEM_FAIL name = '||
1195: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1196: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_GET_TRANS_ITEM_FAIL', p_content_id);
1197:
1198: RAISE FND_API.G_EXC_ERROR;

Line 1195: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1191:
1192: if (return_status <> FND_API.G_RET_STS_SUCCESS) then
1193:
1194: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_GET_TRANS_ITEM_FAIL name = '||
1195: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1196: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_GET_TRANS_ITEM_FAIL', p_content_id);
1197:
1198: RAISE FND_API.G_EXC_ERROR;
1199:

Line 1196: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_GET_TRANS_ITEM_FAIL', p_content_id);

1192: if (return_status <> FND_API.G_RET_STS_SUCCESS) then
1193:
1194: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_GET_TRANS_ITEM_FAIL name = '||
1195: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1196: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_GET_TRANS_ITEM_FAIL', p_content_id);
1197:
1198: RAISE FND_API.G_EXC_ERROR;
1199:
1200: else

Line 1202: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_REND_DETAILS name = '||citem_name,

1198: RAISE FND_API.G_EXC_ERROR;
1199:
1200: else
1201:
1202: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_REND_DETAILS name = '||citem_name,
1203: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1204: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,
1205: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1206:

Line 1203: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1199:
1200: else
1201:
1202: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_REND_DETAILS name = '||citem_name,
1203: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1204: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,
1205: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1206:
1207: counter := 0;

Line 1204: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,

1200: else
1201:
1202: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_REND_DETAILS name = '||citem_name,
1203: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1204: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,
1205: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1206:
1207: counter := 0;
1208:

Line 1205: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1201:
1202: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_REND_DETAILS name = '||citem_name,
1203: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1204: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,
1205: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1206:
1207: counter := 0;
1208:
1209: -- Starting to process the returns from get_trans_item()

Line 1215: JTF_FM_UTL_V.PRINT_MESSAGE('com count '||

1211: IF component_citems IS NOT NULL THEN
1212:
1213: comp_count := component_citems.COUNT;
1214:
1215: JTF_FM_UTL_V.PRINT_MESSAGE('com count '||
1216: comp_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1217:
1218: LOOP
1219:

Line 1216: comp_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1212:
1213: comp_count := component_citems.COUNT;
1214:
1215: JTF_FM_UTL_V.PRINT_MESSAGE('com count '||
1216: comp_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1217:
1218: LOOP
1219:
1220: EXIT WHEN comp_count = counter;

Line 1223: JTF_FM_UTL_V.PRINT_MESSAGE('component citems = ' ||

1219:
1220: EXIT WHEN comp_count = counter;
1221: counter := counter + 1;
1222:
1223: JTF_FM_UTL_V.PRINT_MESSAGE('component citems = ' ||
1224: component_citems(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1225: l_full_name);
1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||
1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

Line 1224: component_citems(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

1220: EXIT WHEN comp_count = counter;
1221: counter := counter + 1;
1222:
1223: JTF_FM_UTL_V.PRINT_MESSAGE('component citems = ' ||
1224: component_citems(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1225: l_full_name);
1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||
1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1228: l_full_name);

Line 1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||

1222:
1223: JTF_FM_UTL_V.PRINT_MESSAGE('component citems = ' ||
1224: component_citems(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1225: l_full_name);
1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||
1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1228: l_full_name);
1229: JTF_FM_UTL_V.PRINT_MESSAGE('component_citem_names = ' ||
1230: component_citem_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

Line 1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

1223: JTF_FM_UTL_V.PRINT_MESSAGE('component citems = ' ||
1224: component_citems(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1225: l_full_name);
1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||
1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1228: l_full_name);
1229: JTF_FM_UTL_V.PRINT_MESSAGE('component_citem_names = ' ||
1230: component_citem_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1231: l_full_name);

Line 1229: JTF_FM_UTL_V.PRINT_MESSAGE('component_citem_names = ' ||

1225: l_full_name);
1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||
1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1228: l_full_name);
1229: JTF_FM_UTL_V.PRINT_MESSAGE('component_citem_names = ' ||
1230: component_citem_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1231: l_full_name);
1232:
1233: -- Check if this is a QUERY

Line 1230: component_citem_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

1226: JTF_FM_UTL_V.PRINT_MESSAGE('component_attrib_types = ' ||
1227: component_attrib_types(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1228: l_full_name);
1229: JTF_FM_UTL_V.PRINT_MESSAGE('component_citem_names = ' ||
1230: component_citem_names(counter),JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1231: l_full_name);
1232:
1233: -- Check if this is a QUERY
1234:

Line 1254: IF (JTF_FM_UTL_V.CONFIRM_RTF(x_temp_file_id)) THEN

1250:
1251: -- For the attachment, need to determine whether RTF, PDF,
1252: -- HTML, or text
1253:
1254: IF (JTF_FM_UTL_V.CONFIRM_RTF(x_temp_file_id)) THEN
1255:
1256: l_doc_type := G_MIME_TBL(4);
1257: l_file_type := ' rtf_id ="';
1258:

Line 1259: ELSIF(JTF_FM_UTL_V.CONFIRM_PDF(x_temp_file_id)) THEN

1255:
1256: l_doc_type := G_MIME_TBL(4);
1257: l_file_type := ' rtf_id ="';
1258:
1259: ELSIF(JTF_FM_UTL_V.CONFIRM_PDF(x_temp_file_id)) THEN
1260:
1261: l_doc_type := G_MIME_TBL(3);
1262: l_file_type := ' pdf_id ="';
1263:

Line 1264: ELSIF(JTF_FM_UTL_V.CONFIRM_TEXT_HTML(x_temp_file_id)) THEN

1260:
1261: l_doc_type := G_MIME_TBL(3);
1262: l_file_type := ' pdf_id ="';
1263:
1264: ELSIF(JTF_FM_UTL_V.CONFIRM_TEXT_HTML(x_temp_file_id)) THEN
1265:
1266: l_doc_type := G_MIME_TBL(2);
1267: l_file_type := ' id ="';
1268:

Line 1309: JTF_FM_UTL_V.PRINT_MESSAGE('x_html :' || x_html,

1305: x_temp_file_id);
1306:
1307: END IF;
1308:
1309: JTF_FM_UTL_V.PRINT_MESSAGE('x_html :' || x_html,
1310: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1311: JTF_FM_UTL_V.PRINT_MESSAGE('----------------------------------------',
1312: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1313: END LOOP;

Line 1310: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1306:
1307: END IF;
1308:
1309: JTF_FM_UTL_V.PRINT_MESSAGE('x_html :' || x_html,
1310: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1311: JTF_FM_UTL_V.PRINT_MESSAGE('----------------------------------------',
1312: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1313: END LOOP;
1314:

Line 1311: JTF_FM_UTL_V.PRINT_MESSAGE('----------------------------------------',

1307: END IF;
1308:
1309: JTF_FM_UTL_V.PRINT_MESSAGE('x_html :' || x_html,
1310: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1311: JTF_FM_UTL_V.PRINT_MESSAGE('----------------------------------------',
1312: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1313: END LOOP;
1314:
1315: END IF;

Line 1312: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1308:
1309: JTF_FM_UTL_V.PRINT_MESSAGE('x_html :' || x_html,
1310: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1311: JTF_FM_UTL_V.PRINT_MESSAGE('----------------------------------------',
1312: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1313: END LOOP;
1314:
1315: END IF;
1316:

Line 1350: JTF_FM_UTL_V.PRINT_MESSAGE('End GET_OCM_REND_DETAILS',

1346: end if;
1347:
1348: DELETE FROM JTF_FM_TEST_REQUESTS WHERE REQUEST_ID = p_request_id;
1349:
1350: JTF_FM_UTL_V.PRINT_MESSAGE('End GET_OCM_REND_DETAILS',
1351: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1352:
1353: EXCEPTION
1354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1351: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1347:
1348: DELETE FROM JTF_FM_TEST_REQUESTS WHERE REQUEST_ID = p_request_id;
1349:
1350: JTF_FM_UTL_V.PRINT_MESSAGE('End GET_OCM_REND_DETAILS',
1351: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1352:
1353: EXCEPTION
1354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1355:

Line 1364: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1360: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1361: p_count => x_msg_count,
1362: p_data => x_msg_data
1363: );
1364: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367:
1368: x_citem_name := NULL;

Line 1376: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1372: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1373: p_count => x_msg_count,
1374: p_data => x_msg_data
1375: );
1376: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1377:
1378: WHEN OTHERS THEN
1379:
1380: x_citem_name := NULL;

Line 1382: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);

1378: WHEN OTHERS THEN
1379:
1380: x_citem_name := NULL;
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
1383:
1384: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1385: THEN
1386: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_OCM_REND_REQ', G_PKG_NAME );

Line 1394: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1390: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1391: p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1395:
1396: for i in 0..x_msg_count loop
1397:
1398: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),

Line 1398: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),

1394: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1395:
1396: for i in 0..x_msg_count loop
1397:
1398: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),
1399: JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1400: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
1401:
1402: end loop;

Line 1399: JTF_FM_UTL_V.G_LEVEL_PROCEDURE,

1395:
1396: for i in 0..x_msg_count loop
1397:
1398: JTF_FM_UTL_V.PRINT_MESSAGE(FND_MSG_PUB.get(i,FND_API.G_FALSE),
1399: JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
1400: 'JTF_FM_REQUEST_GRP.GET_OCM_REND_DETAILS');
1401:
1402: end loop;
1403:

Line 1464: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1460: -- Moved all cursors to JTF_FM_UTILITY PACKAGE
1461:
1462: BEGIN
1463:
1464: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1465:
1466: -- Standard begin of API savepoint
1467: SAVEPOINT Content_XML;
1468:

Line 1505: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_content_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1501: -- unique identifier for getting the document from MES tables
1502: IF (p_content_id IS NULL)
1503: THEN
1504: l_Error_Msg := 'Must pass p_content_id parameter';
1505: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_content_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1506:
1507:
1508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1509: THEN

Line 1521: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_media_type parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1517: -- request without a media_type
1518: ELSIF (p_media_type IS NULL) -- IF (p_media_type IS NULL)
1519: THEN
1520: l_Error_Msg := 'Must pass p_media_type parameters';
1521: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_media_type parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1522:
1523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1524: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_MEDIA_TYPE');
1525: FND_MSG_PUB.Add;

Line 1534: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_request_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1530:
1531: ELSIF (p_request_id IS NULL) -- IF (p_request_id IS NULL)
1532: THEN
1533: l_Error_Msg := 'Must pass p_request_id parameters';
1534: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_request_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1535:
1536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1537: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
1538: FND_MSG_PUB.Add;

Line 1594: JTF_FM_UTL_V.PRINT_MESSAGE('Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1590: -- Check if atleast one valid media type has been specified
1591: IF (l_temp = 0)
1592: THEN
1593: l_Error_Msg := 'Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER';
1594: JTF_FM_UTL_V.PRINT_MESSAGE('Invalid media type specified. Allowed media_types are EMAIL, FAX, PRINTER' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1595:
1596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1597: THEN
1598: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');

Line 1609: JTF_FM_UTL_V.PRINT_MESSAGE('Right after media has been formed' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1605:
1606: l_message := l_message||' '||a;
1607:
1608: -- New XML code added by sxkrishn 10-25-02
1609: JTF_FM_UTL_V.PRINT_MESSAGE('Right after media has been formed' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1610:
1611:
1612:
1613:

Line 1625: l_media := JTF_FM_UTL_V.GET_MEDIA(l_message);

1621: END IF;
1622: l_message := l_message||'>' || a;
1623:
1624:
1625: l_media := JTF_FM_UTL_V.GET_MEDIA(l_message);
1626: --dbms_output.PUT_LINE('media type is :' || l_media);
1627:
1628:
1629: -- Assuming that this call will be made only for OCM contents

Line 1646: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in OCM Repository' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1642: x_msg_count ,
1643: x_msg_data
1644: );
1645: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1646: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in OCM Repository' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1647:
1648: l_message := l_message|| x_html;
1649: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1650: RAISE FND_API.G_EXC_ERROR;

Line 1654: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in OCM Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1650: RAISE FND_API.G_EXC_ERROR;
1651: ELSE
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653:
1654: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in OCM Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1655: END IF;
1656:
1657:
1658:

Line 1718: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

1714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1715: ROLLBACK TO Content_XML;
1716: x_content_xml := NULL;
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1718: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1719: -- Standard call to get message count and if count=1, get the message
1720: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1721: p_count => x_msg_count,
1722: p_data => x_msg_data

Line 1724: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1720: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1721: p_count => x_msg_count,
1722: p_data => x_msg_data
1723: );
1724: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1725:
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: ROLLBACK TO Content_XML;
1728: x_content_xml := NULL;

Line 1730: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

1726: WHEN FND_API.G_EXC_ERROR THEN
1727: ROLLBACK TO Content_XML;
1728: x_content_xml := NULL;
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
1731: -- Standard call to get message count and if count=1, get the message
1732: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1733: p_count => x_msg_count,
1734: p_data => x_msg_data

Line 1736: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1732: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1733: p_count => x_msg_count,
1734: p_data => x_msg_data
1735: );
1736: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1737:
1738: WHEN OTHERS THEN
1739: ROLLBACK TO Content_XML;
1740: x_content_xml := NULL;

Line 1742: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);

1738: WHEN OTHERS THEN
1739: ROLLBACK TO Content_XML;
1740: x_content_xml := NULL;
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
1743:
1744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1745: FND_MSG_PUB.Add_Exc_Msg
1746: (G_PKG_NAME, l_api_name);

Line 1754: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

1750: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
1751: p_count => x_msg_count,
1752: p_data => x_msg_data
1753: );
1754: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1755:
1756: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1757:
1758: END Get_RENDITION_XML;

Line 1756: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1752: p_data => x_msg_data
1753: );
1754: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
1755:
1756: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1757:
1758: END Get_RENDITION_XML;
1759:
1760:

Line 1813: l_fm_pvt_rec JTF_FM_UTL_V.FM_PVT_REC_TYPE;

1809: l_message VARCHAR2(32767);
1810: l_content_nm VARCHAR2(1) := null;
1811: x_test_xml VARCHAR2(32767);
1812:
1813: l_fm_pvt_rec JTF_FM_UTL_V.FM_PVT_REC_TYPE;
1814:
1815: BEGIN
1816: --dbms_output.put_line('In create Fulfillment API');
1817:

Line 1818: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1814:
1815: BEGIN
1816: --dbms_output.put_line('In create Fulfillment API');
1817:
1818: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1819: -- Standard Start of API savepoint
1820: SAVEPOINT create_fulfillment;
1821: -- Standard call to check for call compatibility.
1822: IF NOT FND_API.Compatible_API_Call

Line 1838: JTF_FM_UTL_V.PRINT_MESSAGE('In params-Create_fulfillment Rendition' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1834: FND_MSG_PUB.initialize;
1835: END IF;
1836:
1837: -- If loggin is set at the highest level, record the in params to the API
1838: JTF_FM_UTL_V.PRINT_MESSAGE('In params-Create_fulfillment Rendition' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1835: END IF;
1836:
1837: -- If loggin is set at the highest level, record the in params to the API
1838: JTF_FM_UTL_V.PRINT_MESSAGE('In params-Create_fulfillment Rendition' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1836:
1837: -- If loggin is set at the highest level, record the in params to the API
1838: JTF_FM_UTL_V.PRINT_MESSAGE('In params-Create_fulfillment Rendition' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1837: -- If loggin is set at the highest level, record the in params to the API
1838: JTF_FM_UTL_V.PRINT_MESSAGE('In params-Create_fulfillment Rendition' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1838: JTF_FM_UTL_V.PRINT_MESSAGE('In params-Create_fulfillment Rendition' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1839: JTF_FM_UTL_V.PRINT_MESSAGE('template_id: ' || p_fulfill_electronic_rec.template_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1840: JTF_FM_UTL_V.PRINT_MESSAGE('version_id: ' || p_fulfill_electronic_rec.version_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1841: JTF_FM_UTL_V.PRINT_MESSAGE('object_type: ' || p_fulfill_electronic_rec.object_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1842: JTF_FM_UTL_V.PRINT_MESSAGE('object_id: ' || p_fulfill_electronic_rec.object_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1843: JTF_FM_UTL_V.PRINT_MESSAGE('source_code: ' || p_fulfill_electronic_rec.source_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1844: JTF_FM_UTL_V.PRINT_MESSAGE('source_code_id: ' || p_fulfill_electronic_rec.source_code_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1845: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_type: ' || p_fulfill_electronic_rec.requestor_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1846: JTF_FM_UTL_V.PRINT_MESSAGE('requestor_id: ' || p_fulfill_electronic_rec.requestor_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1847: JTF_FM_UTL_V.PRINT_MESSAGE('server_group: ' || p_fulfill_electronic_rec.server_group,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1848: JTF_FM_UTL_V.PRINT_MESSAGE('schedule_date: ' || p_fulfill_electronic_rec.schedule_date,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1849: JTF_FM_UTL_V.PRINT_MESSAGE('media_types: ' || p_fulfill_electronic_rec.media_types,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1850: JTF_FM_UTL_V.PRINT_MESSAGE('archive: ' || p_fulfill_electronic_rec.archive,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1858:

Line 1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1851: JTF_FM_UTL_V.PRINT_MESSAGE('log_user_ih: ' || p_fulfill_electronic_rec.log_user_ih,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1858:
1859: -- Following have been commented out as they may exceed the limits set:

Line 1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1852: JTF_FM_UTL_V.PRINT_MESSAGE('request_type: ' || p_fulfill_electronic_rec.request_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1858:
1859: -- Following have been commented out as they may exceed the limits set:
1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1853: JTF_FM_UTL_V.PRINT_MESSAGE('language_code: ' || p_fulfill_electronic_rec.language_code,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1854: JTF_FM_UTL_V.PRINT_MESSAGE('profile_id: ' || p_fulfill_electronic_rec.profile_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1855: JTF_FM_UTL_V.PRINT_MESSAGE('order_id: ' || p_fulfill_electronic_rec.order_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1858:
1859: -- Following have been commented out as they may exceed the limits set:
1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1856: JTF_FM_UTL_V.PRINT_MESSAGE('collateral_id: ' || p_fulfill_electronic_rec.collateral_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1858:
1859: -- Following have been commented out as they may exceed the limits set:
1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1857: JTF_FM_UTL_V.PRINT_MESSAGE('subject: ' || p_fulfill_electronic_rec.subject,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1858:
1859: -- Following have been commented out as they may exceed the limits set:
1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1858:
1859: -- Following have been commented out as they may exceed the limits set:
1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1859: -- Following have been commented out as they may exceed the limits set:
1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:

Line 1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1860: --JTF_FM_UTL_V.PRINT_MESSAGE('party_id: ' || p_fulfill_electronic_rec.party_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1861: --JTF_FM_UTL_V.PRINT_MESSAGE('email: ' || p_fulfill_electronic_rec.email,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1862: --JTF_FM_UTL_V.PRINT_MESSAGE('fax: ' || p_fulfill_electronic_rec.fax,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1863: --JTF_FM_UTL_V.PRINT_MESSAGE('printer: ' || p_fulfill_electronic_rec.printer,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1870: JTF_FM_UTL_V.PRINT_MESSAGE('content_type: ' || p_fulfill_electronic_rec.content_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1864: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_values: ' || p_fulfill_electronic_rec.bind_values,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1870: JTF_FM_UTL_V.PRINT_MESSAGE('content_type: ' || p_fulfill_electronic_rec.content_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1871: JTF_FM_UTL_V.PRINT_MESSAGE('stop_list_bypass: ' || p_fulfill_electronic_rec.stop_list_bypass,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1872:

Line 1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1865: --JTF_FM_UTL_V.PRINT_MESSAGE('bind_names: ' || p_fulfill_electronic_rec.bind_names,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1870: JTF_FM_UTL_V.PRINT_MESSAGE('content_type: ' || p_fulfill_electronic_rec.content_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1871: JTF_FM_UTL_V.PRINT_MESSAGE('stop_list_bypass: ' || p_fulfill_electronic_rec.stop_list_bypass,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1872:
1873:

Line 1870: JTF_FM_UTL_V.PRINT_MESSAGE('content_type: ' || p_fulfill_electronic_rec.content_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1866: --JTF_FM_UTL_V.PRINT_MESSAGE('extended_header: ' || p_fulfill_electronic_rec.extended_header,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1870: JTF_FM_UTL_V.PRINT_MESSAGE('content_type: ' || p_fulfill_electronic_rec.content_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1871: JTF_FM_UTL_V.PRINT_MESSAGE('stop_list_bypass: ' || p_fulfill_electronic_rec.stop_list_bypass,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1872:
1873:
1874:

Line 1871: JTF_FM_UTL_V.PRINT_MESSAGE('stop_list_bypass: ' || p_fulfill_electronic_rec.stop_list_bypass,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

1867:
1868: JTF_FM_UTL_V.PRINT_MESSAGE('email_text: ' || p_fulfill_electronic_rec.email_text,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1869: JTF_FM_UTL_V.PRINT_MESSAGE('content_name: ' || p_fulfill_electronic_rec.content_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1870: JTF_FM_UTL_V.PRINT_MESSAGE('content_type: ' || p_fulfill_electronic_rec.content_type,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1871: JTF_FM_UTL_V.PRINT_MESSAGE('stop_list_bypass: ' || p_fulfill_electronic_rec.stop_list_bypass,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
1872:
1873:
1874:
1875:

Line 1908: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1904: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN
1905: l_Error_Msg := null;
1906: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
1907: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
1908: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1909: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
1910: RAISE FND_API.G_EXC_ERROR;
1911:
1912: ELSE

Line 1909: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');

1905: l_Error_Msg := null;
1906: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
1907: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
1908: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1909: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
1910: RAISE FND_API.G_EXC_ERROR;
1911:
1912: ELSE
1913: IF (IS_MED_EPF(p_fulfill_electronic_rec.media_types)) THEN

Line 1924: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1920: l_printer_val := p_fulfill_electronic_rec.printer(1);
1921: ELSE
1922: IF p_fulfill_electronic_rec.request_type = 'S' THEN
1923: l_Error_Msg := 'Chosen Media is Print but missing print address';
1924: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1925: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_PRINT_ADDR');
1926: RAISE FND_API.G_EXC_ERROR;
1927: ELSE--for mass requests
1928: l_printer_val := 'Query';

Line 1925: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_PRINT_ADDR');

1921: ELSE
1922: IF p_fulfill_electronic_rec.request_type = 'S' THEN
1923: l_Error_Msg := 'Chosen Media is Print but missing print address';
1924: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1925: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_PRINT_ADDR');
1926: RAISE FND_API.G_EXC_ERROR;
1927: ELSE--for mass requests
1928: l_printer_val := 'Query';
1929: END IF;

Line 1941: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1937: l_fax_val := p_fulfill_electronic_rec.fax(1);
1938: ELSE
1939: IF p_fulfill_electronic_rec.request_type = 'S' THEN
1940: l_Error_Msg := 'Chosen Media is FAX but missing FAX address';
1941: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1942: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_FAX_ADDR');
1943: RAISE FND_API.G_EXC_ERROR;
1944: ELSE -- no need of fax address for mass requests
1945: l_fax_val := 'Query';

Line 1942: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_FAX_ADDR');

1938: ELSE
1939: IF p_fulfill_electronic_rec.request_type = 'S' THEN
1940: l_Error_Msg := 'Chosen Media is FAX but missing FAX address';
1941: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1942: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_FAX_ADDR');
1943: RAISE FND_API.G_EXC_ERROR;
1944: ELSE -- no need of fax address for mass requests
1945: l_fax_val := 'Query';
1946: END IF;

Line 1961: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1957: ELSE
1958: IF p_fulfill_electronic_rec.request_type = 'S' THEN
1959:
1960: l_Error_Msg := 'Chosen Media is Email but missing email address';
1961: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1962: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_EMAIL_ADDR');
1963: RAISE FND_API.G_EXC_ERROR;
1964: ELSE
1965: l_email_val := 'Query';

Line 1962: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_EMAIL_ADDR');

1958: IF p_fulfill_electronic_rec.request_type = 'S' THEN
1959:
1960: l_Error_Msg := 'Chosen Media is Email but missing email address';
1961: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1962: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_EMAIL_ADDR');
1963: RAISE FND_API.G_EXC_ERROR;
1964: ELSE
1965: l_email_val := 'Query';
1966: END IF;

Line 1975: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

1971: ELSE -- Means media is not E or P or F
1972: l_Error_Msg := null;
1973: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
1974: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
1975: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1976: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
1977: RAISE FND_API.G_EXC_ERROR;
1978:
1979:

Line 1976: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');

1972: l_Error_Msg := null;
1973: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
1974: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
1975: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
1976: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
1977: RAISE FND_API.G_EXC_ERROR;
1978:
1979:
1980: END IF;

Line 1987: JTF_FM_UTL_V.PRINT_MESSAGE('Extended header is null',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

1983:
1984:
1985:
1986: IF(p_fulfill_electronic_rec.extended_header IS NULL) THEN
1987: JTF_FM_UTL_V.PRINT_MESSAGE('Extended header is null',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1988: l_extended_header := FND_API.G_MISS_CHAR;
1989: ELSE
1990: l_extended_header := p_fulfill_electronic_rec.extended_header;
1991: END IF;

Line 2007: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request Return Status is ' || x_return_status,

2003: x_msg_count => l_msg_count,
2004: x_msg_data => l_msg_data,
2005: x_request_id => x_request_history_id
2006: );
2007: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request Return Status is ' || x_return_status,
2008: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2009:
2010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2011: RAISE FND_API.G_EXC_ERROR;

Line 2008: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2004: x_msg_data => l_msg_data,
2005: x_request_id => x_request_history_id
2006: );
2007: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request Return Status is ' || x_return_status,
2008: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2009:
2010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2011: RAISE FND_API.G_EXC_ERROR;
2012: END IF;

Line 2014: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg request id is ' || to_char(x_request_history_id),

2010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2011: RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013:
2014: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg request id is ' || to_char(x_request_history_id),
2015: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2016: l_total := p_fulfill_electronic_rec.bind_names.count;
2017: FOR i IN 1..l_total LOOP
2018: l_bind_var(i) := p_fulfill_electronic_rec.bind_names(i);

Line 2015: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2011: RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013:
2014: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg request id is ' || to_char(x_request_history_id),
2015: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2016: l_total := p_fulfill_electronic_rec.bind_names.count;
2017: FOR i IN 1..l_total LOOP
2018: l_bind_var(i) := p_fulfill_electronic_rec.bind_names(i);
2019: l_bind_val(i) := p_fulfill_electronic_rec.bind_values(i);

Line 2024: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg l_content_id is ' || to_char(l_content_id),

2020: l_bind_var_type(i) := 'VARCHAR2';
2021: END LOOP;
2022:
2023: l_content_id := p_fulfill_electronic_rec.template_id;
2024: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg l_content_id is ' || to_char(l_content_id),
2025: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2026:
2027: /**
2028: just before calling send request we will insert a record into

Line 2025: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2021: END LOOP;
2022:
2023: l_content_id := p_fulfill_electronic_rec.template_id;
2024: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg l_content_id is ' || to_char(l_content_id),
2025: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2026:
2027: /**
2028: just before calling send request we will insert a record into
2029: history table. Reason. GET_FILE_ID should

Line 2033: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST TYPE IS TEST',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2029: history table. Reason. GET_FILE_ID should
2030: know about REQUEST_TYPE 'T'
2031: **/
2032: IF (upper(p_fulfill_electronic_rec.request_type) = 'T') THEN
2033: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST TYPE IS TEST',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2034: INSERT INTO JTF_FM_TEST_REQUESTS (REQUEST_ID) VALUES (x_request_history_id);
2035: END IF;
2036:
2037: /********************************************************

Line 2079: JTF_FM_UTL_V.PRINT_MESSAGE('Get_Rendition_XML Return Status is ' || l_return_status,

2075: p_fulfill_electronic_rec.version_id,
2076: nvl(p_fulfill_electronic_rec.email_format,'BOTH')
2077: );
2078:
2079: JTF_FM_UTL_V.PRINT_MESSAGE('Get_Rendition_XML Return Status is ' || l_return_status,
2080: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2081:
2082: l_content_xml := l_content_xml1;
2083:

Line 2080: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2076: nvl(p_fulfill_electronic_rec.email_format,'BOTH')
2077: );
2078:
2079: JTF_FM_UTL_V.PRINT_MESSAGE('Get_Rendition_XML Return Status is ' || l_return_status,
2080: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2081:
2082: l_content_xml := l_content_xml1;
2083:
2084: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2115: JTF_FM_UTL_V.PRINT_MESSAGE('GET_TEST_XML Return Status is ' || l_return_status,

2111: x_return_status => l_return_status,
2112: x_test_xml => x_test_xml
2113:
2114: ) ;
2115: JTF_FM_UTL_V.PRINT_MESSAGE('GET_TEST_XML Return Status is ' || l_return_status,
2116: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2118: THEN
2119: RAISE FND_API.G_EXC_ERROR;

Line 2116: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2112: x_test_xml => x_test_xml
2113:
2114: ) ;
2115: JTF_FM_UTL_V.PRINT_MESSAGE('GET_TEST_XML Return Status is ' || l_return_status,
2116: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2118: THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;

Line 2152: JTF_FM_UTL_V.PRINT_MESSAGE('Item has a valid query OCM Repository',

2148: -- Mass request is supported only for OCM contents
2149: -- Proceed
2150: IF(INSTR(l_content_xml,'query_id') >0)
2151: THEN
2152: JTF_FM_UTL_V.PRINT_MESSAGE('Item has a valid query OCM Repository',
2153: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2154: IF upper(p_fulfill_electronic_rec.request_type) = 'L' THEN
2155: l_message := '' || l_content_xml || '';
2156: ELSE

Line 2153: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2149: -- Proceed
2150: IF(INSTR(l_content_xml,'query_id') >0)
2151: THEN
2152: JTF_FM_UTL_V.PRINT_MESSAGE('Item has a valid query OCM Repository',
2153: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2154: IF upper(p_fulfill_electronic_rec.request_type) = 'L' THEN
2155: l_message := '' || l_content_xml || '';
2156: ELSE
2157: l_message := '' || l_content_xml || '';

Line 2162: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_OCM_QUERY',l_content_id);

2158: END IF;
2159: ELSE
2160: -- throw error, item should have a query assoc for mass requests
2161: l_Error_Msg := 'Content must have a valid query associated with it.';
2162: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_OCM_QUERY',l_content_id);
2163: RAISE FND_API.G_EXC_ERROR;
2164: END IF;
2165: END IF;
2166: l_fm_pvt_rec.priority := 1.0;

Line 2171: JTF_FM_UTL_V.FM_SUBMIT_REQ_V1

2167: l_fm_pvt_rec.content_xml := l_message;
2168: l_fm_pvt_rec.request_id := x_request_history_id ;
2169: l_fm_pvt_rec.doc_id := 1.0;
2170: l_fm_pvt_rec.doc_ref := 'UNSET';
2171: JTF_FM_UTL_V.FM_SUBMIT_REQ_V1
2172: (
2173: p_api_version ,
2174: p_init_msg_list,
2175: p_commit,

Line 2182: JTF_FM_UTL_V.PRINT_MESSAGE('Submit_Mass_Request Return Status is ' || x_return_status,

2178: x_msg_data,
2179: p_fulfill_electronic_rec,
2180: l_fm_pvt_rec
2181: );
2182: JTF_FM_UTL_V.PRINT_MESSAGE('Submit_Mass_Request Return Status is ' || x_return_status,
2183: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2184: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;

Line 2183: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

2179: p_fulfill_electronic_rec,
2180: l_fm_pvt_rec
2181: );
2182: JTF_FM_UTL_V.PRINT_MESSAGE('Submit_Mass_Request Return Status is ' || x_return_status,
2183: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
2184: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187: