APPS.IGS_PE_OFFICE_HRS_PKG dependencies on IGS_SC_GEN_001

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

406: x_last_update_login => x_last_update_login
407: );
408:
409: IF (x_mode = 'S') THEN
410: igs_sc_gen_001.set_ctx('R');
411: END IF;
412: INSERT INTO igs_pe_office_hrs (
413: office_hrs_id,
414: contact_preference_id,

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

432: x_last_updated_by,
433: x_last_update_login
434: ) RETURNING ROWID, office_hrs_id INTO x_rowid, x_office_hrs_id;
435: IF (x_mode = 'S') THEN
436: igs_sc_gen_001.unset_ctx('R');
437: END IF;
438:
439:
440:

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

446: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
447: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
448: fnd_message.set_token ('ERR_CD', SQLCODE);
449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: ELSE
453: igs_sc_gen_001.unset_ctx('R');
454: RAISE;

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

449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: ELSE
453: igs_sc_gen_001.unset_ctx('R');
454: RAISE;
455: END IF;
456: END insert_row;
457:

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

579: x_last_update_login => x_last_update_login
580: );
581:
582: IF (x_mode = 'S') THEN
583: igs_sc_gen_001.set_ctx('R');
584: END IF;
585: UPDATE igs_pe_office_hrs
586: SET
587: office_hrs_id = new_references.office_hrs_id,

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

596:
597: IF (SQL%NOTFOUND) THEN
598: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: END IF;
603: IF (x_mode = 'S') THEN
604: igs_sc_gen_001.unset_ctx('R');

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

600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: END IF;
603: IF (x_mode = 'S') THEN
604: igs_sc_gen_001.unset_ctx('R');
605: END IF;
606:
607:
608:

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

612: IF (SQLCODE = (-28115)) THEN
613: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
614: fnd_message.set_token ('ERR_CD', SQLCODE);
615: igs_ge_msg_stack.add;
616: igs_sc_gen_001.unset_ctx('R');
617: app_exception.raise_exception;
618: ELSE
619: igs_sc_gen_001.unset_ctx('R');
620: RAISE;

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

615: igs_ge_msg_stack.add;
616: igs_sc_gen_001.unset_ctx('R');
617: app_exception.raise_exception;
618: ELSE
619: igs_sc_gen_001.unset_ctx('R');
620: RAISE;
621: END IF;
622: END update_row;
623:

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

698: x_rowid => x_rowid
699: );
700:
701: IF (x_mode = 'S') THEN
702: igs_sc_gen_001.set_ctx('R');
703: END IF;
704: DELETE FROM igs_pe_office_hrs
705: WHERE rowid = x_rowid;
706:

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

706:
707: IF (SQL%NOTFOUND) THEN
708: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
709: igs_ge_msg_stack.add;
710: igs_sc_gen_001.unset_ctx('R');
711: app_exception.raise_exception;
712: END IF;
713: IF (x_mode = 'S') THEN
714: igs_sc_gen_001.unset_ctx('R');

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

710: igs_sc_gen_001.unset_ctx('R');
711: app_exception.raise_exception;
712: END IF;
713: IF (x_mode = 'S') THEN
714: igs_sc_gen_001.unset_ctx('R');
715: END IF;
716:
717:
718: END delete_row;