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.IGI_CIS_UPDC dependencies on FND_MESSAGE

Line 105: Fnd_message.set_name('IGI','IGI_CIS_MISSING_SEQ');

101: END IF;
102: CLOSE c_gen_id;
103: EXCEPTION
104: WHEN INVALIDSEQ THEN
105: Fnd_message.set_name('IGI','IGI_CIS_MISSING_SEQ');
106: l_message:=fnd_message.get;
107: Debug(l_excep_level, 'GENERATE_TAX_RATE_ID', l_message);
108:
109: END GENERATE_TAX_RATE_ID;

Line 106: l_message:=fnd_message.get;

102: CLOSE c_gen_id;
103: EXCEPTION
104: WHEN INVALIDSEQ THEN
105: Fnd_message.set_name('IGI','IGI_CIS_MISSING_SEQ');
106: l_message:=fnd_message.get;
107: Debug(l_excep_level, 'GENERATE_TAX_RATE_ID', l_message);
108:
109: END GENERATE_TAX_RATE_ID;
110:

Line 241: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');

237: END IF;
238:
239: IF (p_new_certificate_type IS NOT NULL ) THEN
240:
241: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
242: Fnd_message.set_token('mode', p_mode);
243: Fnd_message.set_token('other_mode', 'Certificate Type' );
244: l_message:=Fnd_message.get;
245: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);

Line 242: Fnd_message.set_token('mode', p_mode);

238:
239: IF (p_new_certificate_type IS NOT NULL ) THEN
240:
241: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
242: Fnd_message.set_token('mode', p_mode);
243: Fnd_message.set_token('other_mode', 'Certificate Type' );
244: l_message:=Fnd_message.get;
245: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
246: END IF;

Line 243: Fnd_message.set_token('other_mode', 'Certificate Type' );

239: IF (p_new_certificate_type IS NOT NULL ) THEN
240:
241: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
242: Fnd_message.set_token('mode', p_mode);
243: Fnd_message.set_token('other_mode', 'Certificate Type' );
244: l_message:=Fnd_message.get;
245: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
246: END IF;
247:

Line 244: l_message:=Fnd_message.get;

240:
241: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
242: Fnd_message.set_token('mode', p_mode);
243: Fnd_message.set_token('other_mode', 'Certificate Type' );
244: l_message:=Fnd_message.get;
245: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
246: END IF;
247:
248: ELSE /*else for p_mode*/

Line 254: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');

250: Raise INVALID;
251: END IF;
252: IF (p_new_percentage IS NOT NULL ) THEN
253:
254: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
255: Fnd_message.set_token('mode', p_mode);
256: Fnd_message.set_token('other_mode', 'Percentage' );
257: l_message:=Fnd_message.get;
258: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);

Line 255: Fnd_message.set_token('mode', p_mode);

251: END IF;
252: IF (p_new_percentage IS NOT NULL ) THEN
253:
254: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
255: Fnd_message.set_token('mode', p_mode);
256: Fnd_message.set_token('other_mode', 'Percentage' );
257: l_message:=Fnd_message.get;
258: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
259: END IF;

Line 256: Fnd_message.set_token('other_mode', 'Percentage' );

252: IF (p_new_percentage IS NOT NULL ) THEN
253:
254: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
255: Fnd_message.set_token('mode', p_mode);
256: Fnd_message.set_token('other_mode', 'Percentage' );
257: l_message:=Fnd_message.get;
258: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
259: END IF;
260: END IF;

Line 257: l_message:=Fnd_message.get;

253:
254: Fnd_message.set_name('IGI','IGI_CIS_VALUES_NOT_MATCH');
255: Fnd_message.set_token('mode', p_mode);
256: Fnd_message.set_token('other_mode', 'Percentage' );
257: l_message:=Fnd_message.get;
258: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
259: END IF;
260: END IF;
261:

Line 347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');

343: UPDATE ap_awt_tax_rates
344: SET end_date = l_curr_end_date
345: WHERE rowid = l_certificate.rowid;
346:
347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);

Line 348: Fnd_message.set_token('vendor_name',l_vendor_name);

344: SET end_date = l_curr_end_date
345: WHERE rowid = l_certificate.rowid;
346:
347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);

Line 349: Fnd_message.set_token('vendor_site',l_vendor_site_code);

345: WHERE rowid = l_certificate.rowid;
346:
347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);

Line 350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

346:
347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;

Line 351: Fnd_message.set_token('tax_name',l_certificate.tax_name);

347: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);

Line 352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);

348: Fnd_message.set_token('vendor_name',l_vendor_name);
349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
356: Fnd_message.set_token('eff_to_date',l_curr_end_date);

Line 353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);

349: Fnd_message.set_token('vendor_site',l_vendor_site_code);
350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
356: Fnd_message.set_token('eff_to_date',l_curr_end_date);
357: l_message:=Fnd_message.get;

Line 354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;

350: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
356: Fnd_message.set_token('eff_to_date',l_curr_end_date);
357: l_message:=Fnd_message.get;
358: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);

Line 355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);

351: Fnd_message.set_token('tax_name',l_certificate.tax_name);
352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
356: Fnd_message.set_token('eff_to_date',l_curr_end_date);
357: l_message:=Fnd_message.get;
358: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
359:

Line 356: Fnd_message.set_token('eff_to_date',l_curr_end_date);

352: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
356: Fnd_message.set_token('eff_to_date',l_curr_end_date);
357: l_message:=Fnd_message.get;
358: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
359:
360: IF ((p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6') and (p_mode = 'Types')) THEN ---------------------(61)

Line 357: l_message:=Fnd_message.get;

353: Fnd_message.set_token('cert_number',l_certificate.certificate_number);
354: Fnd_message.set_token ('tax_rate',l_certificate.tax_rate ) ;
355: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
356: Fnd_message.set_token('eff_to_date',l_curr_end_date);
357: l_message:=Fnd_message.get;
358: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
359:
360: IF ((p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6') and (p_mode = 'Types')) THEN ---------------------(61)
361:

Line 362: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;

358: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
359:
360: IF ((p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6') and (p_mode = 'Types')) THEN ---------------------(61)
361:
362: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;
363: l_message:=Fnd_message.get;
364: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
365: END IF; -------------------------------------(61)
366:

Line 363: l_message:=Fnd_message.get;

359:
360: IF ((p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6') and (p_mode = 'Types')) THEN ---------------------(61)
361:
362: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;
363: l_message:=Fnd_message.get;
364: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
365: END IF; -------------------------------------(61)
366:
367:

Line 446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');

442: l_certificate.attribute14,
443: l_certificate.attribute15,
444: l_certificate.org_id);
445:
446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);

Line 447: Fnd_message.set_token('vendor_name',l_vendor_name);

443: l_certificate.attribute15,
444: l_certificate.org_id);
445:
446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);

Line 448: Fnd_message.set_token('vendor_site',l_vendor_site_code);

444: l_certificate.org_id);
445:
446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);

Line 449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);

445:
446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);

Line 450: Fnd_message.set_token('tax_name',l_certificate.tax_name);

446: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);

Line 451: Fnd_message.set_token('cert_type',l_certificate_type);

447: Fnd_message.set_token('vendor_name',l_vendor_name);
448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);
455: Fnd_message.set_token('eff_to_date',l_new_end_date);

Line 452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);

448: Fnd_message.set_token('vendor_site',l_vendor_site_code);
449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);
455: Fnd_message.set_token('eff_to_date',l_new_end_date);
456: L_message:=Fnd_message.get;

Line 453: Fnd_message.set_token('tax_rate' ,l_tax_rate);

449: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE.Cis_Tax_group);
450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);
455: Fnd_message.set_token('eff_to_date',l_new_end_date);
456: L_message:=Fnd_message.get;
457: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);

Line 454: Fnd_message.set_token('eff_from_date',l_new_start_date);

450: Fnd_message.set_token('tax_name',l_certificate.tax_name);
451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);
455: Fnd_message.set_token('eff_to_date',l_new_end_date);
456: L_message:=Fnd_message.get;
457: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
458:

Line 455: Fnd_message.set_token('eff_to_date',l_new_end_date);

451: Fnd_message.set_token('cert_type',l_certificate_type);
452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);
455: Fnd_message.set_token('eff_to_date',l_new_end_date);
456: L_message:=Fnd_message.get;
457: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
458:
459: /* Prepare a new record for the new percentage/new certificate type */

Line 456: L_message:=Fnd_message.get;

452: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
453: Fnd_message.set_token('tax_rate' ,l_tax_rate);
454: Fnd_message.set_token('eff_from_date',l_new_start_date);
455: Fnd_message.set_token('eff_to_date',l_new_end_date);
456: L_message:=Fnd_message.get;
457: Debug(l_state_level, 'upd_cis_cert_type_perc.msg1', l_message);
458:
459: /* Prepare a new record for the new percentage/new certificate type */
460:

Line 501: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');

497:
498:
499:
500:
501: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
502:
503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

Line 503: Fnd_message.set_token('vendor_name',l_vendor_name);

499:
500:
501: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
502:
503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);

Line 504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);

500:
501: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
502:
503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);

Line 505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

501: Fnd_message.set_name('IGI','IGI_CIS_UPDATED_CERT');
502:
503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);

Line 506: Fnd_message.set_token('tax_name',l_certificate.tax_name);

502:
503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);

Line 507: Fnd_message.set_token( 'cert_type',l_certificate_type);

503: Fnd_message.set_token('vendor_name',l_vendor_name);
504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);

Line 508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);

504: Fnd_message.set_token('vendor_site' ,l_vendor_site_code);
505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);
512: l_message := Fnd_message.get;

Line 509: Fnd_message.set_token('tax_rate',l_tax_rate);

505: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);
512: l_message := Fnd_message.get;
513: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);

Line 510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);

506: Fnd_message.set_token('tax_name',l_certificate.tax_name);
507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);
512: l_message := Fnd_message.get;
513: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
514:

Line 511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);

507: Fnd_message.set_token( 'cert_type',l_certificate_type);
508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);
512: l_message := Fnd_message.get;
513: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
514:
515: IF ( (p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6' ) and ( p_mode = 'Types' )) THEN ---------------------(62)

Line 512: l_message := Fnd_message.get;

508: Fnd_message.set_token( 'cert_number',l_certificate.certificate_number);
509: Fnd_message.set_token('tax_rate',l_tax_rate);
510: Fnd_message.set_token('eff_from_date',l_certificate.start_date);
511: Fnd_message.set_token('eff_to_date',l_certificate.end_date);
512: l_message := Fnd_message.get;
513: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
514:
515: IF ( (p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6' ) and ( p_mode = 'Types' )) THEN ---------------------(62)
516: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;

Line 516: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;

512: l_message := Fnd_message.get;
513: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
514:
515: IF ( (p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6' ) and ( p_mode = 'Types' )) THEN ---------------------(62)
516: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;
517: L_message:=fnd_message.get;
518: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
519: END IF; -------------------------------------(62)
520:

Line 517: L_message:=fnd_message.get;

513: Debug(l_state_level, 'upd_cis_cert_type_perc.msg2', l_message);
514:
515: IF ( (p_new_certificate_type = 'CIS4P' OR p_new_certificate_type = 'CIS6' ) and ( p_mode = 'Types' )) THEN ---------------------(62)
516: Fnd_message.set_name( 'IGI','IGI_CIS_NI_NUMBER_REQ') ;
517: L_message:=fnd_message.get;
518: Debug(l_state_level, 'upd_cis_cert_type_perc', l_message);
519: END IF; -------------------------------------(62)
520:
521:

Line 555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');

551:
552: EXCEPTION
553:
554: WHEN UNPROCESSED THEN
555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');
556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);

Line 556: Fnd_message.set_token('vendor_name',l_vendor_name);

552: EXCEPTION
553:
554: WHEN UNPROCESSED THEN
555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');
556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);

Line 557: Fnd_message.set_token('vendor_site',l_vendor_site_code);

553:
554: WHEN UNPROCESSED THEN
555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');
556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);

Line 558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);

554: WHEN UNPROCESSED THEN
555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');
556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);

Line 559: Fnd_message.set_token('tax_name',l_certificate.tax_name);

555: Fnd_message.set_name('IGI','IGI_CIS_REC_NOT_PROCESSED');
556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);

Line 560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);

556: Fnd_message.set_token('vendor_name',l_vendor_name);
557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);
564: fnd_message.set_token('eff_to_date',l_certificate.end_date);

Line 561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);

557: Fnd_message.set_token('vendor_site',l_vendor_site_code);
558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);
564: fnd_message.set_token('eff_to_date',l_certificate.end_date);
565: L_message:=fnd_message.get;

Line 562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);

558: Fnd_message.set_token('tax_group', IGI_CIS_GET_PROFILE. Cis_Tax_group);
559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);
564: fnd_message.set_token('eff_to_date',l_certificate.end_date);
565: L_message:=fnd_message.get;
566: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);

Line 563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);

559: Fnd_message.set_token('tax_name',l_certificate.tax_name);
560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);
564: fnd_message.set_token('eff_to_date',l_certificate.end_date);
565: L_message:=fnd_message.get;
566: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
567:

Line 564: fnd_message.set_token('eff_to_date',l_certificate.end_date);

560: Fnd_message.set_token('cert_type',l_certificate.certificate_type);
561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);
564: fnd_message.set_token('eff_to_date',l_certificate.end_date);
565: L_message:=fnd_message.get;
566: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
567:
568: end ;

Line 565: L_message:=fnd_message.get;

561: Fnd_message.set_token('cert_number' ,l_certificate.certificate_number);
562: Fnd_message.set_token('tax_rate',l_certificate.tax_rate);
563: Fnd_message.set_token('eff_from_date', l_certificate.start_date);
564: fnd_message.set_token('eff_to_date',l_certificate.end_date);
565: L_message:=fnd_message.get;
566: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
567:
568: end ;
569:

Line 576: Fnd_message.set_name('IGI', 'IGI_CIS_REC_NOT_EXISTS');

572:
573: EXCEPTION
574:
575: WHEN INEXISTENT THEN
576: Fnd_message.set_name('IGI', 'IGI_CIS_REC_NOT_EXISTS');
577: L_message:=fnd_message.get;
578: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
579: WHEN INVALID THEN
580: Fnd_message.set_name('IGI','IGI_CIS_INVALID_ARGS');

Line 577: L_message:=fnd_message.get;

573: EXCEPTION
574:
575: WHEN INEXISTENT THEN
576: Fnd_message.set_name('IGI', 'IGI_CIS_REC_NOT_EXISTS');
577: L_message:=fnd_message.get;
578: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
579: WHEN INVALID THEN
580: Fnd_message.set_name('IGI','IGI_CIS_INVALID_ARGS');
581: L_message:=fnd_message.get;

Line 580: Fnd_message.set_name('IGI','IGI_CIS_INVALID_ARGS');

576: Fnd_message.set_name('IGI', 'IGI_CIS_REC_NOT_EXISTS');
577: L_message:=fnd_message.get;
578: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
579: WHEN INVALID THEN
580: Fnd_message.set_name('IGI','IGI_CIS_INVALID_ARGS');
581: L_message:=fnd_message.get;
582: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
583: END upd_cis_cert_type_perc ;
584:

Line 581: L_message:=fnd_message.get;

577: L_message:=fnd_message.get;
578: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
579: WHEN INVALID THEN
580: Fnd_message.set_name('IGI','IGI_CIS_INVALID_ARGS');
581: L_message:=fnd_message.get;
582: Debug(l_excep_level, 'upd_cis_cert_type_perc', l_message);
583: END upd_cis_cert_type_perc ;
584:
585: END IGI_CIS_UPDC;