APPS.IGS_AV_STND_ALT_UNIT_PKG dependencies on IGS_SC_GEN_001

Line 386: igs_sc_gen_001.set_ctx('R');

382: x_last_update_login=>X_LAST_UPDATE_LOGIN
383: );
384:
385: IF (x_mode = 'S') THEN
386: igs_sc_gen_001.set_ctx('R');
387: END IF;
388: insert into IGS_AV_STND_ALT_UNIT (
389: AV_STND_UNIT_ID,
390: ALT_UNIT_CD,

Line 410: igs_sc_gen_001.unset_ctx('R');

406: X_LAST_UPDATED_BY,
407: X_LAST_UPDATE_LOGIN
408: );
409: IF (x_mode = 'S') THEN
410: igs_sc_gen_001.unset_ctx('R');
411: END IF;
412:
413:
414:

Line 428: igs_sc_gen_001.unset_ctx('R');

424: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
425: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
426: fnd_message.set_token ('ERR_CD', SQLCODE);
427: igs_ge_msg_stack.add;
428: igs_sc_gen_001.unset_ctx('R');
429: app_exception.raise_exception;
430: ELSE
431: igs_sc_gen_001.unset_ctx('R');
432: RAISE;

Line 431: igs_sc_gen_001.unset_ctx('R');

427: igs_ge_msg_stack.add;
428: igs_sc_gen_001.unset_ctx('R');
429: app_exception.raise_exception;
430: ELSE
431: igs_sc_gen_001.unset_ctx('R');
432: RAISE;
433: END IF;
434:
435: end INSERT_ROW;

Line 517: igs_sc_gen_001.set_ctx('R');

513: x_last_updated_by=>X_LAST_UPDATED_BY,
514: x_last_update_login=>X_LAST_UPDATE_LOGIN
515: );
516: IF (x_mode = 'S') THEN
517: igs_sc_gen_001.set_ctx('R');
518: END IF;
519: update IGS_AV_STND_ALT_UNIT set
520: OPTIONAL_IND = NEW_REFERENCES.OPTIONAL_IND,
521: LAST_UPDATE_DATE = LAST_UPDATE_DATE,

Line 528: igs_sc_gen_001.unset_ctx('R');

524: where ROWID = X_ROWID ;
525: if (sql%notfound) then
526: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
527: igs_ge_msg_stack.add;
528: igs_sc_gen_001.unset_ctx('R');
529: app_exception.raise_exception;
530: end if;
531: IF (x_mode = 'S') THEN
532: igs_sc_gen_001.unset_ctx('R');

Line 532: igs_sc_gen_001.unset_ctx('R');

528: igs_sc_gen_001.unset_ctx('R');
529: app_exception.raise_exception;
530: end if;
531: IF (x_mode = 'S') THEN
532: igs_sc_gen_001.unset_ctx('R');
533: END IF;
534:
535:
536: EXCEPTION

Line 542: igs_sc_gen_001.unset_ctx('R');

538: IF (SQLCODE = (-28115)) THEN
539: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
540: fnd_message.set_token ('ERR_CD', SQLCODE);
541: igs_ge_msg_stack.add;
542: igs_sc_gen_001.unset_ctx('R');
543: app_exception.raise_exception;
544: ELSE
545: igs_sc_gen_001.unset_ctx('R');
546: RAISE;

Line 545: igs_sc_gen_001.unset_ctx('R');

541: igs_ge_msg_stack.add;
542: igs_sc_gen_001.unset_ctx('R');
543: app_exception.raise_exception;
544: ELSE
545: igs_sc_gen_001.unset_ctx('R');
546: RAISE;
547: END IF;
548:
549: end UPDATE_ROW;

Line 598: igs_sc_gen_001.set_ctx('R');

594: p_action => 'DELETE',
595: x_rowid => X_ROWID
596: );
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.set_ctx('R');
599: END IF;
600: delete from IGS_AV_STND_ALT_UNIT
601: where ROWID = X_ROWID ;
602: if (sql%notfound) then

Line 605: igs_sc_gen_001.unset_ctx('R');

601: where ROWID = X_ROWID ;
602: if (sql%notfound) then
603: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
604: igs_ge_msg_stack.add;
605: igs_sc_gen_001.unset_ctx('R');
606: app_exception.raise_exception;
607: end if;
608: IF (x_mode = 'S') THEN
609: igs_sc_gen_001.unset_ctx('R');

Line 609: igs_sc_gen_001.unset_ctx('R');

605: igs_sc_gen_001.unset_ctx('R');
606: app_exception.raise_exception;
607: end if;
608: IF (x_mode = 'S') THEN
609: igs_sc_gen_001.unset_ctx('R');
610: END IF;
611:
612: end DELETE_ROW;
613: