APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LIST_IMPORT_PUB

Line 1591: AMS_List_Import_PUB.Create_Customer (

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

Line 1638: AMS_List_Import_PUB.error_capture (

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

Line 1659: AMS_List_Import_PUB.error_capture (

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

Line 1681: AMS_List_Import_PUB.error_capture (

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

Line 1711: AMS_List_Import_PUB.error_capture (

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

Line 1961: AMS_List_Import_PUB.Create_Customer (

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

Line 2035: AMS_List_Import_PUB.error_capture (

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

Line 2056: AMS_List_Import_PUB.error_capture (

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

Line 2078: AMS_List_Import_PUB.error_capture (

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

Line 2109: AMS_List_Import_PUB.error_capture (

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

Line 2183: AMS_List_Import_PUB.error_capture (

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

Line 13867: AMS_List_Import_PUB.error_capture (

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

Line 18487: AMS_List_Import_PUB.error_capture (

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

Line 18513: AMS_List_Import_PUB.error_capture (

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

Line 21007: AMS_List_Import_PUB.process_element_duplicate (

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

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

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

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

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