APPS.IGS_PE_ACT_SITE_PKG dependencies on IGS_SC_GEN_001

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

329: x_primary_flag => x_primary_flag
330: );
331:
332: IF (x_mode = 'S') THEN
333: igs_sc_gen_001.set_ctx('R');
334: END IF;
335: INSERT INTO igs_pe_act_site (
336: person_id,
337: activity_site_cd,

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

359: new_references.remarks,
360: new_references.primary_flag
361: ) RETURNING ROWID INTO x_rowid;
362: IF (x_mode = 'S') THEN
363: igs_sc_gen_001.unset_ctx('R');
364: END IF;
365:
366:
367:

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

370: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
371: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
372: fnd_message.set_token ('ERR_CD', SQLCODE);
373: igs_ge_msg_stack.add;
374: igs_sc_gen_001.unset_ctx('R');
375: app_exception.raise_exception;
376: ELSE
377: igs_sc_gen_001.unset_ctx('R');
378: RAISE;

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

373: igs_ge_msg_stack.add;
374: igs_sc_gen_001.unset_ctx('R');
375: app_exception.raise_exception;
376: ELSE
377: igs_sc_gen_001.unset_ctx('R');
378: RAISE;
379: END IF;
380: END insert_row;
381:

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

501: x_primary_flag => x_primary_flag
502: );
503:
504: IF (x_mode = 'S') THEN
505: igs_sc_gen_001.set_ctx('R');
506: END IF;
507: UPDATE igs_pe_act_site
508: SET
509: location_id = new_references.location_id,

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

517:
518: IF (SQL%NOTFOUND) THEN
519: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
520: igs_ge_msg_stack.add;
521: igs_sc_gen_001.unset_ctx('R');
522: app_exception.raise_exception;
523: END IF;
524: IF (x_mode = 'S') THEN
525: igs_sc_gen_001.unset_ctx('R');

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

521: igs_sc_gen_001.unset_ctx('R');
522: app_exception.raise_exception;
523: END IF;
524: IF (x_mode = 'S') THEN
525: igs_sc_gen_001.unset_ctx('R');
526: END IF;
527:
528:
529:

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

532: IF (SQLCODE = (-28115)) THEN
533: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
534: fnd_message.set_token ('ERR_CD', SQLCODE);
535: igs_ge_msg_stack.add;
536: igs_sc_gen_001.unset_ctx('R');
537: app_exception.raise_exception;
538: ELSE
539: igs_sc_gen_001.unset_ctx('R');
540: RAISE;

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

535: igs_ge_msg_stack.add;
536: igs_sc_gen_001.unset_ctx('R');
537: app_exception.raise_exception;
538: ELSE
539: igs_sc_gen_001.unset_ctx('R');
540: RAISE;
541: END IF;
542: END update_row;
543:

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

627: x_rowid => x_rowid
628: );
629:
630: IF (x_mode = 'S') THEN
631: igs_sc_gen_001.set_ctx('R');
632: END IF;
633: DELETE FROM igs_pe_act_site
634: WHERE rowid = x_rowid;
635:

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

635:
636: IF (SQL%NOTFOUND) THEN
637: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
638: igs_ge_msg_stack.add;
639: igs_sc_gen_001.unset_ctx('R');
640: app_exception.raise_exception;
641: END IF;
642: IF (x_mode = 'S') THEN
643: igs_sc_gen_001.unset_ctx('R');

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

639: igs_sc_gen_001.unset_ctx('R');
640: app_exception.raise_exception;
641: END IF;
642: IF (x_mode = 'S') THEN
643: igs_sc_gen_001.unset_ctx('R');
644: END IF;
645:
646:
647: END delete_row;