APPS.IGS_PE_NONIMG_EMPL_PKG dependencies on IGS_SC_GEN_001

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

335: x_print_flag => x_print_flag
336: );
337:
338: IF (x_mode = 'S') THEN
339: igs_sc_gen_001.set_ctx('R');
340: END IF;
341: INSERT INTO igs_pe_nonimg_empl (
342: nonimg_empl_id,
343: nonimg_form_id,

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

377: new_references.action_code,
378: new_references.print_flag
379: ) RETURNING ROWID, nonimg_empl_id INTO x_rowid, x_nonimg_empl_id;
380: IF (x_mode = 'S') THEN
381: igs_sc_gen_001.unset_ctx('R');
382: END IF;
383:
384:
385:

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

388: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
389: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
390: fnd_message.set_token ('ERR_CD', SQLCODE);
391: igs_ge_msg_stack.add;
392: igs_sc_gen_001.unset_ctx('R');
393: app_exception.raise_exception;
394: ELSE
395: igs_sc_gen_001.unset_ctx('R');
396: RAISE;

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

391: igs_ge_msg_stack.add;
392: igs_sc_gen_001.unset_ctx('R');
393: app_exception.raise_exception;
394: ELSE
395: igs_sc_gen_001.unset_ctx('R');
396: RAISE;
397: END IF;
398: END insert_row;
399:

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

556: x_print_flag => x_print_flag
557: );
558:
559: IF (x_mode = 'S') THEN
560: igs_sc_gen_001.set_ctx('R');
561: END IF;
562: UPDATE igs_pe_nonimg_empl
563: SET
564: nonimg_form_id = new_references.nonimg_form_id,

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

580:
581: IF (SQL%NOTFOUND) THEN
582: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: END IF;
587: IF (x_mode = 'S') THEN
588: igs_sc_gen_001.unset_ctx('R');

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

584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: END IF;
587: IF (x_mode = 'S') THEN
588: igs_sc_gen_001.unset_ctx('R');
589: END IF;
590:
591:
592:

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

595: IF (SQLCODE = (-28115)) THEN
596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE
602: igs_sc_gen_001.unset_ctx('R');
603: RAISE;

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

598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE
602: igs_sc_gen_001.unset_ctx('R');
603: RAISE;
604: END IF;
605: END update_row;
606:

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

705: x_rowid => x_rowid
706: );
707:
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: DELETE FROM igs_pe_nonimg_empl
712: WHERE rowid = x_rowid;
713:

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

713:
714: IF (SQL%NOTFOUND) THEN
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
716: igs_ge_msg_stack.add;
717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: END IF;
720: IF (x_mode = 'S') THEN
721: igs_sc_gen_001.unset_ctx('R');

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

717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: END IF;
720: IF (x_mode = 'S') THEN
721: igs_sc_gen_001.unset_ctx('R');
722: END IF;
723:
724:
725: END delete_row;