APPS.IGS_PE_HZ_REL_PKG dependencies on IGS_SC_GEN_001

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

606: x_last_update_login => x_last_update_login
607: );
608:
609: IF (x_mode = 'S') THEN
610: igs_sc_gen_001.set_ctx('R');
611: END IF;
612: INSERT INTO igs_pe_hz_rel (
613: relationship_id,
614: directional_flag,

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

644: x_last_updated_by,
645: x_last_update_login
646: ) RETURNING ROWID INTO x_rowid;
647: IF (x_mode = 'S') THEN
648: igs_sc_gen_001.unset_ctx('R');
649: END IF;
650:
651:
652: IF new_references.directional_flag = 'F' THEN

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

686: x_last_updated_by,
687: x_last_update_login
688: );
689: IF (x_mode = 'S') THEN
690: igs_sc_gen_001.unset_ctx('R');
691: END IF;
692:
693:
694: after_dml(p_action => 'INSERT',x_rowid => x_rowid);

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

699: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
700: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
701: fnd_message.set_token ('ERR_CD', SQLCODE);
702: igs_ge_msg_stack.add;
703: igs_sc_gen_001.unset_ctx('R');
704: app_exception.raise_exception;
705: ELSE
706: igs_sc_gen_001.unset_ctx('R');
707: RAISE;

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

702: igs_ge_msg_stack.add;
703: igs_sc_gen_001.unset_ctx('R');
704: app_exception.raise_exception;
705: ELSE
706: igs_sc_gen_001.unset_ctx('R');
707: RAISE;
708: END IF;
709: END insert_row;
710:

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

857: );
858:
859:
860: IF (x_mode = 'S') THEN
861: igs_sc_gen_001.set_ctx('R');
862: END IF;
863: --if the passed emergency contact flag is not null then update the database value. Else don't update emergency Contact value.
864: IF new_references.emergency_contact_flag is NOT NULL THEN
865: UPDATE igs_pe_hz_rel

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

897:
898: IF (SQL%NOTFOUND) THEN
899: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
900: igs_ge_msg_stack.add;
901: igs_sc_gen_001.unset_ctx('R');
902: app_exception.raise_exception;
903: END IF;
904: IF (x_mode = 'S') THEN
905: igs_sc_gen_001.unset_ctx('R');

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

901: igs_sc_gen_001.unset_ctx('R');
902: app_exception.raise_exception;
903: END IF;
904: IF (x_mode = 'S') THEN
905: igs_sc_gen_001.unset_ctx('R');
906: END IF;
907:
908:
909: after_dml(p_action => 'UPDATE', x_rowid => x_rowid);

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

914: IF (SQLCODE = (-28115)) THEN
915: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
916: fnd_message.set_token ('ERR_CD', SQLCODE);
917: igs_ge_msg_stack.add;
918: igs_sc_gen_001.unset_ctx('R');
919: app_exception.raise_exception;
920: ELSE
921: igs_sc_gen_001.unset_ctx('R');
922: RAISE;

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

917: igs_ge_msg_stack.add;
918: igs_sc_gen_001.unset_ctx('R');
919: app_exception.raise_exception;
920: ELSE
921: igs_sc_gen_001.unset_ctx('R');
922: RAISE;
923: END IF;
924: END update_row;
925:

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

1019: x_rowid => x_rowid
1020: );
1021:
1022: IF (x_mode = 'S') THEN
1023: igs_sc_gen_001.set_ctx('R');
1024: END IF;
1025: DELETE FROM igs_pe_hz_rel
1026: WHERE rowid = x_rowid;
1027:

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

1027:
1028: IF (SQL%NOTFOUND) THEN
1029: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1030: igs_ge_msg_stack.add;
1031: igs_sc_gen_001.unset_ctx('R');
1032: app_exception.raise_exception;
1033: END IF;
1034: IF (x_mode = 'S') THEN
1035: igs_sc_gen_001.unset_ctx('R');

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

1031: igs_sc_gen_001.unset_ctx('R');
1032: app_exception.raise_exception;
1033: END IF;
1034: IF (x_mode = 'S') THEN
1035: igs_sc_gen_001.unset_ctx('R');
1036: END IF;
1037:
1038:
1039: END delete_row;