DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LIST_IMPORT_PUB

Line 1592: AMS_List_Import_PUB.Create_Customer (

1588: psite_rec.created_by_module := 'AMS_LIST_IMPORT';
1589: psiteuse_rec.created_by_module := 'AMS_LIST_IMPORT';
1590: cpoint_rec.created_by_module := 'AMS_LIST_IMPORT';
1591:
1592: AMS_List_Import_PUB.Create_Customer (
1593: p_api_version => 1,
1594: p_init_msg_list => 'T',
1595: p_commit => 'F',
1596: x_return_status => x_return_status,

Line 1639: AMS_List_Import_PUB.error_capture (

1635: if x_return_status <> 'S' then
1636: UPDATE ams_imp_source_lines
1637: SET load_status = 'ERROR', ENABLED_FLAG = null
1638: WHERE import_source_line_id = i_import_source_line_id;
1639: AMS_List_Import_PUB.error_capture (
1640: 1, 'T', 'F', null,
1641: x_return_status,
1642: x_msg_count,
1643: x_msg_data,

Line 1660: AMS_List_Import_PUB.error_capture (

1656: if l_vr_code_exists is null then
1657: UPDATE ams_imp_source_lines
1658: SET load_status = 'ERROR',ENABLED_FLAG = null
1659: WHERE import_source_line_id = i_import_source_line_id;
1660: AMS_List_Import_PUB.error_capture (
1661: 1,
1662: 'T',
1663: 'F',
1664: null,

Line 1682: AMS_List_Import_PUB.error_capture (

1678: if l_resource_id is null then
1679: UPDATE ams_imp_source_lines
1680: SET load_status = 'ERROR',ENABLED_FLAG = null
1681: WHERE import_source_line_id = i_import_source_line_id;
1682: AMS_List_Import_PUB.error_capture (
1683: 1,
1684: 'T',
1685: 'F',
1686: null,

Line 1712: AMS_List_Import_PUB.error_capture (

1708: if x_return_status <> 'S' then
1709: UPDATE ams_imp_source_lines
1710: SET load_status = 'ERROR',ENABLED_FLAG = null
1711: WHERE import_source_line_id = i_import_source_line_id;
1712: AMS_List_Import_PUB.error_capture (
1713: 1,
1714: 'T',
1715: 'F',
1716: null,

Line 1962: AMS_List_Import_PUB.Create_Customer (

1958: psite_rec.created_by_module := 'AMS_LIST_IMPORT';
1959: psiteuse_rec.created_by_module := 'AMS_LIST_IMPORT';
1960: cpoint_rec.created_by_module := 'AMS_LIST_IMPORT';
1961:
1962: AMS_List_Import_PUB.Create_Customer (
1963: p_api_version => 1,
1964: p_init_msg_list => 'T',
1965: p_commit => 'F',
1966: x_return_status => x_return_status,

Line 2036: AMS_List_Import_PUB.error_capture (

2032: if x_return_status <> 'S' then
2033: UPDATE ams_imp_source_lines
2034: SET load_status = 'ERROR',ENABLED_FLAG = null
2035: WHERE import_source_line_id = i_import_source_line_id;
2036: AMS_List_Import_PUB.error_capture (
2037: 1, 'T', 'F', null,
2038: x_return_status,
2039: x_msg_count,
2040: x_msg_data,

Line 2057: AMS_List_Import_PUB.error_capture (

2053: if l_vr_code_exists is null then
2054: UPDATE ams_imp_source_lines
2055: SET load_status = 'ERROR',ENABLED_FLAG = null
2056: WHERE import_source_line_id = i_import_source_line_id;
2057: AMS_List_Import_PUB.error_capture (
2058: 1,
2059: 'T',
2060: 'F',
2061: null,

Line 2079: AMS_List_Import_PUB.error_capture (

2075: if l_resource_id is null then
2076: UPDATE ams_imp_source_lines
2077: SET load_status = 'ERROR',ENABLED_FLAG = null
2078: WHERE import_source_line_id = i_import_source_line_id;
2079: AMS_List_Import_PUB.error_capture (
2080: 1,
2081: 'T',
2082: 'F',
2083: null,

Line 2110: AMS_List_Import_PUB.error_capture (

2106: if x_return_status <> 'S' then
2107: UPDATE ams_imp_source_lines
2108: SET load_status = 'ERROR',ENABLED_FLAG = null
2109: WHERE import_source_line_id = i_import_source_line_id;
2110: AMS_List_Import_PUB.error_capture (
2111: 1,
2112: 'T',
2113: 'F',
2114: null,

Line 2184: AMS_List_Import_PUB.error_capture (

2180: retcode:= 2;
2181: UPDATE ams_imp_source_lines
2182: SET load_status = 'ERROR'
2183: WHERE import_source_line_id = i_import_source_line_id;
2184: AMS_List_Import_PUB.error_capture (
2185: 1,
2186: 'T',
2187: 'F',
2188: null,

Line 13868: AMS_List_Import_PUB.error_capture (

13864: p_log_used_by_id => p_import_list_header_id,
13865: p_msg_data => 'Error while executing Process_customers_xml process.',
13866: p_msg_type => 'DEBUG'
13867: );
13868: AMS_List_Import_PUB.error_capture (
13869: 1,
13870: 'T',
13871: 'F',
13872: null,

Line 18488: AMS_List_Import_PUB.error_capture (

18484: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
18485: END LOOP;
18486: END IF;
18487: if x_return_status <> 'S' then
18488: AMS_List_Import_PUB.error_capture (
18489: 1, 'T', 'F', null,
18490: x_return_status,
18491: x_msg_count,
18492: x_msg_data,

Line 18514: AMS_List_Import_PUB.error_capture (

18510: update ams_imp_source_lines set load_status = 'ERROR'
18511: where import_list_header_id = p_import_list_header_id
18512: and load_status in ('ACTIVE','RELOAD');
18513:
18514: AMS_List_Import_PUB.error_capture (
18515: 1, 'T', 'F', null,
18516: x_return_status,
18517: x_msg_count,
18518: x_msg_data,

Line 21008: AMS_List_Import_PUB.process_element_duplicate (

21004: LOOP
21005: fetch c_dup_xml_recs into i_xml_element_id;
21006:
21007: exit when c_dup_xml_recs%notfound;
21008: AMS_List_Import_PUB.process_element_duplicate (
21009: p_import_list_header_id,
21010: i_xml_element_id);
21011: END LOOP;
21012: close c_dup_xml_recs;

Line 21570: WF_CORE.CONTEXT('AMS_LIST_IMPORT_PUB', 'TEST_Pre_sub', p_event.getEventName(), p_subscription_guid);

21566: FND_MESSAGE.SET_NAME( 'AMS', 'API_DEBUG_MESSAGE' );
21567: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
21568: FND_MSG_PUB.ADD;
21569: */
21570: WF_CORE.CONTEXT('AMS_LIST_IMPORT_PUB', 'TEST_Pre_sub', p_event.getEventName(), p_subscription_guid);
21571: WF_EVENT.setErrorInfo(p_event, 'ERROR');
21572:
21573: RETURN 'ERROR';
21574:

Line 21664: WF_CORE.CONTEXT('AMS_LIST_IMPORT_PUB', 'TEST_Post_sub', p_event.getEventName(), p_subscription_guid);

21660: FND_MESSAGE.SET_NAME( 'AMS', 'API_DEBUG_MESSAGE' );
21661: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
21662: FND_MSG_PUB.ADD;
21663: */
21664: WF_CORE.CONTEXT('AMS_LIST_IMPORT_PUB', 'TEST_Post_sub', p_event.getEventName(), p_subscription_guid);
21665: WF_EVENT.setErrorInfo(p_event, 'ERROR');
21666:
21667: RETURN 'ERROR';
21668: