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_PROD_RELN_PKG dependencies on FND_API

Line 70: DECODE( px_discount_product_reln_id, FND_API.G_MISS_NUM, NULL, px_discount_product_reln_id),

66: last_updated_by,
67: last_update_login,
68: object_version_number
69: ) VALUES (
70: DECODE( px_discount_product_reln_id, FND_API.G_MISS_NUM, NULL, px_discount_product_reln_id),
71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

67: last_update_login,
68: object_version_number
69: ) VALUES (
70: DECODE( px_discount_product_reln_id, FND_API.G_MISS_NUM, NULL, px_discount_product_reln_id),
71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),

68: object_version_number
69: ) VALUES (
70: DECODE( px_discount_product_reln_id, FND_API.G_MISS_NUM, NULL, px_discount_product_reln_id),
71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

69: ) VALUES (
70: DECODE( px_discount_product_reln_id, FND_API.G_MISS_NUM, NULL, px_discount_product_reln_id),
71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

70: DECODE( px_discount_product_reln_id, FND_API.G_MISS_NUM, NULL, px_discount_product_reln_id),
71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

Line 75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

71: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
79:

Line 76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

72: DECODE( p_off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id),
73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
79:
80: END Insert_Row;

Line 77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

73: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
79:
80: END Insert_Row;
81:

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

74: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
79:
80: END Insert_Row;
81:
82:

Line 111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),

107: IS
108: BEGIN
109: Update ozf_discount_product_reln
110: SET
111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),
112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),

108: BEGIN
109: Update ozf_discount_product_reln
110: SET
111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),
112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),

109: Update ozf_discount_product_reln
110: SET
111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),
112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = nvl(p_object_version_number,0) + 1

Line 114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

110: SET
111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),
112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = nvl(p_object_version_number,0) + 1
118: WHERE discount_product_reln_id = p_discount_product_reln_id

Line 115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),
112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = nvl(p_object_version_number,0) + 1
118: WHERE discount_product_reln_id = p_discount_product_reln_id
119: AND object_version_number = p_object_version_number;

Line 116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
114: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = nvl(p_object_version_number,0) + 1
118: WHERE discount_product_reln_id = p_discount_product_reln_id
119: AND object_version_number = p_object_version_number;
120:

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: AND object_version_number = p_object_version_number;
120:
121:
122: IF (SQL%NOTFOUND) THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126:
127: END Update_Row;

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: DELETE FROM ozf_discount_product_reln
150: WHERE discount_product_reln_id = p_discount_product_reln_id
151: AND object_version_number = p_object_version_number;
152: If (SQL%NOTFOUND) then
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: End If;
155: END Delete_Row ;
156:
157: -- ========================================================

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: DELETE FROM ozf_discount_product_reln
176: WHERE offer_discount_line_id = p_offer_discount_line_id;
177:
178: If (SQL%NOTFOUND) then
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: End If;
181:
182: END DELETE;
183:

Line 216: RAISE FND_API.g_exc_error;

212: FETCH c INTO Recinfo;
213: IF (c%NOTFOUND) THEN
214: CLOSE c;
215: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
216: RAISE FND_API.g_exc_error;
217: END IF;
218: CLOSE c;
219: END Lock_Row;
220: