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_LISTIMPORT_PVT dependencies on FND_MESSAGE

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

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

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

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

Line 2213: p_msg_data => FND_MESSAGE.get,

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

Line 2460: l_mesg_text := fnd_message.get;

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

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

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

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

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

Line 2487: p_msg_data => FND_MESSAGE.get,

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

Line 2532: l_mesg_text := fnd_message.get;

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

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

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

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

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

Line 2565: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 2982: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

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

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

Line 3000: l_msg_buf := FND_MESSAGE.get;

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

Line 3178: l_mesg_text := fnd_message.get;

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

Line 3321: l_mesg_text := fnd_message.get;

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

Line 3548: l_mesg_text := fnd_message.get;

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

Line 3668: l_mesg_text := fnd_message.get;

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

Line 4261: l_mesg_text := fnd_message.get;

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

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

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

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

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

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

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

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

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

Line 6816: l_invalid_number := FND_MESSAGE.get;

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

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

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

Line 6818: l_invalid_size := FND_MESSAGE.get;

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

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

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

Line 6820: l_null_value := FND_MESSAGE.get;

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

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

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

Line 6822: l_invalid_src_system := FND_MESSAGE.get;

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

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

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

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

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

Line 7667: p_msg_data => FND_MESSAGE.get,

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

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

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

Line 7744: l_invalid_date := FND_MESSAGE.get;

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

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

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

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

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

Line 8072: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

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

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

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

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

Line 8276: p_msg_data => FND_MESSAGE.get,

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

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

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

Line 10052: l_invalid_number := FND_MESSAGE.get;

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

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

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

Line 10054: l_invalid_size := FND_MESSAGE.get;

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

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

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

Line 10056: l_null_value := FND_MESSAGE.get;

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

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

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

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

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

Line 11105: p_msg_data => FND_MESSAGE.get,

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

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

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

Line 11990: l_invalid_number := FND_MESSAGE.get;

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

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

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

Line 11992: l_invalid_size := FND_MESSAGE.get;

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

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

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

Line 11994: l_null_value := FND_MESSAGE.get;

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

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

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

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

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

Line 13411: p_msg_data => FND_MESSAGE.get,

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

Line 14398: l_mesg_text := fnd_message.get;

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

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

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

Line 15376: l_invalid_number := FND_MESSAGE.get;

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

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

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

Line 15378: l_invalid_size := FND_MESSAGE.get;

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

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

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

Line 15380: l_null_value := FND_MESSAGE.get;

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

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

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

Line 15382: l_invalid_src_system := FND_MESSAGE.get;

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

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

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

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

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

Line 15854: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 16000: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 16135: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 17086: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 17593: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 18031: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 18301: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 18340: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 18506: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 18788: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 19060: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 19386: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 19648: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 20039: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 20355: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 20511: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 20669: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 20827: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 21153: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 21266: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 21358: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

Line 21475: p_msg_data => FND_MESSAGE.get,

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

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

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

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

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

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

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

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

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