DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on FND_MESSAGE

Line 2208: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

2204: user_status_id = l_user_status_id,
2205: status_date = sysdate
2206: where import_list_header_id = p_import_list_header_id;
2207: commit;
2208: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2209: FND_MESSAGE.Set_Token('ROW','Error in TCA load program ' || SQLERRM||' '||SQLCODE);
2210: AMS_Utility_PVT.Create_Log (
2211: x_return_status => l_return_status,
2212: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 2209: FND_MESSAGE.Set_Token('ROW','Error in TCA load program ' || SQLERRM||' '||SQLCODE);

2205: status_date = sysdate
2206: where import_list_header_id = p_import_list_header_id;
2207: commit;
2208: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2209: FND_MESSAGE.Set_Token('ROW','Error in TCA load program ' || SQLERRM||' '||SQLCODE);
2210: AMS_Utility_PVT.Create_Log (
2211: x_return_status => l_return_status,
2212: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2213: p_log_used_by_id => p_import_list_header_id,

Line 2214: p_msg_data => FND_MESSAGE.get,

2210: AMS_Utility_PVT.Create_Log (
2211: x_return_status => l_return_status,
2212: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2213: p_log_used_by_id => p_import_list_header_id,
2214: p_msg_data => FND_MESSAGE.get,
2215: p_msg_type => 'DEBUG'
2216: );
2217: end list_import_to_hz;
2218:

Line 2461: l_mesg_text := fnd_message.get;

2457: start_time => l_start_time
2458: );
2459:
2460: IF l_request_id = 0 THEN
2461: l_mesg_text := fnd_message.get;
2462: AMS_Utility_PVT.Create_Log (
2463: x_return_status => l_return_status,
2464: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2465: p_log_used_by_id => p_import_list_header_id,

Line 2481: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_REQUEST_ID');

2477: where import_list_header_id = p_import_list_header_id;
2478: commit;
2479: RAISE FND_API.g_exc_unexpected_error;
2480: ELSE
2481: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_REQUEST_ID');
2482: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
2483:
2484: Ams_Utility_PVT.Create_Log (
2485: x_return_status => l_return_status,

Line 2482: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);

2478: commit;
2479: RAISE FND_API.g_exc_unexpected_error;
2480: ELSE
2481: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_REQUEST_ID');
2482: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
2483:
2484: Ams_Utility_PVT.Create_Log (
2485: x_return_status => l_return_status,
2486: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 2488: p_msg_data => FND_MESSAGE.get,

2484: Ams_Utility_PVT.Create_Log (
2485: x_return_status => l_return_status,
2486: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2487: p_log_used_by_id => p_import_list_header_id,
2488: p_msg_data => FND_MESSAGE.get,
2489: p_msg_type => 'MILESTONE'
2490: );
2491: END IF;
2492: Commit;

Line 2533: l_mesg_text := fnd_message.get;

2529: -- the conc request was not successfully
2530: -- submitted.
2531: ---------------------------------------------
2532: IF NOT l_wait_status THEN
2533: l_mesg_text := fnd_message.get;
2534: AMS_Utility_PVT.Create_Log (
2535: x_return_status => l_return_status,
2536: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2537: p_log_used_by_id => p_import_list_header_id,

Line 2559: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOADED_NO_ROWS');

2555: OPEN c_loaded_rows;
2556: FETCH c_loaded_rows INTO l_loaded_rows;
2557: CLOSE c_loaded_rows;
2558:
2559: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOADED_NO_ROWS');
2560: FND_MESSAGE.set_token ('NUM_ROWS', l_loaded_rows);
2561:
2562: Ams_Utility_PVT.Create_Log (
2563: x_return_status => l_return_status,

Line 2560: FND_MESSAGE.set_token ('NUM_ROWS', l_loaded_rows);

2556: FETCH c_loaded_rows INTO l_loaded_rows;
2557: CLOSE c_loaded_rows;
2558:
2559: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOADED_NO_ROWS');
2560: FND_MESSAGE.set_token ('NUM_ROWS', l_loaded_rows);
2561:
2562: Ams_Utility_PVT.Create_Log (
2563: x_return_status => l_return_status,
2564: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 2566: p_msg_data => FND_MESSAGE.get,

2562: Ams_Utility_PVT.Create_Log (
2563: x_return_status => l_return_status,
2564: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2565: p_log_used_by_id => p_import_list_header_id,
2566: p_msg_data => FND_MESSAGE.get,
2567: p_msg_level => 80,
2568: p_msg_type => 'MILESTONE'
2569: );
2570:

Line 2976: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_COMPLETE');

2972: end if;
2973:
2974:
2975: -- Import completed successfully
2976: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_COMPLETE');
2977: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
2978:
2979: AMS_Utility_PVT.Create_Log (
2980: x_return_status => l_return_status,

Line 2977: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);

2973:
2974:
2975: -- Import completed successfully
2976: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_COMPLETE');
2977: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
2978:
2979: AMS_Utility_PVT.Create_Log (
2980: x_return_status => l_return_status,
2981: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 2983: p_msg_data => FND_MESSAGE.get,

2979: AMS_Utility_PVT.Create_Log (
2980: x_return_status => l_return_status,
2981: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
2982: p_log_used_by_id => p_import_list_header_id,
2983: p_msg_data => FND_MESSAGE.get,
2984: p_msg_type => 'DEBUG'
2985: );
2986:
2987: errbuf := SUBSTR (FND_MESSAGE.GET, 1, 240);

Line 2987: errbuf := SUBSTR (FND_MESSAGE.GET, 1, 240);

2983: p_msg_data => FND_MESSAGE.get,
2984: p_msg_type => 'DEBUG'
2985: );
2986:
2987: errbuf := SUBSTR (FND_MESSAGE.GET, 1, 240);
2988: retcode := 0; -- no problems.
2989:
2990: EXCEPTION
2991: WHEN OTHERS THEN

Line 2999: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_FAILED');

2995: p_log_used_by_id => p_import_list_header_id,
2996: p_msg_data => sqlerrm ,
2997: p_msg_type => 'DEBUG'
2998: );
2999: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_FAILED');
3000: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
3001: l_msg_buf := FND_MESSAGE.get;
3002:
3003: AMS_Utility_PVT.Create_Log (

Line 3000: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);

2996: p_msg_data => sqlerrm ,
2997: p_msg_type => 'DEBUG'
2998: );
2999: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_FAILED');
3000: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
3001: l_msg_buf := FND_MESSAGE.get;
3002:
3003: AMS_Utility_PVT.Create_Log (
3004: x_return_status => l_return_status,

Line 3001: l_msg_buf := FND_MESSAGE.get;

2997: p_msg_type => 'DEBUG'
2998: );
2999: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_LOAD_FAILED');
3000: FND_MESSAGE.set_token ('REQUEST_ID', l_request_id);
3001: l_msg_buf := FND_MESSAGE.get;
3002:
3003: AMS_Utility_PVT.Create_Log (
3004: x_return_status => l_return_status,
3005: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 3179: l_mesg_text := fnd_message.get;

3175:
3176: end if;
3177:
3178: IF l_request_id = 0 THEN
3179: l_mesg_text := fnd_message.get;
3180: AMS_Utility_PVT.Create_Log (
3181: x_return_status => l_return_status,
3182: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
3183: p_log_used_by_id => p_import_list_header_id,

Line 3322: l_mesg_text := fnd_message.get;

3318: -- the conc request was not successfully
3319: -- submitted.
3320: ---------------------------------------------
3321: IF NOT l_wait_status THEN
3322: l_mesg_text := fnd_message.get;
3323: AMS_Utility_PVT.Create_Log (
3324: x_return_status => l_return_status,
3325: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
3326: p_log_used_by_id => p_import_list_header_id,

Line 3549: l_mesg_text := fnd_message.get;

3545: argument5 => p_generate_list,
3546: argument6 => p_list_name
3547: );
3548: IF l_request_id = 0 THEN
3549: l_mesg_text := fnd_message.get;
3550: AMS_Utility_PVT.Create_Log (
3551: x_return_status => l_return_status,
3552: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
3553: p_log_used_by_id => p_import_list_header_id,

Line 3669: l_mesg_text := fnd_message.get;

3665: p_msg_data => 'Starting client side import program (AMSIMCCM) -- concurrent program_id is '||to_char(l_request_id),
3666: p_msg_type => 'DEBUG');
3667: commit;
3668: IF l_request_id = 0 THEN
3669: l_mesg_text := fnd_message.get;
3670: AMS_Utility_PVT.Create_Log (
3671: x_return_status => l_return_status,
3672: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
3673: p_log_used_by_id => p_import_list_header_id,

Line 4262: l_mesg_text := fnd_message.get;

4258: p_msg_type => 'DEBUG'
4259: );
4260:
4261: IF l_request_id = 0 THEN
4262: l_mesg_text := fnd_message.get;
4263: AMS_Utility_PVT.Create_Log (
4264: x_return_status => l_return_status,
4265: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
4266: p_log_used_by_id => p_import_list_header_id,

Line 4937: FND_MESSAGE.SET_NAME('AMS', 'API_DEBUG_MESSAGE');

4933: CLOSE b2borb2c;
4934:
4935: if x_rented_list_flag <> 'R' then
4936: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4937: FND_MESSAGE.SET_NAME('AMS', 'API_DEBUG_MESSAGE');
4938: FND_MESSAGE.SET_TOKEN('ROW','Party was not created through rented list.');
4939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4940: FND_MSG_PUB.ADD;
4941: ROLLBACK;

Line 4938: FND_MESSAGE.SET_TOKEN('ROW','Party was not created through rented list.');

4934:
4935: if x_rented_list_flag <> 'R' then
4936: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4937: FND_MESSAGE.SET_NAME('AMS', 'API_DEBUG_MESSAGE');
4938: FND_MESSAGE.SET_TOKEN('ROW','Party was not created through rented list.');
4939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4940: FND_MSG_PUB.ADD;
4941: ROLLBACK;
4942: RETURN;

Line 4939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

4935: if x_rented_list_flag <> 'R' then
4936: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4937: FND_MESSAGE.SET_NAME('AMS', 'API_DEBUG_MESSAGE');
4938: FND_MESSAGE.SET_TOKEN('ROW','Party was not created through rented list.');
4939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4940: FND_MSG_PUB.ADD;
4941: ROLLBACK;
4942: RETURN;
4943: end if;

Line 6816: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');

6812: RAISE FND_API.G_EXC_ERROR;
6813: END IF;
6814: p_return_status := FND_API.G_RET_STS_SUCCESS;
6815:
6816: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
6817: l_invalid_number := FND_MESSAGE.get;
6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

Line 6817: l_invalid_number := FND_MESSAGE.get;

6813: END IF;
6814: p_return_status := FND_API.G_RET_STS_SUCCESS;
6815:
6816: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
6817: l_invalid_number := FND_MESSAGE.get;
6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;

Line 6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');

6814: p_return_status := FND_API.G_RET_STS_SUCCESS;
6815:
6816: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
6817: l_invalid_number := FND_MESSAGE.get;
6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;
6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');

Line 6819: l_invalid_size := FND_MESSAGE.get;

6815:
6816: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
6817: l_invalid_number := FND_MESSAGE.get;
6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;
6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
6823: l_invalid_src_system := FND_MESSAGE.get;

Line 6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

6816: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
6817: l_invalid_number := FND_MESSAGE.get;
6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;
6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
6823: l_invalid_src_system := FND_MESSAGE.get;
6824:

Line 6821: l_null_value := FND_MESSAGE.get;

6817: l_invalid_number := FND_MESSAGE.get;
6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;
6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
6823: l_invalid_src_system := FND_MESSAGE.get;
6824:
6825: OPEN c_lead_batch_id;

Line 6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');

6818: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;
6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
6823: l_invalid_src_system := FND_MESSAGE.get;
6824:
6825: OPEN c_lead_batch_id;
6826: FETCH c_lead_batch_id into l_batch_id;

Line 6823: l_invalid_src_system := FND_MESSAGE.get;

6819: l_invalid_size := FND_MESSAGE.get;
6820: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
6821: l_null_value := FND_MESSAGE.get;
6822: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
6823: l_invalid_src_system := FND_MESSAGE.get;
6824:
6825: OPEN c_lead_batch_id;
6826: FETCH c_lead_batch_id into l_batch_id;
6827: CLOSE c_lead_batch_id;

Line 7662: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

7658:
7659: EXCEPTION
7660: WHEN OTHERS THEN
7661: p_return_status := FND_API.G_RET_STS_ERROR;
7662: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
7663: FND_MESSAGE.Set_Token('ROW','Error in execute_lead_data_validation:' || SQLERRM||' '||SQLCODE);
7664: AMS_Utility_PVT.Create_Log (
7665: x_return_status => l_return_status,
7666: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 7663: FND_MESSAGE.Set_Token('ROW','Error in execute_lead_data_validation:' || SQLERRM||' '||SQLCODE);

7659: EXCEPTION
7660: WHEN OTHERS THEN
7661: p_return_status := FND_API.G_RET_STS_ERROR;
7662: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
7663: FND_MESSAGE.Set_Token('ROW','Error in execute_lead_data_validation:' || SQLERRM||' '||SQLCODE);
7664: AMS_Utility_PVT.Create_Log (
7665: x_return_status => l_return_status,
7666: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7667: p_log_used_by_id => p_import_list_header_id,

Line 7668: p_msg_data => FND_MESSAGE.get,

7664: AMS_Utility_PVT.Create_Log (
7665: x_return_status => l_return_status,
7666: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7667: p_log_used_by_id => p_import_list_header_id,
7668: p_msg_data => FND_MESSAGE.get,
7669: p_msg_type => 'DEBUG'
7670: );
7671:
7672: end execute_lead_data_validation;

Line 7744: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATE_VAL_ERROR_CHK');

7740: cursor c_file_type is
7741: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
7742:
7743: begin
7744: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATE_VAL_ERROR_CHK');
7745: l_invalid_date := FND_MESSAGE.get;
7746: x_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
7747: open c_file_type;
7748: fetch c_file_type into l_file_type;

Line 7745: l_invalid_date := FND_MESSAGE.get;

7741: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
7742:
7743: begin
7744: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATE_VAL_ERROR_CHK');
7745: l_invalid_date := FND_MESSAGE.get;
7746: x_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
7747: open c_file_type;
7748: fetch c_file_type into l_file_type;
7749: close c_file_type;

Line 8067: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

8063: end if;
8064: end if;
8065: EXCEPTION
8066: WHEN OTHERS THEN
8067: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8068: FND_MESSAGE.Set_Token('ROW','Error in date_validate:' || SQLERRM||' '||SQLCODE);
8069: AMS_Utility_PVT.Create_Log (
8070: x_return_status => l_return_status,
8071: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 8068: FND_MESSAGE.Set_Token('ROW','Error in date_validate:' || SQLERRM||' '||SQLCODE);

8064: end if;
8065: EXCEPTION
8066: WHEN OTHERS THEN
8067: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8068: FND_MESSAGE.Set_Token('ROW','Error in date_validate:' || SQLERRM||' '||SQLCODE);
8069: AMS_Utility_PVT.Create_Log (
8070: x_return_status => l_return_status,
8071: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
8072: p_log_used_by_id => p_import_list_header_id,

Line 8073: p_msg_data => FND_MESSAGE.get,

8069: AMS_Utility_PVT.Create_Log (
8070: x_return_status => l_return_status,
8071: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
8072: p_log_used_by_id => p_import_list_header_id,
8073: p_msg_data => FND_MESSAGE.get,
8074: p_msg_type => 'DEBUG'
8075: );
8076:
8077: end date_validate;

Line 8187: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_INVALID_VAL');

8183:
8184: BEGIN
8185:
8186:
8187: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_INVALID_VAL');
8188: l_invalid_value := 'RELATIONSHIP_TYPE :: RELATIONSHIP_CODE :: ' || FND_MESSAGE.get;
8189:
8190:
8191:

Line 8188: l_invalid_value := 'RELATIONSHIP_TYPE :: RELATIONSHIP_CODE :: ' || FND_MESSAGE.get;

8184: BEGIN
8185:
8186:
8187: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_INVALID_VAL');
8188: l_invalid_value := 'RELATIONSHIP_TYPE :: RELATIONSHIP_CODE :: ' || FND_MESSAGE.get;
8189:
8190:
8191:
8192: OPEN c_lead_batch_id;

Line 8271: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

8267:
8268: EXCEPTION
8269: WHEN OTHERS THEN
8270: p_return_status := FND_API.G_RET_STS_ERROR;
8271: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8272: FND_MESSAGE.Set_Token('ROW','Error in execute_relationship_validation:' || SQLERRM||' '||SQLCODE);
8273: AMS_Utility_PVT.Create_Log (
8274: x_return_status => l_return_status,
8275: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 8272: FND_MESSAGE.Set_Token('ROW','Error in execute_relationship_validation:' || SQLERRM||' '||SQLCODE);

8268: EXCEPTION
8269: WHEN OTHERS THEN
8270: p_return_status := FND_API.G_RET_STS_ERROR;
8271: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8272: FND_MESSAGE.Set_Token('ROW','Error in execute_relationship_validation:' || SQLERRM||' '||SQLCODE);
8273: AMS_Utility_PVT.Create_Log (
8274: x_return_status => l_return_status,
8275: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
8276: p_log_used_by_id => p_import_list_header_id,

Line 8277: p_msg_data => FND_MESSAGE.get,

8273: AMS_Utility_PVT.Create_Log (
8274: x_return_status => l_return_status,
8275: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
8276: p_log_used_by_id => p_import_list_header_id,
8277: p_msg_data => FND_MESSAGE.get,
8278: p_msg_type => 'DEBUG'
8279: );
8280:
8281: end execute_reltnship_validation;

Line 10052: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');

10048: RAISE FND_API.G_EXC_ERROR;
10049: END IF;
10050: p_return_status := FND_API.G_RET_STS_SUCCESS;
10051:
10052: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
10053: l_invalid_number := FND_MESSAGE.get;
10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
10055: l_invalid_size := FND_MESSAGE.get;
10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

Line 10053: l_invalid_number := FND_MESSAGE.get;

10049: END IF;
10050: p_return_status := FND_API.G_RET_STS_SUCCESS;
10051:
10052: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
10053: l_invalid_number := FND_MESSAGE.get;
10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
10055: l_invalid_size := FND_MESSAGE.get;
10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
10057: l_null_value := FND_MESSAGE.get;

Line 10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');

10050: p_return_status := FND_API.G_RET_STS_SUCCESS;
10051:
10052: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
10053: l_invalid_number := FND_MESSAGE.get;
10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
10055: l_invalid_size := FND_MESSAGE.get;
10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
10057: l_null_value := FND_MESSAGE.get;
10058:

Line 10055: l_invalid_size := FND_MESSAGE.get;

10051:
10052: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
10053: l_invalid_number := FND_MESSAGE.get;
10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
10055: l_invalid_size := FND_MESSAGE.get;
10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
10057: l_null_value := FND_MESSAGE.get;
10058:
10059: OPEN b2borb2c;

Line 10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

10052: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
10053: l_invalid_number := FND_MESSAGE.get;
10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
10055: l_invalid_size := FND_MESSAGE.get;
10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
10057: l_null_value := FND_MESSAGE.get;
10058:
10059: OPEN b2borb2c;
10060: FETCH b2borb2c into l_imp_type;

Line 10057: l_null_value := FND_MESSAGE.get;

10053: l_invalid_number := FND_MESSAGE.get;
10054: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
10055: l_invalid_size := FND_MESSAGE.get;
10056: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
10057: l_null_value := FND_MESSAGE.get;
10058:
10059: OPEN b2borb2c;
10060: FETCH b2borb2c into l_imp_type;
10061: CLOSE b2borb2c;

Line 11100: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

11096:
11097: EXCEPTION
11098: WHEN OTHERS THEN
11099: p_return_status := FND_API.G_RET_STS_ERROR;
11100: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
11101: FND_MESSAGE.Set_Token('ROW','Error in execute_cust_data_validation:' || SQLERRM||' '||SQLCODE);
11102: AMS_Utility_PVT.Create_Log (
11103: x_return_status => l_return_status,
11104: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 11101: FND_MESSAGE.Set_Token('ROW','Error in execute_cust_data_validation:' || SQLERRM||' '||SQLCODE);

11097: EXCEPTION
11098: WHEN OTHERS THEN
11099: p_return_status := FND_API.G_RET_STS_ERROR;
11100: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
11101: FND_MESSAGE.Set_Token('ROW','Error in execute_cust_data_validation:' || SQLERRM||' '||SQLCODE);
11102: AMS_Utility_PVT.Create_Log (
11103: x_return_status => l_return_status,
11104: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
11105: p_log_used_by_id => p_import_list_header_id,

Line 11106: p_msg_data => FND_MESSAGE.get,

11102: AMS_Utility_PVT.Create_Log (
11103: x_return_status => l_return_status,
11104: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
11105: p_log_used_by_id => p_import_list_header_id,
11106: p_msg_data => FND_MESSAGE.get,
11107: p_msg_type => 'DEBUG'
11108: );
11109:
11110: end execute_cust_data_validation;

Line 11990: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');

11986: RAISE FND_API.G_EXC_ERROR;
11987: END IF;
11988: p_return_status := FND_API.G_RET_STS_SUCCESS;
11989:
11990: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
11991: l_invalid_number := FND_MESSAGE.get;
11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
11993: l_invalid_size := FND_MESSAGE.get;
11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

Line 11991: l_invalid_number := FND_MESSAGE.get;

11987: END IF;
11988: p_return_status := FND_API.G_RET_STS_SUCCESS;
11989:
11990: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
11991: l_invalid_number := FND_MESSAGE.get;
11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
11993: l_invalid_size := FND_MESSAGE.get;
11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
11995: l_null_value := FND_MESSAGE.get;

Line 11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');

11988: p_return_status := FND_API.G_RET_STS_SUCCESS;
11989:
11990: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
11991: l_invalid_number := FND_MESSAGE.get;
11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
11993: l_invalid_size := FND_MESSAGE.get;
11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
11995: l_null_value := FND_MESSAGE.get;
11996:

Line 11993: l_invalid_size := FND_MESSAGE.get;

11989:
11990: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
11991: l_invalid_number := FND_MESSAGE.get;
11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
11993: l_invalid_size := FND_MESSAGE.get;
11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
11995: l_null_value := FND_MESSAGE.get;
11996:
11997: OPEN b2borb2c;

Line 11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

11990: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
11991: l_invalid_number := FND_MESSAGE.get;
11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
11993: l_invalid_size := FND_MESSAGE.get;
11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
11995: l_null_value := FND_MESSAGE.get;
11996:
11997: OPEN b2borb2c;
11998: FETCH b2borb2c into x_b2b;

Line 11995: l_null_value := FND_MESSAGE.get;

11991: l_invalid_number := FND_MESSAGE.get;
11992: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
11993: l_invalid_size := FND_MESSAGE.get;
11994: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
11995: l_null_value := FND_MESSAGE.get;
11996:
11997: OPEN b2borb2c;
11998: FETCH b2borb2c into x_b2b;
11999: close b2borb2c;

Line 13406: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

13402:
13403: EXCEPTION
13404: WHEN OTHERS THEN
13405: p_return_status := FND_API.G_RET_STS_ERROR;
13406: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
13407: FND_MESSAGE.Set_Token('ROW','Error in exe_custxml_data_validation:' || SQLERRM||' '||SQLCODE);
13408: AMS_Utility_PVT.Create_Log (
13409: x_return_status => l_return_status,
13410: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 13407: FND_MESSAGE.Set_Token('ROW','Error in exe_custxml_data_validation:' || SQLERRM||' '||SQLCODE);

13403: EXCEPTION
13404: WHEN OTHERS THEN
13405: p_return_status := FND_API.G_RET_STS_ERROR;
13406: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
13407: FND_MESSAGE.Set_Token('ROW','Error in exe_custxml_data_validation:' || SQLERRM||' '||SQLCODE);
13408: AMS_Utility_PVT.Create_Log (
13409: x_return_status => l_return_status,
13410: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
13411: p_log_used_by_id => p_import_list_header_id,

Line 13412: p_msg_data => FND_MESSAGE.get,

13408: AMS_Utility_PVT.Create_Log (
13409: x_return_status => l_return_status,
13410: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
13411: p_log_used_by_id => p_import_list_header_id,
13412: p_msg_data => FND_MESSAGE.get,
13413: p_msg_type => 'DEBUG'
13414: );
13415:
13416: end exe_custxml_data_validation;

Line 14399: l_mesg_text := fnd_message.get;

14395: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
14396: p_log_used_by_id => p_import_list_header_id,
14397: p_msg_data => 'Error in (AMSILHZC) -- concurrent program_id is '||to_char(l_request_id),
14398: p_msg_type => 'DEBUG');
14399: l_mesg_text := fnd_message.get;
14400: AMS_Utility_PVT.Create_Log (
14401: x_return_status => l_return_status,
14402: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
14403: p_log_used_by_id => p_import_list_header_id,

Line 15376: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');

15372: RAISE FND_API.G_EXC_ERROR;
15373: END IF;
15374: p_return_status := FND_API.G_RET_STS_SUCCESS;
15375:
15376: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
15377: l_invalid_number := FND_MESSAGE.get;
15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

Line 15377: l_invalid_number := FND_MESSAGE.get;

15373: END IF;
15374: p_return_status := FND_API.G_RET_STS_SUCCESS;
15375:
15376: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
15377: l_invalid_number := FND_MESSAGE.get;
15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;

Line 15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');

15374: p_return_status := FND_API.G_RET_STS_SUCCESS;
15375:
15376: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
15377: l_invalid_number := FND_MESSAGE.get;
15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;
15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');

Line 15379: l_invalid_size := FND_MESSAGE.get;

15375:
15376: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
15377: l_invalid_number := FND_MESSAGE.get;
15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;
15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
15383: l_invalid_src_system := FND_MESSAGE.get;

Line 15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');

15376: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATATYPE_ERROR_CHK');
15377: l_invalid_number := FND_MESSAGE.get;
15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;
15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
15383: l_invalid_src_system := FND_MESSAGE.get;
15384:

Line 15381: l_null_value := FND_MESSAGE.get;

15377: l_invalid_number := FND_MESSAGE.get;
15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;
15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
15383: l_invalid_src_system := FND_MESSAGE.get;
15384:
15385: OPEN c_lead_batch_id;

Line 15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');

15378: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_SIZE_ERROR_CHK');
15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;
15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
15383: l_invalid_src_system := FND_MESSAGE.get;
15384:
15385: OPEN c_lead_batch_id;
15386: FETCH c_lead_batch_id into l_batch_id;

Line 15383: l_invalid_src_system := FND_MESSAGE.get;

15379: l_invalid_size := FND_MESSAGE.get;
15380: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_COL_NULL_ERROR_CHK');
15381: l_null_value := FND_MESSAGE.get;
15382: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_SOUR_SYS_ERROR_CHK');
15383: l_invalid_src_system := FND_MESSAGE.get;
15384:
15385: OPEN c_lead_batch_id;
15386: FETCH c_lead_batch_id into l_batch_id;
15387: CLOSE c_lead_batch_id;

Line 15849: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

15845:
15846: EXCEPTION
15847: WHEN OTHERS THEN
15848: p_return_status := FND_API.G_RET_STS_ERROR;
15849: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
15850: FND_MESSAGE.Set_Token('ROW','Error in execute_event_data_validation:' || SQLERRM||' '||SQLCODE);
15851: AMS_Utility_PVT.Create_Log (
15852: x_return_status => l_return_status,
15853: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 15850: FND_MESSAGE.Set_Token('ROW','Error in execute_event_data_validation:' || SQLERRM||' '||SQLCODE);

15846: EXCEPTION
15847: WHEN OTHERS THEN
15848: p_return_status := FND_API.G_RET_STS_ERROR;
15849: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
15850: FND_MESSAGE.Set_Token('ROW','Error in execute_event_data_validation:' || SQLERRM||' '||SQLCODE);
15851: AMS_Utility_PVT.Create_Log (
15852: x_return_status => l_return_status,
15853: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
15854: p_log_used_by_id => p_import_list_header_id,

Line 15855: p_msg_data => FND_MESSAGE.get,

15851: AMS_Utility_PVT.Create_Log (
15852: x_return_status => l_return_status,
15853: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
15854: p_log_used_by_id => p_import_list_header_id,
15855: p_msg_data => FND_MESSAGE.get,
15856: p_msg_type => 'DEBUG'
15857: );
15858:
15859: end execute_event_data_validation;

Line 15995: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

15991: where import_list_header_id = p_import_list_header_id;
15992:
15993: exception
15994: WHEN OTHERS THEN
15995: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
15996: FND_MESSAGE.Set_Token('ROW','Error in process_status_code :' || SQLERRM||' '||SQLCODE);
15997: AMS_Utility_PVT.Create_Log (
15998: x_return_status => l_return_status,
15999: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 15996: FND_MESSAGE.Set_Token('ROW','Error in process_status_code :' || SQLERRM||' '||SQLCODE);

15992:
15993: exception
15994: WHEN OTHERS THEN
15995: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
15996: FND_MESSAGE.Set_Token('ROW','Error in process_status_code :' || SQLERRM||' '||SQLCODE);
15997: AMS_Utility_PVT.Create_Log (
15998: x_return_status => l_return_status,
15999: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
16000: p_log_used_by_id => p_import_list_header_id,

Line 16001: p_msg_data => FND_MESSAGE.get,

15997: AMS_Utility_PVT.Create_Log (
15998: x_return_status => l_return_status,
15999: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
16000: p_log_used_by_id => p_import_list_header_id,
16001: p_msg_data => FND_MESSAGE.get,
16002: p_msg_type => 'DEBUG'
16003: );
16004:
16005: end process_status_code;

Line 16130: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

16126: END if;
16127:
16128: exception
16129: WHEN OTHERS THEN
16130: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
16131: FND_MESSAGE.Set_Token('ROW','Error in Process_customers_xml :' || SQLERRM||' '||SQLCODE);
16132: AMS_Utility_PVT.Create_Log (
16133: x_return_status => x_return_status,
16134: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 16131: FND_MESSAGE.Set_Token('ROW','Error in Process_customers_xml :' || SQLERRM||' '||SQLCODE);

16127:
16128: exception
16129: WHEN OTHERS THEN
16130: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
16131: FND_MESSAGE.Set_Token('ROW','Error in Process_customers_xml :' || SQLERRM||' '||SQLCODE);
16132: AMS_Utility_PVT.Create_Log (
16133: x_return_status => x_return_status,
16134: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
16135: p_log_used_by_id => p_import_list_header_id,

Line 16136: p_msg_data => FND_MESSAGE.get,

16132: AMS_Utility_PVT.Create_Log (
16133: x_return_status => x_return_status,
16134: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
16135: p_log_used_by_id => p_import_list_header_id,
16136: p_msg_data => FND_MESSAGE.get,
16137: p_msg_type => 'DEBUG'
16138: );
16139:
16140:

Line 17081: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

17077: p_cust_tbl := l_customer_tbl;
17078:
17079: exception
17080: WHEN OTHERS THEN
17081: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
17082: FND_MESSAGE.Set_Token('ROW','Error in Process_b2b_xml_data :' || SQLERRM||' '||SQLCODE);
17083: AMS_Utility_PVT.Create_Log (
17084: x_return_status => x_return_status,
17085: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 17082: FND_MESSAGE.Set_Token('ROW','Error in Process_b2b_xml_data :' || SQLERRM||' '||SQLCODE);

17078:
17079: exception
17080: WHEN OTHERS THEN
17081: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
17082: FND_MESSAGE.Set_Token('ROW','Error in Process_b2b_xml_data :' || SQLERRM||' '||SQLCODE);
17083: AMS_Utility_PVT.Create_Log (
17084: x_return_status => x_return_status,
17085: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
17086: p_log_used_by_id => p_import_list_header_id,

Line 17087: p_msg_data => FND_MESSAGE.get,

17083: AMS_Utility_PVT.Create_Log (
17084: x_return_status => x_return_status,
17085: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
17086: p_log_used_by_id => p_import_list_header_id,
17087: p_msg_data => FND_MESSAGE.get,
17088: p_msg_type => 'DEBUG'
17089: );
17090:
17091:

Line 17588: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

17584: p_cust_tbl := l_customer_tbl;
17585:
17586: exception
17587: WHEN OTHERS THEN
17588: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
17589: FND_MESSAGE.Set_Token('ROW','Error in Process_b2c_xml_data :' || SQLERRM||' '||SQLCODE);
17590: AMS_Utility_PVT.Create_Log (
17591: x_return_status => x_return_status,
17592: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 17589: FND_MESSAGE.Set_Token('ROW','Error in Process_b2c_xml_data :' || SQLERRM||' '||SQLCODE);

17585:
17586: exception
17587: WHEN OTHERS THEN
17588: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
17589: FND_MESSAGE.Set_Token('ROW','Error in Process_b2c_xml_data :' || SQLERRM||' '||SQLCODE);
17590: AMS_Utility_PVT.Create_Log (
17591: x_return_status => x_return_status,
17592: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
17593: p_log_used_by_id => p_import_list_header_id,

Line 17594: p_msg_data => FND_MESSAGE.get,

17590: AMS_Utility_PVT.Create_Log (
17591: x_return_status => x_return_status,
17592: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
17593: p_log_used_by_id => p_import_list_header_id,
17594: p_msg_data => FND_MESSAGE.get,
17595: p_msg_type => 'DEBUG'
17596: );
17597:
17598: END Process_b2c_xml_data;

Line 18026: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

18022: commit;
18023:
18024: exception
18025: WHEN OTHERS THEN
18026: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18027: FND_MESSAGE.Set_Token('ROW','Error in Create_b2b_src_lines:' || SQLERRM||' '||SQLCODE);
18028: AMS_Utility_PVT.Create_Log (
18029: x_return_status => x_return_status,
18030: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 18027: FND_MESSAGE.Set_Token('ROW','Error in Create_b2b_src_lines:' || SQLERRM||' '||SQLCODE);

18023:
18024: exception
18025: WHEN OTHERS THEN
18026: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18027: FND_MESSAGE.Set_Token('ROW','Error in Create_b2b_src_lines:' || SQLERRM||' '||SQLCODE);
18028: AMS_Utility_PVT.Create_Log (
18029: x_return_status => x_return_status,
18030: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18031: p_log_used_by_id => p_import_list_header_id,

Line 18032: p_msg_data => FND_MESSAGE.get,

18028: AMS_Utility_PVT.Create_Log (
18029: x_return_status => x_return_status,
18030: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18031: p_log_used_by_id => p_import_list_header_id,
18032: p_msg_data => FND_MESSAGE.get,
18033: p_msg_type => 'DEBUG'
18034: );
18035:
18036: end Create_b2b_src_lines;

Line 18296: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

18292: commit;
18293:
18294: exception
18295: WHEN OTHERS THEN
18296: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18297: FND_MESSAGE.Set_Token('ROW','Error in Create_b2c_src_lines:' || SQLERRM||' '||SQLCODE);
18298: AMS_Utility_PVT.Create_Log (
18299: x_return_status => x_return_status,
18300: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 18297: FND_MESSAGE.Set_Token('ROW','Error in Create_b2c_src_lines:' || SQLERRM||' '||SQLCODE);

18293:
18294: exception
18295: WHEN OTHERS THEN
18296: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18297: FND_MESSAGE.Set_Token('ROW','Error in Create_b2c_src_lines:' || SQLERRM||' '||SQLCODE);
18298: AMS_Utility_PVT.Create_Log (
18299: x_return_status => x_return_status,
18300: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18301: p_log_used_by_id => p_import_list_header_id,

Line 18302: p_msg_data => FND_MESSAGE.get,

18298: AMS_Utility_PVT.Create_Log (
18299: x_return_status => x_return_status,
18300: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18301: p_log_used_by_id => p_import_list_header_id,
18302: p_msg_data => FND_MESSAGE.get,
18303: p_msg_type => 'DEBUG'
18304: );
18305:
18306: end Create_b2c_src_lines;

Line 18335: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

18331: where imp_xml_element_id = p_xml_element_id;
18332: end if;
18333: exception
18334: WHEN OTHERS THEN
18335: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18336: FND_MESSAGE.Set_Token('ROW','Error in update_element_error :' || SQLERRM||' '||SQLCODE);
18337: AMS_Utility_PVT.Create_Log (
18338: x_return_status => x_return_status,
18339: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 18336: FND_MESSAGE.Set_Token('ROW','Error in update_element_error :' || SQLERRM||' '||SQLCODE);

18332: end if;
18333: exception
18334: WHEN OTHERS THEN
18335: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18336: FND_MESSAGE.Set_Token('ROW','Error in update_element_error :' || SQLERRM||' '||SQLCODE);
18337: AMS_Utility_PVT.Create_Log (
18338: x_return_status => x_return_status,
18339: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18340: p_log_used_by_id => p_import_list_header_id,

Line 18341: p_msg_data => FND_MESSAGE.get,

18337: AMS_Utility_PVT.Create_Log (
18338: x_return_status => x_return_status,
18339: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18340: p_log_used_by_id => p_import_list_header_id,
18341: p_msg_data => FND_MESSAGE.get,
18342: p_msg_type => 'DEBUG'
18343: );
18344:
18345:

Line 18501: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

18497: return;
18498: end if;
18499: exception
18500: WHEN OTHERS THEN
18501: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18502: FND_MESSAGE.Set_Token('ROW','Error in create_list_note :' || SQLERRM||' '||SQLCODE);
18503: AMS_Utility_PVT.Create_Log (
18504: x_return_status => l_return_status,
18505: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 18502: FND_MESSAGE.Set_Token('ROW','Error in create_list_note :' || SQLERRM||' '||SQLCODE);

18498: end if;
18499: exception
18500: WHEN OTHERS THEN
18501: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18502: FND_MESSAGE.Set_Token('ROW','Error in create_list_note :' || SQLERRM||' '||SQLCODE);
18503: AMS_Utility_PVT.Create_Log (
18504: x_return_status => l_return_status,
18505: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18506: p_log_used_by_id => p_import_list_header_id,

Line 18507: p_msg_data => FND_MESSAGE.get,

18503: AMS_Utility_PVT.Create_Log (
18504: x_return_status => l_return_status,
18505: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18506: p_log_used_by_id => p_import_list_header_id,
18507: p_msg_data => FND_MESSAGE.get,
18508: p_msg_type => 'DEBUG'
18509: );
18510: update ams_imp_source_lines set load_status = 'ERROR'
18511: where import_list_header_id = p_import_list_header_id

Line 18783: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

18779:
18780: EXCEPTION
18781: WHEN OTHERS THEN
18782: x_return_status := FND_API.G_RET_STS_ERROR;
18783: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18784: FND_MESSAGE.Set_Token('ROW','Error in org_existence_checking :' || SQLERRM||' '||SQLCODE);
18785: AMS_Utility_PVT.Create_Log (
18786: x_return_status => x_return_status,
18787: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 18784: FND_MESSAGE.Set_Token('ROW','Error in org_existence_checking :' || SQLERRM||' '||SQLCODE);

18780: EXCEPTION
18781: WHEN OTHERS THEN
18782: x_return_status := FND_API.G_RET_STS_ERROR;
18783: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
18784: FND_MESSAGE.Set_Token('ROW','Error in org_existence_checking :' || SQLERRM||' '||SQLCODE);
18785: AMS_Utility_PVT.Create_Log (
18786: x_return_status => x_return_status,
18787: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18788: p_log_used_by_id => p_import_list_header_id,

Line 18789: p_msg_data => FND_MESSAGE.get,

18785: AMS_Utility_PVT.Create_Log (
18786: x_return_status => x_return_status,
18787: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
18788: p_log_used_by_id => p_import_list_header_id,
18789: p_msg_data => FND_MESSAGE.get,
18790: p_msg_type => 'DEBUG'
18791: );
18792:
18793: end org_existence_checking;

Line 19055: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

19051:
19052: EXCEPTION
19053: WHEN OTHERS THEN
19054: x_return_status := FND_API.G_RET_STS_ERROR;
19055: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
19056: FND_MESSAGE.Set_Token('ROW','Error in org_existence_checking_osr :' || SQLERRM||' '||SQLCODE);
19057: AMS_Utility_PVT.Create_Log (
19058: x_return_status => x_return_status,
19059: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 19056: FND_MESSAGE.Set_Token('ROW','Error in org_existence_checking_osr :' || SQLERRM||' '||SQLCODE);

19052: EXCEPTION
19053: WHEN OTHERS THEN
19054: x_return_status := FND_API.G_RET_STS_ERROR;
19055: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
19056: FND_MESSAGE.Set_Token('ROW','Error in org_existence_checking_osr :' || SQLERRM||' '||SQLCODE);
19057: AMS_Utility_PVT.Create_Log (
19058: x_return_status => x_return_status,
19059: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
19060: p_log_used_by_id => p_import_list_header_id,

Line 19061: p_msg_data => FND_MESSAGE.get,

19057: AMS_Utility_PVT.Create_Log (
19058: x_return_status => x_return_status,
19059: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
19060: p_log_used_by_id => p_import_list_header_id,
19061: p_msg_data => FND_MESSAGE.get,
19062: p_msg_type => 'DEBUG'
19063: );
19064:
19065: end org_existence_checking_osr;

Line 19381: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

19377:
19378: EXCEPTION
19379: WHEN OTHERS THEN
19380: x_return_status := FND_API.G_RET_STS_ERROR;
19381: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
19382: FND_MESSAGE.Set_Token('ROW','Error in per_existence_checking :' || SQLERRM||' '||SQLCODE);
19383: AMS_Utility_PVT.Create_Log (
19384: x_return_status => x_return_status,
19385: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 19382: FND_MESSAGE.Set_Token('ROW','Error in per_existence_checking :' || SQLERRM||' '||SQLCODE);

19378: EXCEPTION
19379: WHEN OTHERS THEN
19380: x_return_status := FND_API.G_RET_STS_ERROR;
19381: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
19382: FND_MESSAGE.Set_Token('ROW','Error in per_existence_checking :' || SQLERRM||' '||SQLCODE);
19383: AMS_Utility_PVT.Create_Log (
19384: x_return_status => x_return_status,
19385: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
19386: p_log_used_by_id => p_import_list_header_id,

Line 19387: p_msg_data => FND_MESSAGE.get,

19383: AMS_Utility_PVT.Create_Log (
19384: x_return_status => x_return_status,
19385: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
19386: p_log_used_by_id => p_import_list_header_id,
19387: p_msg_data => FND_MESSAGE.get,
19388: p_msg_type => 'DEBUG'
19389: );
19390:
19391: end per_existence_checking;

Line 19643: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

19639: -- TO CHECK WITH address and country
19640: EXCEPTION
19641: WHEN OTHERS THEN
19642: x_return_status := FND_API.G_RET_STS_ERROR;
19643: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
19644: FND_MESSAGE.Set_Token('ROW','Error in per_existence_checking_osr :' || SQLERRM||' '||SQLCODE);
19645: AMS_Utility_PVT.Create_Log (
19646: x_return_status => x_return_status,
19647: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 19644: FND_MESSAGE.Set_Token('ROW','Error in per_existence_checking_osr :' || SQLERRM||' '||SQLCODE);

19640: EXCEPTION
19641: WHEN OTHERS THEN
19642: x_return_status := FND_API.G_RET_STS_ERROR;
19643: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
19644: FND_MESSAGE.Set_Token('ROW','Error in per_existence_checking_osr :' || SQLERRM||' '||SQLCODE);
19645: AMS_Utility_PVT.Create_Log (
19646: x_return_status => x_return_status,
19647: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
19648: p_log_used_by_id => p_import_list_header_id,

Line 19649: p_msg_data => FND_MESSAGE.get,

19645: AMS_Utility_PVT.Create_Log (
19646: x_return_status => x_return_status,
19647: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
19648: p_log_used_by_id => p_import_list_header_id,
19649: p_msg_data => FND_MESSAGE.get,
19650: p_msg_type => 'DEBUG'
19651: );
19652:
19653: end per_existence_checking_osr;

Line 20034: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

20030:
20031: EXCEPTION
20032: WHEN OTHERS THEN
20033: x_return_status := FND_API.G_RET_STS_ERROR;
20034: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20035: FND_MESSAGE.Set_Token('ROW','Error in org_cont_existence_checking :' || SQLERRM||' '||SQLCODE);
20036: AMS_Utility_PVT.Create_Log (
20037: x_return_status => x_return_status,
20038: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 20035: FND_MESSAGE.Set_Token('ROW','Error in org_cont_existence_checking :' || SQLERRM||' '||SQLCODE);

20031: EXCEPTION
20032: WHEN OTHERS THEN
20033: x_return_status := FND_API.G_RET_STS_ERROR;
20034: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20035: FND_MESSAGE.Set_Token('ROW','Error in org_cont_existence_checking :' || SQLERRM||' '||SQLCODE);
20036: AMS_Utility_PVT.Create_Log (
20037: x_return_status => x_return_status,
20038: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20039: p_log_used_by_id => p_import_list_header_id,

Line 20040: p_msg_data => FND_MESSAGE.get,

20036: AMS_Utility_PVT.Create_Log (
20037: x_return_status => x_return_status,
20038: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20039: p_log_used_by_id => p_import_list_header_id,
20040: p_msg_data => FND_MESSAGE.get,
20041: p_msg_type => 'DEBUG'
20042: );
20043:
20044: end org_cont_existence_checking;

Line 20350: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

20346:
20347: EXCEPTION
20348: WHEN OTHERS THEN
20349: x_return_status := FND_API.G_RET_STS_ERROR;
20350: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20351: FND_MESSAGE.Set_Token('ROW','Error in org_cont_existence_chk_osr :' || SQLERRM||' '||SQLCODE);
20352: AMS_Utility_PVT.Create_Log (
20353: x_return_status => x_return_status,
20354: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 20351: FND_MESSAGE.Set_Token('ROW','Error in org_cont_existence_chk_osr :' || SQLERRM||' '||SQLCODE);

20347: EXCEPTION
20348: WHEN OTHERS THEN
20349: x_return_status := FND_API.G_RET_STS_ERROR;
20350: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20351: FND_MESSAGE.Set_Token('ROW','Error in org_cont_existence_chk_osr :' || SQLERRM||' '||SQLCODE);
20352: AMS_Utility_PVT.Create_Log (
20353: x_return_status => x_return_status,
20354: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20355: p_log_used_by_id => p_import_list_header_id,

Line 20356: p_msg_data => FND_MESSAGE.get,

20352: AMS_Utility_PVT.Create_Log (
20353: x_return_status => x_return_status,
20354: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20355: p_log_used_by_id => p_import_list_header_id,
20356: p_msg_data => FND_MESSAGE.get,
20357: p_msg_type => 'DEBUG'
20358: );
20359:
20360: end org_cont_existence_chk_osr;

Line 20506: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

20502:
20503: EXCEPTION
20504: WHEN OTHERS THEN
20505: x_return_status := FND_API.G_RET_STS_ERROR;
20506: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20507: FND_MESSAGE.Set_Token('ROW','Error in org_address_existence_checking :' || SQLERRM||' '||SQLCODE);
20508: AMS_Utility_PVT.Create_Log (
20509: x_return_status => x_return_status,
20510: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 20507: FND_MESSAGE.Set_Token('ROW','Error in org_address_existence_checking :' || SQLERRM||' '||SQLCODE);

20503: EXCEPTION
20504: WHEN OTHERS THEN
20505: x_return_status := FND_API.G_RET_STS_ERROR;
20506: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20507: FND_MESSAGE.Set_Token('ROW','Error in org_address_existence_checking :' || SQLERRM||' '||SQLCODE);
20508: AMS_Utility_PVT.Create_Log (
20509: x_return_status => x_return_status,
20510: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20511: p_log_used_by_id => p_import_list_header_id,

Line 20512: p_msg_data => FND_MESSAGE.get,

20508: AMS_Utility_PVT.Create_Log (
20509: x_return_status => x_return_status,
20510: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20511: p_log_used_by_id => p_import_list_header_id,
20512: p_msg_data => FND_MESSAGE.get,
20513: p_msg_type => 'DEBUG'
20514: );
20515:
20516: end org_address_existence_checking;

Line 20664: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

20660:
20661: EXCEPTION
20662: WHEN OTHERS THEN
20663: x_return_status := FND_API.G_RET_STS_ERROR;
20664: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20665: FND_MESSAGE.Set_Token('ROW','Error in org_address1_exist_checking :' || SQLERRM||' '||SQLCODE);
20666: AMS_Utility_PVT.Create_Log (
20667: x_return_status => x_return_status,
20668: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 20665: FND_MESSAGE.Set_Token('ROW','Error in org_address1_exist_checking :' || SQLERRM||' '||SQLCODE);

20661: EXCEPTION
20662: WHEN OTHERS THEN
20663: x_return_status := FND_API.G_RET_STS_ERROR;
20664: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20665: FND_MESSAGE.Set_Token('ROW','Error in org_address1_exist_checking :' || SQLERRM||' '||SQLCODE);
20666: AMS_Utility_PVT.Create_Log (
20667: x_return_status => x_return_status,
20668: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20669: p_log_used_by_id => p_import_list_header_id,

Line 20670: p_msg_data => FND_MESSAGE.get,

20666: AMS_Utility_PVT.Create_Log (
20667: x_return_status => x_return_status,
20668: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20669: p_log_used_by_id => p_import_list_header_id,
20670: p_msg_data => FND_MESSAGE.get,
20671: p_msg_type => 'DEBUG'
20672: );
20673:
20674: end org_address1_exist_checking;

Line 20822: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

20818:
20819: EXCEPTION
20820: WHEN OTHERS THEN
20821: x_return_status := FND_API.G_RET_STS_ERROR;
20822: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20823: FND_MESSAGE.Set_Token('ROW','Error in per_address_existence_checking :' || SQLERRM||' '||SQLCODE);
20824: AMS_Utility_PVT.Create_Log (
20825: x_return_status => x_return_status,
20826: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 20823: FND_MESSAGE.Set_Token('ROW','Error in per_address_existence_checking :' || SQLERRM||' '||SQLCODE);

20819: EXCEPTION
20820: WHEN OTHERS THEN
20821: x_return_status := FND_API.G_RET_STS_ERROR;
20822: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
20823: FND_MESSAGE.Set_Token('ROW','Error in per_address_existence_checking :' || SQLERRM||' '||SQLCODE);
20824: AMS_Utility_PVT.Create_Log (
20825: x_return_status => x_return_status,
20826: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20827: p_log_used_by_id => p_import_list_header_id,

Line 20828: p_msg_data => FND_MESSAGE.get,

20824: AMS_Utility_PVT.Create_Log (
20825: x_return_status => x_return_status,
20826: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
20827: p_log_used_by_id => p_import_list_header_id,
20828: p_msg_data => FND_MESSAGE.get,
20829: p_msg_type => 'DEBUG'
20830: );
20831:
20832: end per_address_existence_checking;

Line 21148: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

21144: commit;
21145: EXCEPTION
21146: WHEN OTHERS THEN
21147: x_return_status := FND_API.G_RET_STS_ERROR;
21148: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21149: FND_MESSAGE.Set_Token('ROW','Error in org_party_update:' || SQLERRM||' '||SQLCODE);
21150: AMS_Utility_PVT.Create_Log (
21151: x_return_status => x_return_status,
21152: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 21149: FND_MESSAGE.Set_Token('ROW','Error in org_party_update:' || SQLERRM||' '||SQLCODE);

21145: EXCEPTION
21146: WHEN OTHERS THEN
21147: x_return_status := FND_API.G_RET_STS_ERROR;
21148: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21149: FND_MESSAGE.Set_Token('ROW','Error in org_party_update:' || SQLERRM||' '||SQLCODE);
21150: AMS_Utility_PVT.Create_Log (
21151: x_return_status => x_return_status,
21152: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21153: p_log_used_by_id => p_import_list_header_id,

Line 21154: p_msg_data => FND_MESSAGE.get,

21150: AMS_Utility_PVT.Create_Log (
21151: x_return_status => x_return_status,
21152: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21153: p_log_used_by_id => p_import_list_header_id,
21154: p_msg_data => FND_MESSAGE.get,
21155: p_msg_type => 'DEBUG'
21156: );
21157:
21158: end org_party_update;

Line 21261: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

21257: commit;
21258: EXCEPTION
21259: WHEN OTHERS THEN
21260: x_return_status := FND_API.G_RET_STS_ERROR;
21261: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21262: FND_MESSAGE.Set_Token('ROW','Error in gen_transposed_phone_number :' || SQLERRM||' '||SQLCODE);
21263: AMS_Utility_PVT.Create_Log (
21264: x_return_status => x_return_status,
21265: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 21262: FND_MESSAGE.Set_Token('ROW','Error in gen_transposed_phone_number :' || SQLERRM||' '||SQLCODE);

21258: EXCEPTION
21259: WHEN OTHERS THEN
21260: x_return_status := FND_API.G_RET_STS_ERROR;
21261: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21262: FND_MESSAGE.Set_Token('ROW','Error in gen_transposed_phone_number :' || SQLERRM||' '||SQLCODE);
21263: AMS_Utility_PVT.Create_Log (
21264: x_return_status => x_return_status,
21265: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21266: p_log_used_by_id => p_import_list_header_id,

Line 21267: p_msg_data => FND_MESSAGE.get,

21263: AMS_Utility_PVT.Create_Log (
21264: x_return_status => x_return_status,
21265: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21266: p_log_used_by_id => p_import_list_header_id,
21267: p_msg_data => FND_MESSAGE.get,
21268: p_msg_type => 'DEBUG'
21269: );
21270:
21271: end gen_transposed_phone_number;

Line 21353: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

21349: end if;
21350:
21351: EXCEPTION
21352: WHEN OTHERS THEN
21353: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21354: FND_MESSAGE.Set_Token('ROW','Error in update_xml_error_text :' || SQLERRM||' '||SQLCODE);
21355: AMS_Utility_PVT.Create_Log (
21356: x_return_status => l_return_status,
21357: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 21354: FND_MESSAGE.Set_Token('ROW','Error in update_xml_error_text :' || SQLERRM||' '||SQLCODE);

21350:
21351: EXCEPTION
21352: WHEN OTHERS THEN
21353: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21354: FND_MESSAGE.Set_Token('ROW','Error in update_xml_error_text :' || SQLERRM||' '||SQLCODE);
21355: AMS_Utility_PVT.Create_Log (
21356: x_return_status => l_return_status,
21357: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21358: p_log_used_by_id => p_import_list_header_id,

Line 21359: p_msg_data => FND_MESSAGE.get,

21355: AMS_Utility_PVT.Create_Log (
21356: x_return_status => l_return_status,
21357: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21358: p_log_used_by_id => p_import_list_header_id,
21359: p_msg_data => FND_MESSAGE.get,
21360: p_msg_type => 'DEBUG'
21361: );
21362:
21363: end update_xml_error_text;

Line 21470: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

21466: end if;
21467: */
21468: EXCEPTION
21469: WHEN OTHERS THEN
21470: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21471: FND_MESSAGE.Set_Token('ROW','Error in Raise_Business_event :' ||SQLERRM||' '||SQLCODE);
21472: AMS_Utility_PVT.Create_Log (
21473: x_return_status => l_return_status,
21474: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 21471: FND_MESSAGE.Set_Token('ROW','Error in Raise_Business_event :' ||SQLERRM||' '||SQLCODE);

21467: */
21468: EXCEPTION
21469: WHEN OTHERS THEN
21470: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
21471: FND_MESSAGE.Set_Token('ROW','Error in Raise_Business_event :' ||SQLERRM||' '||SQLCODE);
21472: AMS_Utility_PVT.Create_Log (
21473: x_return_status => l_return_status,
21474: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21475: p_log_used_by_id => p_import_list_header_id,

Line 21476: p_msg_data => FND_MESSAGE.get,

21472: AMS_Utility_PVT.Create_Log (
21473: x_return_status => l_return_status,
21474: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
21475: p_log_used_by_id => p_import_list_header_id,
21476: p_msg_data => FND_MESSAGE.get,
21477: p_msg_type => 'DEBUG'
21478: );
21479:
21480: end Raise_Business_event;

Line 21566: FND_MESSAGE.SET_NAME( 'AMS', 'API_DEBUG_MESSAGE' );

21562: EXCEPTION
21563: WHEN OTHERS THEN
21564: -- ROLLBACK TO TEST_Pre_sub;
21565: /*
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);

Line 21567: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );

21563: WHEN OTHERS THEN
21564: -- ROLLBACK TO TEST_Pre_sub;
21565: /*
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');

Line 21660: FND_MESSAGE.SET_NAME( 'AMS', 'API_DEBUG_MESSAGE' );

21656: EXCEPTION
21657: WHEN OTHERS THEN
21658: -- ROLLBACK TO TEST_Post_sub;
21659: /*
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);

Line 21661: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );

21657: WHEN OTHERS THEN
21658: -- ROLLBACK TO TEST_Post_sub;
21659: /*
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');