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.OZF_VOL_OFFR_PKG dependencies on FND_API

Line 79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

75: p_tier_value_to,
76: p_volume_type,
77: p_active,
78: p_uom_code,
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
80:
81: END Insert_Row;
82:
83:

Line 119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),

115: OZF_UTILITY_PVT.debug_message('ver: ' || px_object_version_number);
116:
117: Update ozf_volume_offer_tiers
118: SET
119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),

Line 120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),

116:
117: Update ozf_volume_offer_tiers
118: SET
119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),

Line 121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),

117: Update ozf_volume_offer_tiers
118: SET
119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),

Line 122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),

118: SET
119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),

Line 123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),

119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),

Line 124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),

120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),
128: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),

Line 125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),

121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),
128: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
129: object_version_number = object_version_number + 1

Line 126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),

122: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),
128: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
129: object_version_number = object_version_number + 1
130: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id

Line 127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),

123: break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),
128: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
129: object_version_number = object_version_number + 1
130: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
131: AND object_version_number = px_object_version_number;

Line 128: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),

124: tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
125: tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
126: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
127: active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),
128: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
129: object_version_number = object_version_number + 1
130: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
131: AND object_version_number = px_object_version_number;
132:

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: AND object_version_number = px_object_version_number;
132:
133: IF (SQL%NOTFOUND) THEN
134: OZF_UTILITY_PVT.debug_message('no data found');
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: OZF_UTILITY_PVT.debug_message('after inserting');
138:
139: px_object_version_number := nvl(px_object_version_number,0) + 1;

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

163: DELETE FROM ozf_volume_offer_tiers
164: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
165: AND object_version_number = p_object_version_number;
166: If (SQL%NOTFOUND) then
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: End If;
169: END Delete_Row ;
170:
171:

Line 205: RAISE FND_API.g_exc_error;

201: FETCH c INTO Recinfo;
202: IF (c%NOTFOUND) THEN
203: CLOSE c;
204: OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');
205: RAISE FND_API.g_exc_error;
206: END IF;
207: CLOSE c;
208: END Lock_Row;
209: