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.VEA_TPA_UTIL_PVT dependencies on FND_API

Line 413: RAISE FND_API.G_EXC_ERROR;

409: --
410: --
411: l_location := '0030';
412: --
413: RAISE FND_API.G_EXC_ERROR;
414: --}
415: END IF;
416: --}
417: EXCEPTION

Line 556: x_api_return_status := FND_API.G_RET_STS_ERROR;

552: THEN
553: --{
554: l_location := '0030';
555: --
556: x_api_return_status := FND_API.G_RET_STS_ERROR;
557: --}
558: ELSIF p_error_type = G_UNEXPECTED_ERROR
559: THEN
560: --{

Line 563: x_api_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: THEN
560: --{
561: l_location := '0040';
562: --
563: x_api_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: --}
565: ELSE
566: --{
567: l_location := '0050';

Line 569: x_api_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: ELSE
566: --{
567: l_location := '0050';
568: --
569: x_api_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: --
571: --
572: l_location := '0060';
573: --

Line 604: p_encoded => FND_API.G_FALSE

600: FND_MSG_PUB.Count_and_Get
601: (
602: p_count => x_msg_count,
603: p_data => x_msg_data,
604: p_encoded => FND_API.G_FALSE
605: );
606: --
607: --
608: --}

Line 675: FND_MSG_PUB.GET( p_encoded => FND_API.G_FALSE )

671: --
672: FND_FILE.PUT_LINE
673: (
674: FND_FILE.LOG,
675: FND_MSG_PUB.GET( p_encoded => FND_API.G_FALSE )
676: );
677: --}
678: END LOOP;
679: --}

Line 685: IF nvl(p_api_return_status, FND_API.G_RET_STS_SUCCESS ) = FND_API.G_RET_STS_SUCCESS

681: --
682: --
683: l_location := '0050';
684: --
685: IF nvl(p_api_return_status, FND_API.G_RET_STS_SUCCESS ) = FND_API.G_RET_STS_SUCCESS
686: THEN
687: --{
688: l_location := '0060';
689: --

Line 702: RAISE FND_API.G_EXC_ERROR;

698: --
699: l_location := '0080';
700: --
701: --APP_EXCEPTION.RAISE_EXCEPTION;
702: RAISE FND_API.G_EXC_ERROR;
703: --}
704: END IF;
705: --}
706: EXCEPTION

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

728: p_api_name IN VARCHAR2,
729: p_api_type IN VARCHAR2,
730: p_api_current_version IN NUMBER,
731: p_api_caller_version IN NUMBER,
732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
733: x_savepoint_name OUT NOCOPY VARCHAR2,
734: x_api_return_status OUT NOCOPY VARCHAR2
735: )
736: IS

Line 775: IF NOT FND_API.Compatible_API_Call

771: -- Standard call to check for call compatibility
772: --
773: l_location := '0040';
774: --
775: IF NOT FND_API.Compatible_API_Call
776: (
777: p_api_current_version,
778: p_api_caller_version,
779: p_api_name,

Line 786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

782: THEN
783: --{
784: l_location := '0050';
785: --
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: --}
788: END IF;
789: --
790: --

Line 795: IF FND_API.to_Boolean( p_init_msg_list )

791: -- Initialize message list if p_init_msg_list is set to TRUE
792: --
793: l_location := '0060';
794: --
795: IF FND_API.to_Boolean( p_init_msg_list )
796: THEN
797: --{
798: l_location := '0070';
799: --

Line 809: x_api_return_status := FND_API.G_RET_STS_SUCCESS;

805: -- Initialize API return status to Success
806: --
807: l_location := '0080';
808: --
809: x_api_return_status := FND_API.G_RET_STS_SUCCESS;
810: --}
811: EXCEPTION
812: --{
813: WHEN OTHERS

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

833: ========================================================================*/
834: PROCEDURE
835: api_footer
836: (
837: p_commit IN VARCHAR2 := FND_API.G_FALSE,
838: x_msg_count OUT NOCOPY NUMBER,
839: x_msg_data OUT NOCOPY VARCHAR2
840: )
841: IS

Line 854: IF FND_API.to_Boolean( p_commit )

850: -- Standard check of p_commit
851: --
852: l_location := '0010';
853: --
854: IF FND_API.to_Boolean( p_commit )
855: THEN
856: --{
857: l_location := '0020';
858: --

Line 873: p_encoded => FND_API.G_FALSE

869: FND_MSG_PUB.Count_and_Get
870: (
871: p_count => x_msg_count,
872: p_data => x_msg_data,
873: p_encoded => FND_API.G_FALSE
874: );
875: --}
876: EXCEPTION
877: --{

Line 896: PURPOSE: Obtains profile value - Cover API for FND API

892: /*========================================================================
893:
894: PROCEDURE NAME: get_profile_value
895:
896: PURPOSE: Obtains profile value - Cover API for FND API
897:
898: ========================================================================*/
899: FUNCTION
900: get_profile_value

Line 1013: PURPOSE: Returns current user ID - Cover API for FND API

1009: /*========================================================================
1010:
1011: PROCEDURE NAME: get_user_id
1012:
1013: PURPOSE: Returns current user ID - Cover API for FND API
1014:
1015: ========================================================================*/
1016: FUNCTION
1017: get_user_id

Line 1050: PURPOSE: Returns current login ID - Cover API for FND API

1046: /*========================================================================
1047:
1048: PROCEDURE NAME: get_login_id
1049:
1050: PURPOSE: Returns current login ID - Cover API for FND API
1051:
1052: ========================================================================*/
1053: FUNCTION
1054: get_login_id

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

1091: PROCEDURE
1092: get_constants
1093: (
1094: p_api_version IN NUMBER,
1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: x_return_status OUT NOCOPY VARCHAR2,
1099: x_msg_count OUT NOCOPY NUMBER,

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

1092: get_constants
1093: (
1094: p_api_version IN NUMBER,
1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: x_return_status OUT NOCOPY VARCHAR2,
1099: x_msg_count OUT NOCOPY NUMBER,
1100: x_msg_data OUT NOCOPY VARCHAR2,

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

1093: (
1094: p_api_version IN NUMBER,
1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: x_return_status OUT NOCOPY VARCHAR2,
1099: x_msg_count OUT NOCOPY NUMBER,
1100: x_msg_data OUT NOCOPY VARCHAR2,
1101: x_true OUT NOCOPY VARCHAR2,

Line 1145: x_true := FND_API.G_TRUE;

1141: --
1142: --
1143: l_location := '0010';
1144: --
1145: x_true := FND_API.G_TRUE;
1146: x_false := FND_API.G_FALSE;
1147: --
1148: l_location := '0020';
1149: --

Line 1146: x_false := FND_API.G_FALSE;

1142: --
1143: l_location := '0010';
1144: --
1145: x_true := FND_API.G_TRUE;
1146: x_false := FND_API.G_FALSE;
1147: --
1148: l_location := '0020';
1149: --
1150: x_valid_level_full := FND_API.G_VALID_LEVEL_FULL;

Line 1150: x_valid_level_full := FND_API.G_VALID_LEVEL_FULL;

1146: x_false := FND_API.G_FALSE;
1147: --
1148: l_location := '0020';
1149: --
1150: x_valid_level_full := FND_API.G_VALID_LEVEL_FULL;
1151: x_valid_level_none := FND_API.G_VALID_LEVEL_NONE;
1152: --
1153: l_location := '0030';
1154: --

Line 1151: x_valid_level_none := FND_API.G_VALID_LEVEL_NONE;

1147: --
1148: l_location := '0020';
1149: --
1150: x_valid_level_full := FND_API.G_VALID_LEVEL_FULL;
1151: x_valid_level_none := FND_API.G_VALID_LEVEL_NONE;
1152: --
1153: l_location := '0030';
1154: --
1155: x_success := FND_API.G_RET_STS_SUCCESS;

Line 1155: x_success := FND_API.G_RET_STS_SUCCESS;

1151: x_valid_level_none := FND_API.G_VALID_LEVEL_NONE;
1152: --
1153: l_location := '0030';
1154: --
1155: x_success := FND_API.G_RET_STS_SUCCESS;
1156: x_error := FND_API.G_RET_STS_ERROR;
1157: x_unexpected_error := FND_API.G_RET_STS_UNEXP_ERROR;
1158: --
1159: --

Line 1156: x_error := FND_API.G_RET_STS_ERROR;

1152: --
1153: l_location := '0030';
1154: --
1155: x_success := FND_API.G_RET_STS_SUCCESS;
1156: x_error := FND_API.G_RET_STS_ERROR;
1157: x_unexpected_error := FND_API.G_RET_STS_UNEXP_ERROR;
1158: --
1159: --
1160: l_location := '0040';

Line 1157: x_unexpected_error := FND_API.G_RET_STS_UNEXP_ERROR;

1153: l_location := '0030';
1154: --
1155: x_success := FND_API.G_RET_STS_SUCCESS;
1156: x_error := FND_API.G_RET_STS_ERROR;
1157: x_unexpected_error := FND_API.G_RET_STS_UNEXP_ERROR;
1158: --
1159: --
1160: l_location := '0040';
1161: --

Line 1181: WHEN FND_API.G_EXC_ERROR

1177: );
1178: --}
1179: EXCEPTION
1180: --{
1181: WHEN FND_API.G_EXC_ERROR
1182: THEN
1183: --{
1184: --RAISE;
1185: vea_tpa_util_pvt.handle_error

Line 1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1193: x_msg_data => x_msg_data,
1194: x_api_return_status => x_return_status
1195: );
1196: --}
1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1198: THEN
1199: --{
1200: --RAISE;
1201: vea_tpa_util_pvt.handle_error

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

1240: PROCEDURE
1241: isVEAInstalled
1242: (
1243: p_api_version IN NUMBER,
1244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1247: x_return_status OUT NOCOPY VARCHAR2,
1248: x_msg_count OUT NOCOPY NUMBER,

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

1241: isVEAInstalled
1242: (
1243: p_api_version IN NUMBER,
1244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1247: x_return_status OUT NOCOPY VARCHAR2,
1248: x_msg_count OUT NOCOPY NUMBER,
1249: x_msg_data OUT NOCOPY VARCHAR2,

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

1242: (
1243: p_api_version IN NUMBER,
1244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1247: x_return_status OUT NOCOPY VARCHAR2,
1248: x_msg_count OUT NOCOPY NUMBER,
1249: x_msg_data OUT NOCOPY VARCHAR2,
1250: x_vea_install_status OUT NOCOPY VARCHAR2

Line 1308: WHEN FND_API.G_EXC_ERROR

1304: );
1305: --}
1306: EXCEPTION
1307: --{
1308: WHEN FND_API.G_EXC_ERROR
1309: THEN
1310: --{
1311: --RAISE;
1312: vea_tpa_util_pvt.handle_error

Line 1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1320: x_msg_data => x_msg_data,
1321: x_api_return_status => x_return_status
1322: );
1323: --}
1324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1325: THEN
1326: --{
1327: --RAISE;
1328: vea_tpa_util_pvt.handle_error

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

1420: PROCEDURE
1421: preProcess
1422: (
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,

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

1421: preProcess
1422: (
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,
1429: x_msg_data OUT NOCOPY VARCHAR2,

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

1422: (
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,
1429: x_msg_data OUT NOCOPY VARCHAR2,
1430: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

Line 1541: WHEN FND_API.G_EXC_ERROR

1537: );
1538: --}
1539: EXCEPTION
1540: --{
1541: WHEN FND_API.G_EXC_ERROR
1542: THEN
1543: --{
1544: --RAISE;
1545: vea_tpa_util_pvt.handle_error

Line 1557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1553: x_msg_data => x_msg_data,
1554: x_api_return_status => x_return_status
1555: );
1556: --}
1557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1558: THEN
1559: --{
1560: --RAISE;
1561: vea_tpa_util_pvt.handle_error

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

1607: PROCEDURE
1608: postProcess
1609: (
1610: p_api_version IN NUMBER,
1611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_msg_count OUT NOCOPY NUMBER,

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

1608: postProcess
1609: (
1610: p_api_version IN NUMBER,
1611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_msg_count OUT NOCOPY NUMBER,
1616: x_msg_data OUT NOCOPY VARCHAR2,

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

1609: (
1610: p_api_version IN NUMBER,
1611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_msg_count OUT NOCOPY NUMBER,
1616: x_msg_data OUT NOCOPY VARCHAR2,
1617: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,

Line 1838: WHEN FND_API.G_EXC_ERROR

1834: );
1835: --}
1836: EXCEPTION
1837: --{
1838: WHEN FND_API.G_EXC_ERROR
1839: THEN
1840: --{
1841: --RAISE;
1842: vea_tpa_util_pvt.handle_error

Line 1854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1850: x_msg_data => x_msg_data,
1851: x_api_return_status => x_return_status
1852: );
1853: --}
1854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1855: THEN
1856: --{
1857: --RAISE;
1858: vea_tpa_util_pvt.handle_error

Line 2926: IF l_return_status = FND_API.G_RET_STS_SUCCESS

2922: p_Ext_val1 => p_external_value
2923: );
2924: --
2925: --
2926: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2927: THEN
2928: --{
2929: l_code_conversion_rec.parameter_name := l_parameter_name;
2930: l_code_conversion_rec.layer_provider_code := p_layer_provider_code;

Line 2959: p_encoded => FND_API.G_FALSE

2955: l_message
2956: || ' '
2957: || FND_MSG_PUB.GET
2958: (
2959: p_encoded => FND_API.G_FALSE
2960: ),
2961: 1,
2962: 32767
2963: );

Line 3063: IF l_return_status = FND_API.G_RET_STS_SUCCESS

3059: p_Ext_val1 => p_external_value
3060: );
3061: --
3062: --
3063: IF l_return_status = FND_API.G_RET_STS_SUCCESS
3064: THEN
3065: --{
3066: RETURN(l_internal_value);
3067: --}

Line 3086: p_encoded => FND_API.G_FALSE

3082: l_message
3083: || ' '
3084: || FND_MSG_PUB.GET
3085: (
3086: p_encoded => FND_API.G_FALSE
3087: ),
3088: 1,
3089: 32767
3090: );

Line 3193: IF l_return_status = FND_API.G_RET_STS_SUCCESS

3189: p_Ext_val5 => l_external_value5
3190: );
3191: --
3192: --
3193: IF l_return_status = FND_API.G_RET_STS_SUCCESS
3194: THEN
3195: --{
3196: RETURN(l_external_value);
3197: --}

Line 3216: p_encoded => FND_API.G_FALSE

3212: l_message
3213: || ' '
3214: || FND_MSG_PUB.GET
3215: (
3216: p_encoded => FND_API.G_FALSE
3217: ),
3218: 1,
3219: 32767
3220: );

Line 3525: RAISE FND_API.G_EXC_ERROR;

3521: BEGIN
3522: --{
3523: IF p_key IS NULL
3524: THEN
3525: RAISE FND_API.G_EXC_ERROR;
3526: END IF;
3527: --
3528: --
3529: IF p_key < C_INDEX_LIMIT

Line 3589: RAISE FND_API.G_EXC_ERROR;

3585: BEGIN
3586: --{
3587: IF p_key IS NULL
3588: THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: END IF;
3591: --
3592: --
3593: IF p_key < C_INDEX_LIMIT

Line 3599: RAISE FND_API.G_EXC_ERROR;

3595: IF p_cache_tbl.EXISTS(p_key)
3596: THEN
3597: x_value := p_cache_tbl(p_key).value;
3598: ELSE
3599: RAISE FND_API.G_EXC_ERROR;
3600: END IF;
3601: ELSE
3602: l_index := p_cache_ext_tbl.FIRST;
3603: --

Line 3618: RAISE FND_API.G_EXC_ERROR;

3614: END LOOP;
3615: --
3616: IF NOT(l_found)
3617: THEN
3618: RAISE FND_API.G_EXC_ERROR;
3619: END IF;
3620: END IF;
3621: --}
3622: EXCEPTION