APPS.IGS_PE_HZ_LOCATIONS_PKG dependencies on IGS_SC_GEN_001

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

302: x_last_update_login => x_last_update_login
303: );
304:
305: IF (x_mode = 'S') THEN
306: igs_sc_gen_001.set_ctx('R');
307: END IF;
308: INSERT INTO igs_pe_hz_locations (
309: location_id,
310: other_details_1,

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

338: x_program_application_id,
339: x_program_update_date
340: );
341: IF (x_mode = 'S') THEN
342: igs_sc_gen_001.unset_ctx('R');
343: END IF;
344:
345:
346: OPEN c;

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

357: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
358: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
359: fnd_message.set_token ('ERR_CD', SQLCODE);
360: igs_ge_msg_stack.add;
361: igs_sc_gen_001.unset_ctx('R');
362: app_exception.raise_exception;
363: ELSE
364: igs_sc_gen_001.unset_ctx('R');
365: RAISE;

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

360: igs_ge_msg_stack.add;
361: igs_sc_gen_001.unset_ctx('R');
362: app_exception.raise_exception;
363: ELSE
364: igs_sc_gen_001.unset_ctx('R');
365: RAISE;
366: END IF;
367: END insert_row;
368:

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

508: END IF;
509: END IF;
510:
511: IF (x_mode = 'S') THEN
512: igs_sc_gen_001.set_ctx('R');
513: END IF;
514: UPDATE igs_pe_hz_locations
515: SET
516: other_details_1 = new_references.other_details_1,

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

529:
530: IF (SQL%NOTFOUND) THEN
531: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: END IF;
536: IF (x_mode = 'S') THEN
537: igs_sc_gen_001.unset_ctx('R');

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

533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: END IF;
536: IF (x_mode = 'S') THEN
537: igs_sc_gen_001.unset_ctx('R');
538: END IF;
539:
540:
541:

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

544: IF (SQLCODE = (-28115)) THEN
545: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
546: fnd_message.set_token ('ERR_CD', SQLCODE);
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: ELSE
551: igs_sc_gen_001.unset_ctx('R');
552: RAISE;

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

547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: ELSE
551: igs_sc_gen_001.unset_ctx('R');
552: RAISE;
553: END IF;
554: END update_row;
555:

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

633: x_rowid => x_rowid
634: );
635:
636: IF (x_mode = 'S') THEN
637: igs_sc_gen_001.set_ctx('R');
638: END IF;
639: DELETE FROM igs_pe_hz_locations
640: WHERE rowid = x_rowid;
641:

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

641:
642: IF (SQL%NOTFOUND) THEN
643: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
644: igs_ge_msg_stack.add;
645: igs_sc_gen_001.unset_ctx('R');
646: app_exception.raise_exception;
647: END IF;
648: IF (x_mode = 'S') THEN
649: igs_sc_gen_001.unset_ctx('R');

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

645: igs_sc_gen_001.unset_ctx('R');
646: app_exception.raise_exception;
647: END IF;
648: IF (x_mode = 'S') THEN
649: igs_sc_gen_001.unset_ctx('R');
650: END IF;
651:
652:
653: END delete_row;