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.AMS_PARTYIMPORT_PVT dependencies on AMS_UTILITY_PVT

Line 122: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

118: IF (AMS_DEBUG_HIGH_ON) THEN
119:
120:
121:
122: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
123:
124: END IF;
125:
126: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 144: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

140:
141: ----------------------- validate -----------------------
142: IF (AMS_DEBUG_HIGH_ON) THEN
143:
144: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
145: END IF;
146:
147: Validate_Party (
148: p_api_version => l_api_version,

Line 192: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');

188:
189: -------------------------- insert --------------------------
190: IF (AMS_DEBUG_HIGH_ON) THEN
191:
192: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
193: END IF;
194:
195: INSERT INTO ams_party_sources (
196: party_sources_id,

Line 747: AMS_Utility_PVT.debug_message (l_full_name || ': End');

743: IF (AMS_DEBUG_HIGH_ON) THEN
744:
745:
746:
747: AMS_Utility_PVT.debug_message (l_full_name || ': End');
748:
749: END IF;
750:
751: EXCEPTION

Line 813: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

809: IF (AMS_DEBUG_HIGH_ON) THEN
810:
811:
812:
813: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
814:
815: END IF;
816:
817: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 861: AMS_Utility_PVT.debug_message(l_full_name || ': End');

857: IF (AMS_DEBUG_HIGH_ON) THEN
858:
859:
860:
861: AMS_Utility_PVT.debug_message(l_full_name || ': End');
862:
863: END IF;
864:
865: EXCEPTION

Line 939: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

935: BEGIN
936: --------------------- initialize -----------------------
937: IF (AMS_DEBUG_HIGH_ON) THEN
938:
939: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
940: END IF;
941:
942: IF FND_API.to_boolean (p_init_msg_list) THEN
943: FND_MSG_PUB.initialize;

Line 981: AMS_Utility_PVT.debug_message (l_full_name || ': End');

977: IF (AMS_DEBUG_HIGH_ON) THEN
978:
979:
980:
981: AMS_Utility_PVT.debug_message (l_full_name || ': End');
982:
983: END IF;
984:
985: EXCEPTION

Line 986: WHEN AMS_Utility_PVT.resource_locked THEN

982:
983: END IF;
984:
985: EXCEPTION
986: WHEN AMS_Utility_PVT.resource_locked THEN
987: x_return_status := FND_API.g_ret_sts_error;
988: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
989: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
990: FND_MSG_PUB.add;

Line 1057: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1053: IF (AMS_DEBUG_HIGH_ON) THEN
1054:
1055:
1056:
1057: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1058:
1059: END IF;
1060:
1061: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 1079: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

1075:
1076: ----------------------- validate ----------------------
1077: IF (AMS_DEBUG_HIGH_ON) THEN
1078:
1079: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
1080: END IF;
1081:
1082: -- replace g_miss_char/num/date with current column values
1083: Complete_Party_Rec (p_party_rec, l_party_rec);

Line 1404: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1400: IF (AMS_DEBUG_HIGH_ON) THEN
1401:
1402:
1403:
1404: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1405:
1406: END IF;
1407:
1408: EXCEPTION

Line 1467: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1463: BEGIN
1464: --------------------- initialize -----------------------
1465: IF (AMS_DEBUG_HIGH_ON) THEN
1466:
1467: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1468: END IF;
1469:
1470: IF FND_API.to_boolean (p_init_msg_list) THEN
1471: FND_MSG_PUB.initialize;

Line 1488: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');

1484:
1485: ---------------------- validate ------------------------
1486: IF (AMS_DEBUG_HIGH_ON) THEN
1487:
1488: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
1489: END IF;
1490:
1491: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1492: Check_Party_Items (

Line 1509: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');

1505: IF (AMS_DEBUG_HIGH_ON) THEN
1506:
1507:
1508:
1509: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
1510:
1511: END IF;
1512:
1513: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 1538: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1534: IF (AMS_DEBUG_HIGH_ON) THEN
1535:
1536:
1537:
1538: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1539:
1540: END IF;
1541:
1542: EXCEPTION

Line 1591: AMS_Utility_PVT.debug_message ('Check required items');

1587: IS
1588: BEGIN
1589: IF (AMS_DEBUG_HIGH_ON) THEN
1590:
1591: AMS_Utility_PVT.debug_message ('Check required items');
1592: END IF;
1593: --
1594: -- Validate required items.
1595: Check_Party_Req_Items (

Line 1608: AMS_Utility_PVT.debug_message ('Check unique items');

1604: IF (AMS_DEBUG_HIGH_ON) THEN
1605:
1606:
1607:
1608: AMS_Utility_PVT.debug_message ('Check unique items');
1609:
1610: END IF;
1611: --
1612: -- Validate uniqueness.

Line 1627: AMS_Utility_PVT.debug_message ('Check FK items');

1623: IF (AMS_DEBUG_HIGH_ON) THEN
1624:
1625:
1626:
1627: AMS_Utility_PVT.debug_message ('Check FK items');
1628:
1629: END IF;
1630: Check_Party_FK_Items(
1631: p_party_rec => p_party_rec,

Line 1643: AMS_Utility_PVT.debug_message ('Check lookup items');

1639: IF (AMS_DEBUG_HIGH_ON) THEN
1640:
1641:
1642:
1643: AMS_Utility_PVT.debug_message ('Check lookup items');
1644:
1645: END IF;
1646: Check_Party_Lookup_Items (
1647: p_party_rec => p_party_rec,

Line 1659: AMS_Utility_PVT.debug_message ('Check flag items');

1655: IF (AMS_DEBUG_HIGH_ON) THEN
1656:
1657:
1658:
1659: AMS_Utility_PVT.debug_message ('Check flag items');
1660:
1661: END IF;
1662: Check_Party_Flag_Items(
1663: p_party_rec => p_party_rec,

Line 3434: IF AMS_Utility_PVT.check_uniqueness (

3430: -- check if this ID is unique.
3431: IF p_validation_mode = JTF_PLSQL_API.g_create
3432: AND p_party_rec.party_sources_id IS NOT NULL
3433: THEN
3434: IF AMS_Utility_PVT.check_uniqueness (
3435: 'ams_party_sources',
3436: 'party_sources_id = ' || p_party_rec.party_sources_id
3437: ) = FND_API.g_false
3438: THEN

Line 3474: IF AMS_Utility_PVT.check_fk_exists (

3470:
3471: --
3472: -- PARTY_ID
3473: IF p_party_rec.party_id <> FND_API.g_miss_num THEN
3474: IF AMS_Utility_PVT.check_fk_exists (
3475: p_table_name => 'HZ_PARTIES',
3476: p_pk_name => 'PARTY_ID',
3477: p_pk_value => p_party_rec.party_id,
3478: p_pk_data_type => AMS_Utility_PVT.g_number

Line 3478: p_pk_data_type => AMS_Utility_PVT.g_number

3474: IF AMS_Utility_PVT.check_fk_exists (
3475: p_table_name => 'HZ_PARTIES',
3476: p_pk_name => 'PARTY_ID',
3477: p_pk_value => p_party_rec.party_id,
3478: p_pk_data_type => AMS_Utility_PVT.g_number
3479: ) = FND_API.g_false THEN
3480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3481: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_PARTY_ID');
3482: FND_MSG_PUB.add;

Line 3493: IF AMS_Utility_PVT.check_fk_exists (

3489:
3490: --
3491: -- IMPORT_SOURCE_LINE_ID
3492: IF p_party_rec.import_source_line_id <> FND_API.g_miss_num THEN
3493: IF AMS_Utility_PVT.check_fk_exists (
3494: p_table_name => 'AMS_IMP_SOURCE_LINES',
3495: p_pk_name => 'IMPORT_SOURCE_LINE_ID',
3496: p_pk_value => p_party_rec.import_source_line_id,
3497: p_pk_data_type => AMS_Utility_PVT.g_number

Line 3497: p_pk_data_type => AMS_Utility_PVT.g_number

3493: IF AMS_Utility_PVT.check_fk_exists (
3494: p_table_name => 'AMS_IMP_SOURCE_LINES',
3495: p_pk_name => 'IMPORT_SOURCE_LINE_ID',
3496: p_pk_value => p_party_rec.import_source_line_id,
3497: p_pk_data_type => AMS_Utility_PVT.g_number
3498: ) = FND_API.g_false THEN
3499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3500: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_IMP_SRC_LINE_ID');
3501: FND_MSG_PUB.add;

Line 3512: IF AMS_Utility_PVT.check_fk_exists (

3508:
3509: --
3510: -- IMPORT_LIST_HEADER_ID
3511: IF p_party_rec.import_list_header_id <> FND_API.g_miss_num THEN
3512: IF AMS_Utility_PVT.check_fk_exists (
3513: p_table_name => 'AMS_IMP_LIST_HEADERS_ALL',
3514: p_pk_name => 'IMPORT_LIST_HEADER_ID',
3515: p_pk_value => p_party_rec.import_list_header_id,
3516: p_pk_data_type => AMS_Utility_PVT.g_number

Line 3516: p_pk_data_type => AMS_Utility_PVT.g_number

3512: IF AMS_Utility_PVT.check_fk_exists (
3513: p_table_name => 'AMS_IMP_LIST_HEADERS_ALL',
3514: p_pk_name => 'IMPORT_LIST_HEADER_ID',
3515: p_pk_value => p_party_rec.import_list_header_id,
3516: p_pk_data_type => AMS_Utility_PVT.g_number
3517: ) = FND_API.g_false THEN
3518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3519: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_IMP_LIST_HDR_ID');
3520: FND_MSG_PUB.add;

Line 3531: IF AMS_Utility_PVT.check_fk_exists (

3527:
3528: --
3529: -- LIST_SOURCE_TYPE_ID
3530: IF p_party_rec.list_source_type_id <> FND_API.g_miss_num THEN
3531: IF AMS_Utility_PVT.check_fk_exists (
3532: p_table_name => 'AMS_LIST_SRC_TYPES',
3533: p_pk_name => 'LIST_SOURCE_TYPE_ID',
3534: p_pk_value => p_party_rec.list_source_type_id,
3535: p_pk_data_type => AMS_Utility_PVT.g_number

Line 3535: p_pk_data_type => AMS_Utility_PVT.g_number

3531: IF AMS_Utility_PVT.check_fk_exists (
3532: p_table_name => 'AMS_LIST_SRC_TYPES',
3533: p_pk_name => 'LIST_SOURCE_TYPE_ID',
3534: p_pk_value => p_party_rec.list_source_type_id,
3535: p_pk_data_type => AMS_Utility_PVT.g_number
3536: ) = FND_API.g_false THEN
3537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3538: FND_MESSAGE.set_name('AMS', 'AMS_PARTY_BAD_LST_SRC_TYPE_ID');
3539: FND_MSG_PUB.add;

Line 3592: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.used_flag) = FND_API.g_false THEN

3588:
3589: --
3590: -- USED_FLAG
3591: IF p_party_rec.used_flag <> FND_API.g_miss_char AND p_party_rec.used_flag IS NOT NULL THEN
3592: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.used_flag) = FND_API.g_false THEN
3593: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3594: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_BAD_USED_FLAG');
3595: FND_MSG_PUB.add;
3596: END IF;

Line 3606: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.overlay_flag) = FND_API.g_false THEN

3602:
3603: --
3604: -- OVERLAY_FLAG
3605: IF p_party_rec.overlay_flag <> FND_API.g_miss_char AND p_party_rec.overlay_flag IS NOT NULL THEN
3606: IF AMS_Utility_PVT.is_Y_or_N (p_party_rec.overlay_flag) = FND_API.g_false THEN
3607: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
3608: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_BAD_OVERLAY_FLAG');
3609: FND_MSG_PUB.add;
3610: END IF;

Line 3863: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

3859: BEGIN
3860: --------------------- initialize -----------------------
3861: IF (AMS_DEBUG_HIGH_ON) THEN
3862:
3863: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
3864: END IF;
3865:
3866: IF FND_API.to_boolean (p_init_msg_list) THEN
3867: FND_MSG_PUB.initialize;

Line 4285: AMS_Utility_PVT.debug_message (l_full_name || ': End');

4281: IF (AMS_DEBUG_HIGH_ON) THEN
4282:
4283:
4284:
4285: AMS_Utility_PVT.debug_message (l_full_name || ': End');
4286:
4287: END IF;
4288:
4289: EXCEPTION

Line 4417: AMS_Utility_PVT.Create_Log (

4413:
4414: -- Import completed successfully
4415: FND_MESSAGE.set_name ('AMS', 'AMS_PARTY_PROCESS_COMPLETE');
4416:
4417: AMS_Utility_PVT.Create_Log (
4418: x_return_status => l_return_status,
4419: p_arc_log_used_by => 'IMPH',
4420: p_log_used_by_id => p_import_list_header_id,
4421: p_msg_data => FND_MESSAGE.get,