DBA Data[Home] [Help]

APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_GEN_008

Line 255: --sapanigr 24-Feb-2006 Bug#5018036 - Cursor cur_person_number removed and replaced by call to function igs_fi_gen_008.get_party_number.

251: -- Earlier this field was being left null.
252: --abshriva 8-Jun-2006 Bug 5178298 Invalid Value Message in Log File: Added proper messages
253: --
254: --abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
255: --sapanigr 24-Feb-2006 Bug#5018036 - Cursor cur_person_number removed and replaced by call to function igs_fi_gen_008.get_party_number.
256: --sapanigr 15-Feb-2006 Bug#5018036 - Cursor cur_bill_to_addr was a union of three select stmts. This is
257: -- changed to one select statement by using IN function to reduce share memory usage.
258: --sapanigr 12-Feb-2006 Bug#5018036 - Cursor cur_person_number now queries hz_parties instead of igs_fi_parties_v. (R12 SQL Repository tuning)
259: --sapanigr 23-Nov-2005 Bug#4744481 - Cursor cur_bill_to_addr modifed to check for active address usage.

Line 772: -- Bug#5018036 cur_person_number replaced by call to igs_fi_gen_008.get_party_number

768: CLOSE cur_start_date;
769: IF (l_d_start_date > p_d_cutoff_dt) THEN
770: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_LSTDT');
771: -- Bug#2564643 Removed code assigning value to token SUB_ACCOUNT_NAME .
772: -- Bug#5018036 cur_person_number replaced by call to igs_fi_gen_008.get_party_number
773: l_person_number := igs_fi_gen_008.get_party_number(p_n_person_id);
774: fnd_message.set_token ('PERSON_NUMBER', l_person_number);
775: igs_ge_msg_stack.add;
776: END IF;

Line 773: l_person_number := igs_fi_gen_008.get_party_number(p_n_person_id);

769: IF (l_d_start_date > p_d_cutoff_dt) THEN
770: fnd_message.set_name ('IGS', 'IGS_FI_CUTOFF_LSTDT');
771: -- Bug#2564643 Removed code assigning value to token SUB_ACCOUNT_NAME .
772: -- Bug#5018036 cur_person_number replaced by call to igs_fi_gen_008.get_party_number
773: l_person_number := igs_fi_gen_008.get_party_number(p_n_person_id);
774: fnd_message.set_token ('PERSON_NUMBER', l_person_number);
775: igs_ge_msg_stack.add;
776: END IF;
777: END IF;

Line 1510: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(p_n_person_id));

1506: igs_ge_msg_stack.add;
1507:
1508: -- Log Person Number in the log file.
1509: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1510: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(p_n_person_id));
1511: igs_ge_msg_stack.add;
1512: END;
1513: ELSE
1514: FOR rec_cur_person_ids IN cur_person_ids (p_n_prsid_grp_id) LOOP

Line 1536: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(rec_cur_person_ids.person_id));

1532: igs_ge_msg_stack.add;
1533:
1534: -- Log Person Number in the log file.
1535: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1536: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(rec_cur_person_ids.person_id));
1537: igs_ge_msg_stack.add;
1538: END;
1539: END LOOP;
1540: END IF;