eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_LEASE_PVT dependencies on PN_NOTE_HEADERS

Line 5482: l_lookup_code PN_NOTE_HEADERS.NOTE_TYPE_LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;

5478: IS
5479: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5480: l_index BINARY_INTEGER;
5481: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
5482: l_lookup_code PN_NOTE_HEADERS.NOTE_TYPE_LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;
5483: l_cur_id NUMBER;
5484: l_tbl_index BINARY_INTEGER;
5485: l_tbl_flag NUMBER := 1;
5486: l_tbl temp_tbl_type;

Line 5553: IF (get_attribute_status('PN_NOTE_HEADERS') > 0) THEN

5549:
5550: -- dff validations
5551:
5552:
5553: IF (get_attribute_status('PN_NOTE_HEADERS') > 0) THEN
5554: ----------dbms_output.put_line('NOTE HEADER:1');
5555: /*get_attribute_mandatory_status('PN_NOTE_HEADERS'
5556: ,p_note_tbl(l_index).attribute1
5557: ,p_note_tbl(l_index).attribute2

Line 5555: /*get_attribute_mandatory_status('PN_NOTE_HEADERS'

5551:
5552:
5553: IF (get_attribute_status('PN_NOTE_HEADERS') > 0) THEN
5554: ----------dbms_output.put_line('NOTE HEADER:1');
5555: /*get_attribute_mandatory_status('PN_NOTE_HEADERS'
5556: ,p_note_tbl(l_index).attribute1
5557: ,p_note_tbl(l_index).attribute2
5558: ,p_note_tbl(l_index).attribute3
5559: ,p_note_tbl(l_index).attribute4

Line 5605: p_api_name => 'PN_NOTE_HEADERS'--l_api_name_full

5601: AND (p_note_tbl(l_index).attribute14 = pn_lease_utils.g_pn_miss_char OR p_note_tbl(l_index).attribute14 IS NULL)
5602: AND (p_note_tbl(l_index).attribute15 = pn_lease_utils.g_pn_miss_char OR p_note_tbl(l_index).attribute15 IS NULL)
5603: ) THEN
5604: PN_LEASE_UTILS.validate_desc_flex (
5605: p_api_name => 'PN_NOTE_HEADERS'--l_api_name_full
5606: , p_application_short_name => 'PN'
5607: , p_desc_flex_name => 'PN_NOTE_HEADERS'
5608: , p_desc_segment1 => p_note_tbl(l_index).attribute1
5609: , p_desc_segment2 => p_note_tbl(l_index).attribute2

Line 5607: , p_desc_flex_name => 'PN_NOTE_HEADERS'

5603: ) THEN
5604: PN_LEASE_UTILS.validate_desc_flex (
5605: p_api_name => 'PN_NOTE_HEADERS'--l_api_name_full
5606: , p_application_short_name => 'PN'
5607: , p_desc_flex_name => 'PN_NOTE_HEADERS'
5608: , p_desc_segment1 => p_note_tbl(l_index).attribute1
5609: , p_desc_segment2 => p_note_tbl(l_index).attribute2
5610: , p_desc_segment3 => p_note_tbl(l_index).attribute3
5611: , p_desc_segment4 => p_note_tbl(l_index).attribute4

Line 5633: fnd_message.set_token ('COLUMN', 'PN_NOTE_HEADERS_DESC_FIELDS');

5629: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
5630: ----------dbms_output.put_line('NOTES:1'||x_return_status);
5631: l_tbl_flag := 0;
5632: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
5633: fnd_message.set_token ('COLUMN', 'PN_NOTE_HEADERS_DESC_FIELDS');
5634: fnd_message.set_token ('P_TEXT', 'PN_NOTE_HEADERS'|| '-'|| SQLERRM);
5635: fnd_msg_pub.ADD;
5636: RAISE fnd_api.g_exc_error;
5637: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 5634: fnd_message.set_token ('P_TEXT', 'PN_NOTE_HEADERS'|| '-'|| SQLERRM);

5630: ----------dbms_output.put_line('NOTES:1'||x_return_status);
5631: l_tbl_flag := 0;
5632: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
5633: fnd_message.set_token ('COLUMN', 'PN_NOTE_HEADERS_DESC_FIELDS');
5634: fnd_message.set_token ('P_TEXT', 'PN_NOTE_HEADERS'|| '-'|| SQLERRM);
5635: fnd_msg_pub.ADD;
5636: RAISE fnd_api.g_exc_error;
5637: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
5638: ----------dbms_output.put_line('NOTES:2'||x_return_status);

Line 5641: fnd_message.set_token ('COLUMN', 'PN_NOTE_HEADERS_DESC_FIELDS');

5637: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
5638: ----------dbms_output.put_line('NOTES:2'||x_return_status);
5639: l_tbl_flag := 0;
5640: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
5641: fnd_message.set_token ('COLUMN', 'PN_NOTE_HEADERS_DESC_FIELDS');
5642: fnd_message.set_token ('P_TEXT', 'PN_NOTE_HEADERS'|| '-'|| SQLERRM);
5643: fnd_msg_pub.ADD;
5644: RAISE fnd_api.g_exc_unexpected_error;
5645: END IF;

Line 5642: fnd_message.set_token ('P_TEXT', 'PN_NOTE_HEADERS'|| '-'|| SQLERRM);

5638: ----------dbms_output.put_line('NOTES:2'||x_return_status);
5639: l_tbl_flag := 0;
5640: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
5641: fnd_message.set_token ('COLUMN', 'PN_NOTE_HEADERS_DESC_FIELDS');
5642: fnd_message.set_token ('P_TEXT', 'PN_NOTE_HEADERS'|| '-'|| SQLERRM);
5643: fnd_msg_pub.ADD;
5644: RAISE fnd_api.g_exc_unexpected_error;
5645: END IF;
5646: END IF;

Line 5696: l_note_header_id PN_NOTE_HEADERS.NOTE_HEADER_ID%TYPE;

5692: l_index BINARY_INTEGER;
5693: l_hdr_row_id VARCHAR2(100) ;
5694: l_dt_row_id VARCHAR2(100) ;
5695: l_note_header_tbl lease_note_tbl_type := p_note_tbl;
5696: l_note_header_id PN_NOTE_HEADERS.NOTE_HEADER_ID%TYPE;
5697: l_note_detail_id PN_NOTE_DETAILS.NOTE_DETAIL_ID%TYPE;
5698: BEGIN
5699: ----------------------dbms_output.put_line('PVT INSERT PROCEDURE FOR NOTE HEADER:STARTING'||p_note_tbl(1).note_date);--Rupak
5700: pvt_debug(g_pkg_name||'-Inside NOTE_INSERT_ROW',3);

Line 5707: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:Calling PN_NOTE_HEADERS_PKG.INSERT_ROW',3);

5703: -- IF p_tbl(l_index).temp_flag = 1 THEN --Commented Rupak
5704: l_hdr_row_id := NULL;
5705: l_note_header_id := NULL;
5706: -- --------------------dbms_output.put_line('PVT INSERT PROCEDURE FOR NOTE HEADER: '||l_index||' RECORD');--Rupak
5707: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:Calling PN_NOTE_HEADERS_PKG.INSERT_ROW',3);
5708: pn_note_headers_pkg.insert_row (
5709: x_rowid => l_hdr_row_id
5710: , x_note_header_id => l_note_header_id
5711: , x_lease_id => p_lease_id

Line 5708: pn_note_headers_pkg.insert_row (

5704: l_hdr_row_id := NULL;
5705: l_note_header_id := NULL;
5706: -- --------------------dbms_output.put_line('PVT INSERT PROCEDURE FOR NOTE HEADER: '||l_index||' RECORD');--Rupak
5707: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:Calling PN_NOTE_HEADERS_PKG.INSERT_ROW',3);
5708: pn_note_headers_pkg.insert_row (
5709: x_rowid => l_hdr_row_id
5710: , x_note_header_id => l_note_header_id
5711: , x_lease_id => p_lease_id
5712: , x_note_type_lookup_code => l_note_header_tbl(l_index).note_type_lookup_code

Line 5737: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:PN_NOTE_HEADERS_PKG.INSERT_ROW Successful',3);

5733: , x_attribute14 => l_note_header_tbl(l_index).attribute14
5734: , x_attribute15 => l_note_header_tbl(l_index).attribute15
5735: );
5736:
5737: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:PN_NOTE_HEADERS_PKG.INSERT_ROW Successful',3);
5738: IF l_note_header_id is NOT NULL THEN
5739: ----------------------dbms_output.put_line('NOTE HEADER CREATED WITH NOTE HEADER ID: '||l_note_header_id);--Rupak
5740: l_note_header_tbl(l_index).note_header_id := l_note_header_id;
5741: l_note_detail_id := NULL;

Line 5843: l_lookup_code PN_NOTE_HEADERS.NOTE_TYPE_LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;

5839: IS
5840: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5841: l_index BINARY_INTEGER;
5842: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
5843: l_lookup_code PN_NOTE_HEADERS.NOTE_TYPE_LOOKUP_CODE%TYPE := pn_lease_utils.g_pn_miss_char;
5844: l_cur_id NUMBER;
5845: l_tbl_index BINARY_INTEGER;
5846: l_tbl_flag NUMBER ;
5847: l_tbl temp_tbl_type;

Line 5878: FROM pn_note_headers

5874: , attribute12
5875: , attribute13
5876: , attribute14
5877: , attribute15
5878: FROM pn_note_headers
5879: WHERE note_header_id = l_cur_id;
5880: lcu_note_hdr_rec c_note%ROWTYPE;
5881: BEGIN
5882: l_return_status := fnd_api.g_ret_sts_success ;

Line 6026: , p_desc_flex_name => 'PN_NOTE_HEADERS'

6022: END IF;
6023: PN_LEASE_UTILS.validate_desc_flex (
6024: p_api_name => 'PN_API'--l_api_name_full
6025: , p_application_short_name => 'PN'
6026: , p_desc_flex_name => 'PN_NOTE_HEADERS'
6027: , p_desc_segment1 => p_note_tbl(l_index).attribute1
6028: , p_desc_segment2 => p_note_tbl(l_index).attribute2
6029: , p_desc_segment3 => p_note_tbl(l_index).attribute3
6030: , p_desc_segment4 => p_note_tbl(l_index).attribute4

Line 6104: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:Calling PN_NOTE_HEADERS_PKG.UPDATE_ROW',3);

6100: BEGIN
6101: ----------------dbms_output.put_line('IN UPDATE NOTE:1'||p_tbl(l_index).temp_flag);
6102: l_flag := 'N';
6103: IF p_tbl(l_index).temp_flag = 2 THEN
6104: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:Calling PN_NOTE_HEADERS_PKG.UPDATE_ROW',3);
6105: pn_note_headers_pkg.update_row (
6106: x_note_header_id => p_note_tbl(l_index).note_header_id
6107: , x_lease_id => p_lease_id
6108: , x_note_type_lookup_code => p_note_tbl(l_index).note_type_lookup_code

Line 6105: pn_note_headers_pkg.update_row (

6101: ----------------dbms_output.put_line('IN UPDATE NOTE:1'||p_tbl(l_index).temp_flag);
6102: l_flag := 'N';
6103: IF p_tbl(l_index).temp_flag = 2 THEN
6104: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:Calling PN_NOTE_HEADERS_PKG.UPDATE_ROW',3);
6105: pn_note_headers_pkg.update_row (
6106: x_note_header_id => p_note_tbl(l_index).note_header_id
6107: , x_lease_id => p_lease_id
6108: , x_note_type_lookup_code => p_note_tbl(l_index).note_type_lookup_code
6109: , x_note_date => trunc(p_note_tbl(l_index).note_date)

Line 6134: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:Calling PN_NOTE_HEADERS_PKG.UPDATE_ROW Succesful',3);

6130: --x_return_status:=fnd_api.g_ret_sts_success;
6131:
6132: l_flag := 'Y';
6133: ----------------------dbms_output.put_line('NOTE HEADER UPDATED WITH NOTE HEADER ID : '||p_note_tbl(l_index).note_header_id );--Rupak
6134: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:Calling PN_NOTE_HEADERS_PKG.UPDATE_ROW Succesful',3);
6135: ----------------dbms_output.put_line('Note Details:123'||p_note_tbl(l_index).note_detail_id);
6136: IF (p_note_tbl(l_index).note_detail_id IS NULL OR p_note_tbl(l_index).note_detail_id = pn_lease_utils.g_pn_miss_num) THEN
6137: BEGIN
6138: SELECT note_detail_id