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_REQUEST_GRP dependencies on JTF_FM_UTL_V

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

67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: l_message := '' || p_content_xml || '';
70:
71: JTF_FM_UTL_V.PRINT_MESSAGE('Creating Batch XML ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
72: l_index := 0;
73: -- Get the greatest index of the last entry in all the address tables.
74: IF l_index < p_fax.LAST THEN
75: l_index := p_fax.LAST;

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

79: END IF;
80: IF l_index < p_printer.LAST THEN
81: l_index := p_printer.LAST;
82: END IF;
83: JTF_FM_UTL_V.PRINT_MESSAGE (to_char(l_index),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
84:
85: IF (l_index = 0) THEN
86: l_Error_Msg := 'Must pass batch address list';
87: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

91: RAISE FND_API.G_EXC_ERROR;
92: ELSE
93:
94: l_message := l_message||'';
95: JTF_FM_UTL_V.PRINT_MESSAGE('Getting the greatest value ..'||TO_CHAR(l_index),
96: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
97: FOR i IN 1..l_index LOOP
98: -- Check if atleast one destination address has been passed
99: IF( p_email.EXISTS(i) OR p_fax.EXISTS(i) OR p_printer.EXISTS(i)) THEN

Line 96: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

92: ELSE
93:
94: l_message := l_message||'';
95: JTF_FM_UTL_V.PRINT_MESSAGE('Getting the greatest value ..'||TO_CHAR(l_index),
96: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
97: FOR i IN 1..l_index LOOP
98: -- Check if atleast one destination address has been passed
99: IF( p_email.EXISTS(i) OR p_fax.EXISTS(i) OR p_printer.EXISTS(i)) THEN
100: -- For each table check if the record exists.

Line 198: l_fm_pvt_rec JTF_FM_UTL_V.FM_PVT_REC_TYPE;

194: l_message VARCHAR2(32767);
195: l_content_nm VARCHAR2(1) := null;
196: x_test_xml VARCHAR2(32767);
197:
198: l_fm_pvt_rec JTF_FM_UTL_V.FM_PVT_REC_TYPE;
199:
200: BEGIN
201: --dbms_output.put_line('In create Fulfillment API');
202:

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

199:
200: BEGIN
201: --dbms_output.put_line('In create Fulfillment API');
202:
203: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
204: -- Standard Start of API savepoint
205: SAVEPOINT create_fulfillment;
206: -- Standard call to check for call compatibility.
207: IF NOT FND_API.Compatible_API_Call

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

250: IF LENGTH(p_fulfill_electronic_rec.media_types) >3 THEN
251: l_Error_Msg := null;
252: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
253: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
254: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
255: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
256: RAISE FND_API.G_EXC_ERROR;
257:
258: ELSE

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

251: l_Error_Msg := null;
252: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
253: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
254: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
255: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
256: RAISE FND_API.G_EXC_ERROR;
257:
258: ELSE
259: IF (IS_MED_EPF(p_fulfill_electronic_rec.media_types)) THEN

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

266: l_printer_val := p_fulfill_electronic_rec.printer(1);
267: ELSE
268: IF p_fulfill_electronic_rec.request_type = 'S' THEN
269: l_Error_Msg := 'Chosen Media is Print but missing print address';
270: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
271: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_PRINT_ADDR');
272: RAISE FND_API.G_EXC_ERROR;
273: ELSE--for mass requests
274: l_printer_val := 'Query';

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

267: ELSE
268: IF p_fulfill_electronic_rec.request_type = 'S' THEN
269: l_Error_Msg := 'Chosen Media is Print but missing print address';
270: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
271: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_PRINT_ADDR');
272: RAISE FND_API.G_EXC_ERROR;
273: ELSE--for mass requests
274: l_printer_val := 'Query';
275: END IF;

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

283: l_fax_val := p_fulfill_electronic_rec.fax(1);
284: ELSE
285: IF p_fulfill_electronic_rec.request_type = 'S' THEN
286: l_Error_Msg := 'Chosen Media is FAX but missing FAX address';
287: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
288: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_FAX_ADDR');
289: RAISE FND_API.G_EXC_ERROR;
290: ELSE -- no need of fax address for mass requests
291: l_fax_val := 'Query';

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

284: ELSE
285: IF p_fulfill_electronic_rec.request_type = 'S' THEN
286: l_Error_Msg := 'Chosen Media is FAX but missing FAX address';
287: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
288: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_FAX_ADDR');
289: RAISE FND_API.G_EXC_ERROR;
290: ELSE -- no need of fax address for mass requests
291: l_fax_val := 'Query';
292: END IF;

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

303: ELSE
304: IF p_fulfill_electronic_rec.request_type = 'S' THEN
305:
306: l_Error_Msg := 'Chosen Media is Email but missing email address';
307: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
308: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_EMAIL_ADDR');
309: RAISE FND_API.G_EXC_ERROR;
310: ELSE
311: l_email_val := 'Query';

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

304: IF p_fulfill_electronic_rec.request_type = 'S' THEN
305:
306: l_Error_Msg := 'Chosen Media is Email but missing email address';
307: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
308: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_EMAIL_ADDR');
309: RAISE FND_API.G_EXC_ERROR;
310: ELSE
311: l_email_val := 'Query';
312: END IF;

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

317: ELSE -- Means media is not E or P or F
318: l_Error_Msg := null;
319: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
320: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
321: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
322: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
323: RAISE FND_API.G_EXC_ERROR;
324:
325:

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

318: l_Error_Msg := null;
319: l_Error_Msg := 'Invalid media type specified. Only allowed values are ';
320: l_Error_Msg := l_ERROR_Msg || 'EPF,EFP,FEP,FPE,PEF,PFE,EP,EF,E,PE,PF,P,FE,FP,F';
321: JTF_FM_UTL_V.PRINT_MESSAGE(l_Error_msg, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
322: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CF_INVALID_MEDIA');
323: RAISE FND_API.G_EXC_ERROR;
324:
325:
326: END IF;

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

330:
331:
332:
333: IF(p_fulfill_electronic_rec.extended_header IS NULL) THEN
334: JTF_FM_UTL_V.PRINT_MESSAGE('Extended header is null',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
335: l_extended_header := FND_API.G_MISS_CHAR;
336: ELSE
337: l_extended_header := p_fulfill_electronic_rec.extended_header;
338: END IF;

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

350: x_msg_count => l_msg_count,
351: x_msg_data => l_msg_data,
352: x_request_id => x_request_history_id
353: );
354: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request Return Status is ' || x_return_status,
355: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
356:
357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
358: RAISE FND_API.G_EXC_ERROR;

Line 355: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

351: x_msg_data => l_msg_data,
352: x_request_id => x_request_history_id
353: );
354: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request Return Status is ' || x_return_status,
355: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
356:
357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;

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

357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg request id is ' || to_char(x_request_history_id),
362: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
363: l_total := p_fulfill_electronic_rec.bind_names.count;
364: FOR i IN 1..l_total LOOP
365: l_bind_var(i) := p_fulfill_electronic_rec.bind_names(i);

Line 362: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg request id is ' || to_char(x_request_history_id),
362: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
363: l_total := p_fulfill_electronic_rec.bind_names.count;
364: FOR i IN 1..l_total LOOP
365: l_bind_var(i) := p_fulfill_electronic_rec.bind_names(i);
366: l_bind_val(i) := p_fulfill_electronic_rec.bind_values(i);

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

367: l_bind_var_type(i) := 'VARCHAR2';
368: END LOOP;
369:
370: l_content_id := p_fulfill_electronic_rec.template_id;
371: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg l_content_id is ' || to_char(l_content_id),
372: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
373:
374: /**
375: just before calling send request we will insert a record into

Line 372: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

368: END LOOP;
369:
370: l_content_id := p_fulfill_electronic_rec.template_id;
371: JTF_FM_UTL_V.PRINT_MESSAGE('Inside ocm pkg l_content_id is ' || to_char(l_content_id),
372: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
373:
374: /**
375: just before calling send request we will insert a record into
376: history table. Reason. GET_ATTACH_FILE_ID AND GET_FILE_ID in jtfgfmob.pls should

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

377: know about REQUEST_TYPE 'T'
378: other details in GET_ATTACH_FILE_ID and GET_FILE_ID
379: **/
380: IF (upper(p_fulfill_electronic_rec.request_type) = 'T') THEN
381: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST TYPE IS TEST',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
382: INSERT INTO JTF_FM_TEST_REQUESTS (REQUEST_ID) VALUES (x_request_history_id);
383: END IF;
384:
385: /********************************************************

Line 429: JTF_FM_UTL_V.PRINT_MESSAGE('Get_Content_XML Return Status is ' || x_return_status,

425: p_content_source => 'ocm',
426: p_version => p_fulfill_electronic_rec.version_id
427: );
428:
429: JTF_FM_UTL_V.PRINT_MESSAGE('Get_Content_XML Return Status is ' || x_return_status,
430: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
431:
432: l_content_xml := l_content_xml1;
433:

Line 430: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

426: p_version => p_fulfill_electronic_rec.version_id
427: );
428:
429: JTF_FM_UTL_V.PRINT_MESSAGE('Get_Content_XML Return Status is ' || x_return_status,
430: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
431:
432: l_content_xml := l_content_xml1;
433:
434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 464: JTF_FM_UTL_V.PRINT_MESSAGE('GET_TEST_XML Return Status is ' || x_return_status,

460: x_return_status => l_return_status,
461: x_test_xml => x_test_xml
462:
463: ) ;
464: JTF_FM_UTL_V.PRINT_MESSAGE('GET_TEST_XML Return Status is ' || x_return_status,
465: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
466: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
467: THEN
468: RAISE FND_API.G_EXC_ERROR;

Line 465: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

461: x_test_xml => x_test_xml
462:
463: ) ;
464: JTF_FM_UTL_V.PRINT_MESSAGE('GET_TEST_XML Return Status is ' || x_return_status,
465: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
466: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
467: THEN
468: RAISE FND_API.G_EXC_ERROR;
469: END IF;

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

497: -- Mass request is supported only for OCM contents
498: -- Proceed
499: IF(INSTR(l_content_xml,'query_id') >0)
500: THEN
501: JTF_FM_UTL_V.PRINT_MESSAGE('Item has a valid query OCM Repository',
502: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
503: IF upper(p_fulfill_electronic_rec.request_type) = 'L' THEN
504: l_message := '' || l_content_xml || '';
505: ELSE

Line 502: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

498: -- Proceed
499: IF(INSTR(l_content_xml,'query_id') >0)
500: THEN
501: JTF_FM_UTL_V.PRINT_MESSAGE('Item has a valid query OCM Repository',
502: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
503: IF upper(p_fulfill_electronic_rec.request_type) = 'L' THEN
504: l_message := '' || l_content_xml || '';
505: ELSE
506: l_message := '' || l_content_xml || '';

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

507: END IF;
508: ELSE
509: -- throw error, item should have a query assoc for mass requests
510: l_Error_Msg := 'Content must have a valid query associated with it.';
511: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_OCM_QUERY',l_content_id);
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514: END IF;
515: l_fm_pvt_rec.priority := 1.0;

Line 520: JTF_FM_UTL_V.FM_SUBMIT_REQ_V1

516: l_fm_pvt_rec.content_xml := l_message;
517: l_fm_pvt_rec.request_id := x_request_history_id ;
518: l_fm_pvt_rec.doc_id := 1.0;
519: l_fm_pvt_rec.doc_ref := 'UNSET';
520: JTF_FM_UTL_V.FM_SUBMIT_REQ_V1
521: (
522: p_api_version ,
523: p_init_msg_list,
524: p_commit,

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

527: x_msg_data,
528: p_fulfill_electronic_rec,
529: l_fm_pvt_rec
530: );
531: JTF_FM_UTL_V.PRINT_MESSAGE('Submit_Mass_Request Return Status is ' || x_return_status,
532: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
533: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

Line 532: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

528: p_fulfill_electronic_rec,
529: l_fm_pvt_rec
530: );
531: JTF_FM_UTL_V.PRINT_MESSAGE('Submit_Mass_Request Return Status is ' || x_return_status,
532: JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
533: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: