APPS.IGS_PE_HZ_PARTY_REL_PKG dependencies on IGS_SC_GEN_001

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

235: x_last_update_login => x_last_update_login
236: );
237:
238: IF (x_mode = 'S') THEN
239: igs_sc_gen_001.set_ctx('R');
240: END IF;
241: INSERT INTO igs_pe_hz_party_rel (
242: party_relationship_id,
243: other_rel_type,

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

263: x_program_application_id,
264: x_program_update_date
265: );
266: IF (x_mode = 'S') THEN
267: igs_sc_gen_001.unset_ctx('R');
268: END IF;
269:
270:
271: OPEN c;

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

282: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
283: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
284: fnd_message.set_token ('ERR_CD', SQLCODE);
285: igs_ge_msg_stack.add;
286: igs_sc_gen_001.unset_ctx('R');
287: app_exception.raise_exception;
288: ELSE
289: igs_sc_gen_001.unset_ctx('R');
290: RAISE;

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

285: igs_ge_msg_stack.add;
286: igs_sc_gen_001.unset_ctx('R');
287: app_exception.raise_exception;
288: ELSE
289: igs_sc_gen_001.unset_ctx('R');
290: RAISE;
291: END IF;
292: END insert_row;
293:

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

413: END IF;
414: END IF;
415:
416: IF (x_mode = 'S') THEN
417: igs_sc_gen_001.set_ctx('R');
418: END IF;
419: UPDATE igs_pe_hz_party_rel
420: SET
421: other_rel_type = new_references.other_rel_type,

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

430:
431: IF (SQL%NOTFOUND) THEN
432: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
433: igs_ge_msg_stack.add;
434: igs_sc_gen_001.unset_ctx('R');
435: app_exception.raise_exception;
436: END IF;
437: IF (x_mode = 'S') THEN
438: igs_sc_gen_001.unset_ctx('R');

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

434: igs_sc_gen_001.unset_ctx('R');
435: app_exception.raise_exception;
436: END IF;
437: IF (x_mode = 'S') THEN
438: igs_sc_gen_001.unset_ctx('R');
439: END IF;
440:
441:
442:

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

445: IF (SQLCODE = (-28115)) THEN
446: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
447: fnd_message.set_token ('ERR_CD', SQLCODE);
448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;
451: ELSE
452: igs_sc_gen_001.unset_ctx('R');
453: RAISE;

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

448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;
451: ELSE
452: igs_sc_gen_001.unset_ctx('R');
453: RAISE;
454: END IF;
455: END update_row;
456:

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

522: x_rowid => x_rowid
523: );
524:
525: IF (x_mode = 'S') THEN
526: igs_sc_gen_001.set_ctx('R');
527: END IF;
528: DELETE FROM igs_pe_hz_party_rel
529: WHERE rowid = x_rowid;
530:

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

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

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

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