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

Line 76: DECODE( px_initiation_source_id, FND_API.G_MISS_NUM, NULL, px_initiation_source_id),

72: last_updated_by,
73: last_update_date,
74: last_update_login
75: ) VALUES (
76: DECODE( px_initiation_source_id, FND_API.G_MISS_NUM, NULL, px_initiation_source_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),

Line 77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

73: last_update_date,
74: last_update_login
75: ) VALUES (
76: DECODE( px_initiation_source_id, FND_API.G_MISS_NUM, NULL, px_initiation_source_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),

74: last_update_login
75: ) VALUES (
76: DECODE( px_initiation_source_id, FND_API.G_MISS_NUM, NULL, px_initiation_source_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),

75: ) VALUES (
76: DECODE( px_initiation_source_id, FND_API.G_MISS_NUM, NULL, px_initiation_source_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),

76: DECODE( px_initiation_source_id, FND_API.G_MISS_NUM, NULL, px_initiation_source_id),
77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

77: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
85: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

78: DECODE( p_enrl_request_id, FND_API.G_MISS_NUM, NULL, p_enrl_request_id),
79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
85: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
86:

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

79: DECODE( p_prev_membership_id, FND_API.G_MISS_NUM, NULL, p_prev_membership_id),
80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
85: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
86:
87: END Insert_Row;

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

80: DECODE( p_enrl_change_rule_id, FND_API.G_MISS_NUM, NULL, p_enrl_change_rule_id),
81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
85: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
86:
87: END Insert_Row;
88:

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

81: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
82: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
83: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
84: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
85: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
86:
87: END Insert_Row;
88:
89:

Line 118: initiation_source_id = DECODE( p_initiation_source_id, null, initiation_source_id, FND_API.G_MISS_NUM, null, p_initiation_source_id),

114: IS
115: BEGIN
116: Update pv_pg_enrq_init_sources
117: SET
118: initiation_source_id = DECODE( p_initiation_source_id, null, initiation_source_id, FND_API.G_MISS_NUM, null, p_initiation_source_id),
119: object_version_number = nvl(p_object_version_number,0) + 1 ,
120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),

Line 120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),

116: Update pv_pg_enrq_init_sources
117: SET
118: initiation_source_id = DECODE( p_initiation_source_id, null, initiation_source_id, FND_API.G_MISS_NUM, null, p_initiation_source_id),
119: object_version_number = nvl(p_object_version_number,0) + 1 ,
120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
123: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),

117: SET
118: initiation_source_id = DECODE( p_initiation_source_id, null, initiation_source_id, FND_API.G_MISS_NUM, null, p_initiation_source_id),
119: object_version_number = nvl(p_object_version_number,0) + 1 ,
120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
123: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),

118: initiation_source_id = DECODE( p_initiation_source_id, null, initiation_source_id, FND_API.G_MISS_NUM, null, p_initiation_source_id),
119: object_version_number = nvl(p_object_version_number,0) + 1 ,
120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
123: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
126: WHERE initiation_source_id = p_initiation_source_id

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

119: object_version_number = nvl(p_object_version_number,0) + 1 ,
120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
123: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
126: WHERE initiation_source_id = p_initiation_source_id
127: AND object_version_number = p_object_version_number;

Line 124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

120: enrl_request_id = DECODE( p_enrl_request_id, null, enrl_request_id, FND_API.G_MISS_NUM, null, p_enrl_request_id),
121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
123: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
126: WHERE initiation_source_id = p_initiation_source_id
127: AND object_version_number = p_object_version_number;
128:

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

121: prev_membership_id = DECODE( p_prev_membership_id, null, prev_membership_id, FND_API.G_MISS_NUM, null, p_prev_membership_id),
122: enrl_change_rule_id = DECODE( p_enrl_change_rule_id, null, enrl_change_rule_id, FND_API.G_MISS_NUM, null, p_enrl_change_rule_id),
123: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
124: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
125: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
126: WHERE initiation_source_id = p_initiation_source_id
127: AND object_version_number = p_object_version_number;
128:
129:

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: AND object_version_number = p_object_version_number;
128:
129:
130: IF (SQL%NOTFOUND) THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134:
135: END Update_Row;

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: DELETE FROM pv_pg_enrq_init_sources
158: WHERE initiation_source_id = p_initiation_source_id
159: AND object_version_number = p_object_version_number;
160: If (SQL%NOTFOUND) then
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: End If;
163: END Delete_Row ;
164:
165:

Line 199: RAISE FND_API.g_exc_error;

195: FETCH c INTO Recinfo;
196: IF (c%NOTFOUND) THEN
197: CLOSE c;
198: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
199: RAISE FND_API.g_exc_error;
200: END IF;
201: CLOSE c;
202: END Lock_Row;
203: