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

Line 6: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;

2: /* $Header: jtfgfmb.pls 120.11 2006/06/20 22:31:30 ahattark ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(200) := 'jtf.plsql.jtfgfmb.JTF_FM_REQUEST_GRP';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfgfmb.pls';
5: --
6: G_VALID_LEVEL_LOGIN CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
7:
8:
9: ---------------------------------------------------------------
10: -- Please do not remove this from this package

Line 48: l_message := replace(l_message, FND_API.G_MISS_CHAR, l_tag);

44: l_tag := '&' || 'apos;';
45: l_message := replace(l_message, '''', l_tag);
46:
47: l_tag := '^@' || ' ';
48: l_message := replace(l_message, FND_API.G_MISS_CHAR, l_tag);
49:
50: l_tag := '^@' || ' ';
51: l_message := replace(l_message, '''', l_tag);
52:

Line 241: p_encoded => FND_API.g_false,

237: FND_MSG_PUB.Add;
238: END IF;
239: --Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.g_false,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );
245:

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: FND_MSG_PUB.Add;
249: END IF;
250: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
251: EXCEPTION
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: END IF;
250: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
251: EXCEPTION
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.g_false,

Line 257: p_encoded => FND_API.g_false,

253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.g_false,
258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 262: WHEN FND_API.G_EXC_ERROR THEN

258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
262: WHEN FND_API.G_EXC_ERROR THEN
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: p_data => x_msg_data
260: );
261: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
262: WHEN FND_API.G_EXC_ERROR THEN
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.g_false,

Line 267: p_encoded => FND_API.g_false,

263: x_return_status := FND_API.G_RET_STS_ERROR;
264: --JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.g_false,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );
271: JTF_FM_UTL_V.PRINT_MESSAGE('x_message: '||x_msg_data,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: );
271: JTF_FM_UTL_V.PRINT_MESSAGE('x_message: '||x_msg_data,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
272: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
273: WHEN OTHERS THEN
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
276: IF FND_MSG_PUB.Check_Msg_Level
277: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN

Line 284: p_encoded => FND_API.g_false,

280: (G_PKG_NAME, l_api_name);
281: END IF;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

306: ---------------------------------------------------------------------
307: PROCEDURE New_Cancel_Request --anchaudh added
308: (
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,

Line 311: p_commit IN VARCHAR2 := FND_API.G_FALSE,

307: PROCEDURE New_Cancel_Request --anchaudh added
308: (
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,

Line 312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

308: (
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
311: p_commit IN VARCHAR2 := FND_API.G_FALSE,
312: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_request_id IN NUMBER,

Line 317: p_submit_dt_tm IN DATE := FND_API.G_MISS_DATE

313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_request_id IN NUMBER,
317: p_submit_dt_tm IN DATE := FND_API.G_MISS_DATE
318: )
319: IS
320:
321: l_api_version CONSTANT NUMBER := 1.0;

Line 334: IF NOT FND_API.Compatible_API_Call (

330: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
331: -- Standard begin of API savepoint
332: SAVEPOINT new_Cancel;
333:
334: IF NOT FND_API.Compatible_API_Call (
335: l_api_version,
336: p_api_version,
337: l_api_name,
338: G_PKG_NAME)

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: p_api_version,
337: l_api_name,
338: G_PKG_NAME)
339: THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: --Initialize message list if p_init_msg_list is TRUE.
344: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 344: IF FND_API.To_Boolean (p_init_msg_list) THEN

340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: --Initialize message list if p_init_msg_list is TRUE.
344: IF FND_API.To_Boolean (p_init_msg_list) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: -- Debug Message

Line 356: x_return_status := FND_API.G_RET_STS_SUCCESS;

352: FND_MSG_PUB.Add;
353: END IF;
354:
355: -- Initialize API return status to success
356: x_return_status := FND_API.G_RET_STS_SUCCESS;
357: Cancel_Request(
358: p_api_version => 1.0,
359: p_init_msg_list => p_init_msg_list ,
360: p_commit => p_commit,

Line 383: IF FND_API.To_Boolean ( p_commit ) THEN

379: FND_MESSAGE.Set_Token('ARG1', l_full_name);
380: FND_MSG_PUB.Add;
381: END IF;
382: --Standard check of commit
383: IF FND_API.To_Boolean ( p_commit ) THEN
384: COMMIT WORK;
385: END IF;
386: -- Debug Message
387: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 394: p_encoded => FND_API.g_false,

390: FND_MSG_PUB.Add;
391: END IF;
392: --Standard call to get message count and if count=1, get the message
393: FND_MSG_PUB.Count_And_Get (
394: p_encoded => FND_API.g_false,
395: p_count => x_msg_count,
396: p_data => x_msg_data
397: );
398:

Line 405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

401: FND_MSG_PUB.Add;
402: END IF;
403: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
404: EXCEPTION
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO new_cancel;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
409: -- Standard call to get message count and if count=1, get the message

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
404: EXCEPTION
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO new_cancel;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
409: -- Standard call to get message count and if count=1, get the message
410: FND_MSG_PUB.Count_And_Get (
411: p_encoded => FND_API.g_false,

Line 411: p_encoded => FND_API.g_false,

407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
409: -- Standard call to get message count and if count=1, get the message
410: FND_MSG_PUB.Count_And_Get (
411: p_encoded => FND_API.g_false,
412: p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 416: WHEN FND_API.G_EXC_ERROR THEN

412: p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO new_cancel;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
420: -- Standard call to get message count and if count=1, get the message

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414: );
415: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO new_cancel;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
420: -- Standard call to get message count and if count=1, get the message
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.g_false,

Line 422: p_encoded => FND_API.g_false,

418: x_return_status := FND_API.G_RET_STS_ERROR;
419: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
420: -- Standard call to get message count and if count=1, get the message
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.g_false,
423: p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426: JTF_FM_UTL_V.PRINT_MESSAGE('x_message: '||x_msg_data,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

426: JTF_FM_UTL_V.PRINT_MESSAGE('x_message: '||x_msg_data,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
427: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
428: WHEN OTHERS THEN
429: ROLLBACK TO new_cancel;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
432: IF FND_MSG_PUB.Check_Msg_Level
433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN

Line 440: p_encoded => FND_API.g_false,

436: (G_PKG_NAME, l_api_name);
437: END IF;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (
440: p_encoded => FND_API.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );
444: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 531: RAISE FND_API.G_EXC_ERROR;

527:
528: CLOSE query_c;
529: l_Error_Msg := 'Could not find content in the database';
530: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
531: RAISE FND_API.G_EXC_ERROR;
532: ELSE
533:
534: select fnd_lobs_s.nextval into x_query_file_id from dual;
535: JTF_FM_UTL_V.PRINT_MESSAGE('GOT FILE ID SEQ from FND_LOBS '|| x_query_file_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 599: RAISE FND_API.G_EXC_ERROR;

595: when others then
596: ROLLBACK TO query_status;
597: l_Error_Msg := 'Could not find Query Details in JTF_FM_QUERIES_ALL table';
598: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
599: RAISE FND_API.G_EXC_ERROR;
600:
601: END INSERT_QUERY;
602:
603: /*****************************************************

Line 643: RAISE FND_API.G_EXC_ERROR;

639: when others then
640: ROLLBACK TO query_status;
641: l_Error_Msg := 'Could not find Query Details in JTF_FM_QUERIES_ALL table';
642: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_QUERY_NOT_FOUND',p_query_id);
643: RAISE FND_API.G_EXC_ERROR;
644:
645: END CHECK_AND_INSERT_QUERY;
646:
647: /**

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: WHEN OTHERS
847: THEN
848: JTF_FM_UTL_V.PRINT_MESSAGE('UNEXPECTED ERROR IN PROCEDURE INSERT_REQUEST_CONTENTS', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
849:
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851:
852: END INSERT_REQUEST_CONTENTS;
853:
854:

Line 2357: RAISE FND_API.G_EXC_ERROR;

2353: FND_MESSAGE.Set_Token('ARG2',p_request_id);
2354: FND_MSG_PUB.Add;
2355: END IF;
2356:
2357: RAISE FND_API.G_EXC_ERROR;
2358: END;
2359:
2360: /*
2361: l_amount := DBMS_LOB.GETLENGTH(l_bind);

Line 2395: IF p_media_address = FND_API.G_MISS_CHAR

2391:
2392: -- Identify the media types requested
2393: IF (INSTR(UPPER(p_media_type), 'PRINTER') > 0)
2394: THEN
2395: IF p_media_address = FND_API.G_MISS_CHAR
2396: THEN
2397: l_message := l_message||' '||null||' '||a;
2398: ELSE -- IF p_printer
2399: l_message := l_message||' '||p_media_address||' '||a;

Line 2407: IF p_media_address = FND_API.G_MISS_CHAR

2403: END IF; -- IF (INSTR(p_media_type,
2404:
2405: IF (INSTR(UPPER(p_media_type), 'EMAIL') > 0)
2406: THEN
2407: IF p_media_address = FND_API.G_MISS_CHAR
2408: THEN
2409: l_message := l_message||' '||null||' '||a;
2410: ELSE -- IF p_email
2411: l_message := l_message||' '||p_media_address||' '||a;

Line 2419: IF p_media_address = FND_API.G_MISS_CHAR

2415: END IF; -- IF (INSTR(p_media_type
2416:
2417: IF (INSTR(UPPER(p_media_type), 'FAX') > 0)
2418: THEN
2419: IF p_media_address = FND_API.G_MISS_CHAR
2420: THEN
2421: l_message := l_message||' '||null||' '||a;
2422: ELSE -- IF p_fax
2423: l_message := l_message||' '||p_media_address||' '||a;

Line 2441: RAISE FND_API.G_EXC_ERROR;

2437: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
2438: FND_MSG_PUB.Add;
2439: END IF; -- IF FND_MSG_PUB.check_msg_level
2440:
2441: RAISE FND_API.G_EXC_ERROR;
2442:
2443: END IF; -- IF (l_temp = 0)
2444:
2445: l_message := l_message||' '||a;

Line 2526: RAISE FND_API.G_EXC_ERROR;

2522: WHEN NO_DATA_FOUND THEN
2523: JTF_FM_UTL_V.PRINT_MESSAGE('JTF_FM_OCM_NOTAPP_OR_ABS',
2524: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, 'JTF_FM_REQUEST_GRP.GET_FILE_ID');
2525: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
2526: RAISE FND_API.G_EXC_ERROR;
2527: END;
2528:
2529: JTF_FM_UTL_V.PRINT_MESSAGE('END' || l_full_name,
2530: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);

Line 2587: RAISE FND_API.G_EXC_ERROR;

2583: WHEN NO_DATA_FOUND
2584: THEN
2585: JTF_FM_UTL_V.PRINT_MESSAGE(' JTF_FM_OCM_NOTAPP_OR_ABS' ||' : ' || p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_ATTACH_FILE_ID');
2586: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
2587: RAISE FND_API.G_EXC_ERROR;
2588:
2589: END;
2590:
2591:

Line 2597: ,p_init_msg_list => Fnd_Api.g_false

2593:
2594:
2595: Ibc_Citem_Admin_Grp.get_attribute_bundle(
2596: p_citem_ver_id => l_cItemVersionId
2597: ,p_init_msg_list => Fnd_Api.g_false
2598: ,p_api_version_number => Ibc_Citem_Admin_Grp.G_API_VERSION_DEFAULT
2599: ,x_attribute_type_codes => attribute_type_codes
2600: ,x_attribute_type_names => attribute_type_names
2601: ,x_attributes => attributes

Line 2608: if (return_status <> FND_API.G_RET_STS_SUCCESS) then

2604: ,x_msg_count => msg_count
2605: ,x_msg_data => msg_data
2606: );
2607:
2608: if (return_status <> FND_API.G_RET_STS_SUCCESS) then
2609: RAISE FND_API.G_EXC_ERROR;
2610: else
2611: att_count := attribute_type_codes.COUNT;
2612:

Line 2609: RAISE FND_API.G_EXC_ERROR;

2605: ,x_msg_data => msg_data
2606: );
2607:
2608: if (return_status <> FND_API.G_RET_STS_SUCCESS) then
2609: RAISE FND_API.G_EXC_ERROR;
2610: else
2611: att_count := attribute_type_codes.COUNT;
2612:
2613: LOOP

Line 2730: x_return_status := FND_API.G_RET_STS_SUCCESS;

2726: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name,
2727: JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
2728:
2729: -- Initialize API return status to success
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;
2731:
2732:
2733: SELECT DISTINCT COUNT(REQUEST_ID) INTO l_req_count FROM JTF_FM_TEST_REQUESTS
2734: WHERE REQUEST_ID = p_request_id ;

Line 2743: IF(p_version IS NOT NULL AND p_version <> FND_API.G_MISS_NUM) THEN

2739: JTF_FM_UTL_V.PRINT_MESSAGE(' IT IS A TEST REQUEST:THE COUNT IS ' ||
2740: l_req_count, JTF_FM_UTL_V.G_LEVEL_PROCEDURE,
2741: 'JTF_FM_REQUEST_GRP.GET_OCM_ITEM_DETAILS');
2742:
2743: IF(p_version IS NOT NULL AND p_version <> FND_API.G_MISS_NUM) THEN
2744:
2745: -- In 11.5.9 Fulfillment had users pass 1 or 1.0 in as the version
2746: -- number (meaning "live")and hence had code that "looked up" the right
2747: -- x_item_version_id to pass to GET_ITEM. However in 11.5.10, the

Line 2784: IF(p_version IS NOT NULL AND p_version <> FND_API.G_MISS_NUM) THEN

2780: END IF;
2781:
2782: ELSE
2783:
2784: IF(p_version IS NOT NULL AND p_version <> FND_API.G_MISS_NUM) THEN
2785:
2786: -- See comment above for test requests where p_version is not null!
2787: x_item_version_id := p_version;
2788:

Line 2810: RAISE FND_API.G_EXC_ERROR;

2806: 'Content is either not present in OCM or is not approved' ||
2807: p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE, l_full_name);
2808: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_NOTAPP_OR_ABS', p_content_id);
2809:
2810: RAISE FND_API.G_EXC_ERROR;
2811:
2812: END;
2813:
2814: JTF_FM_UTL_V.PRINT_MESSAGE(' Before calling IBC_CITEM_ADMIN_GRP.get_item' ,

Line 2821: ,p_init_msg_list => FND_API.g_true

2817: BEGIN
2818:
2819: IBC_CITEM_ADMIN_GRP.get_item(
2820: p_citem_ver_id => x_item_version_id
2821: ,p_init_msg_list => FND_API.g_true
2822: ,p_api_version_number => IBC_CITEM_ADMIN_GRP.G_API_VERSION_DEFAULT
2823: ,x_content_item_id => content_item_id
2824: ,x_citem_name => citem_name
2825: ,x_citem_version => citem_version

Line 2868: RAISE FND_API.G_EXC_ERROR;

2864: EXCEPTION
2865: WHEN OTHERS THEN
2866: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_EXCEPTION_IN_GET_ITEM', p_content_id);
2867:
2868: RAISE FND_API.G_EXC_ERROR;
2869:
2870: END;
2871:
2872:

Line 2875: if (return_status <> FND_API.G_RET_STS_SUCCESS)

2871:
2872:
2873:
2874: JTF_FM_UTL_V.PRINT_MESSAGE('Return status from GET ITEM IS:'|| return_status,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2875: if (return_status <> FND_API.G_RET_STS_SUCCESS)
2876: then
2877: RAISE FND_API.G_EXC_ERROR;
2878: else
2879: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_ITEM_DETAILS name = '||citem_name ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 2877: RAISE FND_API.G_EXC_ERROR;

2873:
2874: JTF_FM_UTL_V.PRINT_MESSAGE('Return status from GET ITEM IS:'|| return_status,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2875: if (return_status <> FND_API.G_RET_STS_SUCCESS)
2876: then
2877: RAISE FND_API.G_EXC_ERROR;
2878: else
2879: JTF_FM_UTL_V.PRINT_MESSAGE('IN GET_OCM_ITEM_DETAILS name = '||citem_name ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2880: JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST ID IS name = '|| p_request_id,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
2881:

Line 3048: RAISE FND_API.G_EXC_ERROR;

3044:
3045: ELSE
3046: JTF_FM_UTL_V.PRINT_MESSAGE(' Should have HTML Rendition' ||p_content_id, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3047: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_OCM_HTML_REND_ABS', p_content_id);
3048: RAISE FND_API.G_EXC_ERROR;
3049:
3050: END IF;
3051:
3052: end if;

Line 3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3057:
3058:
3059: EXCEPTION
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3062: THEN
3063:
3064: x_citem_name := NULL;
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3062: THEN
3063:
3064: x_citem_name := NULL;
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: -- Standard call to get message count and if count=1, get the message
3067: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3068: p_count => x_msg_count,
3069: p_data => x_msg_data

Line 3067: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3063:
3064: x_citem_name := NULL;
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066: -- Standard call to get message count and if count=1, get the message
3067: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3068: p_count => x_msg_count,
3069: p_data => x_msg_data
3070: );
3071: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3073: WHEN FND_API.G_EXC_ERROR

3069: p_data => x_msg_data
3070: );
3071: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3072:
3073: WHEN FND_API.G_EXC_ERROR
3074: THEN
3075:
3076: x_citem_name := NULL;
3077: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3077: x_return_status := FND_API.G_RET_STS_ERROR;

3073: WHEN FND_API.G_EXC_ERROR
3074: THEN
3075:
3076: x_citem_name := NULL;
3077: x_return_status := FND_API.G_RET_STS_ERROR;
3078:
3079: -- Standard call to get message count and if count=1, get the message
3080: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3081: p_count => x_msg_count,

Line 3080: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3076: x_citem_name := NULL;
3077: x_return_status := FND_API.G_RET_STS_ERROR;
3078:
3079: -- Standard call to get message count and if count=1, get the message
3080: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3081: p_count => x_msg_count,
3082: p_data => x_msg_data
3083: );
3084: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3086: WHEN OTHERS
3087: THEN
3088:
3089: x_citem_name := NULL;
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3092:
3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3094: THEN

Line 3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3095: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', G_PKG_NAME );
3096: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3097:
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3100: p_count => x_msg_count,
3101: p_data => x_msg_data
3102: );
3103: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3106: 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_ITEM_DETAILS');

3102: );
3103: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3104:
3105: for i in 0..x_msg_count loop
3106: 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_ITEM_DETAILS');
3107:
3108: end loop;
3109:
3110:

Line 3186: x_return_status := FND_API.G_RET_STS_SUCCESS;

3182:
3183: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3184:
3185: -- Initialize API return status to success
3186: x_return_status := FND_API.G_RET_STS_SUCCESS;
3187:
3188: JTF_FM_UTL_V.PRINT_MESSAGE('Procedure to check MES contents',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3189:
3190: /***

Line 3210: RAISE FND_API.G_EXC_ERROR;

3206: JTF_FM_UTL_V.PRINT_MESSAGE('Invalid Content_id',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3207: CLOSE CATTACH;
3208: l_Error_Msg := 'Could not find content in the database';
3209: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_DISP_CONTENT_NOT_FOUND',p_content_id);
3210: RAISE FND_API.G_EXC_ERROR;
3211: ELSE
3212:
3213: IF (JTF_FM_UTL_V.CONFIRM_RTF(l_file_id)) THEN
3214: l_file_id_type := ' rtf_id = " ';

Line 3267: RAISE FND_API.G_EXC_ERROR;

3263: JTF_FM_UTL_V.PRINT_MESSAGE('Could not find content in the database',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3264: CLOSE CCONT;
3265: l_Error_Msg := 'Could not find content in the database';
3266: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_DISP_CONTENT_NOT_FOUND',p_content_id);
3267: RAISE FND_API.G_EXC_ERROR;
3268: ELSE
3269:
3270: -- Validate that the content has a query associated with it
3271: OPEN CQUER;

Line 3276: RAISE FND_API.G_EXC_ERROR;

3272: FETCH CQUER INTO x_query_id;
3273: IF (CQUER%NOTFOUND) THEN
3274: CLOSE CQUER;
3275: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_CONT_NOT_QUERY',p_content_id);
3276: RAISE FND_API.G_EXC_ERROR;
3277: ELSE
3278:
3279: IF ((INSTR(UPPER(p_media_type), 'E') > 0) OR (INSTR(UPPER(p_media_type), 'F') > 0)) THEN-- If Email or Fax
3280: IF (JTF_FM_UTL_V.CONFIRM_RTF(l_file_id)) THEN -- If RTF

Line 3287: RAISE FND_API.G_EXC_ERROR;

3283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3284: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_RTF_EMAIL_FAX');
3285: FND_MSG_PUB.Add;
3286: END IF; -- IF FND_MSG_PUB.check_msg_level
3287: RAISE FND_API.G_EXC_ERROR;
3288: ELSIF(JTF_FM_UTL_V.CONFIRM_PDF(l_file_id)) THEN -- IF PDF
3289: l_Error_Msg := 'Cant send a PDF through Email or Fax';
3290: JTF_FM_UTL_V.PRINT_MESSAGE('Cant send a PDF through Email or Fax' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3295: RAISE FND_API.G_EXC_ERROR;

3291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3292: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_PDF_EMAIL_FAX');
3293: FND_MSG_PUB.Add;
3294: END IF; -- IF FND_MSG_PUB.check_msg_level
3295: RAISE FND_API.G_EXC_ERROR;
3296: ELSIF(JTF_FM_UTL_V.CONFIRM_TEXT_HTML(l_file_id)) THEN -- If it is a Text or HTML
3297: x_html := x_html ||' 3298: l_count_total := l_count_total +1;
3299: INSERT_REQUEST_CONTENTS(

Line 3322: RAISE FND_API.G_EXC_ERROR;

3318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3319: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_CONTENT_TYPE');
3320: FND_MSG_PUB.Add;
3321: END IF; -- IF FND_MSG_PUB.check_msg_level
3322: RAISE FND_API.G_EXC_ERROR;
3323:
3324: END IF; -- JTF_FM_UTL_V.CONFIRM_RTF, PDF, TEXT_HTML
3325:
3326: ELSE -- If Print media_type

Line 3387: RAISE FND_API.G_EXC_ERROR;

3383: THEN
3384: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_CONTENT_TYPE');
3385: FND_MSG_PUB.Add;
3386: END IF; -- IF FND_MSG_PUB.check_msg_level
3387: RAISE FND_API.G_EXC_ERROR;
3388:
3389: END IF; -- JTF_FM_UTL_V.CONFIRM_RTF, PDF, TEXT_HTML
3390: END IF; -- EMAIL, PRINTER, FAX
3391:

Line 3516: RAISE FND_API.G_EXC_ERROR;

3512: JTF_FM_UTL_V.PRINT_MESSAGE('could not find Content_id' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3513:
3514:
3515: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_DISP_CONTENT_NOT_FOUND',p_content_id);
3516: RAISE FND_API.G_EXC_ERROR;
3517:
3518: END IF;
3519:
3520: --CLOSE CCONT;

Line 3526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3522:
3523: JTF_FM_UTL_V.PRINT_MESSAGE('END PROCEDURE GET_MES_ITEM_DETAILS' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3524:
3525: EXCEPTION
3526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3527: THEN
3528:
3529: x_citem_name := NULL;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3527: THEN
3528:
3529: x_citem_name := NULL;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3531: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3532: -- Standard call to get message count and if count=1, get the message
3533: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3534: p_count => x_msg_count,

Line 3533: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3529: x_citem_name := NULL;
3530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3531: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3532: -- Standard call to get message count and if count=1, get the message
3533: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3534: p_count => x_msg_count,
3535: p_data => x_msg_data
3536: );
3537: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3539: WHEN FND_API.G_EXC_ERROR

3535: p_data => x_msg_data
3536: );
3537: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3538:
3539: WHEN FND_API.G_EXC_ERROR
3540: THEN
3541: x_citem_name := NULL;
3542: x_return_status := FND_API.G_RET_STS_ERROR;
3543: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

Line 3542: x_return_status := FND_API.G_RET_STS_ERROR;

3538:
3539: WHEN FND_API.G_EXC_ERROR
3540: THEN
3541: x_citem_name := NULL;
3542: x_return_status := FND_API.G_RET_STS_ERROR;
3543: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3544: -- Standard call to get message count and if count=1, get the message
3545: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3546: p_count => x_msg_count,

Line 3545: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3541: x_citem_name := NULL;
3542: x_return_status := FND_API.G_RET_STS_ERROR;
3543: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3544: -- Standard call to get message count and if count=1, get the message
3545: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3546: p_count => x_msg_count,
3547: p_data => x_msg_data
3548: );
3549: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3551: WHEN OTHERS
3552: THEN
3553:
3554: x_citem_name := NULL;
3555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: JTF_FM_UTL_V.PRINT_MESSAGE(SQLERRM ,JTF_FM_UTL_V.G_LEVEL_ERROR ,l_full_name);
3557:
3558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3559: THEN

Line 3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

3560: FND_MSG_PUB.Add_Exc_Msg('JTF_FM_REQUEST_GRP', l_api_name);
3561: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
3562:
3563: -- Standard call to get message count and if count=1, get the message
3564: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
3565: p_count => x_msg_count,
3566: p_data => x_msg_data
3567: );
3568: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3580:
3581: PROCEDURE Start_Request
3582: (
3583: p_api_version IN NUMBER,
3584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3587: x_return_status OUT NOCOPY VARCHAR2,
3588: x_msg_count OUT NOCOPY NUMBER,

Line 3585: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3581: PROCEDURE Start_Request
3582: (
3583: p_api_version IN NUMBER,
3584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3587: x_return_status OUT NOCOPY VARCHAR2,
3588: x_msg_count OUT NOCOPY NUMBER,
3589: x_msg_data OUT NOCOPY VARCHAR2,

Line 3586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3582: (
3583: p_api_version IN NUMBER,
3584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3587: x_return_status OUT NOCOPY VARCHAR2,
3588: x_msg_count OUT NOCOPY NUMBER,
3589: x_msg_data OUT NOCOPY VARCHAR2,
3590: x_request_id OUT NOCOPY NUMBER

Line 3608: IF NOT FND_API.Compatible_API_Call (

3604:
3605: -- Standard begin of API savepoint
3606: SAVEPOINT Start_request;
3607:
3608: IF NOT FND_API.Compatible_API_Call (
3609: l_api_version,
3610: p_api_version,
3611: l_api_name,
3612: G_PKG_NAME)

Line 3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3610: p_api_version,
3611: l_api_name,
3612: G_PKG_NAME)
3613: THEN
3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3615: END IF;
3616:
3617: --Initialize message list if p_init_msg_list is TRUE.
3618: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 3618: IF FND_API.To_Boolean (p_init_msg_list) THEN

3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3615: END IF;
3616:
3617: --Initialize message list if p_init_msg_list is TRUE.
3618: IF FND_API.To_Boolean (p_init_msg_list) THEN
3619: FND_MSG_PUB.initialize;
3620: END IF;
3621:
3622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 3629: x_return_status := FND_API.G_RET_STS_SUCCESS;

3625: FND_MSG_PUB.Add;
3626: END IF;
3627:
3628: -- Initialize API return status to success
3629: x_return_status := FND_API.G_RET_STS_SUCCESS;
3630:
3631: JTF_FM_UTL_V.PRINT_MESSAGE('Start_Request called by ' || to_number(FND_GLOBAL.USER_ID) ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3632:
3633: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;

Line 3643: IF FND_API.To_Boolean ( p_commit ) THEN

3639: FND_MSG_PUB.Add;
3640: END IF;
3641:
3642: --Standard check of commit
3643: IF FND_API.To_Boolean ( p_commit ) THEN
3644: COMMIT WORK;
3645: END IF;
3646: JTF_FM_UTL_V.PRINT_MESSAGE('End procedure start_request ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3647:

Line 3657: p_encoded => FND_API.g_false,

3653: END IF;
3654:
3655: --Standard call to get message count and if count=1, get the message
3656: FND_MSG_PUB.count_and_get(
3657: p_encoded => FND_API.g_false,
3658: p_count => x_msg_count,
3659: p_data => x_msg_data
3660: );
3661: EXCEPTION

Line 3662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3658: p_count => x_msg_count,
3659: p_data => x_msg_data
3660: );
3661: EXCEPTION
3662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3663: ROLLBACK TO Start_Request;
3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3665: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3666: -- Standard call to get message count and if count=1, get the message

Line 3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3660: );
3661: EXCEPTION
3662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3663: ROLLBACK TO Start_Request;
3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3665: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3666: -- Standard call to get message count and if count=1, get the message
3667: FND_MSG_PUB.count_and_get(
3668: p_encoded => FND_API.g_false,

Line 3668: p_encoded => FND_API.g_false,

3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3665: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3666: -- Standard call to get message count and if count=1, get the message
3667: FND_MSG_PUB.count_and_get(
3668: p_encoded => FND_API.g_false,
3669: p_count => x_msg_count,
3670: p_data => x_msg_data
3671: );
3672: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3673: WHEN FND_API.G_EXC_ERROR THEN

3669: p_count => x_msg_count,
3670: p_data => x_msg_data
3671: );
3672: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3673: WHEN FND_API.G_EXC_ERROR THEN
3674: ROLLBACK TO Start_Request;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3677: -- Standard call to get message count and if count=1, get the message

Line 3675: x_return_status := FND_API.G_RET_STS_ERROR;

3671: );
3672: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3673: WHEN FND_API.G_EXC_ERROR THEN
3674: ROLLBACK TO Start_Request;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3677: -- Standard call to get message count and if count=1, get the message
3678: FND_MSG_PUB.count_and_get(
3679: p_encoded => FND_API.g_false,

Line 3679: p_encoded => FND_API.g_false,

3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
3677: -- Standard call to get message count and if count=1, get the message
3678: FND_MSG_PUB.count_and_get(
3679: p_encoded => FND_API.g_false,
3680: p_count => x_msg_count,
3681: p_data => x_msg_data
3682: );
3683: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3682: );
3683: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
3684: WHEN OTHERS THEN
3685: ROLLBACK TO Start_Request;
3686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3687: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
3688: IF FND_MSG_PUB.Check_Msg_Level
3689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3690: THEN

Line 3696: p_encoded => FND_API.g_false,

3692: (G_PKG_NAME, l_api_name);
3693: END IF;
3694: -- Standard call to get message count and if count=1, get the message
3695: FND_MSG_PUB.count_and_get(
3696: p_encoded => FND_API.g_false,
3697: p_count => x_msg_count,
3698: p_data => x_msg_data
3699: );
3700: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 3715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3711:
3712: PROCEDURE Get_Content_XML
3713: (
3714: p_api_version IN NUMBER,
3715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3716: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3718: x_return_status OUT NOCOPY VARCHAR2,
3719: x_msg_count OUT NOCOPY NUMBER,

Line 3716: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3712: PROCEDURE Get_Content_XML
3713: (
3714: p_api_version IN NUMBER,
3715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3716: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3718: x_return_status OUT NOCOPY VARCHAR2,
3719: x_msg_count OUT NOCOPY NUMBER,
3720: x_msg_data OUT NOCOPY VARCHAR2,

Line 3717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3713: (
3714: p_api_version IN NUMBER,
3715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3716: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3718: x_return_status OUT NOCOPY VARCHAR2,
3719: x_msg_count OUT NOCOPY NUMBER,
3720: x_msg_data OUT NOCOPY VARCHAR2,
3721: p_content_id IN NUMBER,

Line 3722: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,

3718: x_return_status OUT NOCOPY VARCHAR2,
3719: x_msg_count OUT NOCOPY NUMBER,
3720: x_msg_data OUT NOCOPY VARCHAR2,
3721: p_content_id IN NUMBER,
3722: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
3723: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
3724: p_quantity IN NUMBER := 1,
3725: p_media_type IN VARCHAR2,
3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3723: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated

3719: x_msg_count OUT NOCOPY NUMBER,
3720: x_msg_data OUT NOCOPY VARCHAR2,
3721: p_content_id IN NUMBER,
3722: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
3723: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
3724: p_quantity IN NUMBER := 1,
3725: p_media_type IN VARCHAR2,
3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,

3722: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
3723: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
3724: p_quantity IN NUMBER := 1,
3725: p_media_type IN VARCHAR2,
3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
3728: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
3729: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
3730: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,

3723: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
3724: p_quantity IN NUMBER := 1,
3725: p_media_type IN VARCHAR2,
3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
3728: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
3729: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
3730: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
3731: p_content_type IN VARCHAR2,

Line 3728: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,

3724: p_quantity IN NUMBER := 1,
3725: p_media_type IN VARCHAR2,
3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
3728: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
3729: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
3730: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
3731: p_content_type IN VARCHAR2,
3732: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 3729: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

3725: p_media_type IN VARCHAR2,
3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
3728: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
3729: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
3730: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
3731: p_content_type IN VARCHAR2,
3732: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
3733: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 3730: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,

3726: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
3727: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
3728: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
3729: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
3730: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
3731: p_content_type IN VARCHAR2,
3732: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
3733: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
3734: p_bind_var_type IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 3786: IF NOT FND_API.Compatible_API_Call (l_api_version,

3782: a:= b||c; */
3783: a := '';
3784:
3785: -- Check for API version compatibility
3786: IF NOT FND_API.Compatible_API_Call (l_api_version,
3787: p_api_version,
3788: l_api_name,
3789: G_PKG_NAME)
3790: THEN

Line 3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3787: p_api_version,
3788: l_api_name,
3789: G_PKG_NAME)
3790: THEN
3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3792: END IF; -- NOT FND_API.Compatible_API_Call
3793:
3794: --Initialize message list if p_init_msg_list is TRUE.
3795: IF FND_API.To_Boolean (p_init_msg_list)

Line 3792: END IF; -- NOT FND_API.Compatible_API_Call

3788: l_api_name,
3789: G_PKG_NAME)
3790: THEN
3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3792: END IF; -- NOT FND_API.Compatible_API_Call
3793:
3794: --Initialize message list if p_init_msg_list is TRUE.
3795: IF FND_API.To_Boolean (p_init_msg_list)
3796: THEN

Line 3795: IF FND_API.To_Boolean (p_init_msg_list)

3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3792: END IF; -- NOT FND_API.Compatible_API_Call
3793:
3794: --Initialize message list if p_init_msg_list is TRUE.
3795: IF FND_API.To_Boolean (p_init_msg_list)
3796: THEN
3797: FND_MSG_PUB.initialize;
3798: END IF; -- FND_API.To_Boolean
3799:

Line 3798: END IF; -- FND_API.To_Boolean

3794: --Initialize message list if p_init_msg_list is TRUE.
3795: IF FND_API.To_Boolean (p_init_msg_list)
3796: THEN
3797: FND_MSG_PUB.initialize;
3798: END IF; -- FND_API.To_Boolean
3799:
3800: -- Debug Message
3801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3802: THEN

Line 3809: x_return_status := FND_API.G_RET_STS_SUCCESS;

3805: FND_MSG_PUB.Add;
3806: END IF; -- FND_MSG_PUB.Check_Msg_level
3807:
3808: -- Initialize API return status to success
3809: x_return_status := FND_API.G_RET_STS_SUCCESS;
3810:
3811: -- Check if Content_id parameter is NULL. Content_id represents the
3812: -- unique identifier for getting the document from MES tables
3813: IF (p_content_id IS NULL)

Line 3824: RAISE FND_API.G_EXC_ERROR;

3820: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_ID');
3821: FND_MSG_PUB.Add;
3822: END IF; -- IF FND_MSG_PUB.check_msg_level
3823:
3824: RAISE FND_API.G_EXC_ERROR;
3825:
3826: -- check if the media_type paramater is NULL. No point in processing a
3827: -- request without a media_type
3828: ELSIF (p_media_type IS NULL) -- IF (p_media_type IS NULL)

Line 3838: RAISE FND_API.G_EXC_ERROR;

3834: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_MEDIA_TYPE');
3835: FND_MSG_PUB.Add;
3836: END IF; -- IF FND_MSG_PUB.check_msg_level
3837:
3838: RAISE FND_API.G_EXC_ERROR;
3839: -- Must pass a request_type
3840: ELSIF (p_content_type IS NULL) -- IF (p_content_id IS NULL)
3841: THEN
3842: l_Error_Msg := 'Must pass p_content_type parameters';

Line 3850: RAISE FND_API.G_EXC_ERROR;

3846: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENTTYPE');
3847: FND_MSG_PUB.Add;
3848: END IF; -- IF FND_MSG_PUB.check_msg_level
3849:
3850: RAISE FND_API.G_EXC_ERROR;
3851: ELSIF (p_request_id IS NULL) -- IF (p_request_id IS NULL)
3852: THEN
3853: l_Error_Msg := 'Must pass p_request_id parameters';
3854: JTF_FM_UTL_V.PRINT_MESSAGE('Must pass p_request_id parameter ' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);

Line 3861: RAISE FND_API.G_EXC_ERROR;

3857: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
3858: FND_MSG_PUB.Add;
3859: END IF; -- IF _FND_MSG_PUB.check_msg_level
3860:
3861: RAISE FND_API.G_EXC_ERROR;
3862: ELSE -- IF (p_content_id IS NULL)
3863:
3864: -- Start forming the XML Request for the content
3865:

Line 3873: IF p_printer = FND_API.G_MISS_CHAR

3869:
3870: -- Identify the media types requested
3871: IF (INSTR(p_media_type, 'PRINTER') > 0)
3872: THEN
3873: IF p_printer = FND_API.G_MISS_CHAR
3874: THEN
3875: l_message := l_message||''||null||' '||a;
3876: ELSE -- IF p_printer
3877: l_message := l_message||''||p_printer||' '||a;

Line 3886: IF p_email = FND_API.G_MISS_CHAR

3882: END IF; -- IF (INSTR(p_media_type,
3883:
3884: IF (INSTR(p_media_type, 'EMAIL') > 0)
3885: THEN
3886: IF p_email = FND_API.G_MISS_CHAR
3887: THEN
3888: l_message := l_message||''||null||' '||a;
3889: ELSE -- IF p_email
3890: l_message := l_message||''||p_email||' '||a;

Line 3899: IF p_fax = FND_API.G_MISS_CHAR

3895: END IF; -- IF (INSTR(p_media_type
3896:
3897: IF (INSTR(p_media_type, 'FAX') > 0)
3898: THEN
3899: IF p_fax = FND_API.G_MISS_CHAR
3900: THEN
3901: l_message := l_message||''||null||' '||a;
3902: ELSE -- IF p_fax
3903: l_message := l_message||''||p_fax||' '||a;

Line 3922: RAISE FND_API.G_EXC_ERROR;

3918: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_INVALID_MEDIATYPE');
3919: FND_MSG_PUB.Add;
3920: END IF; -- IF FND_MSG_PUB.check_msg_level
3921:
3922: RAISE FND_API.G_EXC_ERROR;
3923:
3924: END IF; -- IF (l_temp = 0)
3925:
3926: l_message := l_message||' '||a;

Line 3936: IF p_version <> FND_API.G_MISS_NUM THEN

3932: l_message := l_message||' 3933:
3934: l_message := l_message||' quantity="'||to_char(p_quantity)||'" user_note="'|| REPLACE_TAG(p_user_note)||'" source ="' || p_content_source || '" '||a;
3935:
3936: IF p_version <> FND_API.G_MISS_NUM THEN
3937: l_message := l_message||' version_id="' || p_version || '"' || a;
3938:
3939: END IF;
3940:

Line 3952: OR p_version = FND_API.G_MISS_NUM THEN

3948: IF (upper(p_content_source) = 'OCM') THEN
3949: -- Following changes were made for Bug # 3211971
3950: -- If version id passed is 1 we will pass null so that the live version will be picked up
3951: IF p_version = 1 OR p_version = 1.0
3952: OR p_version = FND_API.G_MISS_NUM THEN
3953:
3954: l_version := null;
3955:
3956: ELSE

Line 3983: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3979: x_return_status ,
3980: x_msg_count ,
3981: x_msg_data);
3982:
3983: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3984:
3985: JTF_FM_UTL_V.PRINT_MESSAGE('Got back the details from Renditons Successfully',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3986: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in OCM Rend Repository' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
3987:

Line 4008: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4004: x_return_status ,
4005: x_msg_count ,
4006: x_msg_data
4007: );
4008: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4009: JTF_FM_UTL_V.PRINT_MESSAGE('Got OCM Items details the old way successfully',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4010: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in OCM Repository' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4011:
4012: l_message := l_message|| x_html;

Line 4013: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4009: JTF_FM_UTL_V.PRINT_MESSAGE('Got OCM Items details the old way successfully',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4010: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in OCM Repository' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4011:
4012: l_message := l_message|| x_html;
4013: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: ELSE
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017:

Line 4014: RAISE FND_API.G_EXC_ERROR;

4010: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in OCM Repository' ,JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4011:
4012: l_message := l_message|| x_html;
4013: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: ELSE
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017:
4018: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in OCM Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);

Line 4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4012: l_message := l_message|| x_html;
4013: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: ELSE
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017:
4018: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in OCM Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
4019: END IF;
4020: END IF;

Line 4037: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)

4033: x_return_status ,
4034: x_msg_count ,
4035: x_msg_data
4036: );
4037: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)
4038: THEN
4039: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4040: l_message := l_message|| x_html;
4041: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)

Line 4041: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)

4037: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)
4038: THEN
4039: JTF_FM_UTL_V.PRINT_MESSAGE('Item present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4040: l_message := l_message|| x_html;
4041: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)
4042: THEN
4043: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4044: RAISE FND_API.G_EXC_ERROR;
4045: ELSE

Line 4044: RAISE FND_API.G_EXC_ERROR;

4040: l_message := l_message|| x_html;
4041: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)
4042: THEN
4043: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4044: RAISE FND_API.G_EXC_ERROR;
4045: ELSE
4046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4047: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
4048: END IF;

Line 4046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4042: THEN
4043: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4044: RAISE FND_API.G_EXC_ERROR;
4045: ELSE
4046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4047: JTF_FM_UTL_V.PRINT_MESSAGE('Item NOT present in MES Repository',JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
4048: END IF;
4049: END IF;
4050:

Line 4104: IF FND_API.To_Boolean ( p_commit )

4100: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4101:
4102: --Standard check of commit
4103:
4104: IF FND_API.To_Boolean ( p_commit )
4105: THEN
4106: COMMIT WORK;
4107: END IF; -- IF FND_API.To_Boolean
4108:

Line 4107: END IF; -- IF FND_API.To_Boolean

4103:
4104: IF FND_API.To_Boolean ( p_commit )
4105: THEN
4106: COMMIT WORK;
4107: END IF; -- IF FND_API.To_Boolean
4108:
4109: -- Debug Message
4110: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4111: THEN

Line 4118: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4114: FND_MSG_PUB.Add;
4115: END IF; -- IF FND_MSG_PUB.Check_Msg_level
4116:
4117: --Standard call to get message count and if count=1, get the message
4118: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4119: p_count => x_msg_count,
4120: p_data => x_msg_data
4121: );
4122:

Line 4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

4120: p_data => x_msg_data
4121: );
4122:
4123: EXCEPTION
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4125: THEN
4126: ROLLBACK TO Content_XML;
4127: x_content_xml := NULL;
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4125: THEN
4126: ROLLBACK TO Content_XML;
4127: x_content_xml := NULL;
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4130: -- Standard call to get message count and if count=1, get the message
4131: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4132: p_count => x_msg_count,

Line 4131: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4127: x_content_xml := NULL;
4128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4129: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4130: -- Standard call to get message count and if count=1, get the message
4131: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4132: p_count => x_msg_count,
4133: p_data => x_msg_data
4134: );
4135: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4137: WHEN FND_API.G_EXC_ERROR

4133: p_data => x_msg_data
4134: );
4135: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
4136:
4137: WHEN FND_API.G_EXC_ERROR
4138: THEN
4139: ROLLBACK TO Content_XML;
4140: x_content_xml := NULL;
4141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4141: x_return_status := FND_API.G_RET_STS_ERROR;

4137: WHEN FND_API.G_EXC_ERROR
4138: THEN
4139: ROLLBACK TO Content_XML;
4140: x_content_xml := NULL;
4141: x_return_status := FND_API.G_RET_STS_ERROR;
4142: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4143: -- Standard call to get message count and if count=1, get the message
4144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4145: p_count => x_msg_count,

Line 4144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4140: x_content_xml := NULL;
4141: x_return_status := FND_API.G_RET_STS_ERROR;
4142: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4143: -- Standard call to get message count and if count=1, get the message
4144: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4145: p_count => x_msg_count,
4146: p_data => x_msg_data
4147: );
4148: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4150: WHEN OTHERS
4151: THEN
4152: ROLLBACK TO Content_XML;
4153: x_content_xml := NULL;
4154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4155: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4156:
4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4158: THEN

Line 4164: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4160: (G_PKG_NAME, l_api_name);
4161: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4162:
4163: -- Standard call to get message count and if count=1, get the message
4164: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4165: p_count => x_msg_count,
4166: p_data => x_msg_data
4167: );
4168: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4181:
4182: PROCEDURE Get_Content_XML
4183: (
4184: p_api_version IN NUMBER,
4185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4188: x_return_status OUT NOCOPY VARCHAR2,
4189: x_msg_count OUT NOCOPY NUMBER,

Line 4186: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4182: PROCEDURE Get_Content_XML
4183: (
4184: p_api_version IN NUMBER,
4185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4188: x_return_status OUT NOCOPY VARCHAR2,
4189: x_msg_count OUT NOCOPY NUMBER,
4190: x_msg_data OUT NOCOPY VARCHAR2,

Line 4187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4183: (
4184: p_api_version IN NUMBER,
4185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4188: x_return_status OUT NOCOPY VARCHAR2,
4189: x_msg_count OUT NOCOPY NUMBER,
4190: x_msg_data OUT NOCOPY VARCHAR2,
4191: p_content_id IN NUMBER,

Line 4192: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,

4188: x_return_status OUT NOCOPY VARCHAR2,
4189: x_msg_count OUT NOCOPY NUMBER,
4190: x_msg_data OUT NOCOPY VARCHAR2,
4191: p_content_id IN NUMBER,
4192: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
4193: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
4194: p_quantity IN NUMBER := 1,
4195: p_media_type IN VARCHAR2,
4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4193: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated

4189: x_msg_count OUT NOCOPY NUMBER,
4190: x_msg_data OUT NOCOPY VARCHAR2,
4191: p_content_id IN NUMBER,
4192: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
4193: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
4194: p_quantity IN NUMBER := 1,
4195: p_media_type IN VARCHAR2,
4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,

4192: p_content_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
4193: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
4194: p_quantity IN NUMBER := 1,
4195: p_media_type IN VARCHAR2,
4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
4198: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
4199: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
4200: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,

4193: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR, -- depreciated
4194: p_quantity IN NUMBER := 1,
4195: p_media_type IN VARCHAR2,
4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
4198: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
4199: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
4200: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
4201: p_content_type IN VARCHAR2,

Line 4198: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,

4194: p_quantity IN NUMBER := 1,
4195: p_media_type IN VARCHAR2,
4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
4198: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
4199: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
4200: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
4201: p_content_type IN VARCHAR2,
4202: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 4199: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

4195: p_media_type IN VARCHAR2,
4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
4198: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
4199: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
4200: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
4201: p_content_type IN VARCHAR2,
4202: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
4203: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 4200: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,

4196: p_printer IN VARCHAR2 := FND_API.G_MISS_CHAR,
4197: p_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
4198: p_fax IN VARCHAR2 := FND_API.G_MISS_CHAR,
4199: p_file_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
4200: p_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
4201: p_content_type IN VARCHAR2,
4202: p_bind_var IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
4203: p_bind_val IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
4204: p_bind_var_type IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 4210: l_version NUMBER := FND_API.G_MISS_NUM;

4206: x_content_xml OUT NOCOPY VARCHAR2
4207: ) IS
4208: l_content_source VARCHAR2(30) := 'mes';
4209: l_body VARCHAR2(30) := 'no';
4210: l_version NUMBER := FND_API.G_MISS_NUM;
4211: l_api_name CONSTANT varchar2(100) := 'GET_CONTENT_XML';
4212: l_full_name CONSTANT varchar2(2000) := G_PKG_NAME || '.' || l_api_name;
4213:
4214: BEGIN

Line 4262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4258: ---------------------------------------------------------------
4259:
4260: PROCEDURE Send_Request
4261: (p_api_version IN NUMBER,
4262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4265: x_return_status OUT NOCOPY VARCHAR2,
4266: x_msg_count OUT NOCOPY NUMBER,

Line 4263: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4259:
4260: PROCEDURE Send_Request
4261: (p_api_version IN NUMBER,
4262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4265: x_return_status OUT NOCOPY VARCHAR2,
4266: x_msg_count OUT NOCOPY NUMBER,
4267: x_msg_data OUT NOCOPY VARCHAR2,

Line 4264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4260: PROCEDURE Send_Request
4261: (p_api_version IN NUMBER,
4262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4265: x_return_status OUT NOCOPY VARCHAR2,
4266: x_msg_count OUT NOCOPY NUMBER,
4267: x_msg_data OUT NOCOPY VARCHAR2,
4268: p_template_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4268: p_template_id IN NUMBER := FND_API.G_MISS_NUM,

4264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4265: x_return_status OUT NOCOPY VARCHAR2,
4266: x_msg_count OUT NOCOPY NUMBER,
4267: x_msg_data OUT NOCOPY VARCHAR2,
4268: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4269: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4270: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4272: p_user_id IN NUMBER,

Line 4269: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,

4265: x_return_status OUT NOCOPY VARCHAR2,
4266: x_msg_count OUT NOCOPY NUMBER,
4267: x_msg_data OUT NOCOPY VARCHAR2,
4268: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4269: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4270: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4272: p_user_id IN NUMBER,
4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,

Line 4270: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

4266: x_msg_count OUT NOCOPY NUMBER,
4267: x_msg_data OUT NOCOPY VARCHAR2,
4268: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4269: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4270: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4272: p_user_id IN NUMBER,
4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

4267: x_msg_data OUT NOCOPY VARCHAR2,
4268: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4269: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4270: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4272: p_user_id IN NUMBER,
4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

4270: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4272: p_user_id IN NUMBER,
4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

4271: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4272: p_user_id IN NUMBER,
4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

4272: p_user_id IN NUMBER,
4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

4273: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

4274: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4282: p_queue_response IN VARCHAR2 := 'S',

Line 4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

4275: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4282: p_queue_response IN VARCHAR2 := 'S',
4283: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

4276: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4282: p_queue_response IN VARCHAR2 := 'S',
4283: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4284: p_content_xml IN VARCHAR2,

Line 4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

4277: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4278: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4282: p_queue_response IN VARCHAR2 := 'S',
4283: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4284: p_content_xml IN VARCHAR2,
4285: p_request_id IN NUMBER,

Line 4283: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

4279: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4280: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4281: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4282: p_queue_response IN VARCHAR2 := 'S',
4283: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4284: p_content_xml IN VARCHAR2,
4285: p_request_id IN NUMBER,
4286: p_preview IN VARCHAR2 := FND_API.G_FALSE
4287: ) IS

Line 4286: p_preview IN VARCHAR2 := FND_API.G_FALSE

4282: p_queue_response IN VARCHAR2 := 'S',
4283: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4284: p_content_xml IN VARCHAR2,
4285: p_request_id IN NUMBER,
4286: p_preview IN VARCHAR2 := FND_API.G_FALSE
4287: ) IS
4288: l_api_name CONSTANT VARCHAR2(30) := 'Submit_Single_Request';
4289: l_api_version CONSTANT NUMBER := 1.0;
4290: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME ||'.'|| l_api_name;

Line 4301: IF p_template_id <> FND_API.G_MISS_NUM THEN

4297: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN ' || l_full_name , JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
4298: --
4299: SAVEPOINT SEND_Request;
4300:
4301: IF p_template_id <> FND_API.G_MISS_NUM THEN
4302: l_fulfill_electronic_rec.template_id := p_template_id;
4303: END IF;
4304: IF p_object_type <> FND_API.G_MISS_CHAR THEN
4305: l_fulfill_electronic_rec.object_type := p_object_type;

Line 4304: IF p_object_type <> FND_API.G_MISS_CHAR THEN

4300:
4301: IF p_template_id <> FND_API.G_MISS_NUM THEN
4302: l_fulfill_electronic_rec.template_id := p_template_id;
4303: END IF;
4304: IF p_object_type <> FND_API.G_MISS_CHAR THEN
4305: l_fulfill_electronic_rec.object_type := p_object_type;
4306: END IF;
4307: IF p_object_id <> FND_API.G_MISS_NUM THEN
4308: l_fulfill_electronic_rec.object_id := p_object_id;

Line 4307: IF p_object_id <> FND_API.G_MISS_NUM THEN

4303: END IF;
4304: IF p_object_type <> FND_API.G_MISS_CHAR THEN
4305: l_fulfill_electronic_rec.object_type := p_object_type;
4306: END IF;
4307: IF p_object_id <> FND_API.G_MISS_NUM THEN
4308: l_fulfill_electronic_rec.object_id := p_object_id;
4309: END IF;
4310: IF p_source_code <> FND_API.G_MISS_CHAR THEN
4311: l_fulfill_electronic_rec.source_code := p_source_code;

Line 4310: IF p_source_code <> FND_API.G_MISS_CHAR THEN

4306: END IF;
4307: IF p_object_id <> FND_API.G_MISS_NUM THEN
4308: l_fulfill_electronic_rec.object_id := p_object_id;
4309: END IF;
4310: IF p_source_code <> FND_API.G_MISS_CHAR THEN
4311: l_fulfill_electronic_rec.source_code := p_source_code;
4312: END IF;
4313: IF p_source_code_id <> FND_API.G_MISS_NUM THEN
4314: l_fulfill_electronic_rec.source_code_id := p_source_code_id;

Line 4313: IF p_source_code_id <> FND_API.G_MISS_NUM THEN

4309: END IF;
4310: IF p_source_code <> FND_API.G_MISS_CHAR THEN
4311: l_fulfill_electronic_rec.source_code := p_source_code;
4312: END IF;
4313: IF p_source_code_id <> FND_API.G_MISS_NUM THEN
4314: l_fulfill_electronic_rec.source_code_id := p_source_code_id;
4315: END IF;
4316: IF p_user_id <> FND_API.G_MISS_NUM THEN
4317: l_fulfill_electronic_rec.requestor_id := p_user_id;

Line 4316: IF p_user_id <> FND_API.G_MISS_NUM THEN

4312: END IF;
4313: IF p_source_code_id <> FND_API.G_MISS_NUM THEN
4314: l_fulfill_electronic_rec.source_code_id := p_source_code_id;
4315: END IF;
4316: IF p_user_id <> FND_API.G_MISS_NUM THEN
4317: l_fulfill_electronic_rec.requestor_id := p_user_id;
4318: END IF;
4319: IF p_order_id <> FND_API.G_MISS_NUM THEN
4320: l_fulfill_electronic_rec.order_id := p_order_id;

Line 4319: IF p_order_id <> FND_API.G_MISS_NUM THEN

4315: END IF;
4316: IF p_user_id <> FND_API.G_MISS_NUM THEN
4317: l_fulfill_electronic_rec.requestor_id := p_user_id;
4318: END IF;
4319: IF p_order_id <> FND_API.G_MISS_NUM THEN
4320: l_fulfill_electronic_rec.order_id := p_order_id;
4321: END IF;
4322: IF p_subject <> FND_API.G_MISS_CHAR THEN
4323: l_fulfill_electronic_rec.subject := p_subject;

Line 4322: IF p_subject <> FND_API.G_MISS_CHAR THEN

4318: END IF;
4319: IF p_order_id <> FND_API.G_MISS_NUM THEN
4320: l_fulfill_electronic_rec.order_id := p_order_id;
4321: END IF;
4322: IF p_subject <> FND_API.G_MISS_CHAR THEN
4323: l_fulfill_electronic_rec.subject := p_subject;
4324: END IF;
4325: IF p_extended_header <> FND_API.G_MISS_CHAR THEN
4326: l_fulfill_electronic_rec.extended_header := p_extended_header;

Line 4325: IF p_extended_header <> FND_API.G_MISS_CHAR THEN

4321: END IF;
4322: IF p_subject <> FND_API.G_MISS_CHAR THEN
4323: l_fulfill_electronic_rec.subject := p_subject;
4324: END IF;
4325: IF p_extended_header <> FND_API.G_MISS_CHAR THEN
4326: l_fulfill_electronic_rec.extended_header := p_extended_header;
4327: END IF;
4328:
4329: IF p_content_xml<> FND_API.G_MISS_CHAR THEN

Line 4329: IF p_content_xml<> FND_API.G_MISS_CHAR THEN

4325: IF p_extended_header <> FND_API.G_MISS_CHAR THEN
4326: l_fulfill_electronic_rec.extended_header := p_extended_header;
4327: END IF;
4328:
4329: IF p_content_xml<> FND_API.G_MISS_CHAR THEN
4330: l_fm_pvt_rec.content_xml := p_content_xml;
4331: END IF;
4332: IF p_request_id <> FND_API.G_MISS_NUM THEN
4333: l_fm_pvt_rec.request_id := p_request_id ;

Line 4332: IF p_request_id <> FND_API.G_MISS_NUM THEN

4328:
4329: IF p_content_xml<> FND_API.G_MISS_CHAR THEN
4330: l_fm_pvt_rec.content_xml := p_content_xml;
4331: END IF;
4332: IF p_request_id <> FND_API.G_MISS_NUM THEN
4333: l_fm_pvt_rec.request_id := p_request_id ;
4334: END IF;
4335: IF p_party_id <> FND_API.G_MISS_NUM THEN
4336: l_fm_pvt_rec.party_id := p_party_id ;

Line 4335: IF p_party_id <> FND_API.G_MISS_NUM THEN

4331: END IF;
4332: IF p_request_id <> FND_API.G_MISS_NUM THEN
4333: l_fm_pvt_rec.request_id := p_request_id ;
4334: END IF;
4335: IF p_party_id <> FND_API.G_MISS_NUM THEN
4336: l_fm_pvt_rec.party_id := p_party_id ;
4337: END IF;
4338:
4339: IF p_queue_response <> FND_API.G_MISS_CHAR THEN

Line 4339: IF p_queue_response <> FND_API.G_MISS_CHAR THEN

4335: IF p_party_id <> FND_API.G_MISS_NUM THEN
4336: l_fm_pvt_rec.party_id := p_party_id ;
4337: END IF;
4338:
4339: IF p_queue_response <> FND_API.G_MISS_CHAR THEN
4340: IF p_queue_response = 'T' THEN
4341: l_fm_pvt_rec.queue := 'S';
4342: ELSE
4343: l_fm_pvt_rec.queue := p_queue_response;

Line 4351: IF p_preview <> FND_API.G_MISS_CHAR THEN

4347: ELSE
4348: l_fm_pvt_rec.queue := p_queue_response;
4349: END IF;
4350:
4351: IF p_preview <> FND_API.G_MISS_CHAR THEN
4352: l_fm_pvt_rec.preview := p_preview;
4353: END IF;
4354: IF p_priority <> FND_API.G_MISS_NUM THEN
4355: l_fm_pvt_rec.priority := p_priority;

Line 4354: IF p_priority <> FND_API.G_MISS_NUM THEN

4350:
4351: IF p_preview <> FND_API.G_MISS_CHAR THEN
4352: l_fm_pvt_rec.preview := p_preview;
4353: END IF;
4354: IF p_priority <> FND_API.G_MISS_NUM THEN
4355: l_fm_pvt_rec.priority := p_priority;
4356: END IF;
4357: IF p_doc_id <> FND_API.G_MISS_NUM THEN
4358: l_fm_pvt_rec.doc_ref := p_doc_ref;

Line 4357: IF p_doc_id <> FND_API.G_MISS_NUM THEN

4353: END IF;
4354: IF p_priority <> FND_API.G_MISS_NUM THEN
4355: l_fm_pvt_rec.priority := p_priority;
4356: END IF;
4357: IF p_doc_id <> FND_API.G_MISS_NUM THEN
4358: l_fm_pvt_rec.doc_ref := p_doc_ref;
4359: l_fm_pvt_rec.doc_id := p_doc_id;
4360: END IF;
4361:

Line 4382: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4378: l_fm_pvt_rec
4379:
4380: );
4381:
4382: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4383:
4384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4385: THEN
4386: FND_MESSAGE.Set_Name('JTF', 'JTF_FM_API_SUCCESS_MESSAGE');

Line 4392: IF FND_API.To_Boolean ( p_commit )

4388: FND_MSG_PUB.Add;
4389: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4390:
4391: --Standard check of commit
4392: IF FND_API.To_Boolean ( p_commit )
4393: THEN
4394: COMMIT WORK;
4395: END IF; -- IF FND_API.To_Boolean
4396: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 4395: END IF; -- IF FND_API.To_Boolean

4391: --Standard check of commit
4392: IF FND_API.To_Boolean ( p_commit )
4393: THEN
4394: COMMIT WORK;
4395: END IF; -- IF FND_API.To_Boolean
4396: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4397:
4398: RAISE FND_API.G_EXC_ERROR;
4399: ELSE

Line 4396: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

4392: IF FND_API.To_Boolean ( p_commit )
4393: THEN
4394: COMMIT WORK;
4395: END IF; -- IF FND_API.To_Boolean
4396: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4397:
4398: RAISE FND_API.G_EXC_ERROR;
4399: ELSE
4400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4398: RAISE FND_API.G_EXC_ERROR;

4394: COMMIT WORK;
4395: END IF; -- IF FND_API.To_Boolean
4396: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4397:
4398: RAISE FND_API.G_EXC_ERROR;
4399: ELSE
4400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4401:
4402:

Line 4400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4396: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
4397:
4398: RAISE FND_API.G_EXC_ERROR;
4399: ELSE
4400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4401:
4402:
4403: END IF;
4404:

Line 4414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4410: FND_MSG_PUB.Add;
4411: END IF; -- IF FND_MSG.PUB.Check_Msg_level
4412:
4413: --Standard call to get message count and if count=1, get the message
4414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4415: p_count => x_msg_count,
4416: p_data => x_msg_data
4417: );
4418: EXCEPTION

Line 4420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

4416: p_data => x_msg_data
4417: );
4418: EXCEPTION
4419:
4420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4421: THEN
4422: ROLLBACK TO Send_Request;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

Line 4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4419:
4420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4421: THEN
4422: ROLLBACK TO Send_Request;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4425: -- Standard call to get message count and if count=1, get the message
4426: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4427: p_count => x_msg_count,

Line 4426: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4422: ROLLBACK TO Send_Request;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4425: -- Standard call to get message count and if count=1, get the message
4426: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4427: p_count => x_msg_count,
4428: p_data => x_msg_data
4429: );
4430: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4432: WHEN FND_API.G_EXC_ERROR

4428: p_data => x_msg_data
4429: );
4430: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
4431:
4432: WHEN FND_API.G_EXC_ERROR
4433: THEN
4434: ROLLBACK TO Send_Request;
4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);

Line 4435: x_return_status := FND_API.G_RET_STS_ERROR;

4431:
4432: WHEN FND_API.G_EXC_ERROR
4433: THEN
4434: ROLLBACK TO Send_Request;
4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4437: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
4438: -- Standard call to get message count and if count=1, get the message
4439: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

Line 4439: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4437: JTF_FM_UTL_V.PRINT_MESSAGE('Expected Error Occured'||l_Error_Msg,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
4438: -- Standard call to get message count and if count=1, get the message
4439: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
4440: p_count => x_msg_count,
4441: p_data => x_msg_data
4442: );
4443: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4444:
4445: WHEN OTHERS
4446: THEN
4447: ROLLBACK TO Send_Request;
4448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4449: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4450:
4451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4452: THEN

Line 4457: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

4453: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4454: END IF; -- IF FND_MSG_PUB.Check_Msg_Level
4455:
4456: -- Standard call to get message count and if count=1, get the message
4457: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data
4460: );
4461: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4472: ---------------------------------------------------------------
4473:
4474: PROCEDURE Submit_Request
4475: (p_api_version IN NUMBER,
4476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4477: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4479: x_return_status OUT NOCOPY VARCHAR2,
4480: x_msg_count OUT NOCOPY NUMBER,

Line 4477: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4473:
4474: PROCEDURE Submit_Request
4475: (p_api_version IN NUMBER,
4476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4477: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4479: x_return_status OUT NOCOPY VARCHAR2,
4480: x_msg_count OUT NOCOPY NUMBER,
4481: x_msg_data OUT NOCOPY VARCHAR2,

Line 4478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4474: PROCEDURE Submit_Request
4475: (p_api_version IN NUMBER,
4476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4477: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4479: x_return_status OUT NOCOPY VARCHAR2,
4480: x_msg_count OUT NOCOPY NUMBER,
4481: x_msg_data OUT NOCOPY VARCHAR2,
4482: p_template_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4482: p_template_id IN NUMBER := FND_API.G_MISS_NUM,

4478: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4479: x_return_status OUT NOCOPY VARCHAR2,
4480: x_msg_count OUT NOCOPY NUMBER,
4481: x_msg_data OUT NOCOPY VARCHAR2,
4482: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4483: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4484: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4486: p_user_id IN NUMBER,

Line 4483: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,

4479: x_return_status OUT NOCOPY VARCHAR2,
4480: x_msg_count OUT NOCOPY NUMBER,
4481: x_msg_data OUT NOCOPY VARCHAR2,
4482: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4483: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4484: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4486: p_user_id IN NUMBER,
4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,

Line 4484: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

4480: x_msg_count OUT NOCOPY NUMBER,
4481: x_msg_data OUT NOCOPY VARCHAR2,
4482: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4483: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4484: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4486: p_user_id IN NUMBER,
4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

4481: x_msg_data OUT NOCOPY VARCHAR2,
4482: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
4483: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
4484: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4486: p_user_id IN NUMBER,
4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

4484: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4486: p_user_id IN NUMBER,
4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

4485: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
4486: p_user_id IN NUMBER,
4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

4486: p_user_id IN NUMBER,
4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

4487: p_priority IN NUMBER := G_PRIORITY_REGULAR,
4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

Line 4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

4488: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,

Line 4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

4489: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
4497: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

4490: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
4497: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4498: p_content_xml IN VARCHAR2,

Line 4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

4491: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
4497: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4498: p_content_xml IN VARCHAR2,
4499: p_request_id IN NUMBER

Line 4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,

4492: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
4497: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4498: p_content_xml IN VARCHAR2,
4499: p_request_id IN NUMBER
4500: ) IS

Line 4497: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

4493: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
4494: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
4495: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
4496: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
4497: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
4498: p_content_xml IN VARCHAR2,
4499: p_request_id IN NUMBER
4500: ) IS
4501: l_queue_response VARCHAR2(2) := 'S';

Line 4533: FND_API.G_FALSE

4529: l_queue_response,
4530: p_extended_header,
4531: p_content_xml,
4532: p_request_id,
4533: FND_API.G_FALSE
4534: );
4535:
4536: JTF_FM_UTL_V.PRINT_MESSAGE('END '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
4537: END Submit_Request;

Line 4549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4545: ---------------------------------------------------------------
4546:
4547: PROCEDURE Submit_Previewed_Request(
4548: p_api_version IN NUMBER,
4549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4550: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4551: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4552: x_return_status OUT NOCOPY VARCHAR2,
4553: x_msg_count OUT NOCOPY NUMBER,

Line 4550: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4546:
4547: PROCEDURE Submit_Previewed_Request(
4548: p_api_version IN NUMBER,
4549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4550: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4551: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4552: x_return_status OUT NOCOPY VARCHAR2,
4553: x_msg_count OUT NOCOPY NUMBER,
4554: x_msg_data OUT NOCOPY VARCHAR2,

Line 4551: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4547: PROCEDURE Submit_Previewed_Request(
4548: p_api_version IN NUMBER,
4549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4550: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4551: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4552: x_return_status OUT NOCOPY VARCHAR2,
4553: x_msg_count OUT NOCOPY NUMBER,
4554: x_msg_data OUT NOCOPY VARCHAR2,
4555: p_request_id IN NUMBER

Line 4606: IF NOT FND_API.Compatible_API_Call (

4602: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
4603: -- Standard begin of API savepoint
4604: SAVEPOINT Previewed;
4605:
4606: IF NOT FND_API.Compatible_API_Call (
4607: l_api_version,
4608: p_api_version,
4609: l_api_name,
4610: G_PKG_NAME)

Line 4612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4608: p_api_version,
4609: l_api_name,
4610: G_PKG_NAME)
4611: THEN
4612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4613: END IF; -- IF NOT FND_API.Compatible_API_Call (
4614:
4615: --Initialize message list if p_init_msg_list is TRUE.
4616: IF FND_API.To_Boolean (p_init_msg_list)

Line 4613: END IF; -- IF NOT FND_API.Compatible_API_Call (

4609: l_api_name,
4610: G_PKG_NAME)
4611: THEN
4612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4613: END IF; -- IF NOT FND_API.Compatible_API_Call (
4614:
4615: --Initialize message list if p_init_msg_list is TRUE.
4616: IF FND_API.To_Boolean (p_init_msg_list)
4617: THEN

Line 4616: IF FND_API.To_Boolean (p_init_msg_list)

4612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4613: END IF; -- IF NOT FND_API.Compatible_API_Call (
4614:
4615: --Initialize message list if p_init_msg_list is TRUE.
4616: IF FND_API.To_Boolean (p_init_msg_list)
4617: THEN
4618: FND_MSG_PUB.initialize;
4619: END IF; -- IF FND_API.To_Boolean (p_init_msg_list)
4620:

Line 4619: END IF; -- IF FND_API.To_Boolean (p_init_msg_list)

4615: --Initialize message list if p_init_msg_list is TRUE.
4616: IF FND_API.To_Boolean (p_init_msg_list)
4617: THEN
4618: FND_MSG_PUB.initialize;
4619: END IF; -- IF FND_API.To_Boolean (p_init_msg_list)
4620:
4621: -- Debug Message
4622: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4623: THEN

Line 4630: x_return_status := FND_API.G_RET_STS_SUCCESS;

4626: FND_MSG_PUB.Add;
4627: END IF; -- IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4628:
4629: -- Initialize API return status to success
4630: x_return_status := FND_API.G_RET_STS_SUCCESS;
4631:
4632: IF (p_request_id IS NULL)
4633: THEN
4634: l_Error_Msg := 'Must pass p_request_id parameter';

Line 4640: RAISE FND_API.G_EXC_ERROR;

4636: THEN
4637: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
4638: FND_MSG_PUB.Add;
4639: END IF; -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4640: RAISE FND_API.G_EXC_ERROR;
4641: ELSE
4642:
4643: OPEN GETREQUEST;
4644: FETCH GETREQUEST

Line 4654: RAISE FND_API.G_EXC_ERROR;

4650: CLOSE GETREQUEST;
4651: l_Error_Msg := 'Could not find REQUEST DATA in the database';
4652: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND', p_request_id);
4653:
4654: RAISE FND_API.G_EXC_ERROR;
4655: ELSE
4656: -- dbms_output.put_line('server id : ' || l_server_id);
4657: -- Get the request and response queue names
4658: OPEN CREQ;

Line 4671: RAISE FND_API.G_EXC_ERROR;

4667: CLOSE CREQ;
4668: l_Error_Msg := 'Could not find queue_names in the database';
4669: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',l_server_id);
4670:
4671: RAISE FND_API.G_EXC_ERROR;
4672: ELSE
4673: -- dbms_output.put_line('request queue : ' || l_request_queue);
4674: -- dbms_output.put_line('response queue : ' || l_response_queue);
4675:

Line 4699: RAISE FND_API.G_EXC_ERROR;

4695: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_ALREADY_PREVIEWED');
4696: FND_MSG_PUB.Add;
4697: END IF; -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4698:
4699: RAISE FND_API.G_EXC_ERROR;
4700:
4701: -- Has a status of 'PREVIEW' in the XML. This is the one that will be
4702: -- honored
4703: ELSIF (INSTR(l_status, 'PREVIEW') > 0)

Line 4756: IF FND_API.To_Boolean ( p_commit ) THEN

4752: END IF; -- IF (GETREQUEST%NOTFOUND)
4753: END IF; -- IF (p_request_id IS NULL)
4754:
4755: --Standard check of commit
4756: IF FND_API.To_Boolean ( p_commit ) THEN
4757: COMMIT WORK;
4758: END IF;
4759: -- Debug Message
4760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 4775: p_encoded => FND_API.g_false,

4771: END IF;
4772:
4773: --Standard call to get message count and if count=1, get the message
4774: FND_MSG_PUB.Count_And_Get (
4775: p_encoded => FND_API.g_false,
4776: p_count => x_msg_count,
4777: p_data => x_msg_data
4778: );
4779:

Line 4786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4782: FND_MSG_PUB.Add;
4783: END IF;
4784:
4785: EXCEPTION
4786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4787: ROLLBACK TO Previewed;
4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4790: -- Standard call to get message count and if count=1, get the message

Line 4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4784:
4785: EXCEPTION
4786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4787: ROLLBACK TO Previewed;
4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4790: -- Standard call to get message count and if count=1, get the message
4791: FND_MSG_PUB.Count_And_Get (
4792: p_encoded => FND_API.g_false,

Line 4792: p_encoded => FND_API.g_false,

4788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4789: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4790: -- Standard call to get message count and if count=1, get the message
4791: FND_MSG_PUB.Count_And_Get (
4792: p_encoded => FND_API.g_false,
4793: p_count => x_msg_count,
4794: p_data => x_msg_data
4795: );
4796: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4797: WHEN FND_API.G_EXC_ERROR THEN

4793: p_count => x_msg_count,
4794: p_data => x_msg_data
4795: );
4796: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: ROLLBACK TO Previewed;
4799: x_return_status := FND_API.G_RET_STS_ERROR;
4800: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4801: -- Standard call to get message count and if count=1, get the message

Line 4799: x_return_status := FND_API.G_RET_STS_ERROR;

4795: );
4796: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
4797: WHEN FND_API.G_EXC_ERROR THEN
4798: ROLLBACK TO Previewed;
4799: x_return_status := FND_API.G_RET_STS_ERROR;
4800: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4801: -- Standard call to get message count and if count=1, get the message
4802: FND_MSG_PUB.Count_And_Get (
4803: p_encoded => FND_API.g_false,

Line 4803: p_encoded => FND_API.g_false,

4799: x_return_status := FND_API.G_RET_STS_ERROR;
4800: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
4801: -- Standard call to get message count and if count=1, get the message
4802: FND_MSG_PUB.Count_And_Get (
4803: p_encoded => FND_API.g_false,
4804: p_count => x_msg_count,
4805: p_data => x_msg_data
4806: );
4807: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4806: );
4807: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
4808: WHEN OTHERS THEN
4809: ROLLBACK TO Previewed;
4810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4811: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
4812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4813: THEN
4814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 4818: p_encoded => FND_API.g_false,

4814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4815: END IF;
4816: -- Standard call to get message count and if count=1, get the message
4817: FND_MSG_PUB.Count_And_Get (
4818: p_encoded => FND_API.g_false,
4819: p_count => x_msg_count,
4820: p_data => x_msg_data
4821: );
4822: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 4842: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4838: ---------------------------------------------------------------
4839:
4840: PROCEDURE Resubmit_Request(
4841: p_api_version IN NUMBER,
4842: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4843: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4844: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4845: x_return_status OUT NOCOPY VARCHAR2,
4846: x_msg_count OUT NOCOPY NUMBER,

Line 4843: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4839:
4840: PROCEDURE Resubmit_Request(
4841: p_api_version IN NUMBER,
4842: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4843: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4844: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4845: x_return_status OUT NOCOPY VARCHAR2,
4846: x_msg_count OUT NOCOPY NUMBER,
4847: x_msg_data OUT NOCOPY VARCHAR2,

Line 4844: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4840: PROCEDURE Resubmit_Request(
4841: p_api_version IN NUMBER,
4842: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4843: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4844: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4845: x_return_status OUT NOCOPY VARCHAR2,
4846: x_msg_count OUT NOCOPY NUMBER,
4847: x_msg_data OUT NOCOPY VARCHAR2,
4848: p_request_id IN NUMBER,

Line 4930: IF NOT FND_API.Compatible_API_Call (

4926: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
4927: -- Standard begin of API savepoint
4928: SAVEPOINT Resubmit;
4929:
4930: IF NOT FND_API.Compatible_API_Call (
4931: l_api_version,
4932: p_api_version,
4933: l_api_name,
4934: G_PKG_NAME)

Line 4936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4932: p_api_version,
4933: l_api_name,
4934: G_PKG_NAME)
4935: THEN
4936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4937: END IF;
4938:
4939: --Initialize message list if p_init_msg_list is TRUE.
4940: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 4940: IF FND_API.To_Boolean (p_init_msg_list) THEN

4936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4937: END IF;
4938:
4939: --Initialize message list if p_init_msg_list is TRUE.
4940: IF FND_API.To_Boolean (p_init_msg_list) THEN
4941: FND_MSG_PUB.initialize;
4942: END IF;
4943:
4944: -- Debug Message

Line 4952: x_return_status := FND_API.G_RET_STS_SUCCESS;

4948: FND_MSG_PUB.Add;
4949: END IF;
4950:
4951: -- Initialize API return status to success
4952: x_return_status := FND_API.G_RET_STS_SUCCESS;
4953:
4954: --Modified the following query as per bug 3651321
4955: select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
4956: into l_org_id

Line 4965: RAISE FND_API.G_EXC_ERROR;

4961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4962: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
4963: FND_MSG_PUB.Add;
4964: END IF;
4965: RAISE FND_API.G_EXC_ERROR;
4966: ELSE
4967: -- Get data from request_history for the request_id passed.
4968: OPEN CDATA;
4969: FETCH CDATA

Line 4991: RAISE FND_API.G_EXC_ERROR;

4987: IF(CDATA%NOTFOUND) THEN
4988: CLOSE CDATA;
4989: l_Error_Msg := 'Could not find REQUEST DATA in the database';
4990: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND' ,p_request_id);
4991: RAISE FND_API.G_EXC_ERROR;
4992: ELSE
4993: -- Get the new request id for the resubmitted Request
4994: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;
4995: -- Get the request and response queue names

Line 5010: RAISE FND_API.G_EXC_ERROR;

5006:
5007: l_Error_Msg := 'Could not find queue_names in the database';
5008: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',l_server_id);
5009:
5010: RAISE FND_API.G_EXC_ERROR;
5011: ELSE
5012: -- Read the XML request from the CLOB
5013: l_amount := DBMS_LOB.GETLENGTH(l_request);
5014: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 5180: IF FND_API.To_Boolean ( p_commit ) THEN

5176: CLOSE CDATA;
5177: END IF;
5178:
5179: --Standard check of commit
5180: IF FND_API.To_Boolean ( p_commit ) THEN
5181: COMMIT WORK;
5182: END IF;
5183: -- Debug Message
5184: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 5198: p_encoded => FND_API.g_false,

5194: FND_MSG_PUB.Add;
5195: END IF;
5196: --Standard call to get message count and if count=1, get the message
5197: FND_MSG_PUB.Count_And_Get (
5198: p_encoded => FND_API.g_false,
5199: p_count => x_msg_count,
5200: p_data => x_msg_data
5201: );
5202: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

Line 5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5204: FND_MSG_PUB.Add;
5205: END IF;
5206: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5207: EXCEPTION
5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5209: ROLLBACK TO Resubmit;
5210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5211: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5212: -- Standard call to get message count and if count=1, get the message

Line 5210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5206: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5207: EXCEPTION
5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5209: ROLLBACK TO Resubmit;
5210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5211: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5212: -- Standard call to get message count and if count=1, get the message
5213: FND_MSG_PUB.Count_And_Get (
5214: p_encoded => FND_API.g_false,

Line 5214: p_encoded => FND_API.g_false,

5210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5211: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5212: -- Standard call to get message count and if count=1, get the message
5213: FND_MSG_PUB.Count_And_Get (
5214: p_encoded => FND_API.g_false,
5215: p_count => x_msg_count,
5216: p_data => x_msg_data
5217: );
5218: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 5219: WHEN FND_API.G_EXC_ERROR THEN

5215: p_count => x_msg_count,
5216: p_data => x_msg_data
5217: );
5218: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5219: WHEN FND_API.G_EXC_ERROR THEN
5220: ROLLBACK TO Resubmit;
5221: x_return_status := FND_API.G_RET_STS_ERROR;
5222: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5223: -- Standard call to get message count and if count=1, get the message

Line 5221: x_return_status := FND_API.G_RET_STS_ERROR;

5217: );
5218: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5219: WHEN FND_API.G_EXC_ERROR THEN
5220: ROLLBACK TO Resubmit;
5221: x_return_status := FND_API.G_RET_STS_ERROR;
5222: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5223: -- Standard call to get message count and if count=1, get the message
5224: FND_MSG_PUB.Count_And_Get (
5225: p_encoded => FND_API.g_false,

Line 5225: p_encoded => FND_API.g_false,

5221: x_return_status := FND_API.G_RET_STS_ERROR;
5222: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5223: -- Standard call to get message count and if count=1, get the message
5224: FND_MSG_PUB.Count_And_Get (
5225: p_encoded => FND_API.g_false,
5226: p_count => x_msg_count,
5227: p_data => x_msg_data
5228: );
5229: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 5232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5228: );
5229: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5230: WHEN OTHERS THEN
5231: ROLLBACK TO Resubmit;
5232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5233: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5234: IF FND_MSG_PUB.Check_Msg_Level
5235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5236: THEN

Line 5242: p_encoded => FND_API.g_false,

5238: (G_PKG_NAME, l_api_name);
5239: END IF;
5240: -- Standard call to get message count and if count=1, get the message
5241: FND_MSG_PUB.Count_And_Get (
5242: p_encoded => FND_API.g_false,
5243: p_count => x_msg_count,
5244: p_data => x_msg_data
5245: );
5246: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 5265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5261: ---------------------------------------------------------------
5262:
5263: PROCEDURE Resubmit_Request(
5264: p_api_version IN NUMBER,
5265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5268: x_return_status OUT NOCOPY VARCHAR2,
5269: x_msg_count OUT NOCOPY NUMBER,

Line 5266: p_commit IN VARCHAR2 := FND_API.G_FALSE,

5262:
5263: PROCEDURE Resubmit_Request(
5264: p_api_version IN NUMBER,
5265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5268: x_return_status OUT NOCOPY VARCHAR2,
5269: x_msg_count OUT NOCOPY NUMBER,
5270: x_msg_data OUT NOCOPY VARCHAR2,

Line 5267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

5263: PROCEDURE Resubmit_Request(
5264: p_api_version IN NUMBER,
5265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5268: x_return_status OUT NOCOPY VARCHAR2,
5269: x_msg_count OUT NOCOPY NUMBER,
5270: x_msg_data OUT NOCOPY VARCHAR2,
5271: p_request_id IN NUMBER

Line 5429: IF NOT FND_API.Compatible_API_Call (

5425: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
5426: -- Standard begin of API savepoint
5427: SAVEPOINT Resubmit_job;
5428:
5429: IF NOT FND_API.Compatible_API_Call (
5430: l_api_version,
5431: p_api_version,
5432: l_api_name,
5433: G_PKG_NAME)

Line 5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5431: p_api_version,
5432: l_api_name,
5433: G_PKG_NAME)
5434: THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: END IF;
5437:
5438:
5439: -- Debug Message

Line 5447: x_return_status := FND_API.G_RET_STS_SUCCESS;

5443: FND_MSG_PUB.Add;
5444: END IF;
5445:
5446: -- Initialize API return status to success
5447: x_return_status := FND_API.G_RET_STS_SUCCESS;
5448:
5449: --Modified the foolowing query as per bug 3651321
5450: select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
5451: into l_org_id

Line 5455: IF(p_job_id IS NULL or p_job_id = FND_API.G_MISS_NUM ) THEN

5451: into l_org_id
5452: from dual;
5453:
5454: -- check if job id is present
5455: IF(p_job_id IS NULL or p_job_id = FND_API.G_MISS_NUM ) THEN
5456: l_ERROR_MSG := 'Must pass job id parmeter';
5457: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_JOB_ID');
5458:
5459: END IF;

Line 5461: IF(p_media_type IS NULL or p_media_type = FND_API.G_MISS_CHAR or p_media_type = '') THEN

5457: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_JOB_ID');
5458:
5459: END IF;
5460: -- check if media type is present
5461: IF(p_media_type IS NULL or p_media_type = FND_API.G_MISS_CHAR or p_media_type = '') THEN
5462: l_ERROR_MSG := 'Must pass media type parmeter';
5463: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_MEDIA_TYPE');
5464: ELSE
5465: IF(upper(TRIM(p_media_type))) ='EMAIL' OR (upper(TRIM(p_media_type))) = 'FAX'

Line 5475: IF(p_media_address IS NULL or p_media_address = FND_API.G_MISS_CHAR or p_media_address = '') THEN

5471: END IF;
5472:
5473: END IF;
5474: -- check media address is present
5475: IF(p_media_address IS NULL or p_media_address = FND_API.G_MISS_CHAR or p_media_address = '') THEN
5476: l_ERROR_MSG := 'Must pass media type parmeter';
5477: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_MEDIA_ADD');
5478:
5479: END IF;

Line 5487: RAISE FND_API.G_EXC_ERROR;

5483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5484: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
5485: FND_MSG_PUB.Add;
5486: END IF;
5487: RAISE FND_API.G_EXC_ERROR;
5488: ELSE
5489: GET_MEDIA(p_media_type,p_media_address,l_media);
5490:
5491: -- Get data from request_history for the request_id passed.

Line 5515: RAISE FND_API.G_EXC_ERROR;

5511: IF(CDATA%NOTFOUND) THEN
5512: CLOSE CDATA;
5513: l_Error_Msg := 'Could not find REQUEST DATA in the database';
5514: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND' ,p_request_id);
5515: RAISE FND_API.G_EXC_ERROR;
5516: ELSE
5517: -- Get the new request id for the resubmitted Request
5518: SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL INTO x_request_id FROM DUAL;
5519: -- Get the request and response queue names

Line 5534: RAISE FND_API.G_EXC_ERROR;

5530:
5531: l_Error_Msg := 'Could not find queue_names in the database';
5532: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',l_server_id);
5533:
5534: RAISE FND_API.G_EXC_ERROR;
5535: ELSE
5536: -- Read the XML request from the CLOB
5537: l_amount := DBMS_LOB.GETLENGTH(l_request);
5538: JTF_FM_UTL_V.PRINT_MESSAGE('LOB LEngth' || l_amount,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 5588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5584: JTF_FM_UTL_V.PRINT_MESSAGE('1:' ||l_pos1,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
5585: JTF_FM_UTL_V.PRINT_MESSAGE('2:' ||l_pos2,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
5586:
5587: IF l_pos1 <= 0 OR l_pos2 <= 0 THEN
5588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5589: ELSE
5590: l_nmessage1 := substr(newXML, 1, (l_pos1-1));
5591: l_nmessage2 := substr(newXML, l_pos2);
5592: l_message := l_nmessage1 || l_media || l_nmessage2;

Line 5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5602: l_pos2 := instr(l_message, '');
5603:
5604:
5605: IF l_pos1 <= 0 OR l_pos2 <= 0 THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: ELSE
5608: l_message1 := substr(l_message, 1, (l_pos1+8));
5609: l_message2 := substr(l_message, l_pos2);
5610: newXML := l_message1 || x_bind_info || l_message2;

Line 5812: IF FND_API.To_Boolean ( p_commit )

5808: CLOSE CDATA;
5809: END IF;
5810:
5811: --Standard check of commit
5812: IF FND_API.To_Boolean ( p_commit )
5813: THEN
5814: COMMIT WORK;
5815: END IF;
5816:

Line 5832: p_encoded => FND_API.g_false,

5828: FND_MSG_PUB.Add;
5829: END IF;
5830: --Standard call to get message count and if count=1, get the message
5831: FND_MSG_PUB.Count_And_Get (
5832: p_encoded => FND_API.g_false,
5833: p_count => x_msg_count,
5834: p_data => x_msg_data
5835: );
5836: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

Line 5842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5838: FND_MSG_PUB.Add;
5839: END IF;
5840: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5841: EXCEPTION
5842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5843: ROLLBACK TO Resubmit_job;
5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5845: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5846: -- Standard call to get message count and if count=1, get the message

Line 5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5840: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5841: EXCEPTION
5842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5843: ROLLBACK TO Resubmit_job;
5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5845: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5846: -- Standard call to get message count and if count=1, get the message
5847: FND_MSG_PUB.Count_And_Get (
5848: p_encoded => FND_API.g_false,

Line 5848: p_encoded => FND_API.g_false,

5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5845: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5846: -- Standard call to get message count and if count=1, get the message
5847: FND_MSG_PUB.Count_And_Get (
5848: p_encoded => FND_API.g_false,
5849: p_count => x_msg_count,
5850: p_data => x_msg_data
5851: );
5852: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 5853: WHEN FND_API.G_EXC_ERROR THEN

5849: p_count => x_msg_count,
5850: p_data => x_msg_data
5851: );
5852: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5853: WHEN FND_API.G_EXC_ERROR THEN
5854: ROLLBACK TO Resubmit_job;
5855: x_return_status := FND_API.G_RET_STS_ERROR;
5856: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5857: -- Standard call to get message count and if count=1, get the message

Line 5855: x_return_status := FND_API.G_RET_STS_ERROR;

5851: );
5852: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5853: WHEN FND_API.G_EXC_ERROR THEN
5854: ROLLBACK TO Resubmit_job;
5855: x_return_status := FND_API.G_RET_STS_ERROR;
5856: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5857: -- Standard call to get message count and if count=1, get the message
5858: FND_MSG_PUB.Count_And_Get (
5859: p_encoded => FND_API.g_false,

Line 5859: p_encoded => FND_API.g_false,

5855: x_return_status := FND_API.G_RET_STS_ERROR;
5856: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5857: -- Standard call to get message count and if count=1, get the message
5858: FND_MSG_PUB.Count_And_Get (
5859: p_encoded => FND_API.g_false,
5860: p_count => x_msg_count,
5861: p_data => x_msg_data
5862: );
5863: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 5866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5862: );
5863: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
5864: WHEN OTHERS THEN
5865: ROLLBACK TO Resubmit_job;
5866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5867: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5868: IF FND_MSG_PUB.Check_Msg_Level
5869: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5870: THEN

Line 5876: p_encoded => FND_API.g_false,

5872: (G_PKG_NAME, l_api_name);
5873: END IF;
5874: -- Standard call to get message count and if count=1, get the message
5875: FND_MSG_PUB.Count_And_Get (
5876: p_encoded => FND_API.g_false,
5877: p_count => x_msg_count,
5878: p_data => x_msg_data
5879: );
5880: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 5901: x_return_status := FND_API.G_RET_STS_SUCCESS;

5897: BEGIN
5898: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
5899: SAVEPOINT pre_correction;
5900: -- Initialize API return status to success
5901: x_return_status := FND_API.G_RET_STS_SUCCESS;
5902:
5903: UPDATE JTF_FM_CONTENT_FAILURES
5904: set corrected_address = p_corrected_address,
5905: corrected_flag = 'Y'

Line 5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5918: FND_MSG_PUB.Add;
5919: END IF;
5920:
5921: EXCEPTION
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: ROLLBACK TO pre_correction;
5924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5925: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5926:

Line 5924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5920:
5921: EXCEPTION
5922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5923: ROLLBACK TO pre_correction;
5924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5925: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5926:
5927: WHEN FND_API.G_EXC_ERROR THEN
5928: ROLLBACK TO pre_correction;

Line 5927: WHEN FND_API.G_EXC_ERROR THEN

5923: ROLLBACK TO pre_correction;
5924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5925: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5926:
5927: WHEN FND_API.G_EXC_ERROR THEN
5928: ROLLBACK TO pre_correction;
5929: x_return_status := FND_API.G_RET_STS_ERROR;
5930: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5931:

Line 5929: x_return_status := FND_API.G_RET_STS_ERROR;

5925: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5926:
5927: WHEN FND_API.G_EXC_ERROR THEN
5928: ROLLBACK TO pre_correction;
5929: x_return_status := FND_API.G_RET_STS_ERROR;
5930: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5931:
5932: WHEN OTHERS THEN
5933: ROLLBACK TO pre_correction;

Line 5934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5930: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
5931:
5932: WHEN OTHERS THEN
5933: ROLLBACK TO pre_correction;
5934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5935: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
5936: IF FND_MSG_PUB.Check_Msg_Level
5937: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5938: THEN

Line 5971: x_return_status := FND_API.G_RET_STS_SUCCESS;

5967: BEGIN
5968: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
5969: SAVEPOINT pre_correction;
5970: -- Initialize API return status to success
5971: x_return_status := FND_API.G_RET_STS_SUCCESS;
5972:
5973: l_job_count := p_job.LAST;
5974: l_add_count := p_corrected_address.LAST;
5975:

Line 5988: RAISE FND_API.G_EXC_ERROR;

5984: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQ_INFO');
5985: FND_MSG_PUB.Add;
5986: END IF; -- IF FND_MSG_PUB.check_msg_level
5987:
5988: RAISE FND_API.G_EXC_ERROR;
5989: ELSE
5990:
5991: FOR i IN 1..l_job_count LOOP
5992: CORRECT_MALFORM_JOB(p_request_id,p_job(i),p_corrected_address(i),x_return_status);

Line 5999: IF FND_API.To_Boolean ( p_commit )

5995: END LOOP;
5996: END IF;
5997:
5998: --Standard check of commit
5999: IF FND_API.To_Boolean ( p_commit )
6000: THEN
6001: COMMIT WORK;
6002: END IF;
6003: -- Success message

Line 6011: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

6007: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6008: FND_MSG_PUB.Add;
6009: END IF;
6010: --Standard call to get message count and if count=1, get the message
6011: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
6012: p_count => x_msg_count,
6013: p_data => x_msg_data
6014: );
6015:

Line 6017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6013: p_data => x_msg_data
6014: );
6015:
6016: EXCEPTION
6017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6018: ROLLBACK TO pre_correction;
6019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6020: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6021:

Line 6019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6015:
6016: EXCEPTION
6017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6018: ROLLBACK TO pre_correction;
6019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6020: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6021:
6022: WHEN FND_API.G_EXC_ERROR THEN
6023: ROLLBACK TO pre_correction;

Line 6022: WHEN FND_API.G_EXC_ERROR THEN

6018: ROLLBACK TO pre_correction;
6019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6020: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6021:
6022: WHEN FND_API.G_EXC_ERROR THEN
6023: ROLLBACK TO pre_correction;
6024: x_return_status := FND_API.G_RET_STS_ERROR;
6025: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6026:

Line 6024: x_return_status := FND_API.G_RET_STS_ERROR;

6020: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6021:
6022: WHEN FND_API.G_EXC_ERROR THEN
6023: ROLLBACK TO pre_correction;
6024: x_return_status := FND_API.G_RET_STS_ERROR;
6025: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6026:
6027: WHEN OTHERS THEN
6028: ROLLBACK TO pre_correction;

Line 6029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6025: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6026:
6027: WHEN OTHERS THEN
6028: ROLLBACK TO pre_correction;
6029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6030: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6031: IF FND_MSG_PUB.Check_Msg_Level
6032: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN

Line 6076: x_return_status := FND_API.G_RET_STS_SUCCESS;

6072: BEGIN
6073: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
6074:
6075: -- Initialize API return status to success
6076: x_return_status := FND_API.G_RET_STS_SUCCESS;
6077:
6078: SAVEPOINT pre_resubmit;
6079:
6080: OPEN CGET_MALFORMED_CORRECTED;

Line 6092: RAISE FND_API.G_EXC_ERROR;

6088: CLOSE CGET_MALFORMED_CORRECTED;
6089: l_Error_Msg := 'Could not find any corrected address for the malformed request';
6090: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_NO_MAL_CORRECTION_FOUND',p_request_id);
6091:
6092: RAISE FND_API.G_EXC_ERROR;
6093: END IF;
6094: LOOP
6095: FETCH CGET_MALFORMED_CORRECTED INTO l_job, l_corrected_address;
6096: EXIT WHEN CGET_MALFORMED_CORRECTED%NOTFOUND;

Line 6123: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)

6119: UPDATE JTF_FM_EMAIL_STATS
6120: SET RESUBMITTED_MALFORMED = RESUBMITTED_MALFORMED+1
6121: where request_id = l_request_id;
6122:
6123: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6124: then
6125: RAISE FND_API.G_EXC_ERROR;
6126: end if;
6127: END LOOP;

Line 6125: RAISE FND_API.G_EXC_ERROR;

6121: where request_id = l_request_id;
6122:
6123: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)
6124: then
6125: RAISE FND_API.G_EXC_ERROR;
6126: end if;
6127: END LOOP;
6128: CLOSE CGET_MALFORMED_CORRECTED;
6129:

Line 6132: IF FND_API.To_Boolean ( p_commit )

6128: CLOSE CGET_MALFORMED_CORRECTED;
6129:
6130:
6131: --Standard check of commit
6132: IF FND_API.To_Boolean ( p_commit )
6133: THEN
6134: COMMIT WORK;
6135: END IF;
6136: -- Success message

Line 6145: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

6141: FND_MSG_PUB.Add;
6142: END IF;
6143:
6144: --Standard call to get message count and if count=1, get the message
6145: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
6146: p_count => x_msg_count,
6147: p_data => x_msg_data
6148: );
6149:

Line 6151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6147: p_data => x_msg_data
6148: );
6149:
6150: EXCEPTION
6151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6152: ROLLBACK TO pre_resubmit;
6153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6154: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6155:

Line 6153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6149:
6150: EXCEPTION
6151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6152: ROLLBACK TO pre_resubmit;
6153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6154: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6155:
6156: WHEN FND_API.G_EXC_ERROR THEN
6157: ROLLBACK TO pre_resubmit;

Line 6156: WHEN FND_API.G_EXC_ERROR THEN

6152: ROLLBACK TO pre_resubmit;
6153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6154: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6155:
6156: WHEN FND_API.G_EXC_ERROR THEN
6157: ROLLBACK TO pre_resubmit;
6158: x_return_status := FND_API.G_RET_STS_ERROR;
6159: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6160:

Line 6158: x_return_status := FND_API.G_RET_STS_ERROR;

6154: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6155:
6156: WHEN FND_API.G_EXC_ERROR THEN
6157: ROLLBACK TO pre_resubmit;
6158: x_return_status := FND_API.G_RET_STS_ERROR;
6159: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6160:
6161: WHEN OTHERS THEN
6162: ROLLBACK TO pre_resubmit;

Line 6163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6159: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6160:
6161: WHEN OTHERS THEN
6162: ROLLBACK TO pre_resubmit;
6163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6164: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6165: IF FND_MSG_PUB.Check_Msg_Level
6166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6167: THEN

Line 6193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

6189: ---------------------------------------------------------------
6190:
6191: PROCEDURE Cancel_Request(
6192: p_api_version IN NUMBER,
6193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6196: x_return_status OUT NOCOPY VARCHAR2,
6197: x_msg_count OUT NOCOPY NUMBER,

Line 6194: p_commit IN VARCHAR2 := FND_API.G_FALSE,

6190:
6191: PROCEDURE Cancel_Request(
6192: p_api_version IN NUMBER,
6193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6196: x_return_status OUT NOCOPY VARCHAR2,
6197: x_msg_count OUT NOCOPY NUMBER,
6198: x_msg_data OUT NOCOPY VARCHAR2,

Line 6195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6191: PROCEDURE Cancel_Request(
6192: p_api_version IN NUMBER,
6193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6196: x_return_status OUT NOCOPY VARCHAR2,
6197: x_msg_count OUT NOCOPY NUMBER,
6198: x_msg_data OUT NOCOPY VARCHAR2,
6199: p_request_id IN NUMBER,

Line 6200: p_submit_dt_tm IN DATE := FND_API.G_MISS_DATE

6196: x_return_status OUT NOCOPY VARCHAR2,
6197: x_msg_count OUT NOCOPY NUMBER,
6198: x_msg_data OUT NOCOPY VARCHAR2,
6199: p_request_id IN NUMBER,
6200: p_submit_dt_tm IN DATE := FND_API.G_MISS_DATE
6201: ) IS
6202: l_api_name CONSTANT VARCHAR2(30) := 'Cancel_Request';
6203: l_api_version CONSTANT NUMBER := 1.0;
6204: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME ||'.'|| l_api_name;

Line 6254: IF NOT FND_API.Compatible_API_Call (

6250: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
6251: -- Standard begin of API savepoint
6252: SAVEPOINT Cancel;
6253:
6254: IF NOT FND_API.Compatible_API_Call (
6255: l_api_version,
6256: p_api_version,
6257: l_api_name,
6258: G_PKG_NAME)

Line 6260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6256: p_api_version,
6257: l_api_name,
6258: G_PKG_NAME)
6259: THEN
6260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6261: END IF;
6262:
6263: --Initialize message list if p_init_msg_list is TRUE.
6264: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 6264: IF FND_API.To_Boolean (p_init_msg_list) THEN

6260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6261: END IF;
6262:
6263: --Initialize message list if p_init_msg_list is TRUE.
6264: IF FND_API.To_Boolean (p_init_msg_list) THEN
6265: FND_MSG_PUB.initialize;
6266: END IF;
6267:
6268: -- Debug Message

Line 6276: x_return_status := FND_API.G_RET_STS_SUCCESS;

6272: FND_MSG_PUB.Add;
6273: END IF;
6274:
6275: -- Initialize API return status to success
6276: x_return_status := FND_API.G_RET_STS_SUCCESS;
6277: JTF_FM_UTL_V.PRINT_MESSAGE('Entering If condition',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
6278: IF (p_request_id IS NULL) THEN
6279: l_Error_Msg := 'Must pass p_request_id parameter';
6280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 6284: RAISE FND_API.G_EXC_ERROR;

6280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6281: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
6282: FND_MSG_PUB.Add;
6283: END IF;
6284: RAISE FND_API.G_EXC_ERROR;
6285:
6286: ELSE
6287: OPEN CMESG;
6288:

Line 6294: RAISE FND_API.G_EXC_ERROR;

6290: IF(CMESG%NOTFOUND) THEN
6291: CLOSE CMESG;
6292: l_Error_Msg := 'Could not find REQUEST DATA in the database';
6293: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND' ,p_request_id);
6294: RAISE FND_API.G_EXC_ERROR;
6295: END IF;
6296: --dbms_output.put_line('serverId, req type , req status is:' || l_server_id ||':' || l_request_type || ':' || l_request_status);
6297: CLOSE CMESG;
6298:

Line 6314: RAISE FND_API.G_EXC_ERROR;

6310:
6311: l_Error_Msg := 'Could not find queue_names in the database';
6312: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_QUEUE_NOTFOUND',l_server_id);
6313:
6314: RAISE FND_API.G_EXC_ERROR;
6315: END IF;
6316:
6317: l_dequeue_options.wait := dbms_aq.no_wait;
6318: l_dequeue_options.navigation := dbms_aq.first_message;

Line 6358: RAISE FND_API.G_EXC_ERROR;

6354:
6355: CLOSE CMASSMSG;
6356: l_Error_Msg := 'Could not find REQUEST DATA in the database';
6357: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_REQUEST_NOTFOUND',p_request_id);
6358: RAISE FND_API.G_EXC_ERROR;
6359: END IF;
6360:
6361:
6362: LOOP -- looping through all the batches queued and removing them

Line 6417: IF FND_API.To_Boolean ( p_commit ) THEN

6413: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6414: FND_MSG_PUB.Add;
6415: END IF;
6416: --Standard check of commit
6417: IF FND_API.To_Boolean ( p_commit ) THEN
6418: COMMIT WORK;
6419: END IF;
6420: -- Debug Message
6421: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 6428: p_encoded => FND_API.g_false,

6424: FND_MSG_PUB.Add;
6425: END IF;
6426: --Standard call to get message count and if count=1, get the message
6427: FND_MSG_PUB.Count_And_Get (
6428: p_encoded => FND_API.g_false,
6429: p_count => x_msg_count,
6430: p_data => x_msg_data
6431: );
6432:

Line 6441: x_return_status := FND_API.G_RET_STS_ERROR;

6437: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6438: EXCEPTION
6439: WHEN L_MESSAGE_NOT_FOUND OR L_NO_MESSAGES THEN
6440: ROLLBACK TO Cancel;
6441: x_return_status := FND_API.G_RET_STS_ERROR;
6442: IF l_count > 0 THEN
6443: l_Error_Msg := 'Successfully cancelled some messages';
6444: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6445: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.g_msg_lvl_success) THEN

Line 6459: p_encoded => FND_API.g_false,

6455: END IF;
6456: END IF;
6457: -- Standard call to get message count and if count=1, get the message
6458: FND_MSG_PUB.Count_And_Get (
6459: p_encoded => FND_API.g_false,
6460: p_count => x_msg_count,
6461: p_data => x_msg_data
6462: );
6463: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6460: p_count => x_msg_count,
6461: p_data => x_msg_data
6462: );
6463: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: ROLLBACK TO Cancel;
6466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6467: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6468: -- Standard call to get message count and if count=1, get the message

Line 6466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6462: );
6463: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: ROLLBACK TO Cancel;
6466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6467: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6468: -- Standard call to get message count and if count=1, get the message
6469: FND_MSG_PUB.Count_And_Get (
6470: p_encoded => FND_API.g_false,

Line 6470: p_encoded => FND_API.g_false,

6466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6467: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6468: -- Standard call to get message count and if count=1, get the message
6469: FND_MSG_PUB.Count_And_Get (
6470: p_encoded => FND_API.g_false,
6471: p_count => x_msg_count,
6472: p_data => x_msg_data
6473: );
6474: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 6475: WHEN FND_API.G_EXC_ERROR THEN

6471: p_count => x_msg_count,
6472: p_data => x_msg_data
6473: );
6474: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6475: WHEN FND_API.G_EXC_ERROR THEN
6476: ROLLBACK TO Cancel;
6477: x_return_status := FND_API.G_RET_STS_ERROR;
6478: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6479: -- Standard call to get message count and if count=1, get the message

Line 6477: x_return_status := FND_API.G_RET_STS_ERROR;

6473: );
6474: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6475: WHEN FND_API.G_EXC_ERROR THEN
6476: ROLLBACK TO Cancel;
6477: x_return_status := FND_API.G_RET_STS_ERROR;
6478: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6479: -- Standard call to get message count and if count=1, get the message
6480: FND_MSG_PUB.Count_And_Get (
6481: p_encoded => FND_API.g_false,

Line 6481: p_encoded => FND_API.g_false,

6477: x_return_status := FND_API.G_RET_STS_ERROR;
6478: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6479: -- Standard call to get message count and if count=1, get the message
6480: FND_MSG_PUB.Count_And_Get (
6481: p_encoded => FND_API.g_false,
6482: p_count => x_msg_count,
6483: p_data => x_msg_data
6484: );
6485: JTF_FM_UTL_V.PRINT_MESSAGE('x_message: '||x_msg_data,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6485: JTF_FM_UTL_V.PRINT_MESSAGE('x_message: '||x_msg_data,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
6486: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6487: WHEN OTHERS THEN
6488: ROLLBACK TO Cancel;
6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6490: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6491: IF FND_MSG_PUB.Check_Msg_Level
6492: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6493: THEN

Line 6499: p_encoded => FND_API.g_false,

6495: (G_PKG_NAME, l_api_name);
6496: END IF;
6497: -- Standard call to get message count and if count=1, get the message
6498: FND_MSG_PUB.Count_And_Get (
6499: p_encoded => FND_API.g_false,
6500: p_count => x_msg_count,
6501: p_data => x_msg_data
6502: );
6503: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 6518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

6514:
6515: PROCEDURE Get_Multiple_Content_XML
6516: (
6517: p_api_version IN NUMBER,
6518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6521: x_return_status OUT NOCOPY VARCHAR2,
6522: x_msg_count OUT NOCOPY NUMBER,

Line 6519: p_commit IN VARCHAR2 := FND_API.G_FALSE,

6515: PROCEDURE Get_Multiple_Content_XML
6516: (
6517: p_api_version IN NUMBER,
6518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6521: x_return_status OUT NOCOPY VARCHAR2,
6522: x_msg_count OUT NOCOPY NUMBER,
6523: x_msg_data OUT NOCOPY VARCHAR2,

Line 6520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6516: (
6517: p_api_version IN NUMBER,
6518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6521: x_return_status OUT NOCOPY VARCHAR2,
6522: x_msg_count OUT NOCOPY NUMBER,
6523: x_msg_data OUT NOCOPY VARCHAR2,
6524: p_request_id IN NUMBER,

Line 6572: IF NOT FND_API.Compatible_API_Call (

6568: -- Standard begin of API savepoint
6569: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
6570: SAVEPOINT Attachment_XML;
6571:
6572: IF NOT FND_API.Compatible_API_Call (
6573: l_api_version,
6574: p_api_version,
6575: l_api_name,
6576: G_PKG_NAME)

Line 6578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6574: p_api_version,
6575: l_api_name,
6576: G_PKG_NAME)
6577: THEN
6578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6579: END IF;
6580:
6581: --Initialize message list if p_init_msg_list is TRUE.
6582: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 6582: IF FND_API.To_Boolean (p_init_msg_list) THEN

6578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6579: END IF;
6580:
6581: --Initialize message list if p_init_msg_list is TRUE.
6582: IF FND_API.To_Boolean (p_init_msg_list) THEN
6583: FND_MSG_PUB.initialize;
6584: END IF;
6585:
6586: -- Debug Message

Line 6594: x_return_status := FND_API.G_RET_STS_SUCCESS;

6590: FND_MSG_PUB.Add;
6591: END IF;
6592:
6593: -- Initialize API return status to success
6594: x_return_status := FND_API.G_RET_STS_SUCCESS;
6595:
6596: IF (p_request_id IS NULL) THEN
6597: l_Error_Msg := 'Must pass p_request_id parameter';
6598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 6602: RAISE FND_API.G_EXC_ERROR;

6598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6599: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_REQUEST_ID');
6600: FND_MSG_PUB.Add;
6601: END IF;
6602: RAISE FND_API.G_EXC_ERROR;
6603: ELSIF p_content_id.count > p_content_type.count THEN
6604: l_Error_Msg := 'Must specify content_type for all contents passed';
6605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6606: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_ID');

Line 6609: RAISE FND_API.G_EXC_ERROR;

6605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6606: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_ID');
6607: FND_MSG_PUB.Add;
6608: END IF;
6609: RAISE FND_API.G_EXC_ERROR;
6610: ELSIF p_content_id.count > p_media_type.count THEN
6611: l_Error_Msg := 'Must specify media_type for all contents passed';
6612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6613: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_MEDIA_TYPE');

Line 6616: RAISE FND_API.G_EXC_ERROR;

6612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6613: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_MEDIA_TYPE');
6614: FND_MSG_PUB.Add;
6615: END IF;
6616: RAISE FND_API.G_EXC_ERROR;
6617: -- ELSIF p_content_id.count > p_document_type.count THEN
6618: -- l_Error_Msg := 'Must specify document_type for all contents passed';
6619: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6620: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');

Line 6624: -- RAISE FND_API.G_EXC_ERROR;

6620: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');
6621: -- FND_MESSAGE.Set_Token('ARG1','p_document_type');
6622: -- FND_MSG_PUB.Add;
6623: -- END IF;
6624: -- RAISE FND_API.G_EXC_ERROR;
6625: -- ELSIF p_content_id.count > p_content_nm.count THEN
6626: -- l_Error_Msg := 'Must specify content_name for all contents passed';
6627: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6628: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');

Line 6632: -- RAISE FND_API.G_EXC_ERROR;

6628: -- FND_MESSAGE.set_name('JTF', 'JTF_FM_PARAMREQD');
6629: -- FND_MESSAGE.Set_Token('ARG1','p_content_nm');
6630: -- FND_MSG_PUB.Add;
6631: -- END IF;
6632: -- RAISE FND_API.G_EXC_ERROR;
6633: ELSE
6634: l_email_count := p_email.count;
6635: l_fax_count := p_fax.count;
6636: l_printer_count := p_printer.count;

Line 6691: RAISE FND_API.G_EXC_ERROR;

6687: FND_MESSAGE.Set_Token('ARG1', p_media_type(i));
6688: FND_MESSAGE.Set_Token('ARG2', p_content_id(i));
6689: FND_MSG_PUB.Add;
6690: END IF;
6691: RAISE FND_API.G_EXC_ERROR;
6692: ELSIF l_temp > 1 THEN
6693: l_Error_Msg := 'Only one of the media_types EMAIL, FAX, PRINTER can be sent per request';
6694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6695: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MULTIPLE_MEDIATYPE');

Line 6699: RAISE FND_API.G_EXC_ERROR;

6695: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MULTIPLE_MEDIATYPE');
6696: FND_MESSAGE.Set_Token('ARG1', to_char(p_content_id(i)));
6697: FND_MSG_PUB.Add;
6698: END IF;
6699: RAISE FND_API.G_EXC_ERROR;
6700: ELSE
6701: null;
6702: END IF;
6703:

Line 6733: RAISE FND_API.G_EXC_ERROR;

6729: l_message := l_message||''||p_content_nm(i)||'';
6730:
6731: ELSE
6732: l_Error_Msg := 'Invalid content type specified. Allowed content types are ATTACHMENT and COLLATERAL';
6733: RAISE FND_API.G_EXC_ERROR;
6734: END IF;
6735: -- End of ITEM
6736: l_message := l_message||'';
6737: l_message := l_message||'';

Line 6753: IF FND_API.To_Boolean ( p_commit ) THEN

6749: FND_MESSAGE.Set_Token('ARG1', l_full_name);
6750: FND_MSG_PUB.Add;
6751: END IF;
6752: --Standard check of commit
6753: IF FND_API.To_Boolean ( p_commit ) THEN
6754: COMMIT WORK;
6755: END IF;
6756: -- Debug Message
6757: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 6764: p_encoded => FND_API.g_false,

6760: FND_MSG_PUB.Add;
6761: END IF;
6762: --Standard call to get message count and if count=1, get the message
6763: FND_MSG_PUB.Count_And_Get (
6764: p_encoded => FND_API.g_false,
6765: p_count => x_msg_count,
6766: p_data => x_msg_data
6767: );
6768: EXCEPTION

Line 6769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6765: p_count => x_msg_count,
6766: p_data => x_msg_data
6767: );
6768: EXCEPTION
6769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6770: ROLLBACK TO Attachment_XML;
6771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6772: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6773: -- Standard call to get message count and if count=1, get the message

Line 6771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6767: );
6768: EXCEPTION
6769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6770: ROLLBACK TO Attachment_XML;
6771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6772: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6773: -- Standard call to get message count and if count=1, get the message
6774: FND_MSG_PUB.Count_And_Get (
6775: p_encoded => FND_API.g_false,

Line 6775: p_encoded => FND_API.g_false,

6771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6772: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6773: -- Standard call to get message count and if count=1, get the message
6774: FND_MSG_PUB.Count_And_Get (
6775: p_encoded => FND_API.g_false,
6776: p_count => x_msg_count,
6777: p_data => x_msg_data
6778: );
6779: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 6780: WHEN FND_API.G_EXC_ERROR THEN

6776: p_count => x_msg_count,
6777: p_data => x_msg_data
6778: );
6779: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6780: WHEN FND_API.G_EXC_ERROR THEN
6781: ROLLBACK TO Attachment_XML;
6782: x_return_status := FND_API.G_RET_STS_ERROR;
6783: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6784: -- Standard call to get message count and if count=1, get the message

Line 6782: x_return_status := FND_API.G_RET_STS_ERROR;

6778: );
6779: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6780: WHEN FND_API.G_EXC_ERROR THEN
6781: ROLLBACK TO Attachment_XML;
6782: x_return_status := FND_API.G_RET_STS_ERROR;
6783: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6784: -- Standard call to get message count and if count=1, get the message
6785: FND_MSG_PUB.Count_And_Get (
6786: p_encoded => FND_API.g_false,

Line 6786: p_encoded => FND_API.g_false,

6782: x_return_status := FND_API.G_RET_STS_ERROR;
6783: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
6784: -- Standard call to get message count and if count=1, get the message
6785: FND_MSG_PUB.Count_And_Get (
6786: p_encoded => FND_API.g_false,
6787: p_count => x_msg_count,
6788: p_data => x_msg_data
6789: );
6790: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6789: );
6790: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
6791: WHEN OTHERS THEN
6792: ROLLBACK TO Attachment_XML;
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6794: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
6795: IF FND_MSG_PUB.Check_Msg_Level
6796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6797: THEN

Line 6803: p_encoded => FND_API.g_false,

6799: (G_PKG_NAME, l_api_name);
6800: END IF;
6801: -- Standard call to get message count and if count=1, get the message
6802: FND_MSG_PUB.Count_And_Get (
6803: p_encoded => FND_API.g_false,
6804: p_count => x_msg_count,
6805: p_data => x_msg_data
6806: );
6807: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 6822: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

6818: ---------------------------------------------------------------
6819:
6820: PROCEDURE Submit_Batch_Request
6821: ( p_api_version IN NUMBER,
6822: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6825: x_return_status OUT NOCOPY VARCHAR2,
6826: x_msg_count OUT NOCOPY NUMBER,

Line 6823: p_commit IN VARCHAR2 := FND_API.G_FALSE,

6819:
6820: PROCEDURE Submit_Batch_Request
6821: ( p_api_version IN NUMBER,
6822: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6825: x_return_status OUT NOCOPY VARCHAR2,
6826: x_msg_count OUT NOCOPY NUMBER,
6827: x_msg_data OUT NOCOPY VARCHAR2,

Line 6824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6820: PROCEDURE Submit_Batch_Request
6821: ( p_api_version IN NUMBER,
6822: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6825: x_return_status OUT NOCOPY VARCHAR2,
6826: x_msg_count OUT NOCOPY NUMBER,
6827: x_msg_data OUT NOCOPY VARCHAR2,
6828: p_template_id IN NUMBER := NULL,

Line 6829: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,

6825: x_return_status OUT NOCOPY VARCHAR2,
6826: x_msg_count OUT NOCOPY NUMBER,
6827: x_msg_data OUT NOCOPY VARCHAR2,
6828: p_template_id IN NUMBER := NULL,
6829: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
6830: p_user_id IN NUMBER,
6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

6827: x_msg_data OUT NOCOPY VARCHAR2,
6828: p_template_id IN NUMBER := NULL,
6829: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
6830: p_user_id IN NUMBER,
6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

Line 6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

6828: p_template_id IN NUMBER := NULL,
6829: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
6830: p_user_id IN NUMBER,
6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

Line 6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

6829: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
6830: p_user_id IN NUMBER,
6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

6830: p_user_id IN NUMBER,
6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
6838: p_list_type IN VARCHAR2,

Line 6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

6831: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
6838: p_list_type IN VARCHAR2,
6839: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

6832: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
6838: p_list_type IN VARCHAR2,
6839: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
6840: p_party_id IN G_NUMBER_TBL_TYPE := L_NUMBER_TBL,

Line 6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

6833: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
6834: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
6838: p_list_type IN VARCHAR2,
6839: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
6840: p_party_id IN G_NUMBER_TBL_TYPE := L_NUMBER_TBL,
6841: p_party_name IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 6839: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,

6835: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
6836: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
6837: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
6838: p_list_type IN VARCHAR2,
6839: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
6840: p_party_id IN G_NUMBER_TBL_TYPE := L_NUMBER_TBL,
6841: p_party_name IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6842: p_printer IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6843: p_email IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,

Line 6846: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

6842: p_printer IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6843: p_email IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6844: p_fax IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6845: p_file_path IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6846: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
6847: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
6848: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
6849: p_content_xml IN VARCHAR2,
6850: p_request_id IN NUMBER,

Line 6847: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,

6843: p_email IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6844: p_fax IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6845: p_file_path IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6846: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
6847: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
6848: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
6849: p_content_xml IN VARCHAR2,
6850: p_request_id IN NUMBER,
6851: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE

Line 6848: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

6844: p_fax IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6845: p_file_path IN G_VARCHAR_TBL_TYPE := L_VARCHAR_TBL,
6846: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
6847: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
6848: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
6849: p_content_xml IN VARCHAR2,
6850: p_request_id IN NUMBER,
6851: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE
6852: ) IS

Line 6851: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE

6847: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
6848: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
6849: p_content_xml IN VARCHAR2,
6850: p_request_id IN NUMBER,
6851: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE
6852: ) IS
6853: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_BATCH_REQUEST';
6854: l_api_version CONSTANT NUMBER := 1.0;
6855: l_full_name CONSTANT VARCHAR2(2000) := G_PKG_NAME ||'.'|| l_api_name;

Line 6876: IF NOT FND_API.Compatible_API_Call (

6872: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
6873: -- Standard begin of API savepoint
6874: SAVEPOINT Batch_Request;
6875:
6876: IF NOT FND_API.Compatible_API_Call (
6877: l_api_version,
6878: p_api_version,
6879: l_api_name,
6880: G_PKG_NAME)

Line 6882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6878: p_api_version,
6879: l_api_name,
6880: G_PKG_NAME)
6881: THEN
6882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6883: END IF;
6884:
6885: --Initialize message list if p_init_msg_list is TRUE.
6886: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 6886: IF FND_API.To_Boolean (p_init_msg_list) THEN

6882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6883: END IF;
6884:
6885: --Initialize message list if p_init_msg_list is TRUE.
6886: IF FND_API.To_Boolean (p_init_msg_list) THEN
6887: FND_MSG_PUB.initialize;
6888: END IF;
6889:
6890: -- Debug Message

Line 6898: x_return_status := FND_API.G_RET_STS_SUCCESS;

6894: FND_MSG_PUB.Add;
6895: END IF;
6896:
6897: -- Initialize API return status to success
6898: x_return_status := FND_API.G_RET_STS_SUCCESS;
6899:
6900: IF (p_list_type IS NULL) THEN
6901: l_Error_Msg := 'Must pass p_list_type parameter';
6902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 6906: RAISE FND_API.G_EXC_ERROR;

6902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6903: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_LIST_TYPE');
6904: FND_MSG_PUB.Add;
6905: END IF;
6906: RAISE FND_API.G_EXC_ERROR;
6907: ELSIF (p_content_xml IS NULL) THEN
6908: l_Error_Msg := 'Must pass p_content_xml parameter';
6909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6910: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');

Line 6914: RAISE FND_API.G_EXC_ERROR;

6910: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
6911: FND_MESSAGE.Set_Token('ARG1','p_content_xml');
6912: FND_MSG_PUB.Add;
6913: END IF;
6914: RAISE FND_API.G_EXC_ERROR;
6915: END IF;
6916:
6917: l_message := '' || p_content_xml || '';
6918: --Print_message('Message1: ' || substr(l_message, 1, 200));

Line 6927: RAISE FND_API.G_EXC_ERROR;

6923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6924: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_VIEW_NAME');
6925: FND_MSG_PUB.Add;
6926: END IF;
6927: RAISE FND_API.G_EXC_ERROR;
6928: ELSE
6929: JTF_FM_UTL_V.PRINT_MESSAGE('Creating View XML ..',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
6930: l_message := l_message || '';
6931: l_message := l_message || ' ';

Line 6964: RAISE FND_API.G_EXC_ERROR;

6960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6961: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_BATCH_LIST');
6962: FND_MSG_PUB.Add;
6963: END IF;
6964: RAISE FND_API.G_EXC_ERROR;
6965: ELSE
6966: l_message := l_message||'';
6967: JTF_FM_UTL_V.PRINT_MESSAGE('Getting the greatest value ..'||TO_CHAR(l_index),JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
6968: FOR i IN 1..l_index LOOP

Line 7009: RAISE FND_API.G_EXC_ERROR;

7005: END IF;
7006: ELSE
7007: l_Error_Msg := 'The value of p_list_type parameter must be either "VIEW" or "ADDRESS"';
7008: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_INVALID_LISTTYPE',p_list_type);
7009: RAISE FND_API.G_EXC_ERROR;
7010: END IF;
7011:
7012: -- Check if the agent wants detailed history
7013: IF p_per_user_history = FND_API.G_FALSE THEN

Line 7013: IF p_per_user_history = FND_API.G_FALSE THEN

7009: RAISE FND_API.G_EXC_ERROR;
7010: END IF;
7011:
7012: -- Check if the agent wants detailed history
7013: IF p_per_user_history = FND_API.G_FALSE THEN
7014: l_party_id := -229929;
7015: END IF;
7016:
7017:

Line 7053: IF FND_API.To_Boolean ( p_commit ) THEN

7049: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7050: FND_MSG_PUB.Add;
7051: END IF;
7052: --Standard check of commit
7053: IF FND_API.To_Boolean ( p_commit ) THEN
7054: COMMIT WORK;
7055: END IF;
7056: -- Debug Message
7057: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 7064: p_encoded => FND_API.g_false,

7060: FND_MSG_PUB.Add;
7061: END IF;
7062: --Standard call to get message count and if count=1, get the message
7063: FND_MSG_PUB.Count_And_Get (
7064: p_encoded => FND_API.g_false,
7065: p_count => x_msg_count,
7066: p_data => x_msg_data
7067: );
7068: EXCEPTION

Line 7069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7065: p_count => x_msg_count,
7066: p_data => x_msg_data
7067: );
7068: EXCEPTION
7069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7070: ROLLBACK TO Batch_Request;
7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7072: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7073: -- Standard call to get message count and if count=1, get the message

Line 7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7067: );
7068: EXCEPTION
7069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7070: ROLLBACK TO Batch_Request;
7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7072: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7073: -- Standard call to get message count and if count=1, get the message
7074: FND_MSG_PUB.Count_And_Get (
7075: p_encoded => FND_API.g_false,

Line 7075: p_encoded => FND_API.g_false,

7071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7072: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7073: -- Standard call to get message count and if count=1, get the message
7074: FND_MSG_PUB.Count_And_Get (
7075: p_encoded => FND_API.g_false,
7076: p_count => x_msg_count,
7077: p_data => x_msg_data
7078: );
7079: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7080: WHEN FND_API.G_EXC_ERROR THEN

7076: p_count => x_msg_count,
7077: p_data => x_msg_data
7078: );
7079: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7080: WHEN FND_API.G_EXC_ERROR THEN
7081: ROLLBACK TO Batch_Request;
7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7084: -- Standard call to get message count and if count=1, get the message

Line 7082: x_return_status := FND_API.G_RET_STS_ERROR;

7078: );
7079: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7080: WHEN FND_API.G_EXC_ERROR THEN
7081: ROLLBACK TO Batch_Request;
7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7084: -- Standard call to get message count and if count=1, get the message
7085: FND_MSG_PUB.Count_And_Get (
7086: p_encoded => FND_API.g_false,

Line 7086: p_encoded => FND_API.g_false,

7082: x_return_status := FND_API.G_RET_STS_ERROR;
7083: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7084: -- Standard call to get message count and if count=1, get the message
7085: FND_MSG_PUB.Count_And_Get (
7086: p_encoded => FND_API.g_false,
7087: p_count => x_msg_count,
7088: p_data => x_msg_data
7089: );
7090: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7089: );
7090: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7091: WHEN OTHERS THEN
7092: ROLLBACK TO Batch_Request;
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7095: IF FND_MSG_PUB.Check_Msg_Level
7096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7097: THEN

Line 7103: p_encoded => FND_API.g_false,

7099: (G_PKG_NAME, l_api_name);
7100: END IF;
7101: -- Standard call to get message count and if count=1, get the message
7102: FND_MSG_PUB.Count_And_Get (
7103: p_encoded => FND_API.g_false,
7104: p_count => x_msg_count,
7105: p_data => x_msg_data
7106: );
7107: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7122: ---------------------------------------------------------------
7123:
7124: PROCEDURE Submit_Mass_Request
7125: ( p_api_version IN NUMBER,
7126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7129: x_return_status OUT NOCOPY VARCHAR2,
7130: x_msg_count OUT NOCOPY NUMBER,

Line 7127: p_commit IN VARCHAR2 := FND_API.G_FALSE,

7123:
7124: PROCEDURE Submit_Mass_Request
7125: ( p_api_version IN NUMBER,
7126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7129: x_return_status OUT NOCOPY VARCHAR2,
7130: x_msg_count OUT NOCOPY NUMBER,
7131: x_msg_data OUT NOCOPY VARCHAR2,

Line 7128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7124: PROCEDURE Submit_Mass_Request
7125: ( p_api_version IN NUMBER,
7126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7129: x_return_status OUT NOCOPY VARCHAR2,
7130: x_msg_count OUT NOCOPY NUMBER,
7131: x_msg_data OUT NOCOPY VARCHAR2,
7132: p_template_id IN NUMBER := NULL,

Line 7133: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,

7129: x_return_status OUT NOCOPY VARCHAR2,
7130: x_msg_count OUT NOCOPY NUMBER,
7131: x_msg_data OUT NOCOPY VARCHAR2,
7132: p_template_id IN NUMBER := NULL,
7133: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
7134: p_user_id IN NUMBER,
7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

7131: x_msg_data OUT NOCOPY VARCHAR2,
7132: p_template_id IN NUMBER := NULL,
7133: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
7134: p_user_id IN NUMBER,
7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

7132: p_template_id IN NUMBER := NULL,
7133: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
7134: p_user_id IN NUMBER,
7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

7133: p_subject IN VARCHAR2 := FND_API.G_MISS_CHAR,
7134: p_user_id IN NUMBER,
7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

7134: p_user_id IN NUMBER,
7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated

Line 7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,

7135: p_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,

7136: p_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,

7137: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
7138: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,

Line 7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,

7139: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
7146: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
7147: p_content_xml IN VARCHAR2,

Line 7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,

7140: p_doc_id IN NUMBER := FND_API.G_MISS_NUM,
7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
7146: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
7147: p_content_xml IN VARCHAR2,
7148: p_request_id IN NUMBER,

Line 7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,

7141: p_doc_ref IN VARCHAR2 := FND_API.G_MISS_CHAR,
7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
7146: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
7147: p_content_xml IN VARCHAR2,
7148: p_request_id IN NUMBER,
7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,

Line 7146: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

7142: p_list_type IN VARCHAR2, --deprecated
7143: p_view_nm IN VARCHAR2 := FND_API.G_MISS_CHAR,
7144: p_server_id IN NUMBER := FND_API.G_MISS_NUM,
7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
7146: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
7147: p_content_xml IN VARCHAR2,
7148: p_request_id IN NUMBER,
7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
7150: p_mass_query_id IN NUMBER, --deprecated

Line 7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,

7145: p_queue_response IN VARCHAR2 := FND_API.G_FALSE,
7146: p_extended_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
7147: p_content_xml IN VARCHAR2,
7148: p_request_id IN NUMBER,
7149: p_per_user_history IN VARCHAR2 := FND_API.G_FALSE,
7150: p_mass_query_id IN NUMBER, --deprecated
7151: p_mass_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7152: p_mass_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL, --deprecated
7153: p_mass_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE := JTF_FM_REQUEST_GRP.L_VARCHAR_TBL --deprecated

Line 7191: IF NOT FND_API.Compatible_API_Call (

7187:
7188: -- Standard begin of API savepoint
7189: SAVEPOINT Mass_Request;
7190:
7191: IF NOT FND_API.Compatible_API_Call (
7192: l_api_version,
7193: p_api_version,
7194: l_api_name,
7195: G_PKG_NAME)

Line 7197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7193: p_api_version,
7194: l_api_name,
7195: G_PKG_NAME)
7196: THEN
7197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7198: END IF;
7199:
7200: --Initialize message list if p_init_msg_list is TRUE.
7201: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 7201: IF FND_API.To_Boolean (p_init_msg_list) THEN

7197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7198: END IF;
7199:
7200: --Initialize message list if p_init_msg_list is TRUE.
7201: IF FND_API.To_Boolean (p_init_msg_list) THEN
7202: FND_MSG_PUB.initialize;
7203: END IF;
7204:
7205: -- Debug Message

Line 7213: x_return_status := FND_API.G_RET_STS_SUCCESS;

7209: FND_MSG_PUB.Add;
7210: END IF;
7211:
7212: -- Initialize API return status to success
7213: x_return_status := FND_API.G_RET_STS_SUCCESS;
7214:
7215: IF (p_content_xml IS NULL) THEN
7216: l_Error_Msg := 'Must pass p_content_xml parameter';
7217:

Line 7223: RAISE FND_API.G_EXC_ERROR;

7219: FND_MESSAGE.set_name('JTF', 'JTF_FM_API_MISSING_CONTENT_XML');
7220: FND_MESSAGE.Set_Token('ARG1','p_content_xml');
7221: FND_MSG_PUB.Add;
7222: END IF;
7223: RAISE FND_API.G_EXC_ERROR;
7224:
7225: ELSE
7226: -- check if content_source is 'ocm', else throw error
7227: -- Mass request is supported only for OCM contents

Line 7238: RAISE FND_API.G_EXC_ERROR;

7234: ELSE
7235: -- throw error, item should have a query assoc for mass requests
7236: l_Error_Msg := 'Content must have a valid query associated with it.';
7237: JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_MISSING_OCM_QUERY',l_content_id);
7238: RAISE FND_API.G_EXC_ERROR;
7239: END IF;
7240:
7241: END IF;
7242:

Line 7245: IF p_per_user_history = FND_API.G_FALSE THEN

7241: END IF;
7242:
7243:
7244: -- Check if the agent wants detailed history
7245: IF p_per_user_history = FND_API.G_FALSE THEN
7246: l_party_id := -229929;
7247: END IF;
7248:
7249: JTF_FM_UTL_V.Print_message('Before Submit Request',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);

Line 7287: IF FND_API.To_Boolean ( p_commit ) THEN

7283: FND_MESSAGE.Set_Token('ARG1', l_full_name);
7284: FND_MSG_PUB.Add;
7285: END IF;
7286: --Standard check of commit
7287: IF FND_API.To_Boolean ( p_commit ) THEN
7288: COMMIT WORK;
7289: END IF;
7290: -- Debug Message
7291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 7298: p_encoded => FND_API.g_false,

7294: FND_MSG_PUB.Add;
7295: END IF;
7296: --Standard call to get message count and if count=1, get the message
7297: FND_MSG_PUB.Count_And_Get (
7298: p_encoded => FND_API.g_false,
7299: p_count => x_msg_count,
7300: p_data => x_msg_data
7301: );
7302: EXCEPTION

Line 7303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7299: p_count => x_msg_count,
7300: p_data => x_msg_data
7301: );
7302: EXCEPTION
7303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7304: ROLLBACK TO Mass_Request;
7305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7306: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7307: -- Standard call to get message count and if count=1, get the message

Line 7305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7301: );
7302: EXCEPTION
7303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7304: ROLLBACK TO Mass_Request;
7305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7306: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7307: -- Standard call to get message count and if count=1, get the message
7308: FND_MSG_PUB.Count_And_Get (
7309: p_encoded => FND_API.g_false,

Line 7309: p_encoded => FND_API.g_false,

7305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7306: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7307: -- Standard call to get message count and if count=1, get the message
7308: FND_MSG_PUB.Count_And_Get (
7309: p_encoded => FND_API.g_false,
7310: p_count => x_msg_count,
7311: p_data => x_msg_data
7312: );
7313: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7314: WHEN FND_API.G_EXC_ERROR THEN

7310: p_count => x_msg_count,
7311: p_data => x_msg_data
7312: );
7313: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7314: WHEN FND_API.G_EXC_ERROR THEN
7315: ROLLBACK TO Mass_Request;
7316: x_return_status := FND_API.G_RET_STS_ERROR;
7317: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7318: -- Standard call to get message count and if count=1, get the message

Line 7316: x_return_status := FND_API.G_RET_STS_ERROR;

7312: );
7313: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7314: WHEN FND_API.G_EXC_ERROR THEN
7315: ROLLBACK TO Mass_Request;
7316: x_return_status := FND_API.G_RET_STS_ERROR;
7317: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7318: -- Standard call to get message count and if count=1, get the message
7319: FND_MSG_PUB.Count_And_Get (
7320: p_encoded => FND_API.g_false,

Line 7320: p_encoded => FND_API.g_false,

7316: x_return_status := FND_API.G_RET_STS_ERROR;
7317: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7318: -- Standard call to get message count and if count=1, get the message
7319: FND_MSG_PUB.Count_And_Get (
7320: p_encoded => FND_API.g_false,
7321: p_count => x_msg_count,
7322: p_data => x_msg_data
7323: );
7324: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7323: );
7324: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7325: WHEN OTHERS THEN
7326: ROLLBACK TO Mass_Request;
7327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7328: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7329: IF FND_MSG_PUB.Check_Msg_Level
7330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7331: THEN

Line 7337: p_encoded => FND_API.g_false,

7333: (G_PKG_NAME, l_api_name);
7334: END IF;
7335: -- Standard call to get message count and if count=1, get the message
7336: FND_MSG_PUB.Count_And_Get (
7337: p_encoded => FND_API.g_false,
7338: p_count => x_msg_count,
7339: p_data => x_msg_data
7340: );
7341: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7411: x_return_status := FND_API.G_RET_STS_SUCCESS;

7407: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN: '|| l_full_name,JTF_FM_UTL_V.G_LEVEL_PROCEDURE,l_full_name);
7408: -- Standard begin of API savepoint
7409: SAVEPOINT PAUSE_RESUME;
7410: -- Initialize API return status to success
7411: x_return_status := FND_API.G_RET_STS_SUCCESS;
7412:
7413: --GET THE SERVER ID
7414:
7415: OPEN CSTATUS(p_request_id);

Line 7592: IF FND_API.To_Boolean ( p_commit )

7588: FND_MSG_PUB.Add;
7589: END IF;
7590: --JTF_FM_UTL_V.HANDLE_ERROR('JTF_FM_API_SUCCESS_MESSAGE', l_full_name);
7591: --Standard check of commit
7592: IF FND_API.To_Boolean ( p_commit )
7593: THEN
7594: COMMIT WORK;
7595: END IF;
7596:

Line 7599: p_encoded => FND_API.g_false,

7595: END IF;
7596:
7597: --Standard call to get message count and if count=1, get the message
7598: FND_MSG_PUB.Count_And_Get (
7599: p_encoded => FND_API.g_false,
7600: p_count => x_msg_count,
7601: p_data => x_msg_data
7602: );
7603:

Line 7611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7607: FND_MSG_PUB.Add;
7608: END IF;
7609: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7610: EXCEPTION
7611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7612: ROLLBACK TO PAUSE_RESUME;
7613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7614: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7615: -- Standard call to get message count and if count=1, get the message

Line 7613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7609: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7610: EXCEPTION
7611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7612: ROLLBACK TO PAUSE_RESUME;
7613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7614: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7615: -- Standard call to get message count and if count=1, get the message
7616: FND_MSG_PUB.Count_And_Get (
7617: p_encoded => FND_API.g_false,

Line 7617: p_encoded => FND_API.g_false,

7613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7614: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7615: -- Standard call to get message count and if count=1, get the message
7616: FND_MSG_PUB.Count_And_Get (
7617: p_encoded => FND_API.g_false,
7618: p_count => x_msg_count,
7619: p_data => x_msg_data
7620: );
7621: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7622: WHEN FND_API.G_EXC_ERROR THEN

7618: p_count => x_msg_count,
7619: p_data => x_msg_data
7620: );
7621: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7622: WHEN FND_API.G_EXC_ERROR THEN
7623: ROLLBACK TO PAUSE_RESUME;
7624: x_return_status := FND_API.G_RET_STS_ERROR;
7625: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7626: -- Standard call to get message count and if count=1, get the message

Line 7624: x_return_status := FND_API.G_RET_STS_ERROR;

7620: );
7621: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7622: WHEN FND_API.G_EXC_ERROR THEN
7623: ROLLBACK TO PAUSE_RESUME;
7624: x_return_status := FND_API.G_RET_STS_ERROR;
7625: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7626: -- Standard call to get message count and if count=1, get the message
7627: FND_MSG_PUB.Count_And_Get (
7628: p_encoded => FND_API.g_false,

Line 7628: p_encoded => FND_API.g_false,

7624: x_return_status := FND_API.G_RET_STS_ERROR;
7625: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, l_Error_Msg);
7626: -- Standard call to get message count and if count=1, get the message
7627: FND_MSG_PUB.Count_And_Get (
7628: p_encoded => FND_API.g_false,
7629: p_count => x_msg_count,
7630: p_data => x_msg_data
7631: );
7632: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);

Line 7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7631: );
7632: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);
7633: WHEN OTHERS THEN
7634: ROLLBACK TO PAUSE_RESUME;
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636: JTF_FM_UTL_V.ADD_ERROR_MESSAGE (l_api_name, SQLERRM);
7637: IF FND_MSG_PUB.Check_Msg_Level
7638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7639: THEN

Line 7645: p_encoded => FND_API.g_false,

7641: (G_PKG_NAME, l_api_name);
7642: END IF;
7643: -- Standard call to get message count and if count=1, get the message
7644: FND_MSG_PUB.Count_And_Get (
7645: p_encoded => FND_API.g_false,
7646: p_count => x_msg_count,
7647: p_data => x_msg_data
7648: );
7649: JTF_FM_UTL_V.GET_ERROR_MESSAGE(x_msg_data);