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

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81:
82: l_object_version_number := nvl(p_object_version_number, 1);
83:
84: -- Initialize API return status to SUCCESS
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: INSERT INTO pv_partner_accesses(
88: partner_access_id,
89: partner_id,

Line 122: DECODE( px_partner_access_id, FND_API.G_MISS_NUM, NULL, px_partner_access_id),

118: attribute13,
119: attribute14,
120: attribute15
121: ) VALUES (
122: DECODE( px_partner_access_id, FND_API.G_MISS_NUM, NULL, px_partner_access_id),
123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),

Line 123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),

119: attribute14,
120: attribute15
121: ) VALUES (
122: DECODE( px_partner_access_id, FND_API.G_MISS_NUM, NULL, px_partner_access_id),
123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),

Line 124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),

120: attribute15
121: ) VALUES (
122: DECODE( px_partner_access_id, FND_API.G_MISS_NUM, NULL, px_partner_access_id),
123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),

Line 125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),

121: ) VALUES (
122: DECODE( px_partner_access_id, FND_API.G_MISS_NUM, NULL, px_partner_access_id),
123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),

Line 126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),

122: DECODE( px_partner_access_id, FND_API.G_MISS_NUM, NULL, px_partner_access_id),
123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),

123: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),

Line 128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),

124: DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id),
125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),

Line 129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),

125: DECODE( p_keep_flag, FND_API.g_miss_char, NULL, p_keep_flag),
126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

126: DECODE( p_created_by_tap_flag, FND_API.g_miss_char, NULL, p_created_by_tap_flag),
127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),

Line 131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),

127: DECODE( p_access_type, FND_API.g_miss_char, NULL, p_access_type),
128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

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

128: DECODE( p_vad_partner_id, FND_API.G_MISS_NUM, NULL, p_vad_partner_id),
129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

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

129: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_last_update_date),
130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),

Line 134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),

130: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

Line 135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),

131: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE,NULL, SYSDATE, p_creation_date),
132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),

132: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID,NULL, FND_GLOBAL.USER_ID, p_created_by),
133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),

133: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),

134: DECODE( p_object_version_number,FND_API.G_MISS_NUM, l_object_version_number, NULL, l_object_version_number, p_object_version_number),
135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

135: DECODE( p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id),
136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

136: DECODE( p_program_application_id, FND_API.G_MISS_NUM, NULL, p_program_application_id),
137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

137: DECODE( p_program_id, FND_API.G_MISS_NUM, NULL, p_program_id),
138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

138: DECODE( p_program_update_date, FND_API.G_MISS_DATE, NULL, p_program_update_date),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

Line 151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:

Line 152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:
156: EXCEPTION

Line 153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:
156: EXCEPTION
157: WHEN OTHERS THEN

Line 154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: ROLLBACK TO Insert_PAccesses_Row ;

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: ROLLBACK TO Insert_PAccesses_Row ;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160:
161: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: -- Standard Start of API savepoint
218: SAVEPOINT Update_PAccesses_Row ;
219:
220: -- Initialize API return status to SUCCESS
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: Update pv_partner_accesses
224: SET
225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),

Line 225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),

221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: Update pv_partner_accesses
224: SET
225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),

Line 226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

222:
223: Update pv_partner_accesses
224: SET
225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),

Line 227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),

223: Update pv_partner_accesses
224: SET
225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),

Line 228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),

224: SET
225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),

225: partner_access_id = DECODE( p_partner_access_id, null, partner_access_id, FND_API.G_MISS_NUM, null, p_partner_access_id),
226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),

226: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),

227: resource_id = DECODE( p_resource_id, null, resource_id, FND_API.G_MISS_NUM, null, p_resource_id),
228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,

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

228: keep_flag = DECODE( p_keep_flag, null, keep_flag, FND_API.g_miss_char, null, p_keep_flag),
229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),

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

229: created_by_tap_flag = DECODE( p_created_by_tap_flag, null, created_by_tap_flag, FND_API.g_miss_char, null, p_created_by_tap_flag),
230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),

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

230: access_type = DECODE( p_access_type, null, access_type, FND_API.g_miss_char, null, p_access_type),
231: vad_partner_id = DECODE( p_vad_partner_id, null, vad_partner_id, FND_API.G_MISS_NUM, null, p_vad_partner_id),
232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),

Line 236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),

232: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

Line 237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),

233: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

Line 238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),

234: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

Line 239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),

235: object_version_number = nvl(p_object_version_number,0) + 1 ,
236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

Line 240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),

236: request_id = DECODE( p_request_id, null, request_id, FND_API.G_MISS_NUM, null, p_request_id),
237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

Line 241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),

237: program_application_id = DECODE( p_program_application_id, null, program_application_id, FND_API.G_MISS_NUM, null, p_program_application_id),
238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

Line 242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),

238: program_id = DECODE( p_program_id, null, program_id, FND_API.G_MISS_NUM, null, p_program_id),
239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

Line 243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),

239: program_update_date = DECODE( p_program_update_date, null, program_update_date, FND_API.G_MISS_DATE, null, p_program_update_date),
240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

Line 244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),

240: attribute_category = DECODE( p_attribute_category, null, attribute_category, FND_API.g_miss_char, null, p_attribute_category),
241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

Line 245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),

241: attribute1 = DECODE( p_attribute1, null, attribute1, FND_API.g_miss_char, null, p_attribute1),
242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

Line 246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),

242: attribute2 = DECODE( p_attribute2, null, attribute2, FND_API.g_miss_char, null, p_attribute2),
243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

Line 247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),

243: attribute3 = DECODE( p_attribute3, null, attribute3, FND_API.g_miss_char, null, p_attribute3),
244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

Line 248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),

244: attribute4 = DECODE( p_attribute4, null, attribute4, FND_API.g_miss_char, null, p_attribute4),
245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

Line 249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),

245: attribute5 = DECODE( p_attribute5, null, attribute5, FND_API.g_miss_char, null, p_attribute5),
246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

Line 250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),

246: attribute6 = DECODE( p_attribute6, null, attribute6, FND_API.g_miss_char, null, p_attribute6),
247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

Line 251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),

247: attribute7 = DECODE( p_attribute7, null, attribute7, FND_API.g_miss_char, null, p_attribute7),
248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
255: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

Line 252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),

248: attribute8 = DECODE( p_attribute8, null, attribute8, FND_API.g_miss_char, null, p_attribute8),
249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
255: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
256: WHERE partner_access_id = p_partner_access_id

Line 253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),

249: attribute9 = DECODE( p_attribute9, null, attribute9, FND_API.g_miss_char, null, p_attribute9),
250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
255: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
256: WHERE partner_access_id = p_partner_access_id
257: AND object_version_number = p_object_version_number;

Line 254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),

250: attribute10 = DECODE( p_attribute10, null, attribute10, FND_API.g_miss_char, null, p_attribute10),
251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
255: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
256: WHERE partner_access_id = p_partner_access_id
257: AND object_version_number = p_object_version_number;
258:

Line 255: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)

251: attribute11 = DECODE( p_attribute11, null, attribute11, FND_API.g_miss_char, null, p_attribute11),
252: attribute12 = DECODE( p_attribute12, null, attribute12, FND_API.g_miss_char, null, p_attribute12),
253: attribute13 = DECODE( p_attribute13, null, attribute13, FND_API.g_miss_char, null, p_attribute13),
254: attribute14 = DECODE( p_attribute14, null, attribute14, FND_API.g_miss_char, null, p_attribute14),
255: attribute15 = DECODE( p_attribute15, null, attribute15, FND_API.g_miss_char, null, p_attribute15)
256: WHERE partner_access_id = p_partner_access_id
257: AND object_version_number = p_object_version_number;
258:
259:

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: AND object_version_number = p_object_version_number;
258:
259:
260: IF (SQL%NOTFOUND) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: EXCEPTION
265:

Line 266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

262: END IF;
263:
264: EXCEPTION
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ROLLBACK TO Update_PAccesses_Row ;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269:
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

264: EXCEPTION
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ROLLBACK TO Update_PAccesses_Row ;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269:
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

273: END IF;
274:
275: WHEN OTHERS THEN
276: ROLLBACK TO Update_PAccesses_Row ;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 310: x_return_status := FND_API.G_RET_STS_SUCCESS;

306: -- Standard Start of API savepoint
307: SAVEPOINT Delete_PAccesses_Row;
308:
309: -- Initialize API return status to SUCCESS
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: DELETE FROM pv_partner_accesses
313: WHERE partner_access_id = p_partner_access_id
314: AND object_version_number = p_object_version_number;

Line 316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

312: DELETE FROM pv_partner_accesses
313: WHERE partner_access_id = p_partner_access_id
314: AND object_version_number = p_object_version_number;
315: If (SQL%NOTFOUND) then
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: End If;
318:
319: EXCEPTION
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: End If;
318:
319: EXCEPTION
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: ROLLBACK TO Delete_PAccesses_Row;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323:
324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318:
319: EXCEPTION
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: ROLLBACK TO Delete_PAccesses_Row;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323:
324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327: END IF;
328:
329: WHEN OTHERS THEN
330: ROLLBACK TO Delete_PAccesses_Row;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332:
333: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
334: THEN
335: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 372: x_return_status := FND_API.G_RET_STS_SUCCESS;

368: -- Standard Start of API savepoint
369: SAVEPOINT Lock_PAccesses_Row;
370:
371: -- Initialize API return status to SUCCESS
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: OPEN c;
375: FETCH c INTO Recinfo;
376: IF (c%NOTFOUND) THEN

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: FETCH c INTO Recinfo;
376: IF (c%NOTFOUND) THEN
377: CLOSE c;
378: PVX_Utility_PVT.error_message ('PV_API_RECORD_NOT_FOUND');
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: CLOSE c;
382: EXCEPTION
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: CLOSE c;
382: EXCEPTION
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: ROLLBACK TO Lock_PAccesses_Row;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386:
387: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: CLOSE c;
382: EXCEPTION
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: ROLLBACK TO Lock_PAccesses_Row;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386:
387: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
388: THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
390: END IF;
391: WHEN OTHERS THEN
392: ROLLBACK TO Lock_PAccesses_Row;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394:
395: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);