APPS.IGS_PE_HZ_PTY_SITES_PKG dependencies on IGS_SC_GEN_001

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

318: x_last_update_login => x_last_update_login
319: );
320:
321: IF (x_mode = 'S') THEN
322: igs_sc_gen_001.set_ctx('R');
323: END IF;
324: INSERT INTO igs_pe_hz_pty_sites (
325: party_site_id,
326: start_date,

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

340: x_last_updated_by,
341: x_last_update_login
342: ) RETURNING ROWID/*, party_site_id */INTO x_rowid/*, x_party_site_id*/;
343: IF (x_mode = 'S') THEN
344: igs_sc_gen_001.unset_ctx('R');
345: END IF;
346:
347:
348:

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

351: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
352: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
353: fnd_message.set_token ('ERR_CD', SQLCODE);
354: igs_ge_msg_stack.add;
355: igs_sc_gen_001.unset_ctx('R');
356: app_exception.raise_exception;
357: ELSE
358: igs_sc_gen_001.unset_ctx('R');
359: RAISE;

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

354: igs_ge_msg_stack.add;
355: igs_sc_gen_001.unset_ctx('R');
356: app_exception.raise_exception;
357: ELSE
358: igs_sc_gen_001.unset_ctx('R');
359: RAISE;
360: END IF;
361: END insert_row;
362:

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

472: x_last_update_login => x_last_update_login
473: );
474:
475: IF (x_mode = 'S') THEN
476: igs_sc_gen_001.set_ctx('R');
477: END IF;
478: UPDATE igs_pe_hz_pty_sites
479: SET
480: party_site_id = new_references.party_site_id,

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

487:
488: IF (SQL%NOTFOUND) THEN
489: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
490: igs_ge_msg_stack.add;
491: igs_sc_gen_001.unset_ctx('R');
492: app_exception.raise_exception;
493: END IF;
494: IF (x_mode = 'S') THEN
495: igs_sc_gen_001.unset_ctx('R');

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

491: igs_sc_gen_001.unset_ctx('R');
492: app_exception.raise_exception;
493: END IF;
494: IF (x_mode = 'S') THEN
495: igs_sc_gen_001.unset_ctx('R');
496: END IF;
497:
498:
499:

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

502: IF (SQLCODE = (-28115)) THEN
503: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
504: fnd_message.set_token ('ERR_CD', SQLCODE);
505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;
508: ELSE
509: igs_sc_gen_001.unset_ctx('R');
510: RAISE;

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

505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;
508: ELSE
509: igs_sc_gen_001.unset_ctx('R');
510: RAISE;
511: END IF;
512: END update_row;
513:

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

582: x_rowid => x_rowid
583: );
584:
585: IF (x_mode = 'S') THEN
586: igs_sc_gen_001.set_ctx('R');
587: END IF;
588: DELETE FROM igs_pe_hz_pty_sites
589: WHERE rowid = x_rowid;
590:

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

590:
591: IF (SQL%NOTFOUND) THEN
592: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
593: igs_ge_msg_stack.add;
594: igs_sc_gen_001.unset_ctx('R');
595: app_exception.raise_exception;
596: END IF;
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.unset_ctx('R');

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

594: igs_sc_gen_001.unset_ctx('R');
595: app_exception.raise_exception;
596: END IF;
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.unset_ctx('R');
599: END IF;
600:
601:
602: END delete_row;