DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_PVT dependencies on FND_GLOBAL

Line 189: , p_resp_appl_id => fnd_global.resp_appl_id

185: , p_desc_segment13 => p_index_constraint_tbl(i).attribute13
186: , p_desc_segment14 => p_index_constraint_tbl(i).attribute14
187: , p_desc_segment15 => p_index_constraint_tbl(i).attribute15
188: , p_desc_context => p_index_constraint_tbl(i).attribute_category
189: , p_resp_appl_id => fnd_global.resp_appl_id
190: , p_resp_id => fnd_global.resp_id
191: , p_return_status => x_return_status
192: );
193: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 190: , p_resp_id => fnd_global.resp_id

186: , p_desc_segment14 => p_index_constraint_tbl(i).attribute14
187: , p_desc_segment15 => p_index_constraint_tbl(i).attribute15
188: , p_desc_context => p_index_constraint_tbl(i).attribute_category
189: , p_resp_appl_id => fnd_global.resp_appl_id
190: , p_resp_id => fnd_global.resp_id
191: , p_return_status => x_return_status
192: );
193: IF (x_return_status = fnd_api.g_ret_sts_error)
194: THEN

Line 346: , p_resp_appl_id => fnd_global.resp_appl_id

342: , p_desc_segment13 => p_rent_index_rec.attribute13
343: , p_desc_segment14 => p_rent_index_rec.attribute14
344: , p_desc_segment15 => p_rent_index_rec.attribute15
345: , p_desc_context => p_rent_index_rec.attribute_category
346: , p_resp_appl_id => fnd_global.resp_appl_id
347: , p_resp_id => fnd_global.resp_id
348: , p_return_status => x_return_status
349: );
350: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 347: , p_resp_id => fnd_global.resp_id

343: , p_desc_segment14 => p_rent_index_rec.attribute14
344: , p_desc_segment15 => p_rent_index_rec.attribute15
345: , p_desc_context => p_rent_index_rec.attribute_category
346: , p_resp_appl_id => fnd_global.resp_appl_id
347: , p_resp_id => fnd_global.resp_id
348: , p_return_status => x_return_status
349: );
350: IF (x_return_status = fnd_api.g_ret_sts_error)
351: THEN

Line 488: , p_resp_appl_id => fnd_global.resp_appl_id

484: , p_desc_segment13 => p_rent_index_rec.agreement_attribute13
485: , p_desc_segment14 => p_rent_index_rec.agreement_attribute14
486: , p_desc_segment15 => p_rent_index_rec.agreement_attribute15
487: , p_desc_context => p_rent_index_rec.agreement_category
488: , p_resp_appl_id => fnd_global.resp_appl_id
489: , p_resp_id => fnd_global.resp_id
490: , p_return_status => x_return_status
491: );
492: IF (x_return_status = fnd_api.g_ret_sts_error)

Line 489: , p_resp_id => fnd_global.resp_id

485: , p_desc_segment14 => p_rent_index_rec.agreement_attribute14
486: , p_desc_segment15 => p_rent_index_rec.agreement_attribute15
487: , p_desc_context => p_rent_index_rec.agreement_category
488: , p_resp_appl_id => fnd_global.resp_appl_id
489: , p_resp_id => fnd_global.resp_id
490: , p_return_status => x_return_status
491: );
492: IF (x_return_status = fnd_api.g_ret_sts_error)
493: THEN

Line 1198: , fnd_global.user_id)

1194: , x_termination_date => p_rent_index_rec.termination_date
1195: , x_index_lease_number => p_rent_index_rec.index_lease_number
1196: , x_last_update_date => NVL (p_rent_index_rec.last_update_date, TRUNC(SYSDATE))
1197: , x_last_updated_by => NVL (p_rent_index_rec.last_updated_by
1198: , fnd_global.user_id)
1199: , x_location_id => p_rent_index_rec.location_id
1200: , x_term_template_id => p_rent_index_rec.term_template_id
1201: , x_abstracted_by => p_rent_index_rec.abstracted_by
1202: , x_assessment_date => p_rent_index_rec.assessment_date

Line 1222: , fnd_global.user_id)

1218: , x_rounding_flag => p_rent_index_rec.rounding_flag
1219: , x_aggregation_flag => p_rent_index_rec.aggregation_flag
1220: , x_gross_flag => NVL (p_rent_index_rec.gross_flag, 'N')
1221: , x_last_update_login => NVL (p_rent_index_rec.last_update_login
1222: , fnd_global.user_id)
1223: , x_attribute_category => p_rent_index_rec.attribute_category
1224: , x_attribute1 => p_rent_index_rec.attribute1
1225: , x_attribute2 => p_rent_index_rec.attribute2
1226: , x_attribute3 => p_rent_index_rec.attribute3

Line 1328: , fnd_global.user_id)

1324: , x_index_lease_number => p_rent_index_rec.index_lease_number
1325: , x_last_update_date => NVL (p_rent_index_rec.last_update_date
1326: , TRUNC(SYSDATE))
1327: , x_last_updated_by => NVL (p_rent_index_rec.last_updated_by
1328: , fnd_global.user_id)
1329: , x_creation_date => NVL (p_rent_index_rec.creation_date, TRUNC(SYSDATE))
1330: , x_created_by => NVL (p_rent_index_rec.created_by
1331: , fnd_global.user_id)
1332: , x_location_id => p_rent_index_rec.location_id

Line 1331: , fnd_global.user_id)

1327: , x_last_updated_by => NVL (p_rent_index_rec.last_updated_by
1328: , fnd_global.user_id)
1329: , x_creation_date => NVL (p_rent_index_rec.creation_date, TRUNC(SYSDATE))
1330: , x_created_by => NVL (p_rent_index_rec.created_by
1331: , fnd_global.user_id)
1332: , x_location_id => p_rent_index_rec.location_id
1333: , x_term_template_id => p_rent_index_rec.term_template_id
1334: , x_abstracted_by => p_rent_index_rec.abstracted_by
1335: , x_assessment_date => p_rent_index_rec.assessment_date

Line 1355: , fnd_global.user_id)

1351: , x_rounding_flag => p_rent_index_rec.rounding_flag
1352: , x_aggregation_flag => p_rent_index_rec.aggregation_flag
1353: , x_gross_flag => NVL (p_rent_index_rec.gross_flag, 'N')
1354: , x_last_update_login => NVL (p_rent_index_rec.last_update_login
1355: , fnd_global.user_id)
1356: , x_attribute_category => p_rent_index_rec.attribute_category
1357: , x_attribute1 => p_rent_index_rec.attribute1
1358: , x_attribute2 => p_rent_index_rec.attribute2
1359: , x_attribute3 => p_rent_index_rec.attribute3

Line 3544: -- , x_created_by => NVL(p_index_constraint_rec.created_by, fnd_global.user_id)

3540: , x_attribute13 => p_index_constraint_rec.attribute13
3541: , x_attribute14 => p_index_constraint_rec.attribute14
3542: , x_attribute15 => p_index_constraint_rec.attribute15
3543: -- , x_creation_date => NVL(p_index_constraint_rec.last_update_date, TRUNC(SYSDATE))
3544: -- , x_created_by => NVL(p_index_constraint_rec.created_by, fnd_global.user_id)
3545: , x_last_update_date => NVL
3546: (p_index_constraint_rec.last_update_date
3547: , TRUNC(SYSDATE))
3548: , x_last_updated_by => NVL

Line 3550: , fnd_global.user_id)

3546: (p_index_constraint_rec.last_update_date
3547: , TRUNC(SYSDATE))
3548: , x_last_updated_by => NVL
3549: (p_index_constraint_rec.last_updated_by
3550: , fnd_global.user_id)
3551: , x_last_update_login => NVL
3552: (p_index_constraint_rec.last_update_login
3553: , fnd_global.user_id));
3554:

Line 3553: , fnd_global.user_id));

3549: (p_index_constraint_rec.last_updated_by
3550: , fnd_global.user_id)
3551: , x_last_update_login => NVL
3552: (p_index_constraint_rec.last_update_login
3553: , fnd_global.user_id));
3554:
3555:
3556: pn_index_rent_pvt.DEBUG ( g_pkg_name
3557: || g_program_unit||

Line 3647: , fnd_global.user_id)

3643: (p_index_constraint_rec.last_update_date
3644: , TRUNC(SYSDATE))
3645: , x_created_by => NVL
3646: (p_index_constraint_rec.created_by
3647: , fnd_global.user_id)
3648: , x_last_update_date => NVL
3649: (p_index_constraint_rec.last_update_date
3650: , TRUNC(SYSDATE))
3651: , x_last_updated_by => NVL

Line 3653: , fnd_global.user_id)

3649: (p_index_constraint_rec.last_update_date
3650: , TRUNC(SYSDATE))
3651: , x_last_updated_by => NVL
3652: (p_index_constraint_rec.last_updated_by
3653: , fnd_global.user_id)
3654: , x_last_update_login => NVL
3655: (p_index_constraint_rec.last_update_login
3656: , fnd_global.user_id));
3657:

Line 3656: , fnd_global.user_id));

3652: (p_index_constraint_rec.last_updated_by
3653: , fnd_global.user_id)
3654: , x_last_update_login => NVL
3655: (p_index_constraint_rec.last_update_login
3656: , fnd_global.user_id));
3657:
3658: pn_index_rent_pvt.DEBUG ( g_pkg_name
3659: || g_program_unit||
3660: ' - pn_index_lease_constraints_pkg.insert_row successful.Index_constraint_id - '||p_index_constraint_rec.index_constraint_id

Line 4340: IF p_rent_index_rec.org_id<>fnd_global.org_id

4336: x_return_status := fnd_api.g_ret_sts_success;
4337:
4338: IF p_rent_index_rec.org_id IS NOT NULL AND p_rent_index_rec.org_id<>pn_index_rent_utils.g_pn_miss_num
4339: THEN
4340: IF p_rent_index_rec.org_id<>fnd_global.org_id
4341: THEN
4342: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4343: fnd_message.set_token('ERR_MSG', 'Operating unit provided do not exists in the list of Operating Units that are allowed access to, for a responsibility');
4344: fnd_msg_pub.ADD;

Line 4541: IF p_rent_index_rec.org_id<>fnd_global.org_id

4537: x_return_status := fnd_api.g_ret_sts_success;
4538:
4539: IF p_rent_index_rec.org_id IS NOT NULL AND p_rent_index_rec.org_id<>pn_index_rent_utils.g_pn_miss_num
4540: THEN
4541: IF p_rent_index_rec.org_id<>fnd_global.org_id
4542: THEN
4543: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4544: fnd_message.set_token('ERR_MSG', 'Operating unit provided do not exists in the list of Operating Units that are allowed access to, for a responsibility');
4545: fnd_msg_pub.ADD;