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_API

Line 1126: -- RAISE FND_API.g_exc_unexpected_error;

1122: p_msg_data => 'List Import Child Req : -- concurrent program_id is '||to_char(new_request_id),
1123: p_msg_type => 'DEBUG'
1124: );
1125: IF new_request_id = 0 THEN
1126: -- RAISE FND_API.g_exc_unexpected_error;
1127: AMS_Utility_PVT.Create_Log (
1128: x_return_status => l_return_status,
1129: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
1130: p_log_used_by_id => p_import_list_header_id,

Line 1701: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1697: end if;
1698:
1699: if x_msg_count > 1 then
1700: FOR i IN 1..x_msg_count LOOP
1701: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1702: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
1703: END LOOP;
1704: x_msg_data := x_tmp_var1;
1705: END IF;

Line 2099: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2095: end if;
2096:
2097: if x_msg_count > 1 then
2098: FOR i IN 1..x_msg_count LOOP
2099: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2100: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
2101: END LOOP;
2102: x_msg_data := x_tmp_var1;
2103: END IF;

Line 2478: RAISE FND_API.g_exc_unexpected_error;

2474: user_status_id = l_user_status_id,
2475: status_date = sysdate
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:

Line 2550: RAISE FND_API.g_exc_unexpected_error;

2546: user_status_id = l_user_status_id,
2547: status_date = sysdate
2548: where import_list_header_id = p_import_list_header_id;
2549: commit;
2550: RAISE FND_API.g_exc_unexpected_error;
2551: END IF;
2552:
2553: ---------------------------------------------
2554: OPEN c_loaded_rows;

Line 2943: FND_API.G_VALID_LEVEL_FULL,

2939: AMS_ListGeneration_PKG.create_import_list
2940: ( 1,
2941: 'T',
2942: 'T',
2943: FND_API.G_VALID_LEVEL_FULL,
2944: p_owner_user_id,
2945: p_import_list_header_id,
2946: i_return_status,
2947: i_msg_count,

Line 3196: RAISE FND_API.g_exc_unexpected_error;

3192: user_status_id = l_user_status_id,
3193: status_date = sysdate
3194: where import_list_header_id = p_import_list_header_id;
3195: commit;
3196: RAISE FND_API.g_exc_unexpected_error;
3197: end if;
3198:
3199: if l_import_type = 'LEAD' then
3200: /*

Line 3230: RAISE FND_API.g_exc_unexpected_error;

3226: */
3227: end if;
3228: /*
3229: IF l_request_id = 0 THEN
3230: RAISE FND_API.g_exc_unexpected_error;
3231: end if;
3232: */
3233: if l_import_type = 'EVENT' then
3234: -- Call the Validate Process

Line 3339: RAISE FND_API.g_exc_unexpected_error;

3335: user_status_id = l_user_status_id,
3336: status_date = sysdate
3337: where import_list_header_id = p_import_list_header_id;
3338: commit;
3339: RAISE FND_API.g_exc_unexpected_error;
3340: END IF;
3341: /*
3342: if l_import_type = 'LEAD' then
3343: capture_lead_error(p_import_list_header_id);

Line 3567: RAISE FND_API.g_exc_unexpected_error;

3563: status_date = sysdate
3564: where import_list_header_id = p_import_list_header_id;
3565: commit;
3566:
3567: RAISE FND_API.g_exc_unexpected_error;
3568: end if;
3569: AMS_Utility_PVT.Create_Log (
3570: x_return_status => l_ret_status,
3571: p_arc_log_used_by => G_ARC_IMPORT_HEADER,

Line 3686: RAISE FND_API.g_exc_unexpected_error;

3682: user_status_id = l_user_status_id,
3683: status_date = sysdate
3684: where import_list_header_id = p_import_list_header_id;
3685: commit;
3686: RAISE FND_API.g_exc_unexpected_error;
3687: end if;
3688:
3689: EXCEPTION
3690: WHEN others THEN

Line 4279: RAISE FND_API.g_exc_unexpected_error;

4275: user_status_id = l_user_status_id,
4276: status_date = sysdate
4277: where import_list_header_id = p_import_list_header_id;
4278: commit;
4279: RAISE FND_API.g_exc_unexpected_error;
4280: end if;
4281:
4282: commit;
4283: -- The concurrent program MUST finish

Line 4302: RAISE FND_API.g_exc_unexpected_error;

4298: -- the conc request was not successfully
4299: -- submitted.
4300: ---------------------------------------------
4301: IF NOT l_wait_status THEN
4302: RAISE FND_API.g_exc_unexpected_error;
4303: END IF;
4304:
4305:
4306: l_rstatus := FND_CONCURRENT.get_REQUEST_status (

Line 4935: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4931: FETCH b2borb2c into x_b2b,x_rented_list_flag,x_import_list_header_id;
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;

Line 5179: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

5175: x_msg_count,
5176: x_msg_data);
5177: if x_msg_count > 1 then
5178: FOR i IN 1..x_msg_count LOOP
5179: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
5180: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
5181: END LOOP;
5182: x_msg_data := x_tmp_var1;
5183: END IF;

Line 5216: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

5212: x_msg_count,
5213: x_msg_data);
5214: if x_msg_count > 1 then
5215: FOR i IN 1..x_msg_count LOOP
5216: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
5217: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
5218: END LOOP;
5219: x_msg_data := x_tmp_var1;
5220: END IF;

Line 5255: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

5251: x_msg_count,
5252: x_msg_data);
5253: if x_msg_count > 1 then
5254: FOR i IN 1..x_msg_count LOOP
5255: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
5256: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
5257: END LOOP;
5258: x_msg_data := x_tmp_var1;
5259: END IF;

Line 5583: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

5579: x_msg_count,
5580: x_msg_data);
5581: if x_msg_count > 1 then
5582: FOR i IN 1..x_msg_count LOOP
5583: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
5584: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
5585: END LOOP;
5586: x_msg_data := x_tmp_var1;
5587: END IF;

Line 6811: RAISE FND_API.G_EXC_ERROR;

6807:
6808: begin
6809:
6810: IF p_import_list_header_id IS NULL THEN
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');

Line 6813: p_return_status := FND_API.G_RET_STS_SUCCESS;

6809:
6810: IF p_import_list_header_id IS NULL THEN
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');

Line 7660: p_return_status := FND_API.G_RET_STS_ERROR;

7656:
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,

Line 8269: p_return_status := FND_API.G_RET_STS_ERROR;

8265:
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,

Line 10047: RAISE FND_API.G_EXC_ERROR;

10043:
10044: begin
10045:
10046: IF p_import_list_header_id IS NULL THEN
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');

Line 10049: p_return_status := FND_API.G_RET_STS_SUCCESS;

10045:
10046: IF p_import_list_header_id IS NULL THEN
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');

Line 11098: p_return_status := FND_API.G_RET_STS_ERROR;

11094: and error_type = 'E');
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,

Line 11985: RAISE FND_API.G_EXC_ERROR;

11981:
11982: begin
11983:
11984: IF p_import_list_header_id IS NULL THEN
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');

Line 11987: p_return_status := FND_API.G_RET_STS_SUCCESS;

11983:
11984: IF p_import_list_header_id IS NULL THEN
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');

Line 13404: p_return_status := FND_API.G_RET_STS_ERROR;

13400: -- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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,

Line 13498: x_return_status := FND_API.g_ret_sts_success;

13494: and loc.country = p_country
13495: and nvl(loc.city,nvl(p_city,'x')) = nvl(p_city,'x');
13496:
13497: begin
13498: x_return_status := FND_API.g_ret_sts_success;
13499: l_address_key := hz_fuzzy_pub.Generate_Key (
13500: p_key_type => 'ADDRESS',
13501: p_address1 => p_address1,
13502: p_postal_code => p_pcode

Line 13516: x_return_status := FND_API.g_ret_sts_unexp_error ;

13512: end if;
13513: p_location_id := l_loc_id;
13514: exception
13515: when others then
13516: x_return_status := FND_API.g_ret_sts_unexp_error ;
13517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13518: FND_MSG_PUB.add_exc_msg(g_pkg_name,'address_echeck');
13519: END IF;
13520: FND_MSG_PUB.count_and_get(

Line 13521: p_encoded => FND_API.g_false,

13517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13518: FND_MSG_PUB.add_exc_msg(g_pkg_name,'address_echeck');
13519: END IF;
13520: FND_MSG_PUB.count_and_get(
13521: p_encoded => FND_API.g_false,
13522: p_count => x_msg_count,
13523: p_data => x_msg_data
13524: );
13525:

Line 13843: FND_API.G_FALSE , -- p_init_msg_list

13839: if l_status_code = 'STAGED' then
13840: if l_file_type = 'XML' and l_execute_mode <> 'R' then
13841: Process_customers_xml (
13842: 1, -- p_api_version_number
13843: FND_API.G_FALSE , -- p_init_msg_list
13844: FND_API.G_FALSE , -- p_commit
13845: FND_API.G_VALID_LEVEL_FULL, -- p_validation_level
13846: x_rstatus ,
13847: x_mcount ,

Line 13844: FND_API.G_FALSE , -- p_commit

13840: if l_file_type = 'XML' and l_execute_mode <> 'R' then
13841: Process_customers_xml (
13842: 1, -- p_api_version_number
13843: FND_API.G_FALSE , -- p_init_msg_list
13844: FND_API.G_FALSE , -- p_commit
13845: FND_API.G_VALID_LEVEL_FULL, -- p_validation_level
13846: x_rstatus ,
13847: x_mcount ,
13848: x_mdata ,

Line 13845: FND_API.G_VALID_LEVEL_FULL, -- p_validation_level

13841: Process_customers_xml (
13842: 1, -- p_api_version_number
13843: FND_API.G_FALSE , -- p_init_msg_list
13844: FND_API.G_FALSE , -- p_commit
13845: FND_API.G_VALID_LEVEL_FULL, -- p_validation_level
13846: x_rstatus ,
13847: x_mcount ,
13848: x_mdata ,
13849: p_import_list_header_id ,

Line 13854: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

13850: l_rec_update_flag -- p_update_flag
13851: );
13852: if x_mcount > 1 then
13853: FOR i IN 1..x_mcount LOOP
13854: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
13855: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
13856: END LOOP;
13857: x_mdata := x_tmp_var1;
13858: END IF;

Line 14417: RAISE FND_API.g_exc_unexpected_error;

14413: status_date = sysdate
14414: where import_list_header_id = p_import_list_header_id;
14415: commit;
14416:
14417: RAISE FND_API.g_exc_unexpected_error;
14418: end if;
14419:
14420: -- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>..
14421: /*

Line 14521: FND_API.G_VALID_LEVEL_FULL,

14517: AMS_ListGeneration_PKG.create_import_list
14518: ( 1,
14519: 'T',
14520: 'T',
14521: FND_API.G_VALID_LEVEL_FULL,
14522: p_owner_user_id,
14523: p_import_list_header_id,
14524: i_return_status,
14525: i_msg_count,

Line 14577: RAISE FND_API.g_exc_unexpected_error;

14573: p_msg_type => 'DEBUG'
14574: );
14575: commit;
14576: IF l_request_id = 0 THEN
14577: RAISE FND_API.g_exc_unexpected_error;
14578: end if;
14579: */
14580: end if;
14581: end if;

Line 15371: RAISE FND_API.G_EXC_ERROR;

15367:
15368: begin
15369:
15370: IF p_import_list_header_id IS NULL THEN
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');

Line 15373: p_return_status := FND_API.G_RET_STS_SUCCESS;

15369:
15370: IF p_import_list_header_id IS NULL THEN
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');

Line 15847: p_return_status := FND_API.G_RET_STS_ERROR;

15843:
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,

Line 16012: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

16008: -- This program is for customer import for XML data.
16009:
16010: PROCEDURE Process_customers_xml (
16011: p_api_version_number IN NUMBER,
16012: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16013: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16015: x_return_status OUT NOCOPY VARCHAR2,
16016: x_msg_count OUT NOCOPY NUMBER,

Line 16013: p_commit IN VARCHAR2 := FND_API.G_FALSE,

16009:
16010: PROCEDURE Process_customers_xml (
16011: p_api_version_number IN NUMBER,
16012: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16013: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16015: x_return_status OUT NOCOPY VARCHAR2,
16016: x_msg_count OUT NOCOPY NUMBER,
16017: x_msg_data OUT NOCOPY VARCHAR2,

Line 16014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

16010: PROCEDURE Process_customers_xml (
16011: p_api_version_number IN NUMBER,
16012: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16013: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16015: x_return_status OUT NOCOPY VARCHAR2,
16016: x_msg_count OUT NOCOPY NUMBER,
16017: x_msg_data OUT NOCOPY VARCHAR2,
16018: p_import_list_header_id IN NUMBER,

Line 18428: l_init_msg_list := FND_API.g_true;

18424: --==============================================================
18425: -- INITIALIZE THE API STATIC VALUES ===
18426: --==============================================================
18427: l_api_version := 1.0;
18428: l_init_msg_list := FND_API.g_true;
18429: l_validation_level := FND_API.g_valid_level_full;
18430: l_commit := FND_API.g_true;
18431: l_msg_count := 0;
18432: l_source_object_code := nvl(p_source_object_code,'PARTY');

Line 18429: l_validation_level := FND_API.g_valid_level_full;

18425: -- INITIALIZE THE API STATIC VALUES ===
18426: --==============================================================
18427: l_api_version := 1.0;
18428: l_init_msg_list := FND_API.g_true;
18429: l_validation_level := FND_API.g_valid_level_full;
18430: l_commit := FND_API.g_true;
18431: l_msg_count := 0;
18432: l_source_object_code := nvl(p_source_object_code,'PARTY');
18433: l_note_status := 'I';

Line 18430: l_commit := FND_API.g_true;

18426: --==============================================================
18427: l_api_version := 1.0;
18428: l_init_msg_list := FND_API.g_true;
18429: l_validation_level := FND_API.g_valid_level_full;
18430: l_commit := FND_API.g_true;
18431: l_msg_count := 0;
18432: l_source_object_code := nvl(p_source_object_code,'PARTY');
18433: l_note_status := 'I';
18434: l_note_type := 'AS_USER';

Line 18482: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

18478: ,p_last_update_login => l_last_update_login
18479: );
18480: if x_msg_count > 1 then
18481: FOR i IN 1..x_msg_count LOOP
18482: x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
18483: x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
18484: END LOOP;
18485: END IF;
18486: if x_return_status <> 'S' then

Line 18626: x_return_status := FND_API.G_RET_STS_SUCCESS;

18622: and pty.status = 'A'
18623: group by b2b.import_source_line_id;
18624:
18625: BEGIN
18626: x_return_status := FND_API.G_RET_STS_SUCCESS;
18627: -- TO POPULATE ORG_KEY
18628: l_last_fetch := FALSE;
18629:
18630: open c_org_key;

Line 18781: x_return_status := FND_API.G_RET_STS_ERROR;

18777: -- TO GET THE MAX PARTY_ID
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,

Line 18899: x_return_status := FND_API.G_RET_STS_SUCCESS;

18895: and pty.status = 'A'
18896: group by b2b.import_source_line_id;
18897:
18898: BEGIN
18899: x_return_status := FND_API.G_RET_STS_SUCCESS;
18900: -- TO POPULATE ORG_KEY
18901: l_last_fetch := FALSE;
18902: open c_org_key;
18903: LOOP

Line 19053: x_return_status := FND_API.G_RET_STS_ERROR;

19049: -- TO GET THE MAX PARTY_ID
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,

Line 19186: x_return_status := FND_API.G_RET_STS_SUCCESS;

19182: and load_status in ('ACTIVE','RELOAD')
19183: group by person_key,email_address,transposed_phone_number,address1,country;
19184:
19185: begin
19186: x_return_status := FND_API.G_RET_STS_SUCCESS;
19187: -- TO POPULATE person_KEY
19188: l_last_fetch := FALSE;
19189:
19190: open c_per_key;

Line 19379: x_return_status := FND_API.G_RET_STS_ERROR;

19375: -- TO CHECK WITH dedup
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,

Line 19495: x_return_status := FND_API.G_RET_STS_SUCCESS;

19491: and b2c.orig_system_reference = party.orig_system_reference
19492: group by b2c.import_source_line_id;
19493:
19494: begin
19495: x_return_status := FND_API.G_RET_STS_SUCCESS;
19496: -- TO POPULATE person_KEY
19497: l_last_fetch := FALSE;
19498: open c_per_key;
19499: LOOP

Line 19641: x_return_status := FND_API.G_RET_STS_ERROR;

19637: close c_address_country;
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,

Line 19846: x_return_status := FND_API.G_RET_STS_SUCCESS;

19842: and load_status in ('ACTIVE','RELOAD')
19843: group by org_key,person_key,email_address,transposed_phone_number;
19844:
19845: begin
19846: x_return_status := FND_API.G_RET_STS_SUCCESS;
19847: -- TO POPULATE person_KEY
19848: l_last_fetch := FALSE;
19849: open c_per_key;
19850: LOOP

Line 20032: x_return_status := FND_API.G_RET_STS_ERROR;

20028: -- TO CHECK WITH dedup
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,

Line 20201: x_return_status := FND_API.G_RET_STS_SUCCESS;

20197: and cpoint.status = 'A'
20198: group by b2b.import_source_line_id;
20199:
20200: begin
20201: x_return_status := FND_API.G_RET_STS_SUCCESS;
20202: -- TO POPULATE person_KEY
20203: l_last_fetch := FALSE;
20204: open c_per_key;
20205: LOOP

Line 20348: x_return_status := FND_API.G_RET_STS_ERROR;

20344: -- TO CHECK WITH phone
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,

Line 20417: x_return_status := FND_API.G_RET_STS_SUCCESS;

20413: and nvl(loc.city,nvl(b2b.city,'x')) = nvl(b2b.city,'x')
20414: group by b2b.import_source_line_id;
20415:
20416: begin
20417: x_return_status := FND_API.G_RET_STS_SUCCESS;
20418: -- TO POPULATE address_KEY
20419: l_last_fetch := FALSE;
20420: open c_addr_key;
20421: LOOP

Line 20504: x_return_status := FND_API.G_RET_STS_ERROR;

20500: -- TO CHECK WITH address
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,

Line 20575: x_return_status := FND_API.G_RET_STS_SUCCESS;

20571: and nvl(loc.city,nvl(b2b.org_city,'x')) = nvl(b2b.org_city,'x')
20572: group by b2b.import_source_line_id;
20573:
20574: begin
20575: x_return_status := FND_API.G_RET_STS_SUCCESS;
20576: -- TO POPULATE address_KEY
20577: l_last_fetch := FALSE;
20578: open c_addr_key;
20579: LOOP

Line 20662: x_return_status := FND_API.G_RET_STS_ERROR;

20658: -- TO CHECK WITH address
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,

Line 20733: x_return_status := FND_API.G_RET_STS_SUCCESS;

20729: and nvl(loc.city,nvl(b2c.city,'x')) = nvl(b2c.city,'x')
20730: group by b2c.import_source_line_id;
20731:
20732: begin
20733: x_return_status := FND_API.G_RET_STS_SUCCESS;
20734: -- TO POPULATE address_KEY
20735: l_last_fetch := FALSE;
20736: open c_addr_key;
20737: LOOP

Line 20820: x_return_status := FND_API.G_RET_STS_ERROR;

20816: -- TO CHECK WITH address
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,

Line 21031: FND_API.G_VALID_LEVEL_FULL,

21027: AMS_ListGeneration_PKG.create_import_list
21028: ( 1,
21029: 'T',
21030: 'T',
21031: FND_API.G_VALID_LEVEL_FULL,
21032: l_owner_user_id,
21033: p_import_list_header_id,
21034: i_return_status,
21035: i_msg_count,

Line 21146: x_return_status := FND_API.G_RET_STS_ERROR;

21142: close c_ordered_recs;
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,

Line 21259: x_return_status := FND_API.G_RET_STS_ERROR;

21255: end if ; -- l_b2b_flag = 'N'
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,