DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on FND_MESSAGE

Line 3904: fnd_message.set_name ('PN','PN_SCHIT_LOCK_DEL');

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);

Line 3905: fnd_message.set_token ('LOC_CODE', l_location_code);

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('********************************************************************************');

Line 3906: fnd_message.set_token ('ODATE', l_tenancy_str_date);

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

Line 3907: fnd_message.set_token ('EDATE', l_tenancy_end_date);

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:

Line 3908: pnp_debug_pkg.put_log_msg(fnd_message.get);

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(

Line 3928: fnd_message.set_name ('PN','PN_SCHIT_CUST');

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);

Line 3929: fnd_message.set_token ('LOC_CODE', l_location_code);

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('********************************************************************************');

Line 3930: fnd_message.set_token ('ODATE', l_tenancy_str_date);

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:

Line 3931: fnd_message.set_token ('EDATE', l_tenancy_end_date);

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;

Line 3932: pnp_debug_pkg.put_log_msg(fnd_message.get);

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;

Line 3990: fnd_message.set_name ('PN','PN_SCHIT_LOCK_UPD');

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);

Line 3991: fnd_message.set_token ('LOC_CODE', l_location_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);
3995: pnp_debug_pkg.put_log_msg('********************************************************************************');

Line 3992: fnd_message.set_token ('ODATE', l_tenancy_str_date);

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

Line 3993: fnd_message.set_token ('EDATE', l_tenancy_end_date);

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:

Line 3994: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

Line 4014: fnd_message.set_name ('PN','PN_SCHIT_CUST');

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);

Line 4015: fnd_message.set_token ('LOC_CODE', l_location_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);
4019: pnp_debug_pkg.put_log_msg('********************************************************************************');

Line 4016: fnd_message.set_token ('ODATE', l_tenancy_str_date);

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;

Line 4017: fnd_message.set_token ('EDATE', l_tenancy_end_date);

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;

Line 4018: pnp_debug_pkg.put_log_msg(fnd_message.get);

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;

Line 6498: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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:

Line 6975: fnd_message.set_name ('PN','PN_SCHIT_DTLS');

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);

Line 6976: fnd_message.set_token ('ID', g_Lease_Id);

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);

Line 6977: fnd_message.set_token ('NUM', g_lease_num);

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('');

Line 6978: fnd_message.set_token ('NAME', g_lease_name);

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:

Line 6979: fnd_message.set_token ('CONTXT', p_lease_context);

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

Line 6980: pnp_debug_pkg.put_log_msg(fnd_message.get);

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:

Line 6985: fnd_message.set_name ('PN','PN_SCHIT_CUR');

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');

Line 6986: l_message := ' '||fnd_message.get||' ';

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||' ';

Line 6987: fnd_message.set_name ('PN','PN_SCHIT_TOT');

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');

Line 6988: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 6989: fnd_message.set_name ('PN','PN_SCHIT_NORM');

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');

Line 6990: l_message := l_message||fnd_message.get||' ';

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;

Line 6991: fnd_message.set_name ('PN','PN_SCHIT_ACC');

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);

Line 6992: l_message := l_message||fnd_message.get||' ';

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:

Line 6993: fnd_message.set_name ('PN','PN_SCHIT_ACR');

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

Line 6994: l_message := l_message||fnd_message.get;

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:

Line 7000: fnd_message.set_name ('PN','PN_RICAL_DATE');

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');

Line 7001: l_message := fnd_message.get||' ';

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||' ';

Line 7002: fnd_message.set_name ('PN','PN_SCHIT_CODE');

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');

Line 7003: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 7004: fnd_message.set_name ('PN','PN_SCHIT_CASH');

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');

Line 7005: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 7006: fnd_message.set_name ('PN','PN_SCHIT_CASH');

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');

Line 7007: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 7008: fnd_message.set_name ('PN','PN_SCHIT_EXP');

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');

Line 7009: l_message := l_message||fnd_message.get||' ';

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;

Line 7010: fnd_message.set_name ('PN','PN_SCHIT_ADJ');

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);

Line 7011: l_message := l_message||fnd_message.get||' ';

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

Line 7012: fnd_message.set_name ('PN','PN_SCHIT_LIA');

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');

Line 7013: l_message := l_message||fnd_message.get;

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||' ';

Line 7016: fnd_message.set_name ('PN','PN_RICAL_DATE');

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');

Line 7017: l_message := fnd_message.get||' ';

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||' ';

Line 7018: fnd_message.set_name ('PN','PN_SCHIT_CODE');

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');

Line 7019: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 7020: fnd_message.set_name ('PN','PN_SCHIT_CASH');

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');

Line 7021: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 7022: fnd_message.set_name ('PN','PN_SCHIT_CASH');

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');

Line 7023: l_message := l_message||fnd_message.get||' ';

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||' ';

Line 7024: fnd_message.set_name ('PN','PN_SCHIT_REV');

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');

Line 7025: l_message := l_message||fnd_message.get||' ';

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;

Line 7026: fnd_message.set_name ('PN','PN_SCHIT_ADJ');

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);

Line 7027: l_message := l_message||fnd_message.get||' ';

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;

Line 7028: fnd_message.set_name ('PN','PN_SCHIT_AST');

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:

Line 7029: l_message := l_message||fnd_message.get;

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

Line 7109: fnd_message.set_name('PN', 'PN_RETRO_RECAGR_REPORT');

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

Line 7110: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

Line 7116: fnd_message.set_name('PN', 'PN_RECAGR_NAME_NUM');

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);

Line 7117: fnd_message.set_token('REC_AGR_NAME', rec.rec_agreement_name);

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('');

Line 7118: fnd_message.set_token('REC_AGR_NUM', rec.rec_agreement_num);

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:

Line 7120: pnp_debug_pkg.put_log_msg(fnd_message.get);

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;

Line 7174: fnd_message.set_name('PN', 'PN_RETRO_VARENT_REPORT');

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

Line 7175: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

Line 7181: fnd_message.set_name('PN', 'PN_VARENT_NUM');

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('');

Line 7182: fnd_message.set_token('VAR_RENT_NUM', vr.rent_num);

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:

Line 7184: pnp_debug_pkg.put_log_msg(fnd_message.get);

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;

Line 8601: fnd_message.set_name('PN', 'PN_SCHIT_CONC_FAIL');

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(' ');

Line 8602: pnp_debug_pkg.put_log_msg(fnd_message.get);

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)

Line 8608: fnd_message.set_name('PN', 'PN_SCHIT_CONC_SUCC');

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:

Line 8609: pnp_debug_pkg.put_log_msg(fnd_message.get);

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('');

Line 8619: fnd_message.set_name ('PN', 'PN_RETRO_NOT_ENABLED');

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;

Line 8620: errbuf := fnd_message.get;

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: