53: g_prof VARCHAR2(50) := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');
54: --
55: -- This program processes the xml data.
56: --
57: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
58: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
59: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
60:
61: -- SOLIN, Bug 3792806
54: --
55: -- This program processes the xml data.
56: --
57: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
58: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
59: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
60:
61: -- SOLIN, Bug 3792806
62: -- Using binded variables to replace literals.
55: -- This program processes the xml data.
56: --
57: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
58: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
59: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
60:
61: -- SOLIN, Bug 3792806
62: -- Using binded variables to replace literals.
63: G_STATUS_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
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;
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;
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;
4943:
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;
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;
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;
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;
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(
13521: p_encoded => FND_API.g_false,
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(
13521: p_encoded => FND_API.g_false,
13522: p_count => x_msg_count,
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(
13521: p_encoded => FND_API.g_false,
13522: p_count => x_msg_count,
13523: p_data => x_msg_data
13524: );
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;
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
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');
21571:
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');
21665: