DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_PUB dependencies on FND_API

Line 35: -- p_init_msg_list FND_API.G_TRUE to reset list

31: -- It will do some basic validations on the the input parameters
32:
33: --
34: -- PARAMETERS : p_api_version_number known api version number
35: -- p_init_msg_list FND_API.G_TRUE to reset list
36: -- p_commit FND_API.G_TRUE to perform a commit
37: -- x_return_status return status
38: -- x_msg_count number of messages in the list
39: -- x_msg_data text of messages

Line 36: -- p_commit FND_API.G_TRUE to perform a commit

32:
33: --
34: -- PARAMETERS : p_api_version_number known api version number
35: -- p_init_msg_list FND_API.G_TRUE to reset list
36: -- p_commit FND_API.G_TRUE to perform a commit
37: -- x_return_status return status
38: -- x_msg_count number of messages in the list
39: -- x_msg_data text of messages
40: -- p_rule_id Pick Release Rule Id --For Defaulting purpose

Line 211: IF NOT FND_API.compatible_api_call( l_api_version,

207: WSH_DEBUG_SV.logmsg(l_module_name,'************************************************************************');
208: --}
209: END IF;
210:
211: IF NOT FND_API.compatible_api_call( l_api_version,
212: p_api_version,
213: l_api_name,
214: G_PKG_NAME) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: IF NOT FND_API.compatible_api_call( l_api_version,
212: p_api_version,
213: l_api_name,
214: G_PKG_NAME) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- Check p_init_msg_list
219: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 219: IF FND_API.to_boolean(p_init_msg_list) THEN

215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- Check p_init_msg_list
219: IF FND_API.to_boolean(p_init_msg_list) THEN
220: --{
221: FND_MSG_PUB.initialize;
222: --}
223: END IF;

Line 320: IF FND_API.TO_BOOLEAN(p_commit) THEN

316: --}
317: END IF;
318:
319:
320: IF FND_API.TO_BOOLEAN(p_commit) THEN
321: --{
322: COMMIT WORK;
323: --}
324: END IF;

Line 330: p_encoded => FND_API.G_FALSE

326: FND_MSG_PUB.Count_And_Get
327: (
328: p_count => x_msg_count,
329: p_data => x_msg_data,
330: p_encoded => FND_API.G_FALSE
331: );
332:
333: IF l_debug_on THEN
334: --{

Line 342: WHEN FND_API.G_EXC_ERROR THEN

338: --
339:
340:
341: EXCEPTION
342: WHEN FND_API.G_EXC_ERROR THEN
343: ROLLBACK TO PICKING_BATCH_PUB;
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: wsh_util_core.add_message(x_return_status);
346: FND_MSG_PUB.Count_And_Get

Line 344: x_return_status := FND_API.G_RET_STS_ERROR ;

340:
341: EXCEPTION
342: WHEN FND_API.G_EXC_ERROR THEN
343: ROLLBACK TO PICKING_BATCH_PUB;
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: wsh_util_core.add_message(x_return_status);
346: FND_MSG_PUB.Count_And_Get
347: (
348: p_count => x_msg_count,

Line 350: p_encoded => FND_API.G_FALSE

346: FND_MSG_PUB.Count_And_Get
347: (
348: p_count => x_msg_count,
349: p_data => x_msg_data,
350: p_encoded => FND_API.G_FALSE
351: );
352:
353: IF l_debug_on THEN
354: --{

Line 355: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

351: );
352:
353: IF l_debug_on THEN
354: --{
355: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
356: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
357: --}
358: END IF;
359: --

Line 356: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

352:
353: IF l_debug_on THEN
354: --{
355: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
356: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
357: --}
358: END IF;
359: --
360:

Line 361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

357: --}
358: END IF;
359: --
360:
361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362: ROLLBACK TO PICKING_BATCH_PUB;
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
364: wsh_util_core.add_message(x_return_status, l_module_name);
365: FND_MSG_PUB.Count_And_Get

Line 363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

359: --
360:
361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362: ROLLBACK TO PICKING_BATCH_PUB;
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
364: wsh_util_core.add_message(x_return_status, l_module_name);
365: FND_MSG_PUB.Count_And_Get
366: (
367: p_count => x_msg_count,

Line 369: p_encoded => FND_API.G_FALSE

365: FND_MSG_PUB.Count_And_Get
366: (
367: p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => FND_API.G_FALSE
370: );
371: --
372:
373: IF l_debug_on THEN

Line 375: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

371: --
372:
373: IF l_debug_on THEN
374: --{
375: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
377: --}
378: END IF;
379: WHEN OTHERS THEN

Line 376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

372:
373: IF l_debug_on THEN
374: --{
375: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
377: --}
378: END IF;
379: WHEN OTHERS THEN
380: ROLLBACK TO PICKING_BATCH_PUB;

Line 387: p_encoded => FND_API.G_FALSE

383: FND_MSG_PUB.Count_And_Get
384: (
385: p_count => x_msg_count,
386: p_data => x_msg_data,
387: p_encoded => FND_API.G_FALSE
388: );
389:
390: IF l_debug_on THEN
391: --{

Line 414: -- p_init_msg_list FND_API.G_TRUE to reset list

410: -- It will do some basic validations on the the input parameters
411: -- like log_level should be positive , and on the not null values of p_batch_rec.
412: --
413: -- PARAMETERS : p_api_version_number known api version number
414: -- p_init_msg_list FND_API.G_TRUE to reset list
415: -- p_commit FND_API.G_TRUE to perform a commit
416: -- x_return_status return status
417: -- x_msg_count number of messages in the list
418: -- x_msg_data text of messages

Line 415: -- p_commit FND_API.G_TRUE to perform a commit

411: -- like log_level should be positive , and on the not null values of p_batch_rec.
412: --
413: -- PARAMETERS : p_api_version_number known api version number
414: -- p_init_msg_list FND_API.G_TRUE to reset list
415: -- p_commit FND_API.G_TRUE to perform a commit
416: -- x_return_status return status
417: -- x_msg_count number of messages in the list
418: -- x_msg_data text of messages
419: -- p_batch_id Picking Batch Id which is used to get Batch

Line 503: IF NOT FND_API.compatible_api_call( l_api_version,

499: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
500: WSH_DEBUG_SV.logmsg(l_module_name,'************************************************************************');
501: --}
502: END IF;
503: IF NOT FND_API.compatible_api_call( l_api_version,
504: p_api_version,
505: l_api_name,
506: G_PKG_NAME) THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

503: IF NOT FND_API.compatible_api_call( l_api_version,
504: p_api_version,
505: l_api_name,
506: G_PKG_NAME) THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510: -- Check p_init_msg_list
511: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 511: IF FND_API.to_boolean(p_init_msg_list) THEN

507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510: -- Check p_init_msg_list
511: IF FND_API.to_boolean(p_init_msg_list) THEN
512: --{
513: FND_MSG_PUB.initialize;
514: --}
515: END IF;

Line 575: IF FND_API.TO_BOOLEAN(p_commit) THEN

571: --}
572: END IF;
573:
574:
575: IF FND_API.TO_BOOLEAN(p_commit) THEN
576: --{
577: COMMIT WORK;
578: --}
579: END IF;

Line 585: p_encoded => FND_API.G_FALSE

581: FND_MSG_PUB.Count_And_Get
582: (
583: p_count => x_msg_count,
584: p_data => x_msg_data,
585: p_encoded => FND_API.G_FALSE
586: );
587:
588: IF l_debug_on THEN
589: --{

Line 595: WHEN FND_API.G_EXC_ERROR THEN

591: --}
592: END IF;
593: --
594: EXCEPTION
595: WHEN FND_API.G_EXC_ERROR THEN
596: x_return_status := FND_API.G_RET_STS_ERROR ;
597: wsh_util_core.add_message(x_return_status);
598: FND_MSG_PUB.Count_And_Get
599: (

Line 596: x_return_status := FND_API.G_RET_STS_ERROR ;

592: END IF;
593: --
594: EXCEPTION
595: WHEN FND_API.G_EXC_ERROR THEN
596: x_return_status := FND_API.G_RET_STS_ERROR ;
597: wsh_util_core.add_message(x_return_status);
598: FND_MSG_PUB.Count_And_Get
599: (
600: p_count => x_msg_count,

Line 602: p_encoded => FND_API.G_FALSE

598: FND_MSG_PUB.Count_And_Get
599: (
600: p_count => x_msg_count,
601: p_data => x_msg_data,
602: p_encoded => FND_API.G_FALSE
603: );
604:
605: IF l_debug_on THEN
606: --{

Line 607: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

603: );
604:
605: IF l_debug_on THEN
606: --{
607: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
609: --}
610: END IF;
611: --

Line 608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

604:
605: IF l_debug_on THEN
606: --{
607: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
609: --}
610: END IF;
611: --
612:

Line 613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

609: --}
610: END IF;
611: --
612:
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: wsh_util_core.add_message(x_return_status, l_module_name);
616: FND_MSG_PUB.Count_And_Get
617: (

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

610: END IF;
611: --
612:
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: wsh_util_core.add_message(x_return_status, l_module_name);
616: FND_MSG_PUB.Count_And_Get
617: (
618: p_count => x_msg_count,

Line 620: p_encoded => FND_API.G_FALSE

616: FND_MSG_PUB.Count_And_Get
617: (
618: p_count => x_msg_count,
619: p_data => x_msg_data,
620: p_encoded => FND_API.G_FALSE
621: );
622: --
623:
624: IF l_debug_on THEN

Line 626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

622: --
623:
624: IF l_debug_on THEN
625: --{
626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
628: --}
629: END IF;
630: WHEN OTHERS THEN

Line 627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

623:
624: IF l_debug_on THEN
625: --{
626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
628: --}
629: END IF;
630: WHEN OTHERS THEN
631: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');

Line 637: p_encoded => FND_API.G_FALSE

633: FND_MSG_PUB.Count_And_Get
634: (
635: p_count => x_msg_count,
636: p_data => x_msg_data,
637: p_encoded => FND_API.G_FALSE
638: );
639:
640: IF l_debug_on THEN
641: --{

Line 665: -- p_init_msg_list FND_API.G_TRUE to reset list

661: -- the batch record from wsh_picking_batches.
662: -- Note: Non-database attributes will be NULL.
663: --
664: -- PARAMETERS : p_api_version_number known api version number
665: -- p_init_msg_list FND_API.G_TRUE to reset list
666: -- p_commit FND_API.G_TRUE to perform a commit
667: -- x_return_status return status
668: -- x_msg_count number of messages in the list
669: -- x_msg_data text of messages

Line 666: -- p_commit FND_API.G_TRUE to perform a commit

662: -- Note: Non-database attributes will be NULL.
663: --
664: -- PARAMETERS : p_api_version_number known api version number
665: -- p_init_msg_list FND_API.G_TRUE to reset list
666: -- p_commit FND_API.G_TRUE to perform a commit
667: -- x_return_status return status
668: -- x_msg_count number of messages in the list
669: -- x_msg_data text of messages
670: -- p_batch_id Picking Batch Id which is used to get Batch

Line 824: IF NOT FND_API.compatible_api_call( l_api_version,

820: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_NAME',P_BATCH_NAME);
821: WSH_DEBUG_SV.logmsg(l_module_name,'************************************************************************');
822: --}
823: END IF;
824: IF NOT FND_API.compatible_api_call( l_api_version,
825: p_api_version,
826: l_api_name,
827: G_PKG_NAME) THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824: IF NOT FND_API.compatible_api_call( l_api_version,
825: p_api_version,
826: l_api_name,
827: G_PKG_NAME) THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830:
831: -- Check p_init_msg_list
832: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 832: IF FND_API.to_boolean(p_init_msg_list) THEN

828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830:
831: -- Check p_init_msg_list
832: IF FND_API.to_boolean(p_init_msg_list) THEN
833: --{
834: FND_MSG_PUB.initialize;
835: --}
836: END IF;

Line 845: IF ( ( l_batch_Id IS NOT NULL AND l_batch_Id <> FND_API.G_MISS_NUM ) OR ( l_batch_Name IS NOT NULL AND l_batch_name <> FND_API.G_MISS_CHAR ) ) THEN

841: l_batch_id := p_batch_id;
842: l_batch_name := p_batch_name;
843:
844: -- Validating Batch Name and Batch Id
845: IF ( ( l_batch_Id IS NOT NULL AND l_batch_Id <> FND_API.G_MISS_NUM ) OR ( l_batch_Name IS NOT NULL AND l_batch_name <> FND_API.G_MISS_CHAR ) ) THEN
846: --{
847: IF ( l_batch_Id = FND_API.G_MISS_NUM ) THEN
848: --{
849: l_batch_Id := NULL;

Line 847: IF ( l_batch_Id = FND_API.G_MISS_NUM ) THEN

843:
844: -- Validating Batch Name and Batch Id
845: IF ( ( l_batch_Id IS NOT NULL AND l_batch_Id <> FND_API.G_MISS_NUM ) OR ( l_batch_Name IS NOT NULL AND l_batch_name <> FND_API.G_MISS_CHAR ) ) THEN
846: --{
847: IF ( l_batch_Id = FND_API.G_MISS_NUM ) THEN
848: --{
849: l_batch_Id := NULL;
850: --}
851: END IF;

Line 852: IF ( l_batch_name = FND_API.G_MISS_CHAR ) THEN

848: --{
849: l_batch_Id := NULL;
850: --}
851: END IF;
852: IF ( l_batch_name = FND_API.G_MISS_CHAR ) THEN
853: --{
854: l_batch_name := NULL;
855: --}
856: END IF;

Line 992: IF FND_API.TO_BOOLEAN(p_commit) THEN

988: END IF;
989:
990:
991:
992: IF FND_API.TO_BOOLEAN(p_commit) THEN
993: COMMIT WORK;
994: END IF;
995:
996: FND_MSG_PUB.Count_And_Get

Line 1000: p_encoded => FND_API.G_FALSE

996: FND_MSG_PUB.Count_And_Get
997: (
998: p_count => x_msg_count,
999: p_data => x_msg_data,
1000: p_encoded => FND_API.G_FALSE
1001: );
1002:
1003: IF l_debug_on THEN
1004: WSH_DEBUG_SV.pop(l_module_name);

Line 1008: WHEN FND_API.G_EXC_ERROR THEN

1004: WSH_DEBUG_SV.pop(l_module_name);
1005: END IF;
1006: --
1007: EXCEPTION
1008: WHEN FND_API.G_EXC_ERROR THEN
1009: IF c_batch_info%ISOPEN THEN
1010: CLOSE c_batch_info;
1011: END IF;
1012: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1012: x_return_status := FND_API.G_RET_STS_ERROR ;

1008: WHEN FND_API.G_EXC_ERROR THEN
1009: IF c_batch_info%ISOPEN THEN
1010: CLOSE c_batch_info;
1011: END IF;
1012: x_return_status := FND_API.G_RET_STS_ERROR ;
1013: wsh_util_core.add_message(x_return_status);
1014: FND_MSG_PUB.Count_And_Get
1015: (
1016: p_count => x_msg_count,

Line 1018: p_encoded => FND_API.G_FALSE

1014: FND_MSG_PUB.Count_And_Get
1015: (
1016: p_count => x_msg_count,
1017: p_data => x_msg_data,
1018: p_encoded => FND_API.G_FALSE
1019: );
1020:
1021: IF l_debug_on THEN
1022: --{

Line 1023: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1019: );
1020:
1021: IF l_debug_on THEN
1022: --{
1023: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1025: --}
1026: END IF;
1027: --

Line 1024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1020:
1021: IF l_debug_on THEN
1022: --{
1023: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1025: --}
1026: END IF;
1027: --
1028:

Line 1029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1025: --}
1026: END IF;
1027: --
1028:
1029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1030: IF c_batch_info%ISOPEN THEN
1031: CLOSE c_batch_info;
1032: END IF;
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1030: IF c_batch_info%ISOPEN THEN
1031: CLOSE c_batch_info;
1032: END IF;
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1034: wsh_util_core.add_message(x_return_status, l_module_name);
1035: FND_MSG_PUB.Count_And_Get
1036: (
1037: p_count => x_msg_count,

Line 1039: p_encoded => FND_API.G_FALSE

1035: FND_MSG_PUB.Count_And_Get
1036: (
1037: p_count => x_msg_count,
1038: p_data => x_msg_data,
1039: p_encoded => FND_API.G_FALSE
1040: );
1041: --
1042:
1043: IF l_debug_on THEN

Line 1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1041: --
1042:
1043: IF l_debug_on THEN
1044: --{
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1047: --}
1048: END IF;
1049:

Line 1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1042:
1043: IF l_debug_on THEN
1044: --{
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1047: --}
1048: END IF;
1049:
1050: WHEN OTHERS THEN

Line 1060: p_encoded => FND_API.G_FALSE

1056: FND_MSG_PUB.Count_And_Get
1057: (
1058: p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => FND_API.G_FALSE
1061: );
1062:
1063: IF l_debug_on THEN
1064: --{