DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on FND_MSG_PUB

Line 57: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

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

Line 58: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

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.

Line 59: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

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';

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 4939: FND_MSG_PUB.ADD;

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:

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 13517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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,

Line 13518: FND_MSG_PUB.add_exc_msg(g_pkg_name,'address_echeck');

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,

Line 13520: FND_MSG_PUB.count_and_get(

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: );

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 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 21567: FND_MSG_PUB.ADD;

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:

Line 21661: FND_MSG_PUB.ADD;

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: