DBA Data[Home] [Help]

APPS.OZF_WEBADI_INTERFACE_PVT dependencies on FND_PROFILE

Line 217: WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID')

213: AND party_id IS NULL and cust_account_id IS NULL;
214:
215: CURSOR get_item_id(p_item_name VARCHAR2)IS
216: SELECT INVENTORY_ITEM_ID ID FROM MTL_SYSTEM_ITEMS_VL
217: WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID')
218: AND CONCATENATED_SEGMENTS = p_item_name;
219:
220: BEGIN
221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 1169: l_file_dir := FND_PROFILE.VALUE('BNE_SERVER_LOG_PATH');

1165: ---End Bugfix 10234121 ----------------------------------------------------------------------
1166:
1167: -- Writing to a file to record the data and debug for any problems
1168:
1169: l_file_dir := FND_PROFILE.VALUE('BNE_SERVER_LOG_PATH');
1170:
1171: IF l_file_dir IS NULL THEN
1172:
1173: OPEN C;

Line 1361: l_partner_party_id := FND_PROFILE.VALUE('OZF_IDSM_ORDER_SRC_PARTY_ID');

1357: Checking the profile of partner party and if it same
1358: as that of the party uploading the batch then the batch is considered
1359: as the direct batch. i.e., setting the direct_order_flag as 'Y'
1360: */
1361: l_partner_party_id := FND_PROFILE.VALUE('OZF_IDSM_ORDER_SRC_PARTY_ID');
1362:
1363: IF P_PARTNER_PARTY_ID = l_partner_party_id THEN
1364: IF p_batch_type <> 'TRACING' THEN
1365: fnd_message.set_name ('OZF', 'OZF_DIRECT_ORDER_TRC_ERR');