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_LANDLORD_SERVICES

Line 7423: IF (get_attribute_status('PN_LANDLORD_SERVICES') > 0) THEN

7419: AND (p_obligation_tbl(l_index).attribute13 = pn_lease_utils.g_pn_miss_char)
7420: AND (p_obligation_tbl(l_index).attribute14 = pn_lease_utils.g_pn_miss_char)
7421: AND (p_obligation_tbl(l_index).attribute15 = pn_lease_utils.g_pn_miss_char)
7422: ) THEN*/
7423: IF (get_attribute_status('PN_LANDLORD_SERVICES') > 0) THEN
7424: /*get_attribute_mandatory_status('PN_LANDLORD_SERVICES'
7425: ,p_obligation_tbl(l_index).attribute1
7426: ,p_obligation_tbl(l_index).attribute2
7427: ,p_obligation_tbl(l_index).attribute3

Line 7424: /*get_attribute_mandatory_status('PN_LANDLORD_SERVICES'

7420: AND (p_obligation_tbl(l_index).attribute14 = pn_lease_utils.g_pn_miss_char)
7421: AND (p_obligation_tbl(l_index).attribute15 = pn_lease_utils.g_pn_miss_char)
7422: ) THEN*/
7423: IF (get_attribute_status('PN_LANDLORD_SERVICES') > 0) THEN
7424: /*get_attribute_mandatory_status('PN_LANDLORD_SERVICES'
7425: ,p_obligation_tbl(l_index).attribute1
7426: ,p_obligation_tbl(l_index).attribute2
7427: ,p_obligation_tbl(l_index).attribute3
7428: ,p_obligation_tbl(l_index).attribute4

Line 7473: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full

7469: AND (p_obligation_tbl(l_index).attribute14 = pn_lease_utils.g_pn_miss_char OR p_obligation_tbl(l_index).attribute14 IS NULL)
7470: AND (p_obligation_tbl(l_index).attribute15 = pn_lease_utils.g_pn_miss_char OR p_obligation_tbl(l_index).attribute15 IS NULL)
7471: ) THEN
7472: PN_LEASE_UTILS.validate_desc_flex (
7473: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full
7474: , p_application_short_name => 'PN'
7475: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'
7476: , p_desc_segment1 => p_obligation_tbl(l_index).attribute1
7477: , p_desc_segment2 => p_obligation_tbl(l_index).attribute2

Line 7475: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'

7471: ) THEN
7472: PN_LEASE_UTILS.validate_desc_flex (
7473: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full
7474: , p_application_short_name => 'PN'
7475: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'
7476: , p_desc_segment1 => p_obligation_tbl(l_index).attribute1
7477: , p_desc_segment2 => p_obligation_tbl(l_index).attribute2
7478: , p_desc_segment3 => p_obligation_tbl(l_index).attribute3
7479: , p_desc_segment4 => p_obligation_tbl(l_index).attribute4

Line 7500: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');

7496: ----------------------dbms_output.put_line('dff validated');
7497: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7498: l_tbl_flag := 0;
7499: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
7500: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
7501: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
7502: fnd_msg_pub.ADD;
7503: RAISE fnd_api.g_exc_error;
7504: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 7501: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);

7497: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7498: l_tbl_flag := 0;
7499: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
7500: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
7501: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
7502: fnd_msg_pub.ADD;
7503: RAISE fnd_api.g_exc_error;
7504: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7505: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

Line 7506: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');

7502: fnd_msg_pub.ADD;
7503: RAISE fnd_api.g_exc_error;
7504: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7505: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
7506: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
7507: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
7508: fnd_msg_pub.ADD;
7509: RAISE fnd_api.g_exc_unexpected_error;
7510: END IF;

Line 7507: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);

7503: RAISE fnd_api.g_exc_error;
7504: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7505: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
7506: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
7507: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
7508: fnd_msg_pub.ADD;
7509: RAISE fnd_api.g_exc_unexpected_error;
7510: END IF;
7511: END IF;

Line 7543: l_landlord_service_id PN_LANDLORD_SERVICES.LANDLORD_SERVICE_ID%TYPE;

7539: )
7540: IS
7541: --l_index NUMBER;
7542: l_row_id VARCHAR2(100) ;
7543: l_landlord_service_id PN_LANDLORD_SERVICES.LANDLORD_SERVICE_ID%TYPE;
7544: BEGIN
7545:
7546: pvt_debug(g_pkg_name||'-Inside OBLIGATION_INSERT_ROW',3);
7547: ----------------------dbms_output.put_line('In OBLIGATION_INSERT_ROW:P_LEASE_ID'||p_lease_id);--Rupak

Line 7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak

7556: for l_index in p_obligation_tbl.FIRST..p_obligation_tbl.LAST LOOP
7557: --l_index := 1;
7558: ----------------------dbms_output.put_line('In OBLIGATION_INSERT_ROW:p_obligation_tblIN FOR OUTSIDE IF'||p_obligation_tbl(l_index).temp_flag);--Rupak
7559: IF p_tbl(l_index).temp_flag = 1 THEN
7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak
7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7562: l_landlord_service_id := NULL;
7563: PN_LANDLORD_SERVICES_PKG.insert_row(
7564: X_ROWID => l_row_id,

Line 7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);

7557: --l_index := 1;
7558: ----------------------dbms_output.put_line('In OBLIGATION_INSERT_ROW:p_obligation_tblIN FOR OUTSIDE IF'||p_obligation_tbl(l_index).temp_flag);--Rupak
7559: IF p_tbl(l_index).temp_flag = 1 THEN
7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak
7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7562: l_landlord_service_id := NULL;
7563: PN_LANDLORD_SERVICES_PKG.insert_row(
7564: X_ROWID => l_row_id,
7565: X_LANDLORD_SERVICE_ID => l_landlord_service_id,

Line 7563: PN_LANDLORD_SERVICES_PKG.insert_row(

7559: IF p_tbl(l_index).temp_flag = 1 THEN
7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak
7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7562: l_landlord_service_id := NULL;
7563: PN_LANDLORD_SERVICES_PKG.insert_row(
7564: X_ROWID => l_row_id,
7565: X_LANDLORD_SERVICE_ID => l_landlord_service_id,
7566: X_LEASE_ID => p_lease_id,
7567: X_LEASE_CHANGE_ID => p_lease_change_id,

Line 7604: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:PN_LANDLORD_SERVICES_PKG.INSERT_ROW Successful',3);

7600: X_OBLIGATION_REFERENCE => p_obligation_tbl(l_index).obligation_reference,
7601: X_OBLIGATION_COMMENTS => p_obligation_tbl(l_index).obligation_comments,
7602: X_org_id => fnd_global.org_id
7603: );
7604: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:PN_LANDLORD_SERVICES_PKG.INSERT_ROW Successful',3);
7605: ----------------------dbms_output.put_line (' RECORD : '||l_index|| ' WITH landlord_service_id: '||l_landlord_service_id||' INSERTED');
7606: p_obligation_tbl(l_index).landlord_service_id := p_obligation_tbl(l_index).landlord_service_id;
7607: END IF;
7608:

Line 7616: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Exception:PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);

7612: WHEN OTHERS THEN
7613: x_return_status := fnd_api.g_ret_sts_unexp_error;
7614: ----------------------dbms_output.put_line('INSERT INTO OBLIGATIONS FAILED') ;
7615: ----------------------dbms_output.put_line('In OBLIGATION INSERT ROW PROC:sqlcode: '||sqlcode||'and sqlerrm: '||sqlerrm);--Rupak
7616: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Exception:PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7617: END OBLIGATION_INSERT_ROW;
7618:
7619: PROCEDURE CREATE_OBLIGATION (
7620: p_lease_id IN NUMBER

Line 7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;

7675: IS
7676: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7677: l_index BINARY_INTEGER;
7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;
7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;
7682: l_cur_id NUMBER;
7683: l_tbl_index BINARY_INTEGER;

Line 7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;

7677: l_index BINARY_INTEGER;
7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;
7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;
7682: l_cur_id NUMBER;
7683: l_tbl_index BINARY_INTEGER;
7684: l_tbl_flag NUMBER;
7685: l_tbl temp_tbl_type;

Line 7724: FROM pn_landlord_services_all

7720: , attribute12
7721: , attribute13
7722: , attribute14
7723: , attribute15
7724: FROM pn_landlord_services_all
7725: WHERE landlord_service_id = p_landlord_service_id;
7726: lcu_oblg_rec c_oblg%ROWTYPE;
7727: BEGIN
7728: l_return_status := fnd_api.g_ret_sts_success ;

Line 8045: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full

8041: p_obligation_tbl(l_index).attribute15 := NULL;
8042: END IF;
8043:
8044: PN_LEASE_UTILS.validate_desc_flex (
8045: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full
8046: , p_application_short_name => 'PN'
8047: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'
8048: , p_desc_segment1 => p_obligation_tbl(l_index).attribute1
8049: , p_desc_segment2 => p_obligation_tbl(l_index).attribute2

Line 8047: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'

8043:
8044: PN_LEASE_UTILS.validate_desc_flex (
8045: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full
8046: , p_application_short_name => 'PN'
8047: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'
8048: , p_desc_segment1 => p_obligation_tbl(l_index).attribute1
8049: , p_desc_segment2 => p_obligation_tbl(l_index).attribute2
8050: , p_desc_segment3 => p_obligation_tbl(l_index).attribute3
8051: , p_desc_segment4 => p_obligation_tbl(l_index).attribute4

Line 8072: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');

8068: --------------------dbms_output.put_line('dff validated');
8069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8070: l_tbl_flag := 0;
8071: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8072: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8073: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8074: fnd_msg_pub.ADD;
8075: RAISE fnd_api.g_exc_error;
8076: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

Line 8073: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);

8069: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8070: l_tbl_flag := 0;
8071: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8072: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8073: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8074: fnd_msg_pub.ADD;
8075: RAISE fnd_api.g_exc_error;
8076: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8077: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

Line 8078: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');

8074: fnd_msg_pub.ADD;
8075: RAISE fnd_api.g_exc_error;
8076: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8077: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8078: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8079: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8080: fnd_msg_pub.ADD;
8081: RAISE fnd_api.g_exc_unexpected_error;
8082: END IF;

Line 8079: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);

8075: RAISE fnd_api.g_exc_error;
8076: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8077: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8078: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8079: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8080: fnd_msg_pub.ADD;
8081: RAISE fnd_api.g_exc_unexpected_error;
8082: END IF;
8083: -- END IF;

Line 8117: l_landlord_service_id pn_landlord_services_all.LANDLORD_SERVICE_ID%TYPE;

8113: )
8114: IS
8115: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8116: l_index BINARY_INTEGER;
8117: l_landlord_service_id pn_landlord_services_all.LANDLORD_SERVICE_ID%TYPE;
8118: l_err_obg_count NUMBER:=0;
8119:
8120: BEGIN
8121: pvt_debug(g_pkg_name||'-Inside OBLIGATION_UPDATE_ROW',3);

Line 8128: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Calling PN_LANDLORD_SERVICES_PKG.update_Row',3);

8124: BEGIN
8125: ----------------------dbms_output.put_line('RECORD UPDATE STARTED FOR OBLIGATIONSIN FOR LOOP');--Rupak
8126: IF p_tbl(l_index).temp_flag = 2 THEN
8127: ----------------------dbms_output.put_line('RECORD UPDATE STARTED FOR OBLIGATIONSIN FOR LOOP IN IF');--Rupak
8128: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Calling PN_LANDLORD_SERVICES_PKG.update_Row',3);
8129: BEGIN
8130: PN_LANDLORD_SERVICES_PKG.update_Row
8131: (
8132: X_LANDLORD_SERVICE_ID => p_obligation_tbl(l_index).landlord_service_id,

Line 8130: PN_LANDLORD_SERVICES_PKG.update_Row

8126: IF p_tbl(l_index).temp_flag = 2 THEN
8127: ----------------------dbms_output.put_line('RECORD UPDATE STARTED FOR OBLIGATIONSIN FOR LOOP IN IF');--Rupak
8128: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Calling PN_LANDLORD_SERVICES_PKG.update_Row',3);
8129: BEGIN
8130: PN_LANDLORD_SERVICES_PKG.update_Row
8131: (
8132: X_LANDLORD_SERVICE_ID => p_obligation_tbl(l_index).landlord_service_id,
8133: X_LEASE_ID => p_lease_id,
8134: X_LEASE_CHANGE_ID => p_lease_change_id,

Line 8169: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:PN_LANDLORD_SERVICES_PKG.update_Row Successful',3);

8165: X_OBLIGATION_REFERENCE => p_obligation_tbl(l_index).obligation_reference,
8166: X_OBLIGATION_COMMENTS => p_obligation_tbl(l_index).obligation_comments
8167: );
8168: ----------------------dbms_output.put_line('RECORD '||l_index||' UPDATED FOR OBLIGATIONS');--Rupak
8169: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:PN_LANDLORD_SERVICES_PKG.update_Row Successful',3);
8170:
8171: EXCEPTION
8172: WHEN OTHERS THEN
8173: ----------------------dbms_output.put_line('EXCEPTION:UPDATE OBLIGATIONS'||SQLERRM);--Rupak

Line 8174: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Exception:PN_LANDLORD_SERVICES_PKG.update_Row'||SQLERRM,3);

8170:
8171: EXCEPTION
8172: WHEN OTHERS THEN
8173: ----------------------dbms_output.put_line('EXCEPTION:UPDATE OBLIGATIONS'||SQLERRM);--Rupak
8174: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Exception:PN_LANDLORD_SERVICES_PKG.update_Row'||SQLERRM,3);
8175: null;
8176: END;
8177: END IF;
8178: EXCEPTION

Line 8467: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');

8463: IF (x_return_status = fnd_api.g_ret_sts_error)
8464: THEN
8465: l_tbl_flag := 0;
8466: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8467: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8468: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8469: fnd_msg_pub.ADD;
8470: RAISE fnd_api.g_exc_error;
8471: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

Line 8468: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);

8464: THEN
8465: l_tbl_flag := 0;
8466: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8467: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8468: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8469: fnd_msg_pub.ADD;
8470: RAISE fnd_api.g_exc_error;
8471: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
8472: THEN

Line 8475: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');

8471: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
8472: THEN
8473: l_tbl_flag := 0;
8474: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8475: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8476: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8477: fnd_msg_pub.ADD;
8478: RAISE fnd_api.g_exc_unexpected_error;
8479: END IF;

Line 8476: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);

8472: THEN
8473: l_tbl_flag := 0;
8474: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
8475: fnd_message.set_token ('COLUMN', 'PN_LANDLORD_SERVICES_DESC_FIELDS');
8476: fnd_message.set_token ('P_TEXT', 'PN_LANDLORD_SERVICES'|| '-'|| SQLERRM);
8477: fnd_msg_pub.ADD;
8478: RAISE fnd_api.g_exc_unexpected_error;
8479: END IF;
8480: END IF;

Line 8917: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full

8913: p_milestone_tbl(l_index).attribute15 := NULL;
8914: END IF;
8915:
8916: PN_LEASE_UTILS.validate_desc_flex (
8917: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full
8918: , p_application_short_name => 'PN'
8919: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'
8920: , p_desc_segment1 => p_milestone_tbl(l_index).attribute1
8921: , p_desc_segment2 => p_milestone_tbl(l_index).attribute2

Line 8919: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'

8915:
8916: PN_LEASE_UTILS.validate_desc_flex (
8917: p_api_name => 'PN_LANDLORD_SERVICES'--l_api_name_full
8918: , p_application_short_name => 'PN'
8919: , p_desc_flex_name => 'PN_LANDLORD_SERVICES'
8920: , p_desc_segment1 => p_milestone_tbl(l_index).attribute1
8921: , p_desc_segment2 => p_milestone_tbl(l_index).attribute2
8922: , p_desc_segment3 => p_milestone_tbl(l_index).attribute3
8923: , p_desc_segment4 => p_milestone_tbl(l_index).attribute4