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

Line 2841: l_return_status := fnd_api.g_ret_sts_success;

2837: --Standard start of API savepoint
2838: SAVEPOINT create_adv_stnd_unit;
2839: fnd_msg_pub.initialize;
2840: --Initialize API return status to success.
2841: l_return_status := fnd_api.g_ret_sts_success;
2842: l_unit_cd := UPPER (l_unit_cd);
2843: l_prev_institution_code := UPPER (l_prev_institution_code);
2844:
2845: IF validate_parameters (p_batch_id => p_batch_id,

Line 3119: l_return_status := fnd_api.g_ret_sts_error;

3115: || l_av_stnd_unit_lvl_id
3116: );
3117: ELSE -- validate_unit
3118: write_message ('Error 3');
3119: l_return_status := fnd_api.g_ret_sts_error;
3120: END IF; --validate_unit
3121: ELSE -- validate_std_unt_db_cons
3122: l_return_status := fnd_api.g_ret_sts_error;
3123: write_message ('Error 4');

Line 3122: l_return_status := fnd_api.g_ret_sts_error;

3118: write_message ('Error 3');
3119: l_return_status := fnd_api.g_ret_sts_error;
3120: END IF; --validate_unit
3121: ELSE -- validate_std_unt_db_cons
3122: l_return_status := fnd_api.g_ret_sts_error;
3123: write_message ('Error 4');
3124: END IF; --validate_std_unt_db_cons
3125: ELSE
3126: write_message (' Updating igs_av_stnd_unit_all');

Line 3206: l_return_status := fnd_api.g_ret_sts_error;

3202: p_prev_institution_code => l_prev_institution_code
3203: )
3204: THEN
3205: write_message ('Error 2');
3206: l_return_status := fnd_api.g_ret_sts_error;
3207: END IF; --create_post_unit
3208: ELSE -- validate_adv_stnd
3209: l_return_status := fnd_api.g_ret_sts_error;
3210: write_message ('Error 8');

Line 3209: l_return_status := fnd_api.g_ret_sts_error;

3205: write_message ('Error 2');
3206: l_return_status := fnd_api.g_ret_sts_error;
3207: END IF; --create_post_unit
3208: ELSE -- validate_adv_stnd
3209: l_return_status := fnd_api.g_ret_sts_error;
3210: write_message ('Error 8');
3211: END IF; --validate_adv_stnd
3212: ELSE -- validate_adv_std_db_cons
3213: l_return_status := fnd_api.g_ret_sts_error;

Line 3213: l_return_status := fnd_api.g_ret_sts_error;

3209: l_return_status := fnd_api.g_ret_sts_error;
3210: write_message ('Error 8');
3211: END IF; --validate_adv_stnd
3212: ELSE -- validate_adv_std_db_cons
3213: l_return_status := fnd_api.g_ret_sts_error;
3214: write_message ('Error 9');
3215: END IF; --validate_adv_std_db_cons
3216: ELSE -- derive_unit_data
3217: l_return_status := fnd_api.g_ret_sts_error;

Line 3217: l_return_status := fnd_api.g_ret_sts_error;

3213: l_return_status := fnd_api.g_ret_sts_error;
3214: write_message ('Error 9');
3215: END IF; --validate_adv_std_db_cons
3216: ELSE -- derive_unit_data
3217: l_return_status := fnd_api.g_ret_sts_error;
3218: write_message ('Error 10');
3219: END IF; -- derive_unit_data
3220: ELSE -- validate_parameters
3221: l_return_status := fnd_api.g_ret_sts_error;

Line 3221: l_return_status := fnd_api.g_ret_sts_error;

3217: l_return_status := fnd_api.g_ret_sts_error;
3218: write_message ('Error 10');
3219: END IF; -- derive_unit_data
3220: ELSE -- validate_parameters
3221: l_return_status := fnd_api.g_ret_sts_error;
3222: write_message ('Error 11');
3223: END IF; --validate_parameters
3224:
3225: /* IF l_return_status IN (fnd_api.g_ret_sts_error, 'E', 'W')

Line 3225: /* IF l_return_status IN (fnd_api.g_ret_sts_error, 'E', 'W')

3221: l_return_status := fnd_api.g_ret_sts_error;
3222: write_message ('Error 11');
3223: END IF; --validate_parameters
3224:
3225: /* IF l_return_status IN (fnd_api.g_ret_sts_error, 'E', 'W')
3226: THEN
3227: write_message ('************************ Roll Back ********************');
3228: ROLLBACK TO create_adv_stnd_unit;
3229: END IF;*/

Line 3254: WHEN fnd_api.g_exc_error

3250: l_return_status := 'W';
3251: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3252: p_data => l_msg_data
3253: );
3254: WHEN fnd_api.g_exc_error
3255: THEN
3256: -- ROLLBACK TO create_adv_stnd_unit;
3257: notify_error (p_batch_id,
3258: l_person_id,

Line 3262: l_return_status := fnd_api.g_ret_sts_error;

3258: l_person_id,
3259: p_program_cd,
3260: 'Error has occurred.See log for Details'
3261: );
3262: l_return_status := fnd_api.g_ret_sts_error;
3263: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3264: p_data => l_msg_data
3265: );
3266: WHEN fnd_api.g_exc_unexpected_error

Line 3266: WHEN fnd_api.g_exc_unexpected_error

3262: l_return_status := fnd_api.g_ret_sts_error;
3263: fnd_msg_pub.count_and_get (p_count => l_msg_count,
3264: p_data => l_msg_data
3265: );
3266: WHEN fnd_api.g_exc_unexpected_error
3267: THEN
3268: -- ROLLBACK TO create_adv_stnd_unit;
3269: l_return_status := fnd_api.g_ret_sts_unexp_error;
3270: notify_error (p_batch_id,

Line 3269: l_return_status := fnd_api.g_ret_sts_unexp_error;

3265: );
3266: WHEN fnd_api.g_exc_unexpected_error
3267: THEN
3268: -- ROLLBACK TO create_adv_stnd_unit;
3269: l_return_status := fnd_api.g_ret_sts_unexp_error;
3270: notify_error (p_batch_id,
3271: l_person_id,
3272: p_program_cd,
3273: 'Error has occurred.See log for Details'

Line 3287: l_return_status := fnd_api.g_ret_sts_unexp_error;

3283: 'Error has occurred.See log for Details'
3284: );
3285: write_message('ERROR ' || sqlerrm);
3286: -- ROLLBACK TO create_adv_stnd_unit;
3287: l_return_status := fnd_api.g_ret_sts_unexp_error;
3288: fnd_message.set_name ('IGS', 'IGS_AV_UNHANDLED_ERROR');
3289: fnd_message.set_token ('ERROR', SQLERRM);
3290: fnd_msg_pub.ADD;
3291: notify_error (p_batch_id,