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.JTF_TERRITORY_TYPE_PVT dependencies on JTF_TERR_TYPES

Line 811: FROM jtf_terr_types

807: attribute12,
808: attribute13,
809: attribute14,
810: attribute15
811: FROM jtf_terr_types
812: WHERE terr_type_id = l_terrtype_id
813: FOR UPDATE NOWAIT;
814:
815: --Local variable declaration

Line 901: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');

897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
898: THEN
899: --dbms_ourtput.put_line('De-Activate Terrtype PVT: C_GetTerrType%NOTFOUND');
900: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
901: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
902: fnd_message.set_token ('PK_ID', TO_CHAR (p_terrtype_id));
903: fnd_msg_pub.add;
904: END IF;
905:

Line 910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');

906: RAISE fnd_api.g_exc_error;
907: END IF;
908:
909: CLOSE c_getterrtype;
910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
911: jtf_terr_types_pkg.update_row (
912: x_rowid => l_rowid,
913: x_terr_type_id => l_ref_terrtype_rec.terr_type_id,
914: x_last_updated_by => l_ref_terrtype_rec.last_updated_by,

Line 911: jtf_terr_types_pkg.update_row (

907: END IF;
908:
909: CLOSE c_getterrtype;
910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
911: jtf_terr_types_pkg.update_row (
912: x_rowid => l_rowid,
913: x_terr_type_id => l_ref_terrtype_rec.terr_type_id,
914: x_last_updated_by => l_ref_terrtype_rec.last_updated_by,
915: x_last_update_date => l_ref_terrtype_rec.last_update_date,

Line 1206: FROM jtf_terr_types

1202: l_terrtype_rec.attribute12,
1203: l_terrtype_rec.attribute13,
1204: l_terrtype_rec.attribute14,
1205: l_terrtype_rec.attribute15
1206: FROM jtf_terr_types
1207: WHERE terr_type_id = p_terrtype_id;
1208: l_terrtype_rec.terr_type_id := NULL;
1209: l_terrtype_rec.name := p_terrtype_name;
1210: l_terrtype_rec.description := p_terrtype_description;

Line 1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');

1728:
1729: --dbms_output.put_line('Value of l_terrtype_id='||TO_CHAR(l_terrtype_id));
1730:
1731: -- Call insert terr_all table handler
1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');
1733: jtf_terr_types_pkg.insert_row (
1734: x_rowid => l_rowid,
1735: x_terr_type_id => l_terrtype_id,
1736: x_last_updated_by => p_terrtype_rec.last_updated_by,

Line 1733: jtf_terr_types_pkg.insert_row (

1729: --dbms_output.put_line('Value of l_terrtype_id='||TO_CHAR(l_terrtype_id));
1730:
1731: -- Call insert terr_all table handler
1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');
1733: jtf_terr_types_pkg.insert_row (
1734: x_rowid => l_rowid,
1735: x_terr_type_id => l_terrtype_id,
1736: x_last_updated_by => p_terrtype_rec.last_updated_by,
1737: x_last_update_date => p_terrtype_rec.last_update_date,

Line 2842: FROM jtf_terr_types

2838: attribute12,
2839: attribute13,
2840: attribute14,
2841: attribute15
2842: FROM jtf_terr_types
2843: WHERE terr_type_id = l_terrtype_id
2844: FOR UPDATE NOWAIT;
2845:
2846: --

Line 2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');

2963: END IF;
2964: END IF;
2965:
2966: --
2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
2968: jtf_terr_types_pkg.update_row (
2969: x_rowid => l_rowid,
2970: x_terr_type_id => p_terrtype_rec.terr_type_id,
2971: x_last_updated_by => p_terrtype_rec.last_updated_by,

Line 2968: jtf_terr_types_pkg.update_row (

2964: END IF;
2965:
2966: --
2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
2968: jtf_terr_types_pkg.update_row (
2969: x_rowid => l_rowid,
2970: x_terr_type_id => p_terrtype_rec.terr_type_id,
2971: x_last_updated_by => p_terrtype_rec.last_updated_by,
2972: x_last_update_date => p_terrtype_rec.last_update_date,

Line 4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');

4165:
4166: --Initialize the return status to success
4167: x_return_status := fnd_api.g_ret_sts_success;
4168: --
4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');
4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);
4171: --
4172: --Prepare message name
4173: fnd_message.set_name ('JTF', 'TERRTYPE_RECORDS_DELETED');

Line 4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);

4166: --Initialize the return status to success
4167: x_return_status := fnd_api.g_ret_sts_success;
4168: --
4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');
4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);
4171: --
4172: --Prepare message name
4173: fnd_message.set_name ('JTF', 'TERRTYPE_RECORDS_DELETED');
4174:

Line 5030: 'JTF_TERR_TYPES'

5026:
5027: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5028: l_validate_id,
5029: 'TERR_TYPE_ID',
5030: 'JTF_TERR_TYPES'
5031: ) <>
5032: fnd_api.g_true
5033: THEN
5034: --dbms_output.put_line (

Line 5038: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');

5034: --dbms_output.put_line (
5035: -- 'Validate_Territory_Usage: l_status <> FND_API.G_TRUE'
5036: --);
5037: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5038: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5039: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5040: fnd_msg_pub.add;
5041: x_return_status := fnd_api.g_ret_sts_error;
5042: END IF;

Line 5256: 'JTF_TERR_TYPES'

5252:
5253: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5254: l_validate_id,
5255: 'TERR_TYPE_ID',
5256: 'JTF_TERR_TYPES'
5257: ) <>
5258: fnd_api.g_true
5259: THEN
5260: --dbms_output.put_line (

Line 5267: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');

5263:
5264: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5265: THEN
5266: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5267: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5268: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5269: fnd_msg_pub.add;
5270: END IF;
5271: