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

Line 575: -- x_return_status should be FND_API.G_RET_STS_SUCCESS for the client's

571:
572: -- Returns the list of all clients with the specified inq record types
573: -- dirty for unprocessed new records
574: -- deferred for processed but deferred records.
575: -- x_return_status should be FND_API.G_RET_STS_SUCCESS for the client's
576: -- to be processed.
577: PROCEDURE get_all_clients(p_dirty IN VARCHAR2,
578: p_deferred IN VARCHAR2,
579: x_clients_tbl OUT NOCOPY vc2_tbl_type,

Line 606: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND

602: ORDER BY a.user_name;
603: BEGIN
604:
605: -- Trivial case
606: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND
607: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: return;
610: END IF;

Line 607: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN

603: BEGIN
604:
605: -- Trivial case
606: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND
607: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: return;
610: END IF;
611:

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604:
605: -- Trivial case
606: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND
607: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: return;
610: END IF;
611:
612: IF ( (p_dirty NOT IN ('Y', 'N')) OR (p_deferred NOT IN ('Y', 'N')) ) OR

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: END IF;
611:
612: IF ( (p_dirty NOT IN ('Y', 'N')) OR (p_deferred NOT IN ('Y', 'N')) ) OR
613: ( (p_dirty = 'N') AND (p_deferred = 'N') ) THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: return;
616: END IF;
617:
618: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 618: x_return_status := FND_API.G_RET_STS_SUCCESS;

614: x_return_status := FND_API.G_RET_STS_ERROR;
615: return;
616: END IF;
617:
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: counter :=1;
620: IF (p_dirty = 'Y') THEN
621: IF(p_deferred = 'Y') THEN
622: FOR cclnt_yy IN c_clients_yy LOOP

Line 654: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN

650: FROM asg_users_inqinfo a
651: WHERE a.device_user_name = p_user_name
652: ORDER BY tranid;
653: BEGIN
654: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: return;
657: END IF;
658:

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: WHERE a.device_user_name = p_user_name
652: ORDER BY tranid;
653: BEGIN
654: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: return;
657: END IF;
658:
659: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 659: x_return_status := FND_API.G_RET_STS_SUCCESS;

655: x_return_status := FND_API.G_RET_STS_ERROR;
656: return;
657: END IF;
658:
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660: counter :=1;
661: FOR cat IN c_all_tran(p_user_name) LOOP
662: x_tranids_tbl(counter) := cat.tranid;
663: counter := counter +1;

Line 685: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

681: l_select_store_sqlstring VARCHAR2(512);
682: l_select_obj_sqlstring VARCHAR2(4000);
683: l_obj_name VARCHAR2(30);
684: BEGIN
685: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
686: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: return;
689: END IF;

Line 686: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

682: l_select_obj_sqlstring VARCHAR2(4000);
683: l_obj_name VARCHAR2(30);
684: BEGIN
685: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
686: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: return;
689: END IF;
690:

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: l_obj_name VARCHAR2(30);
684: BEGIN
685: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
686: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: return;
689: END IF;
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: x_return_status := FND_API.G_RET_STS_ERROR;
688: return;
689: END IF;
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: l_select_store_sqlstring :=
693: 'SELECT store ' ||
694: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
695: 'WHERE clid$$cs = :1 AND ' ||

Line 770: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

766: l_select_store_sqlstring VARCHAR2(512);
767: l_select_obj_sqlstring VARCHAR2(4000);
768: l_obj_name VARCHAR2(30);
769: BEGIN
770: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
771: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
772: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: return;

Line 771: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

767: l_select_obj_sqlstring VARCHAR2(4000);
768: l_obj_name VARCHAR2(30);
769: BEGIN
770: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
771: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
772: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: return;
775: END IF;

Line 772: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN

768: l_obj_name VARCHAR2(30);
769: BEGIN
770: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
771: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
772: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: return;
775: END IF;
776:

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: BEGIN
770: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
771: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
772: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: return;
775: END IF;
776:
777: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 777: x_return_status := FND_API.G_RET_STS_SUCCESS;

773: x_return_status := FND_API.G_RET_STS_ERROR;
774: return;
775: END IF;
776:
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778: l_select_store_sqlstring :=
779: 'SELECT store ' ||
780: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
781: 'WHERE clid$$cs = :1 AND ' ||

Line 863: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

859: l_cursor_ret1 NUMBER;
860: l_store VARCHAR2(30);
861: l_select_store_sqlstring VARCHAR2(512);
862: BEGIN
863: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
864: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
865: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: return;

Line 864: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

860: l_store VARCHAR2(30);
861: l_select_store_sqlstring VARCHAR2(512);
862: BEGIN
863: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
864: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
865: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: return;
868: END IF;

Line 865: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN

861: l_select_store_sqlstring VARCHAR2(512);
862: BEGIN
863: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
864: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
865: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: return;
868: END IF;
869:

Line 866: x_return_status := FND_API.G_RET_STS_ERROR;

862: BEGIN
863: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
864: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
865: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: return;
868: END IF;
869:
870: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 870: x_return_status := FND_API.G_RET_STS_SUCCESS;

866: x_return_status := FND_API.G_RET_STS_ERROR;
867: return;
868: END IF;
869:
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871: l_select_store_sqlstring :=
872: 'SELECT store ' ||
873: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.c$inq '||
874: 'WHERE clid$$cs = :1 AND ' ||

Line 910: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists

906: sort_by_weight(p_pubname, x_pubitems_tbl);
907:
908: END get_all_dirty_pub_items;
909:
910: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
911: -- Returns both dirty and deferred tranids
912: PROCEDURE get_first_tranid(p_user_name IN VARCHAR2,
913: x_tranid OUT NOCOPY NUMBER,
914: x_return_status OUT NOCOPY VARCHAR2)

Line 927: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN

923: FROM asg_user
924: WHERE user_name=p_user_name);
925: l_compacted_tranid NUMBER;
926: BEGIN
927: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: return;
930: END IF;
931:

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

924: WHERE user_name=p_user_name);
925: l_compacted_tranid NUMBER;
926: BEGIN
927: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: return;
930: END IF;
931:
932: --12.1

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

929: return;
930: END IF;
931:
932: --12.1
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934: OPEN c_first_tran(p_user_name);
935: FETCH c_first_tran into x_tranid;
936: IF c_first_tran%NOTFOUND THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;

Line 937: x_return_status := FND_API.G_RET_STS_ERROR;

933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934: OPEN c_first_tran(p_user_name);
935: FETCH c_first_tran into x_tranid;
936: IF c_first_tran%NOTFOUND THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: CLOSE c_first_tran;
939: RETURN;
940: END IF;
941: CLOSE c_first_tran;

Line 951: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists

947: ' TranID: ' || x_tranid);
948:
949: END get_first_tranid;
950:
951: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
952: -- Returns both dirty and deferred tranids
953: PROCEDURE get_next_tranid(p_user_name IN VARCHAR2,
954: p_curr_tranid IN NUMBER,
955: x_tranid OUT NOCOPY NUMBER,

Line 970: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

966: FROM asg_user
967: WHERE user_name=p_user_name);
968: l_compacted_tranid NUMBER;
969: BEGIN
970: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
971: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: return;
974: END IF;

Line 971: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN

967: WHERE user_name=p_user_name);
968: l_compacted_tranid NUMBER;
969: BEGIN
970: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
971: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: return;
974: END IF;
975:

Line 972: x_return_status := FND_API.G_RET_STS_ERROR;

968: l_compacted_tranid NUMBER;
969: BEGIN
970: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
971: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: return;
974: END IF;
975:
976: --12.1

Line 977: x_return_status := FND_API.G_RET_STS_SUCCESS;

973: return;
974: END IF;
975:
976: --12.1
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: OPEN c_next_tran(p_user_name, p_curr_tranid);
979: FETCH c_next_tran into x_tranid;
980: IF x_tranid IS NULL THEN
981: -- When the current tranid is the last one, set the next tranid

Line 984: x_return_status := FND_API.G_RET_STS_ERROR;

980: IF x_tranid IS NULL THEN
981: -- When the current tranid is the last one, set the next tranid
982: -- also to the last one.
983: x_tranid := p_curr_tranid;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: CLOSE c_next_tran;
986: RETURN;
987: END IF;
988: CLOSE c_next_tran;

Line 1000: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists

996:
997: END get_next_tranid;
998:
999: --12.1
1000: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
1001: -- Returns both dirty and deferred tranids
1002: PROCEDURE get_compacted_tranid(p_user_name IN VARCHAR2,
1003: p_tranid IN NUMBER,
1004: x_compacted_tranid OUT NOCOPY NUMBER,

Line 1018: x_return_status := FND_API.G_RET_STS_SUCCESS;

1014: BEGIN
1015: log('get_compacted_tranid: UserName: ' || p_user_name ||
1016: ' Current TranID: ' || p_tranid);
1017:
1018: x_return_status := FND_API.G_RET_STS_SUCCESS;
1019:
1020: OPEN c_auto_sync_tranid(p_user_name, p_tranid);
1021: FETCH c_auto_sync_tranid into l_sync_id;
1022: IF c_auto_sync_tranid%NOTFOUND OR l_sync_id is null THEN

Line 1047: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if there is an error

1043:
1044: END get_compacted_tranid;
1045:
1046: --12.1
1047: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if there is an error
1048: PROCEDURE process_auto_sync(p_user_name IN VARCHAR2,
1049: p_tranid IN NUMBER,
1050: x_compacted_tranid OUT NOCOPY NUMBER,
1051: x_return_status OUT NOCOPY VARCHAR2)

Line 1065: x_return_status := FND_API.G_RET_STS_SUCCESS;

1061: l_compact_tranid NUMBER;
1062: BEGIN
1063: log('process_auto_sync: UserName: ' || p_user_name ||
1064: ' Current TranID: ' || p_tranid);
1065: x_return_status := FND_API.G_RET_STS_SUCCESS;
1066:
1067: OPEN c_end_auto_sync(p_user_name, p_tranid);
1068: FETCH c_end_auto_sync into l_end_tranid;
1069: -- Shouldn't happen normally. Handle gracefully.

Line 1072: x_return_status := FND_API.G_RET_STS_ERROR;

1068: FETCH c_end_auto_sync into l_end_tranid;
1069: -- Shouldn't happen normally. Handle gracefully.
1070: IF l_end_tranid IS NULL THEN
1071: x_compacted_tranid := p_tranid;
1072: x_return_status := FND_API.G_RET_STS_ERROR;
1073: CLOSE c_end_auto_sync;
1074: RETURN;
1075: END IF;
1076: CLOSE c_end_auto_sync;

Line 1126: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

1122: inq_tbl_name VARCHAR2(30);
1123: sql_string VARCHAR2(512);
1124: BEGIN
1125:
1126: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1127: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1128: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1129: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1127: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

1123: sql_string VARCHAR2(512);
1124: BEGIN
1125:
1126: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1127: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1128: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1129: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: return;

Line 1128: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

1124: BEGIN
1125:
1126: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1127: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1128: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1129: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: return;
1132: END IF;

Line 1129: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

1125:
1126: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1127: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1128: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1129: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: return;
1132: END IF;
1133:

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR;

1126: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1127: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1128: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1129: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: return;
1132: END IF;
1133:
1134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1134: x_return_status := FND_API.G_RET_STS_SUCCESS;

1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: return;
1132: END IF;
1133:
1134: x_return_status := FND_API.G_RET_STS_SUCCESS;
1135:
1136: IF CSM_UTIL_PKG.is_html5_user(p_user_name) THEN
1137: sql_string := 'DELETE FROM '|| csm_util_pkg.get_inq_tab(p_pubitem) ||
1138: ' WHERE clid$$cs = :1 AND ' ||' tranid$$ = :2 AND ' ||' seqno$$ = :3';

Line 1155: x_return_status := FND_API.G_RET_STS_ERROR;

1151: USING p_user_name, p_tranid, p_sequence;
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: -- Ignore exceptions
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: log('delete_row: Exception: ', g_err_level);
1157: END;
1158:
1159: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,

Line 1162: IF l_deferred_row = FND_API.G_TRUE THEN

1158:
1159: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
1160: p_pubitem, p_sequence);
1161: -- Update status to processed or passed
1162: IF l_deferred_row = FND_API.G_TRUE THEN
1163: BEGIN
1164: UPDATE asg_deferred_traninfo
1165: SET status = 0
1166: WHERE device_user_name = p_user_name AND

Line 1193: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

1189: curr_pubitem VARCHAR2(30);
1190: inq_tbl_name VARCHAR2(30);
1191: sql_string VARCHAR2(512);
1192: BEGIN
1193: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1194: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1195: (p_pubitems_tbl IS NULL) THEN
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: return;

Line 1194: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

1190: inq_tbl_name VARCHAR2(30);
1191: sql_string VARCHAR2(512);
1192: BEGIN
1193: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1194: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1195: (p_pubitems_tbl IS NULL) THEN
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: return;
1198: END IF;

Line 1196: x_return_status := FND_API.G_RET_STS_ERROR;

1192: BEGIN
1193: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1194: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1195: (p_pubitems_tbl IS NULL) THEN
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: return;
1198: END IF;
1199:
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1200: x_return_status := FND_API.G_RET_STS_SUCCESS;

1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: return;
1198: END IF;
1199:
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;
1201: num_pubitems := p_pubitems_tbl.count;
1202: FOR curr_index in 1..num_pubitems LOOP
1203: curr_pubitem := p_pubitems_tbl(curr_index);
1204: inq_tbl_name := 'CFM$' || curr_pubitem;

Line 1252: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

1248: SELECT resource_id
1249: FROM asg_user
1250: WHERE user_name = p_user_name;
1251: BEGIN
1252: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1253: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1254: (p_pubitems_tbl IS NULL) THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: return;

Line 1253: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

1249: FROM asg_user
1250: WHERE user_name = p_user_name;
1251: BEGIN
1252: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1253: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1254: (p_pubitems_tbl IS NULL) THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: return;
1257: END IF;

Line 1255: x_return_status := FND_API.G_RET_STS_ERROR;

1251: BEGIN
1252: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1253: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1254: (p_pubitems_tbl IS NULL) THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: return;
1257: END IF;
1258:
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1259: x_return_status := FND_API.G_RET_STS_SUCCESS;

1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: return;
1257: END IF;
1258:
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;
1260: num_pubitems := p_pubitems_tbl.count;
1261: FOR curr_index in 1..num_pubitems LOOP
1262: curr_pubitem := p_pubitems_tbl(curr_index);
1263: -- Change to _inq once that synonym exists

Line 1274: x_return_status := FND_API.G_RET_STS_ERROR;

1270: IF c_resource_id%NOTFOUND THEN
1271: CLOSE c_resource_id;
1272: log('purge_pubitems: User: ' || p_user_name ||
1273: ' not found in asg_user table',g_err_level);
1274: x_return_status := FND_API.G_RET_STS_ERROR;
1275: return;
1276: END IF;
1277: CLOSE c_resource_id;
1278:

Line 1368: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

1364: l_select_store_sqlstring VARCHAR2(512);
1365: l_pubitems_tbl vc2_tbl_type;
1366: BEGIN
1367:
1368: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1369: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1370: x_return_status := FND_API.G_RET_STS_ERROR;
1371: return;
1372: END IF;

Line 1369: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

1365: l_pubitems_tbl vc2_tbl_type;
1366: BEGIN
1367:
1368: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1369: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1370: x_return_status := FND_API.G_RET_STS_ERROR;
1371: return;
1372: END IF;
1373:

Line 1370: x_return_status := FND_API.G_RET_STS_ERROR;

1366: BEGIN
1367:
1368: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1369: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1370: x_return_status := FND_API.G_RET_STS_ERROR;
1371: return;
1372: END IF;
1373:
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1374: x_return_status := FND_API.G_RET_STS_SUCCESS;

1370: x_return_status := FND_API.G_RET_STS_ERROR;
1371: return;
1372: END IF;
1373:
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375: l_select_store_sqlstring :=
1376: 'SELECT store ' ||
1377: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
1378: 'WHERE clid$$cs = :1 AND ' ||

Line 1433: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

1429: FROM asg_users_inqinfo
1430: WHERE device_user_name = p_user_name AND
1431: tranid <= p_max_tranid;
1432: BEGIN
1433: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: return;
1436: END IF;
1437:

Line 1434: x_return_status := FND_API.G_RET_STS_ERROR;

1430: WHERE device_user_name = p_user_name AND
1431: tranid <= p_max_tranid;
1432: BEGIN
1433: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: return;
1436: END IF;
1437:
1438: counter :=1;

Line 1439: x_return_status := FND_API.G_RET_STS_SUCCESS;

1435: return;
1436: END IF;
1437:
1438: counter :=1;
1439: x_return_status := FND_API.G_RET_STS_SUCCESS;
1440: -- Get all the tranids for this user
1441: FOR cti in c_tranids(p_user_name, g_current_tranid) LOOP
1442: l_tranid_tbl(counter) := cti.tranid;
1443: counter := counter+1;

Line 1458: -- returns FND_API.G_FALSE if no inq processing is necessary for this user

1454:
1455: END purge_pubitems;
1456:
1457: -- Signal the beginning of inq processing for an user
1458: -- returns FND_API.G_FALSE if no inq processing is necessary for this user
1459: PROCEDURE begin_client_apply(p_user_name IN VARCHAR2,
1460: x_begin_client_apply OUT NOCOPY VARCHAR2,
1461: x_return_status OUT NOCOPY VARCHAR2)
1462: IS

Line 1467: x_return_status := FND_API.G_RET_STS_SUCCESS;

1463: l_sync_tables PLS_INTEGER;
1464: l_tranids_tbl num_tbl_type;
1465: curr_tranid NUMBER;
1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468: x_begin_client_apply := FND_API.G_TRUE;
1469:
1470: -- Check if the c$inq and asg_users_inqinfo are in sync.
1471: get_sync_state(p_user_name, l_sync_tables);

Line 1468: x_begin_client_apply := FND_API.G_TRUE;

1464: l_tranids_tbl num_tbl_type;
1465: curr_tranid NUMBER;
1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468: x_begin_client_apply := FND_API.G_TRUE;
1469:
1470: -- Check if the c$inq and asg_users_inqinfo are in sync.
1471: get_sync_state(p_user_name, l_sync_tables);
1472: log('begin_client_apply: l_sync_tables: ' || l_sync_tables,g_stmt_level);

Line 1503: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

1499: FROM asg_users_inqinfo
1500: WHERE device_user_name = p_user_name;
1501: BEGIN
1502:
1503: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: return;
1506: END IF;
1507:

Line 1504: x_return_status := FND_API.G_RET_STS_ERROR;

1500: WHERE device_user_name = p_user_name;
1501: BEGIN
1502:
1503: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: return;
1506: END IF;
1507:
1508: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1508: x_return_status := FND_API.G_RET_STS_SUCCESS;

1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: return;
1506: END IF;
1507:
1508: x_return_status := FND_API.G_RET_STS_SUCCESS;
1509: purge_pubitems(p_user_name, x_return_status);
1510: FOR caau in c_archive_asg_users(p_user_name) LOOP
1511: curr_tranid := caau.tranid;
1512: curr_tran_processed := caau.processed;

Line 1531: -- returns FND_API.G_FALSE if no user has dirty/deferred data in inq.

1527:
1528: END end_client_apply;
1529:
1530: -- Should be called before any user's transactions are processed
1531: -- returns FND_API.G_FALSE if no user has dirty/deferred data in inq.
1532: PROCEDURE begin_apply(x_begin_apply OUT NOCOPY VARCHAR2,
1533: x_return_status OUT NOCOPY VARCHAR2)
1534: IS
1535: counter PLS_INTEGER;

Line 1551: x_begin_apply := FND_API.G_TRUE;

1547: SELECT count(*) def_trans
1548: FROM asg_deferred_traninfo;
1549: BEGIN
1550:
1551: x_begin_apply := FND_API.G_TRUE;
1552: x_return_status := FND_API.G_RET_STS_SUCCESS;
1553:
1554: -- Get the list of users with dirty data
1555: l_select_users_sqlstring :=

Line 1552: x_return_status := FND_API.G_RET_STS_SUCCESS;

1548: FROM asg_deferred_traninfo;
1549: BEGIN
1550:
1551: x_begin_apply := FND_API.G_TRUE;
1552: x_return_status := FND_API.G_RET_STS_SUCCESS;
1553:
1554: -- Get the list of users with dirty data
1555: l_select_users_sqlstring :=
1556: 'SELECT distinct clid$$cs clientid ' ||

Line 1585: x_begin_apply := FND_API.G_FALSE;

1581: FETCH c_deferred into l_def_count;
1582: CLOSE c_deferred;
1583: IF l_def_count = 0 THEN
1584: -- No uploaded data, dirty or deferred
1585: x_begin_apply := FND_API.G_FALSE;
1586: g_only_deferred_trans := FND_API.G_FALSE;
1587: ELSE
1588: x_begin_apply := FND_API.G_TRUE;
1589: g_only_deferred_trans := FND_API.G_TRUE;

Line 1586: g_only_deferred_trans := FND_API.G_FALSE;

1582: CLOSE c_deferred;
1583: IF l_def_count = 0 THEN
1584: -- No uploaded data, dirty or deferred
1585: x_begin_apply := FND_API.G_FALSE;
1586: g_only_deferred_trans := FND_API.G_FALSE;
1587: ELSE
1588: x_begin_apply := FND_API.G_TRUE;
1589: g_only_deferred_trans := FND_API.G_TRUE;
1590: END IF;

Line 1588: x_begin_apply := FND_API.G_TRUE;

1584: -- No uploaded data, dirty or deferred
1585: x_begin_apply := FND_API.G_FALSE;
1586: g_only_deferred_trans := FND_API.G_FALSE;
1587: ELSE
1588: x_begin_apply := FND_API.G_TRUE;
1589: g_only_deferred_trans := FND_API.G_TRUE;
1590: END IF;
1591: ELSIF (counter >1) THEN
1592: g_only_deferred_trans := FND_API.G_FALSE;

Line 1589: g_only_deferred_trans := FND_API.G_TRUE;

1585: x_begin_apply := FND_API.G_FALSE;
1586: g_only_deferred_trans := FND_API.G_FALSE;
1587: ELSE
1588: x_begin_apply := FND_API.G_TRUE;
1589: g_only_deferred_trans := FND_API.G_TRUE;
1590: END IF;
1591: ELSIF (counter >1) THEN
1592: g_only_deferred_trans := FND_API.G_FALSE;
1593: FOR curr_index IN 1..l_users_tbl.count LOOP

Line 1592: g_only_deferred_trans := FND_API.G_FALSE;

1588: x_begin_apply := FND_API.G_TRUE;
1589: g_only_deferred_trans := FND_API.G_TRUE;
1590: END IF;
1591: ELSIF (counter >1) THEN
1592: g_only_deferred_trans := FND_API.G_FALSE;
1593: FOR curr_index IN 1..l_users_tbl.count LOOP
1594: curr_user := l_users_tbl(curr_index);
1595: begin_client_apply(curr_user, l_begin_client_apply, l_return_status);
1596: END LOOP;

Line 1606: x_return_status := FND_API.G_RET_STS_SUCCESS;

1602: -- session. Always returns TRUE.
1603: PROCEDURE end_apply(x_return_status OUT NOCOPY VARCHAR2)
1604: IS
1605: BEGIN
1606: x_return_status := FND_API.G_RET_STS_SUCCESS;
1607: END end_apply;
1608:
1609: -- Procedure to process synchronous mobile queries from client
1610: PROCEDURE process_mobile_queries(p_user_name IN VARCHAR2,

Line 1622: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

1618: l_sqlerrmsg VARCHAR2(2000);
1619:
1620: BEGIN
1621:
1622: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1623: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1624: log('process_mobile_queries: Invalid user or tranid passed: ' ||
1625: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1626: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1623: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

1619:
1620: BEGIN
1621:
1622: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1623: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1624: log('process_mobile_queries: Invalid user or tranid passed: ' ||
1625: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: return;

Line 1626: x_return_status := FND_API.G_RET_STS_ERROR;

1622: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1623: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1624: log('process_mobile_queries: Invalid user or tranid passed: ' ||
1625: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: return;
1628: END IF;
1629:
1630: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1630: x_return_status := FND_API.G_RET_STS_SUCCESS;

1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: return;
1628: END IF;
1629:
1630: x_return_status := FND_API.G_RET_STS_SUCCESS;
1631:
1632: l_sql := 'SELECT 1 FROM '|| asg_base.G_OLITE_SCHEMA
1633: ||'.C$INQ c_inq WHERE CLID$$CS=:1 AND TRANID$$=:2 AND STORE = :3'
1634: ||' AND exists (select 1 from '||asg_base.G_OLITE_SCHEMA||'.cfm$'||l_pi_name||' inq, CSM_QUERY_B b '

Line 1650: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1646: EXECUTE IMMEDIATE l_sql USING p_user_name,p_tranid,g_stmt_level,'Y',in out x_return_status;
1647:
1648: log('process_mobile_queries: status returned by CSM api - '||x_return_status);
1649:
1650: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1651:
1652: l_sql := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA
1653: ||'.c$inq c_inq WHERE CLID$$CS = :1 AND TRANID$$ = :2 AND STORE = :3'
1654: ||' AND not exists (select 1 from '||asg_base.G_OLITE_SCHEMA||'.cfm$'||l_pi_name||' inq '

Line 1792: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

1788: l_curr_val NUMBER(38);
1789: l_client_num NUMBER;
1790: BEGIN
1791:
1792: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1793: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: log('process_sequences: Invalid user or tranid passed: ' ||
1796: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);

Line 1793: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

1789: l_client_num NUMBER;
1790: BEGIN
1791:
1792: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1793: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: log('process_sequences: Invalid user or tranid passed: ' ||
1796: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1797: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790: BEGIN
1791:
1792: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1793: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: log('process_sequences: Invalid user or tranid passed: ' ||
1796: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: return;

Line 1797: x_return_status := FND_API.G_RET_STS_ERROR;

1793: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: log('process_sequences: Invalid user or tranid passed: ' ||
1796: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: return;
1799: END IF;
1800:
1801: process_sequences_bc(p_user_name,p_tranid);

Line 1803: x_return_status := FND_API.G_RET_STS_SUCCESS;

1799: END IF;
1800:
1801: process_sequences_bc(p_user_name,p_tranid);
1802:
1803: x_return_status := FND_API.G_RET_STS_SUCCESS;
1804: counter := 1;
1805:
1806: SELECT client_number INTO l_client_num
1807: FROM asg_user

Line 1910: x_return_status := FND_API.G_RET_STS_SUCCESS;

1906: SELECT resource_id
1907: FROM asg_user
1908: WHERE user_name = p_user_name;
1909: BEGIN
1910: x_return_status := FND_API.G_RET_STS_SUCCESS;
1911: curr_tranid := p_tranid;
1912:
1913: -- Remove any custom pub items from c$inq
1914: -- Custom pub items are processed directly by custom implementor.

Line 1944: x_return_status := FND_API.G_RET_STS_ERROR;

1940: CLOSE c_resource_id;
1941: IF l_resource_id IS NULL THEN
1942: log('setup_inq_info: Did not find the user: '
1943: || p_user_name || ' in asg_user table',g_err_level);
1944: x_return_status := FND_API.G_RET_STS_ERROR;
1945: return;
1946: END IF;
1947:
1948: INSERT INTO asg_users_inqinfo (device_user_name,

Line 2087: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

2083: l_userid NUMBER;
2084:
2085: BEGIN
2086:
2087: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
2088: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: return;
2091: END IF;

Line 2088: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

2084:
2085: BEGIN
2086:
2087: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
2088: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: return;
2091: END IF;
2092:

Line 2089: x_return_status := FND_API.G_RET_STS_ERROR;

2085: BEGIN
2086:
2087: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
2088: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: return;
2091: END IF;
2092:
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2093: x_return_status := FND_API.G_RET_STS_SUCCESS;

2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: return;
2091: END IF;
2092:
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;
2094:
2095:
2096: -- check if there are any entries in C$inq for this
2097: -- If there aren't any then this means there was some error and we

Line 2158: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) AND

2154: l_pubitems_tbl := g_empty_vc2_tbl;
2155: get_all_pub_items(p_user_name, p_tranid, curr_pub,
2156: l_pubitems_tbl, l_return_status);
2157: -- Check if there is any data for this publication
2158: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) AND
2159: (l_pubitems_tbl.count >0) THEN
2160:
2161: -- For current user and current publication get the
2162: -- responsibility ID and application ID.

Line 2198: x_return_status := FND_API.G_RET_STS_SUCCESS;

2194: WHEN OTHERS THEN
2195: log('process_user: Exception in wrapper call. ' ||
2196: 'Check if valid wrapper exists ' ||
2197: SQLERRM,g_err_level);
2198: x_return_status := FND_API.G_RET_STS_SUCCESS;
2199: --reset
2200: fnd_global.apps_initialize(g_conc_userid, g_conc_respid, g_conc_appid);
2201: return;
2202: END;

Line 2225: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP

2221: get_first_tranid(p_user_name => curr_user,
2222: x_tranid => curr_tranid,
2223: x_return_status => l_return_status);
2224: g_current_tranid := curr_tranid;
2225: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP
2226: log('synchronous_process_upload: Processing tranid: ' || curr_tranid,g_stmt_level);
2227: process_user(p_user_name => curr_user,
2228: p_tranid => curr_tranid,
2229: x_return_status => l_return_status);

Line 2230: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2226: log('synchronous_process_upload: Processing tranid: ' || curr_tranid,g_stmt_level);
2227: process_user(p_user_name => curr_user,
2228: p_tranid => curr_tranid,
2229: x_return_status => l_return_status);
2230: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2231: -- Make the call to get the next tranid
2232: -- This means if upload processing for one transaction failed
2233: -- upload processing for the rest of the transactions is stopped.
2234: get_next_tranid(p_user_name => curr_user,

Line 2271: retcode := FND_API.G_RET_STS_SUCCESS;

2267: BEGIN
2268:
2269: g_user_name := null;
2270: g_is_conc_program := 'Y';
2271: retcode := FND_API.G_RET_STS_SUCCESS;
2272: /*remember the conc program start time*/
2273: g_conc_start_time:=null;
2274: select sysdate into g_conc_start_time from dual;
2275:

Line 2295: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2291: CSM_UTIL_PKG.LOG( 'Processing upload of multi platform users', 'ASG_APPLY.process_upload',FND_LOG.LEVEL_PROCEDURE);
2292: CSM_HTML5_PKG.CONC_PROCESS_UPLOAD(ERRBUF,RETCODE);
2293: ELSE
2294: begin_apply(l_begin_apply, l_return_status);
2295: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2296: log('Error in begin_apply',g_err_level);
2297: retcode := l_return_status;
2298: return;
2299: END IF;

Line 2300: IF (l_begin_apply = FND_API.G_FALSE) THEN

2296: log('Error in begin_apply',g_err_level);
2297: retcode := l_return_status;
2298: return;
2299: END IF;
2300: IF (l_begin_apply = FND_API.G_FALSE) THEN
2301: -- No users to process
2302: log('No users with uploaded data',g_stmt_level);
2303: return;
2304: END IF;

Line 2305: IF (g_only_deferred_trans = FND_API.G_TRUE) THEN

2301: -- No users to process
2302: log('No users with uploaded data',g_stmt_level);
2303: return;
2304: END IF;
2305: IF (g_only_deferred_trans = FND_API.G_TRUE) THEN
2306: log('Only deferred uploaded data is available for processing',
2307: g_stmt_level);
2308: ELSE
2309: log('Both dirty and deferred uploaded data is available for processing',

Line 2321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2317: x_return_status => l_return_status);
2318: log('process_upload: Num of users to process: ' || l_users_tbl.count,
2319: g_stmt_level);
2320:
2321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2322: return;
2323: END IF;
2324:
2325: -- Fill in the client's subscriptions and handlers

Line 2335: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP

2331: get_first_tranid(p_user_name => curr_user,
2332: x_tranid => curr_tranid,
2333: x_return_status => l_return_status);
2334: g_current_tranid := curr_tranid;
2335: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP
2336: log('process_upload: Processing tranid: ' || curr_tranid,g_stmt_level);
2337: process_user(p_user_name => curr_user,
2338: p_tranid => curr_tranid,
2339: x_return_status => l_return_status);

Line 2340: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2336: log('process_upload: Processing tranid: ' || curr_tranid,g_stmt_level);
2337: process_user(p_user_name => curr_user,
2338: p_tranid => curr_tranid,
2339: x_return_status => l_return_status);
2340: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2341: -- Make the call to get the next tranid
2342: -- This means if upload processing for one transaction failed
2343: -- upload processing for the rest of the transactions is stopped.
2344: get_next_tranid(p_user_name => curr_user,