3900: CLOSE get_location_type_csr;
3901:
3902: IF Locked_Area_Expense_Class(l_tenancy_Id, l_tenancy_str_date, l_tenancy_end_date) THEN
3903: pnp_debug_pkg.put_log_msg('********************************************************************************');
3904: fnd_message.set_name ('PN','PN_SCHIT_LOCK_DEL');
3905: fnd_message.set_token ('LOC_CODE', l_location_code);
3906: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3907: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3908: pnp_debug_pkg.put_log_msg(fnd_message.get);
3901:
3902: IF Locked_Area_Expense_Class(l_tenancy_Id, l_tenancy_str_date, l_tenancy_end_date) THEN
3903: pnp_debug_pkg.put_log_msg('********************************************************************************');
3904: fnd_message.set_name ('PN','PN_SCHIT_LOCK_DEL');
3905: fnd_message.set_token ('LOC_CODE', l_location_code);
3906: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3907: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3908: pnp_debug_pkg.put_log_msg(fnd_message.get);
3909: pnp_debug_pkg.put_log_msg('********************************************************************************');
3902: IF Locked_Area_Expense_Class(l_tenancy_Id, l_tenancy_str_date, l_tenancy_end_date) THEN
3903: pnp_debug_pkg.put_log_msg('********************************************************************************');
3904: fnd_message.set_name ('PN','PN_SCHIT_LOCK_DEL');
3905: fnd_message.set_token ('LOC_CODE', l_location_code);
3906: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3907: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3908: pnp_debug_pkg.put_log_msg(fnd_message.get);
3909: pnp_debug_pkg.put_log_msg('********************************************************************************');
3910: ELSE
3903: pnp_debug_pkg.put_log_msg('********************************************************************************');
3904: fnd_message.set_name ('PN','PN_SCHIT_LOCK_DEL');
3905: fnd_message.set_token ('LOC_CODE', l_location_code);
3906: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3907: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3908: pnp_debug_pkg.put_log_msg(fnd_message.get);
3909: pnp_debug_pkg.put_log_msg('********************************************************************************');
3910: ELSE
3911:
3904: fnd_message.set_name ('PN','PN_SCHIT_LOCK_DEL');
3905: fnd_message.set_token ('LOC_CODE', l_location_code);
3906: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3907: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3908: pnp_debug_pkg.put_log_msg(fnd_message.get);
3909: pnp_debug_pkg.put_log_msg('********************************************************************************');
3910: ELSE
3911:
3912: pn_tenancies_pkg.delete_row(
3924:
3925: IF l_action = 'R' THEN --Regenerate
3926:
3927: pnp_debug_pkg.put_log_msg('********************************************************************************');
3928: fnd_message.set_name ('PN','PN_SCHIT_CUST');
3929: fnd_message.set_token ('LOC_CODE', l_location_code);
3930: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3931: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3932: pnp_debug_pkg.put_log_msg(fnd_message.get);
3925: IF l_action = 'R' THEN --Regenerate
3926:
3927: pnp_debug_pkg.put_log_msg('********************************************************************************');
3928: fnd_message.set_name ('PN','PN_SCHIT_CUST');
3929: fnd_message.set_token ('LOC_CODE', l_location_code);
3930: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3931: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3932: pnp_debug_pkg.put_log_msg(fnd_message.get);
3933: pnp_debug_pkg.put_log_msg('********************************************************************************');
3926:
3927: pnp_debug_pkg.put_log_msg('********************************************************************************');
3928: fnd_message.set_name ('PN','PN_SCHIT_CUST');
3929: fnd_message.set_token ('LOC_CODE', l_location_code);
3930: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3931: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3932: pnp_debug_pkg.put_log_msg(fnd_message.get);
3933: pnp_debug_pkg.put_log_msg('********************************************************************************');
3934:
3927: pnp_debug_pkg.put_log_msg('********************************************************************************');
3928: fnd_message.set_name ('PN','PN_SCHIT_CUST');
3929: fnd_message.set_token ('LOC_CODE', l_location_code);
3930: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3931: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3932: pnp_debug_pkg.put_log_msg(fnd_message.get);
3933: pnp_debug_pkg.put_log_msg('********************************************************************************');
3934:
3935: END IF;
3928: fnd_message.set_name ('PN','PN_SCHIT_CUST');
3929: fnd_message.set_token ('LOC_CODE', l_location_code);
3930: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3931: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3932: pnp_debug_pkg.put_log_msg(fnd_message.get);
3933: pnp_debug_pkg.put_log_msg('********************************************************************************');
3934:
3935: END IF;
3936: END IF;
3986: FETCH get_location_type_csr INTO l_location_code, l_loc_type_code;
3987: CLOSE get_location_type_csr;
3988:
3989: pnp_debug_pkg.put_log_msg('********************************************************************************');
3990: fnd_message.set_name ('PN','PN_SCHIT_LOCK_UPD');
3991: fnd_message.set_token ('LOC_CODE', l_location_code);
3992: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3993: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3994: pnp_debug_pkg.put_log_msg(fnd_message.get);
3987: CLOSE get_location_type_csr;
3988:
3989: pnp_debug_pkg.put_log_msg('********************************************************************************');
3990: fnd_message.set_name ('PN','PN_SCHIT_LOCK_UPD');
3991: fnd_message.set_token ('LOC_CODE', l_location_code);
3992: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3993: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3994: pnp_debug_pkg.put_log_msg(fnd_message.get);
3995: pnp_debug_pkg.put_log_msg('********************************************************************************');
3988:
3989: pnp_debug_pkg.put_log_msg('********************************************************************************');
3990: fnd_message.set_name ('PN','PN_SCHIT_LOCK_UPD');
3991: fnd_message.set_token ('LOC_CODE', l_location_code);
3992: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3993: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3994: pnp_debug_pkg.put_log_msg(fnd_message.get);
3995: pnp_debug_pkg.put_log_msg('********************************************************************************');
3996: ELSE
3989: pnp_debug_pkg.put_log_msg('********************************************************************************');
3990: fnd_message.set_name ('PN','PN_SCHIT_LOCK_UPD');
3991: fnd_message.set_token ('LOC_CODE', l_location_code);
3992: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3993: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3994: pnp_debug_pkg.put_log_msg(fnd_message.get);
3995: pnp_debug_pkg.put_log_msg('********************************************************************************');
3996: ELSE
3997:
3990: fnd_message.set_name ('PN','PN_SCHIT_LOCK_UPD');
3991: fnd_message.set_token ('LOC_CODE', l_location_code);
3992: fnd_message.set_token ('ODATE', l_tenancy_str_date);
3993: fnd_message.set_token ('EDATE', l_tenancy_end_date);
3994: pnp_debug_pkg.put_log_msg(fnd_message.get);
3995: pnp_debug_pkg.put_log_msg('********************************************************************************');
3996: ELSE
3997:
3998: UPDATE pn_tenancies_all
4010: FETCH get_location_type_csr INTO l_location_code, l_loc_type_code;
4011: CLOSE get_location_type_csr;
4012:
4013: pnp_debug_pkg.put_log_msg('********************************************************************************');
4014: fnd_message.set_name ('PN','PN_SCHIT_CUST');
4015: fnd_message.set_token ('LOC_CODE', l_location_code);
4016: fnd_message.set_token ('ODATE', l_tenancy_str_date);
4017: fnd_message.set_token ('EDATE', l_tenancy_end_date);
4018: pnp_debug_pkg.put_log_msg(fnd_message.get);
4011: CLOSE get_location_type_csr;
4012:
4013: pnp_debug_pkg.put_log_msg('********************************************************************************');
4014: fnd_message.set_name ('PN','PN_SCHIT_CUST');
4015: fnd_message.set_token ('LOC_CODE', l_location_code);
4016: fnd_message.set_token ('ODATE', l_tenancy_str_date);
4017: fnd_message.set_token ('EDATE', l_tenancy_end_date);
4018: pnp_debug_pkg.put_log_msg(fnd_message.get);
4019: pnp_debug_pkg.put_log_msg('********************************************************************************');
4012:
4013: pnp_debug_pkg.put_log_msg('********************************************************************************');
4014: fnd_message.set_name ('PN','PN_SCHIT_CUST');
4015: fnd_message.set_token ('LOC_CODE', l_location_code);
4016: fnd_message.set_token ('ODATE', l_tenancy_str_date);
4017: fnd_message.set_token ('EDATE', l_tenancy_end_date);
4018: pnp_debug_pkg.put_log_msg(fnd_message.get);
4019: pnp_debug_pkg.put_log_msg('********************************************************************************');
4020: END IF;
4013: pnp_debug_pkg.put_log_msg('********************************************************************************');
4014: fnd_message.set_name ('PN','PN_SCHIT_CUST');
4015: fnd_message.set_token ('LOC_CODE', l_location_code);
4016: fnd_message.set_token ('ODATE', l_tenancy_str_date);
4017: fnd_message.set_token ('EDATE', l_tenancy_end_date);
4018: pnp_debug_pkg.put_log_msg(fnd_message.get);
4019: pnp_debug_pkg.put_log_msg('********************************************************************************');
4020: END IF;
4021: END IF;
4014: fnd_message.set_name ('PN','PN_SCHIT_CUST');
4015: fnd_message.set_token ('LOC_CODE', l_location_code);
4016: fnd_message.set_token ('ODATE', l_tenancy_str_date);
4017: fnd_message.set_token ('EDATE', l_tenancy_end_date);
4018: pnp_debug_pkg.put_log_msg(fnd_message.get);
4019: pnp_debug_pkg.put_log_msg('********************************************************************************');
4020: END IF;
4021: END IF;
4022: END LOOP;
6494:
6495: WHEN OTHERS THEN
6496: x_return_status := FND_API.G_RET_STS_ERROR;
6497: pnp_debug_pkg.log('CREATE_PAYMENT_TERM - Others error ..' || sqlerrm);
6498: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6499:
6500: END Create_Payment_Term;
6501:
6502:
6971:
6972: BEGIN
6973:
6974:
6975: fnd_message.set_name ('PN','PN_SCHIT_DTLS');
6976: fnd_message.set_token ('ID', g_Lease_Id);
6977: fnd_message.set_token ('NUM', g_lease_num);
6978: fnd_message.set_token ('NAME', g_lease_name);
6979: fnd_message.set_token ('CONTXT', p_lease_context);
6972: BEGIN
6973:
6974:
6975: fnd_message.set_name ('PN','PN_SCHIT_DTLS');
6976: fnd_message.set_token ('ID', g_Lease_Id);
6977: fnd_message.set_token ('NUM', g_lease_num);
6978: fnd_message.set_token ('NAME', g_lease_name);
6979: fnd_message.set_token ('CONTXT', p_lease_context);
6980: pnp_debug_pkg.put_log_msg(fnd_message.get);
6973:
6974:
6975: fnd_message.set_name ('PN','PN_SCHIT_DTLS');
6976: fnd_message.set_token ('ID', g_Lease_Id);
6977: fnd_message.set_token ('NUM', g_lease_num);
6978: fnd_message.set_token ('NAME', g_lease_name);
6979: fnd_message.set_token ('CONTXT', p_lease_context);
6980: pnp_debug_pkg.put_log_msg(fnd_message.get);
6981: pnp_debug_pkg.put_log_msg('');
6974:
6975: fnd_message.set_name ('PN','PN_SCHIT_DTLS');
6976: fnd_message.set_token ('ID', g_Lease_Id);
6977: fnd_message.set_token ('NUM', g_lease_num);
6978: fnd_message.set_token ('NAME', g_lease_name);
6979: fnd_message.set_token ('CONTXT', p_lease_context);
6980: pnp_debug_pkg.put_log_msg(fnd_message.get);
6981: pnp_debug_pkg.put_log_msg('');
6982:
6975: fnd_message.set_name ('PN','PN_SCHIT_DTLS');
6976: fnd_message.set_token ('ID', g_Lease_Id);
6977: fnd_message.set_token ('NUM', g_lease_num);
6978: fnd_message.set_token ('NAME', g_lease_name);
6979: fnd_message.set_token ('CONTXT', p_lease_context);
6980: pnp_debug_pkg.put_log_msg(fnd_message.get);
6981: pnp_debug_pkg.put_log_msg('');
6982:
6983: --Bug 13641575 Formatting changes
6976: fnd_message.set_token ('ID', g_Lease_Id);
6977: fnd_message.set_token ('NUM', g_lease_num);
6978: fnd_message.set_token ('NAME', g_lease_name);
6979: fnd_message.set_token ('CONTXT', p_lease_context);
6980: pnp_debug_pkg.put_log_msg(fnd_message.get);
6981: pnp_debug_pkg.put_log_msg('');
6982:
6983: --Bug 13641575 Formatting changes
6984:
6981: pnp_debug_pkg.put_log_msg('');
6982:
6983: --Bug 13641575 Formatting changes
6984:
6985: fnd_message.set_name ('PN','PN_SCHIT_CUR');
6986: l_message := ' '||fnd_message.get||' ';
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6982:
6983: --Bug 13641575 Formatting changes
6984:
6985: fnd_message.set_name ('PN','PN_SCHIT_CUR');
6986: l_message := ' '||fnd_message.get||' ';
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6983: --Bug 13641575 Formatting changes
6984:
6985: fnd_message.set_name ('PN','PN_SCHIT_CUR');
6986: l_message := ' '||fnd_message.get||' ';
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6984:
6985: fnd_message.set_name ('PN','PN_SCHIT_CUR');
6986: l_message := ' '||fnd_message.get||' ';
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6985: fnd_message.set_name ('PN','PN_SCHIT_CUR');
6986: l_message := ' '||fnd_message.get||' ';
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');
6986: l_message := ' '||fnd_message.get||' ';
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');
6994: l_message := l_message||fnd_message.get;
6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');
6994: l_message := l_message||fnd_message.get;
6995: pnp_debug_pkg.put_log_msg(l_message);
6988: l_message := l_message||fnd_message.get||' ';
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');
6994: l_message := l_message||fnd_message.get;
6995: pnp_debug_pkg.put_log_msg(l_message);
6996:
6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');
6994: l_message := l_message||fnd_message.get;
6995: pnp_debug_pkg.put_log_msg(l_message);
6996:
6997: --Bug 13641575 Formatting changes
6990: l_message := l_message||fnd_message.get||' ';
6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');
6992: l_message := l_message||fnd_message.get||' ';
6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');
6994: l_message := l_message||fnd_message.get;
6995: pnp_debug_pkg.put_log_msg(l_message);
6996:
6997: --Bug 13641575 Formatting changes
6998:
6996:
6997: --Bug 13641575 Formatting changes
6998:
6999: IF g_lease_class_code = 'DIRECT' THEN
7000: fnd_message.set_name ('PN','PN_RICAL_DATE');
7001: l_message := fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
6997: --Bug 13641575 Formatting changes
6998:
6999: IF g_lease_class_code = 'DIRECT' THEN
7000: fnd_message.set_name ('PN','PN_RICAL_DATE');
7001: l_message := fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
6998:
6999: IF g_lease_class_code = 'DIRECT' THEN
7000: fnd_message.set_name ('PN','PN_RICAL_DATE');
7001: l_message := fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
6999: IF g_lease_class_code = 'DIRECT' THEN
7000: fnd_message.set_name ('PN','PN_RICAL_DATE');
7001: l_message := fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7000: fnd_message.set_name ('PN','PN_RICAL_DATE');
7001: l_message := fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7001: l_message := fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7003: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7005: l_message := l_message||fnd_message.get||' ';
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7013: l_message := l_message||fnd_message.get;
7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7013: l_message := l_message||fnd_message.get;
7014: pnp_debug_pkg.put_log_msg(l_message);
7007: l_message := l_message||fnd_message.get||' ';
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7013: l_message := l_message||fnd_message.get;
7014: pnp_debug_pkg.put_log_msg(l_message);
7015: ELSE
7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7013: l_message := l_message||fnd_message.get;
7014: pnp_debug_pkg.put_log_msg(l_message);
7015: ELSE
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7009: l_message := l_message||fnd_message.get||' ';
7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7011: l_message := l_message||fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7013: l_message := l_message||fnd_message.get;
7014: pnp_debug_pkg.put_log_msg(l_message);
7015: ELSE
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7017: l_message := fnd_message.get||' ';
7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');
7013: l_message := l_message||fnd_message.get;
7014: pnp_debug_pkg.put_log_msg(l_message);
7015: ELSE
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7017: l_message := fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7013: l_message := l_message||fnd_message.get;
7014: pnp_debug_pkg.put_log_msg(l_message);
7015: ELSE
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7017: l_message := fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7014: pnp_debug_pkg.put_log_msg(l_message);
7015: ELSE
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7017: l_message := fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7015: ELSE
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7017: l_message := fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7016: fnd_message.set_name ('PN','PN_RICAL_DATE');
7017: l_message := fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7017: l_message := fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7019: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7028: fnd_message.set_name ('PN','PN_SCHIT_AST');
7021: l_message := l_message||fnd_message.get||' ';
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7028: fnd_message.set_name ('PN','PN_SCHIT_AST');
7029: l_message := l_message||fnd_message.get;
7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7028: fnd_message.set_name ('PN','PN_SCHIT_AST');
7029: l_message := l_message||fnd_message.get;
7030: pnp_debug_pkg.put_log_msg(l_message);
7023: l_message := l_message||fnd_message.get||' ';
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7028: fnd_message.set_name ('PN','PN_SCHIT_AST');
7029: l_message := l_message||fnd_message.get;
7030: pnp_debug_pkg.put_log_msg(l_message);
7031: END IF;
7024: fnd_message.set_name ('PN','PN_SCHIT_REV');
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7028: fnd_message.set_name ('PN','PN_SCHIT_AST');
7029: l_message := l_message||fnd_message.get;
7030: pnp_debug_pkg.put_log_msg(l_message);
7031: END IF;
7032:
7025: l_message := l_message||fnd_message.get||' ';
7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');
7027: l_message := l_message||fnd_message.get||' ';
7028: fnd_message.set_name ('PN','PN_SCHIT_AST');
7029: l_message := l_message||fnd_message.get;
7030: pnp_debug_pkg.put_log_msg(l_message);
7031: END IF;
7032:
7033: --Bug 13641575 Formatting changes
7105:
7106: IF term_id_tab.count > 0 THEN
7107: pnp_debug_pkg.put_log_msg
7108: ('===========================================================================');
7109: fnd_message.set_name('PN', 'PN_RETRO_RECAGR_REPORT');
7110: pnp_debug_pkg.put_log_msg(fnd_message.get);
7111: pnp_debug_pkg.put_log_msg('');
7112:
7113: FOR i in 1..term_id_tab.count LOOP
7106: IF term_id_tab.count > 0 THEN
7107: pnp_debug_pkg.put_log_msg
7108: ('===========================================================================');
7109: fnd_message.set_name('PN', 'PN_RETRO_RECAGR_REPORT');
7110: pnp_debug_pkg.put_log_msg(fnd_message.get);
7111: pnp_debug_pkg.put_log_msg('');
7112:
7113: FOR i in 1..term_id_tab.count LOOP
7114: FOR rec IN get_agreements_cur(term_id_tab(i)) LOOP
7112:
7113: FOR i in 1..term_id_tab.count LOOP
7114: FOR rec IN get_agreements_cur(term_id_tab(i)) LOOP
7115:
7116: fnd_message.set_name('PN', 'PN_RECAGR_NAME_NUM');
7117: fnd_message.set_token('REC_AGR_NAME', rec.rec_agreement_name);
7118: fnd_message.set_token('REC_AGR_NUM', rec.rec_agreement_num);
7119:
7120: pnp_debug_pkg.put_log_msg(fnd_message.get);
7113: FOR i in 1..term_id_tab.count LOOP
7114: FOR rec IN get_agreements_cur(term_id_tab(i)) LOOP
7115:
7116: fnd_message.set_name('PN', 'PN_RECAGR_NAME_NUM');
7117: fnd_message.set_token('REC_AGR_NAME', rec.rec_agreement_name);
7118: fnd_message.set_token('REC_AGR_NUM', rec.rec_agreement_num);
7119:
7120: pnp_debug_pkg.put_log_msg(fnd_message.get);
7121: pnp_debug_pkg.put_log_msg('');
7114: FOR rec IN get_agreements_cur(term_id_tab(i)) LOOP
7115:
7116: fnd_message.set_name('PN', 'PN_RECAGR_NAME_NUM');
7117: fnd_message.set_token('REC_AGR_NAME', rec.rec_agreement_name);
7118: fnd_message.set_token('REC_AGR_NUM', rec.rec_agreement_num);
7119:
7120: pnp_debug_pkg.put_log_msg(fnd_message.get);
7121: pnp_debug_pkg.put_log_msg('');
7122:
7116: fnd_message.set_name('PN', 'PN_RECAGR_NAME_NUM');
7117: fnd_message.set_token('REC_AGR_NAME', rec.rec_agreement_name);
7118: fnd_message.set_token('REC_AGR_NUM', rec.rec_agreement_num);
7119:
7120: pnp_debug_pkg.put_log_msg(fnd_message.get);
7121: pnp_debug_pkg.put_log_msg('');
7122:
7123: END LOOP;
7124: END LOOP;
7170:
7171: IF term_id_tab.count > 0 THEN
7172: pnp_debug_pkg.put_log_msg
7173: ('===========================================================================');
7174: fnd_message.set_name('PN', 'PN_RETRO_VARENT_REPORT');
7175: pnp_debug_pkg.put_log_msg(fnd_message.get);
7176: pnp_debug_pkg.put_log_msg('');
7177:
7178: FOR i in 1..term_id_tab.count LOOP
7171: IF term_id_tab.count > 0 THEN
7172: pnp_debug_pkg.put_log_msg
7173: ('===========================================================================');
7174: fnd_message.set_name('PN', 'PN_RETRO_VARENT_REPORT');
7175: pnp_debug_pkg.put_log_msg(fnd_message.get);
7176: pnp_debug_pkg.put_log_msg('');
7177:
7178: FOR i in 1..term_id_tab.count LOOP
7179: FOR vr IN get_vr_cur(term_id_tab(i)) LOOP
7177:
7178: FOR i in 1..term_id_tab.count LOOP
7179: FOR vr IN get_vr_cur(term_id_tab(i)) LOOP
7180:
7181: fnd_message.set_name('PN', 'PN_VARENT_NUM');
7182: fnd_message.set_token('VAR_RENT_NUM', vr.rent_num);
7183:
7184: pnp_debug_pkg.put_log_msg(fnd_message.get);
7185: pnp_debug_pkg.put_log_msg('');
7178: FOR i in 1..term_id_tab.count LOOP
7179: FOR vr IN get_vr_cur(term_id_tab(i)) LOOP
7180:
7181: fnd_message.set_name('PN', 'PN_VARENT_NUM');
7182: fnd_message.set_token('VAR_RENT_NUM', vr.rent_num);
7183:
7184: pnp_debug_pkg.put_log_msg(fnd_message.get);
7185: pnp_debug_pkg.put_log_msg('');
7186:
7180:
7181: fnd_message.set_name('PN', 'PN_VARENT_NUM');
7182: fnd_message.set_token('VAR_RENT_NUM', vr.rent_num);
7183:
7184: pnp_debug_pkg.put_log_msg(fnd_message.get);
7185: pnp_debug_pkg.put_log_msg('');
7186:
7187: END LOOP;
7188: END LOOP;
8597: IF (l_requestId = 0 ) THEN
8598: pnp_debug_pkg.log(' ');
8599: pnp_debug_pkg.log('Could not submit Concurrent Request PNCALNDX'
8600: ||' (PN - Calculate Index Rent)');
8601: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
8602: pnp_debug_pkg.put_log_msg(fnd_message.get);
8603:
8604: ELSE -- Got a request Id
8605: pnp_debug_pkg.log(' ');
8598: pnp_debug_pkg.log(' ');
8599: pnp_debug_pkg.log('Could not submit Concurrent Request PNCALNDX'
8600: ||' (PN - Calculate Index Rent)');
8601: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');
8602: pnp_debug_pkg.put_log_msg(fnd_message.get);
8603:
8604: ELSE -- Got a request Id
8605: pnp_debug_pkg.log(' ');
8606: pnp_debug_pkg.log('Concurrent Request '||TO_CHAR(l_requestId)
8604: ELSE -- Got a request Id
8605: pnp_debug_pkg.log(' ');
8606: pnp_debug_pkg.log('Concurrent Request '||TO_CHAR(l_requestId)
8607: ||' has been submitted for: PN - Calculate Index Rent');
8608: fnd_message.set_name('PN', 'PN_SCHIT_CONC_SUCC');
8609: pnp_debug_pkg.put_log_msg(fnd_message.get);
8610: END IF;
8611: END IF;
8612:
8605: pnp_debug_pkg.log(' ');
8606: pnp_debug_pkg.log('Concurrent Request '||TO_CHAR(l_requestId)
8607: ||' has been submitted for: PN - Calculate Index Rent');
8608: fnd_message.set_name('PN', 'PN_SCHIT_CONC_SUCC');
8609: pnp_debug_pkg.put_log_msg(fnd_message.get);
8610: END IF;
8611: END IF;
8612:
8613: pnp_debug_pkg.log('');
8615: pnp_debug_pkg.log('pn_schedules_items.schedule_items -End- (-)');
8616:
8617: EXCEPTION
8618: WHEN RETRO_NOT_ENABLED_EXCEPTION THEN
8619: fnd_message.set_name ('PN', 'PN_RETRO_NOT_ENABLED');
8620: errbuf := fnd_message.get;
8621: pnp_debug_pkg.put_log_msg(errbuf);
8622: retcode := 2;
8623: RAISE;
8616:
8617: EXCEPTION
8618: WHEN RETRO_NOT_ENABLED_EXCEPTION THEN
8619: fnd_message.set_name ('PN', 'PN_RETRO_NOT_ENABLED');
8620: errbuf := fnd_message.get;
8621: pnp_debug_pkg.put_log_msg(errbuf);
8622: retcode := 2;
8623: RAISE;
8624: