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.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on FND_API

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

123: l_parent varchar2(2000);
124:
125: BEGIN
126:
127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128: /*
129: update JTY_WEBADI_OTH_TERR_INTF
130: set parent_terr_id = null
131: where user_sequence = p_user_sequence

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: where terr_name = l_hierarchy_tbl(c).terr_name
194: and user_sequence = p_user_sequence
195: and interface_type = p_intf_type;
196: else
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: fnd_message.clear;
199: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
200: FND_MESSAGE.set_token ('POSITION', l_parent);
201: X_Msg_Data := fnd_message.get();

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: where org_id = l_hierarchy_tbl(c).org_id
236: and name = l_parent
237: and parent_territory_id = l_anc_id;
238: else
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.clear;
241: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
242: FND_MESSAGE.set_token ('POSITION', l_parent);
243: X_Msg_Data := fnd_message.get();

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265: end if;
266:
267: exception
268: when others then
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: end get_hierarchy;
271:
272: PROCEDURE VALIDATE_TERRITORY_RECORDS
273: ( P_USER_SEQUENCE IN NUMBER,

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522:
523: qual_rec Qual_Rec_Type;
524: BEGIN
525:
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: fnd_message.clear;
528: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_NAME');
529: X_Msg_Data := fnd_message.get();
530:

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538:
539: l_header := 'RSC';
540: l_action_flag := 'D';
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: fnd_message.clear;
544: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ID');
545: X_Msg_Data := fnd_message.get();
546:

Line 576: x_return_status := FND_API.G_RET_STS_ERROR;

572: and jwot.status is null;
573:
574: l_action_flag := 'U';
575:
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_message.clear;
578: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_TEMPLATE');
579: X_Msg_Data := fnd_message.get();
580:

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592: and jwot.header <> l_header
593: and jwot.status is null
594: AND jwot.TERR_ID is not null;
595:
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: fnd_message.clear;
598: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_TEMPLATE');
599: X_Msg_Data := fnd_message.get();
600:

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608: and jwot.status is null;
609:
610: -- Commented it as a part of fix for bug #5479649
611: /*
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: fnd_message.clear;
614: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
615: X_Msg_Data := fnd_message.get();
616:

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662:
663: -- Fix for bug #5479649 START
664: -- An error message should be displayed when all the access types
665: -- are NONE for all the transaction type of a resource.
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: fnd_message.clear;
668: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
669: X_Msg_Data := fnd_message.get();
670: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: -- Fix for bug #5479649 END.
695:
696: -- Fix for bug # 6372728 START
697: -- Should display a error message when user tries to add a duplicate reosurce.
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: fnd_message.clear;
700: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_RESOURCE');
701: X_Msg_Data := fnd_message.get();
702:

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721:
722: -- Fix for bug # 6372728 END
723:
724:
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: fnd_message.clear;
727: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_START_DATE');
728: X_Msg_Data := fnd_message.get();
729:

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: and jwot.interface_type = p_intf_type
744: and jwot.header = l_header
745: and jwot.status is null;
746:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: fnd_message.clear;
749: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_END_DATE');
750: X_Msg_Data := fnd_message.get();
751:

Line 771: x_return_status := FND_API.G_RET_STS_ERROR;

767: and jwot.status is null;
768:
769:
770: l_header := 'QUAL';
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: fnd_message.clear;
773: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_QUAL');
774: X_Msg_Data := fnd_message.get();
775:

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: end if;
791:
792: l_header := 'TERR';
793:
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: fnd_message.clear;
796: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_START_DATE');
797: X_Msg_Data := fnd_message.get();
798:

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816: where jwot.parent_terr_id = jta.terr_id
817: and NOT(jwot.TERR_START_DATE between jta.START_DATE_ACTIVE and jta.END_DATE_ACTIVE))
818: );
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: fnd_message.clear;
822: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_END_DATE');
823: X_Msg_Data := fnd_message.get();
824:

Line 846: x_return_status := FND_API.G_RET_STS_ERROR;

842: where jwot.parent_terr_id = jta.terr_id
843: and NOT(jwot.TERR_END_DATE between jta.START_DATE_ACTIVE and jta.END_DATE_ACTIVE))
844: );
845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: fnd_message.clear;
848: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_ACCESS');
849: X_Msg_Data := fnd_message.get();
850:

Line 872: x_return_status := FND_API.G_RET_STS_SUCCESS;

868: and jwot.INTERFACE_TYPE = p_intf_type
869: and jwot.header <> l_header
870: and jwot.status is null;
871:
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: select count(*) into l_count
875: from JTY_WEBADI_OTH_TERR_INTF jwot
876: where status is not null

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885: where status is null
886: and jwot.USER_SEQUENCE = p_USER_SEQUENCE
887: and jwot.INTERFACE_TYPE = p_intf_type;
888:
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: else
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892: end if;
893:

Line 891: x_return_status := FND_API.G_RET_STS_SUCCESS;

887: and jwot.INTERFACE_TYPE = p_intf_type;
888:
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: else
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892: end if;
893:
894: EXCEPTION
895: WHEN OTHERS THEN

Line 896: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

892: end if;
893:
894: EXCEPTION
895: WHEN OTHERS THEN
896: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
897: END VALIDATE_TERRITORY_RECORDS;
898:
899: PROCEDURE SET_CREATE_RECORDS(
900: p_user_sequence IN NUMBER,

Line 1861: x_return_status := FND_API.G_RET_STS_SUCCESS;

1857:
1858: BEGIN
1859:
1860: -- process territory deletion
1861: x_return_status := FND_API.G_RET_STS_SUCCESS;
1862: l_header := 'TERR';
1863: open get_del_terr_csr(p_user_sequence, p_action_flag, p_intf_type, l_header);
1864: fetch get_del_terr_csr bulk collect into l_del_terr_rec.terr_id, l_del_terr_rec.lay_seq_num;
1865: close get_del_terr_csr;

Line 1911: x_return_status := FND_API.G_RET_STS_ERROR;

1907: and interface_type = p_intf_type;
1908:
1909: EXCEPTION
1910: when others then
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.clear;
1913: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_TERR');
1914: X_Msg_Data := fnd_message.get();
1915:

Line 1927: x_return_status := FND_API.G_RET_STS_SUCCESS;

1923: END;
1924: end if;
1925:
1926: -- process qualifier deletion
1927: x_return_status := FND_API.G_RET_STS_SUCCESS;
1928: l_header := 'QUAL';
1929: open get_del_qual_val_csr(p_user_sequence, p_action_flag, p_intf_type, l_header);
1930: fetch get_del_qual_val_csr bulk collect into
1931: l_del_qual_val_rec.qual_value_id, l_del_qual_val_rec.lay_seq_num;

Line 1960: x_return_status := FND_API.G_RET_STS_ERROR;

1956: and interface_type = p_intf_type;
1957:
1958: EXCEPTION
1959: when others then
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: fnd_message.clear;
1962: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL');
1963: X_Msg_Data := fnd_message.get();
1964:

Line 1977: x_return_status := FND_API.G_RET_STS_SUCCESS;

1973: and interface_type = p_intf_type;
1974: END;
1975: end if;
1976:
1977: x_return_status := FND_API.G_RET_STS_SUCCESS;
1978: l_header := 'RSC';
1979: open get_del_rsc_csr(p_user_sequence, p_action_flag, p_intf_type, l_header);
1980: fetch get_del_rsc_csr bulk collect into
1981: l_del_rsc_rec.terr_rsc_id, l_del_rsc_rec.lay_seq_num;

Line 2007: x_return_status := FND_API.G_RET_STS_ERROR;

2003: and interface_type = p_intf_type;
2004:
2005: EXCEPTION
2006: when others then
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: fnd_message.clear;
2009: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_RSC');
2010: X_Msg_Data := fnd_message.get();
2011:

Line 2066: x_return_status := FND_API.G_RET_STS_ERROR;

2062: end if; --get_qual_csr
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: fnd_message.clear;
2068: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL');
2069: X_Msg_Data := fnd_message.get();
2070:

Line 2261: x_return_status := FND_API.G_RET_STS_SUCCESS;

2257: p_terr_values_out_rec.TERR_QUAL_ID;
2258:
2259: --dbms_output.put_line(' C: get_qual_csr:TV, actual row processed: '||SQL%ROWCOUNT);
2260:
2261: x_return_status := FND_API.G_RET_STS_SUCCESS;
2262: END IF; -- TERR_QUAL_ID count
2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2265: x_return_status := FND_API.G_RET_STS_ERROR;

2261: x_return_status := FND_API.G_RET_STS_SUCCESS;
2262: END IF; -- TERR_QUAL_ID count
2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: fnd_message.clear;
2267: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL_VAL');
2268: X_Msg_Data := fnd_message.get();
2269:

Line 2379: x_return_status := FND_API.G_RET_STS_SUCCESS;

2375: l_intf_type varchar2(1) := 'U';
2376:
2377: BEGIN
2378:
2379: x_return_status := FND_API.G_RET_STS_SUCCESS;
2380:
2381: open get_terr_all_csr( p_user_sequence, l_header, p_action_flag, l_intf_type);
2382: fetch get_terr_all_csr bulk collect into l_terr_all_rec.TERR_ID,
2383: l_terr_all_rec.LAST_UPDATE_DATE, l_terr_all_rec.LAST_UPDATED_BY,

Line 2519: x_return_status := FND_API.G_RET_STS_SUCCESS;

2515: and user_sequence = p_user_sequence;
2516:
2517: end if;
2518:
2519: x_return_status := FND_API.G_RET_STS_SUCCESS;
2520: if (p_action_flag = 'U' and l_terr_all_rec.TERR_ID.count > 0) then
2521:
2522: forall i in l_terr_all_rec.TERR_ID.first..l_terr_all_rec.TERR_ID.last
2523: Update JTF_TERR_ALL

Line 2568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2564:
2565: end if;
2566: EXCEPTION
2567: WHEN OTHERS THEN
2568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2569:
2570: END UPDATE_TERR;
2571:
2572: PROCEDURE UPDATE_TERR_QUAL(

Line 4258: x_return_status := FND_API.G_RET_STS_SUCCESS;

4254: l_header varchar2(15) := 'QUAL';
4255: l_action_flag varchar2(1);
4256:
4257: BEGIN
4258: x_return_status := FND_API.G_RET_STS_SUCCESS;
4259: x_msg_data := NULL;
4260:
4261: --l_action_flag := p_action_flag;
4262: l_action_flag := 'C';

Line 4283: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

4279: p_Terr_Qual_Rec => l_Terr_Qual_Rec,
4280: x_return_status => x_return_status,
4281: x_msg_data => x_msg_data);
4282:
4283: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
4284: INSERT_TERR_VALUES(
4285: p_Terr_Qual_Rec => l_terr_qual_rec,
4286: p_terr_values_out_rec => l_terr_values_out_rec,
4287: x_return_status => x_return_status,

Line 4324: if x_return_status = FND_API.G_RET_STS_ERROR then

4320: and user_sequence = p_user_sequence
4321: and header = l_header
4322: and interface_type = l_intf_type;
4323:
4324: if x_return_status = FND_API.G_RET_STS_ERROR then
4325: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4326: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
4327: SET STATUS = x_return_status,
4328: ERROR_MSG = x_msg_data

Line 4347: x_return_status := FND_API.G_RET_STS_SUCCESS;

4343:
4344: end if; -- terr_id count
4345: l_action_flag := 'U';
4346:
4347: x_return_status := FND_API.G_RET_STS_SUCCESS;
4348: open get_qual_csr(P_USER_SEQUENCE, l_action_flag, l_intf_type, l_header);
4349: fetch get_qual_csr bulk collect into
4350: l_Terr_Qual_Rec.TERR_QUAL_ID, l_Terr_Qual_Rec.terr_id,
4351: l_Terr_Qual_Rec.qual_value_id, l_Terr_Qual_Rec.qual_value1,

Line 4368: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

4364: p_Terr_Qual_Rec => l_Terr_Qual_Rec,
4365: x_return_status => x_return_status,
4366: x_msg_data => x_msg_data);
4367:
4368: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
4369: INSERT_TERR_VALUES(
4370: p_Terr_Qual_Rec => l_terr_qual_rec,
4371: p_terr_values_out_rec => l_terr_values_out_rec,
4372: x_return_status => x_return_status,

Line 4409: if x_return_status = FND_API.G_RET_STS_ERROR then

4405: and user_sequence = p_user_sequence
4406: and header = l_header
4407: and interface_type = l_intf_type;
4408:
4409: if x_return_status = FND_API.G_RET_STS_ERROR then
4410: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4411: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
4412: SET STATUS = x_return_status,
4413: ERROR_MSG = x_msg_data

Line 4430: x_return_status := FND_API.G_RET_STS_SUCCESS;

4426: and user_sequence = p_user_sequence;
4427: end if;
4428: end if; -- terr_id count
4429:
4430: x_return_status := FND_API.G_RET_STS_SUCCESS;
4431: open get_c_terr_value_csr(P_USER_SEQUENCE, l_intf_type, l_header);
4432: fetch get_c_terr_value_csr bulk collect into
4433: l_Terr_Qual_Rec.TERR_QUAL_ID, l_Terr_Qual_Rec.terr_id,
4434: l_Terr_Qual_Rec.qual_value_id, l_Terr_Qual_Rec.qual_value1,

Line 4451: if x_return_status = FND_API.G_RET_STS_ERROR then

4447: p_terr_values_out_rec => l_terr_values_out_rec,
4448: x_return_status => x_return_status,
4449: x_msg_data => x_msg_data);
4450:
4451: if x_return_status = FND_API.G_RET_STS_ERROR then
4452: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4453: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
4454: SET STATUS = x_return_status,
4455: ERROR_MSG = x_msg_data

Line 4488: x_return_status := FND_API.G_RET_STS_SUCCESS;

4484:
4485: if (l_Terr_Qual_Rec.TERR_QUAL_ID.count > 0) then
4486: BEGIN
4487: --dbms_output.put_line('U: get_u_terr_value_csr: update TV, rowcount: ' || l_Terr_Qual_Rec.TERR_QUAL_ID.count);
4488: x_return_status := FND_API.G_RET_STS_SUCCESS;
4489: for i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last loop
4490:
4491: l_Terr_Values_Rec.LAST_UPDATE_DATE(i) := l_Terr_Qual_Rec.LAST_UPDATE_DATE(i);
4492: l_Terr_Values_Rec.LAST_UPDATED_BY(i) := l_Terr_Qual_Rec.LAST_UPDATED_BY(i);

Line 4606: x_return_status := FND_API.G_RET_STS_ERROR;

4602: --dbms_output.put_line(' U: get_u_terr_value_csr:TV, actual row processed: '||SQL%ROWCOUNT);
4603:
4604: EXCEPTION
4605: WHEN OTHERS THEN
4606: x_return_status := FND_API.G_RET_STS_ERROR;
4607: fnd_message.clear;
4608: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_QUAL_VAL');
4609: X_Msg_Data := fnd_message.get();
4610:

Line 4641: x_return_status := FND_API.G_RET_STS_SUCCESS;

4637:
4638: if (l_Terr_Qual_Rec.TERR_QUAL_ID.count > 0) then
4639: BEGIN
4640: --dbms_output.put_line('U: get_d_terr_value_csr: delete TV, rowcount: ' || l_Terr_Qual_Rec.TERR_QUAL_ID.count);
4641: x_return_status := FND_API.G_RET_STS_SUCCESS;
4642: forall i in l_Terr_Qual_Rec.qual_value_id.first..l_Terr_Qual_Rec.qual_value_id.last
4643: DELETE FROM JTF_TERR_VALUES_ALL
4644: where TERR_VALUE_ID = l_Terr_Qual_Rec.qual_value_id(i);
4645: --dbms_output.put_line(' U: get_d_terr_value_csr:actual row processed: '||SQL%ROWCOUNT);

Line 4675: x_return_status := FND_API.G_RET_STS_ERROR;

4671: and user_sequence = p_user_sequence;
4672:
4673: EXCEPTION
4674: WHEN OTHERS THEN
4675: x_return_status := FND_API.G_RET_STS_ERROR;
4676: fnd_message.clear;
4677: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL_VAL');
4678: X_Msg_Data := fnd_message.get();
4679:

Line 5058: x_return_status := FND_API.G_RET_STS_SUCCESS;

5054:
5055: BEGIN
5056:
5057: --l_action_flag := p_action_flag;
5058: x_return_status := FND_API.G_RET_STS_SUCCESS;
5059: l_action_flag := 'C';
5060:
5061: -- process resource records
5062: open get_rsc_csr(p_user_sequence, l_intf_type, l_header, l_action_flag);

Line 5189: x_return_status := FND_API.G_RET_STS_SUCCESS;

5185: --dbms_output.put_line(' # records processed for update: '||SQL%ROWCOUNT);
5186: end if;
5187:
5188: BEGIN
5189: x_return_status := FND_API.G_RET_STS_SUCCESS;
5190: open get_c_rsc_access_csr(P_USER_SEQUENCE, l_header, l_intf_type);
5191: fetch get_c_rsc_access_csr bulk collect into l_rsc_access_rec.TERR_RSC_ACCESS_ID,
5192: l_rsc_access_rec.LAST_UPDATE_DATE, l_rsc_access_rec.LAST_UPDATED_BY,
5193: l_rsc_access_rec.CREATION_DATE, l_rsc_access_rec.CREATED_BY,

Line 5244: x_return_status := FND_API.G_RET_STS_ERROR;

5240: end if; -- create resource access type
5241:
5242: exception
5243: when others then
5244: x_return_status := FND_API.G_RET_STS_ERROR;
5245: fnd_message.clear;
5246: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_ACCESS');
5247: X_Msg_Data := fnd_message.get();
5248:

Line 5267: x_return_status := FND_API.G_RET_STS_SUCCESS;

5263: and jwot.status is null;
5264: END;
5265:
5266: BEGIN
5267: x_return_status := FND_API.G_RET_STS_SUCCESS;
5268: open get_u_rsc_access_csr(P_USER_SEQUENCE, l_header, l_intf_type);
5269: fetch get_u_rsc_access_csr bulk collect into l_rsc_access_rec.TERR_RSC_ACCESS_ID,
5270: l_rsc_access_rec.LAST_UPDATE_DATE, l_rsc_access_rec.LAST_UPDATED_BY,
5271: l_rsc_access_rec.CREATION_DATE, l_rsc_access_rec.CREATED_BY,

Line 5309: x_return_status := FND_API.G_RET_STS_ERROR;

5305: end if;
5306:
5307: exception
5308: when others then
5309: x_return_status := FND_API.G_RET_STS_ERROR;
5310: fnd_message.clear;
5311: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_ACCESS');
5312: X_Msg_Data := fnd_message.get();
5313:

Line 5333: x_return_status := FND_API.G_RET_STS_ERROR;

5329: END;
5330:
5331: exception
5332: when others then
5333: x_return_status := FND_API.G_RET_STS_ERROR;
5334: fnd_message.clear;
5335: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_RSC');
5336: X_Msg_Data := fnd_message.get();
5337:

Line 5383: x_return_status := FND_API.G_RET_STS_SUCCESS;

5379: l_lay_seq_num number_tbl_type;
5380:
5381: BEGIN
5382:
5383: x_return_status := FND_API.G_RET_STS_SUCCESS;
5384: --l_action_flag := p_action_flag;
5385: --fnd_file.put_line( FND_FILE.OUTPUT, 'Program starting....., sequence: '||p_USER_SEQUENCE ||', user_id: '||p_user_id);
5386: --dbms_output.put_line('Program starting....., sequence: '||p_USER_SEQUENCE ||', user_id: '||p_user_id);
5387:

Line 5415: if x_return_status = FND_API.G_RET_STS_SUCCESS then

5411: x_msg_data => x_msg_data );
5412:
5413: --dbms_output.put_line('get hierarchy completed, status: ' ||x_return_status);
5414:
5415: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5416: --dbms_output.put_line('set create record ');
5417: -- set all create records id to null
5418: SET_CREATE_RECORDS(
5419: p_user_sequence => p_user_sequence,

Line 5438: if x_return_status = FND_API.G_RET_STS_SUCCESS then

5434: x_return_status => x_return_status,
5435: X_MSG_DATA => x_msg_data);
5436: --dbms_output.put_line('validating record completed, status: '||x_return_status);
5437:
5438: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5439: -- process qualifier records
5440: --dbms_output.put_line(' Call delete records procedure...');
5441: l_action_flag := 'D';
5442: delete_records(

Line 5456: if x_return_status = FND_API.G_RET_STS_SUCCESS then

5452: p_action_flag => l_action_flag,
5453: x_return_status => x_return_status,
5454: x_msg_data => x_msg_data);
5455:
5456: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5457: -- process terr update
5458: --dbms_output.put_line(' process terr update... ');
5459: l_action_flag := 'U';
5460: UPDATE_TERR(

Line 5466: if x_return_status = FND_API.G_RET_STS_SUCCESS then

5462: p_action_flag => l_action_flag,
5463: x_return_status => x_return_status,
5464: x_msg_data => x_msg_data);
5465:
5466: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5467: -- process resources
5468: --dbms_output.put_line(' process resource records');
5469: UPDATE_TERR_RSC(P_USER_SEQUENCE => p_user_sequence,
5470: --p_action_flag => l_action_flag,

Line 5474: if x_return_status = FND_API.G_RET_STS_SUCCESS then

5470: --p_action_flag => l_action_flag,
5471: x_return_status => x_return_status,
5472: x_msg_data => x_msg_data);
5473:
5474: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5475: -- process qualifier
5476: --dbms_output.put_line(' process qualifier records');
5477: UPDATE_TERR_QUAL(P_USER_SEQUENCE => p_user_sequence,
5478: --p_action_flag => l_action_flag,

Line 5573: x_errbuf := FND_API.G_RET_STS_SUCCESS;

5569: and interface_type = l_intf_type
5570: and user_sequence = p_user_sequence;
5571: end if; -- validation
5572:
5573: x_errbuf := FND_API.G_RET_STS_SUCCESS;
5574: x_retcode := 0;
5575: --commit;
5576:
5577: exception