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 570: -- x_return_status should be FND_API.G_RET_STS_SUCCESS for the client's

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

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

597: ORDER BY a.user_name;
598: BEGIN
599:
600: -- Trivial case
601: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND
602: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: return;
605: END IF;

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

598: BEGIN
599:
600: -- Trivial case
601: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND
602: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: return;
605: END IF;
606:

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599:
600: -- Trivial case
601: IF ((p_dirty = FND_API.G_MISS_CHAR) OR (p_dirty IS NULL)) AND
602: ((p_deferred = FND_API.G_MISS_CHAR) OR (p_deferred IS NULL)) THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: return;
605: END IF;
606:
607: IF ( (p_dirty NOT IN ('Y', 'N')) OR (p_deferred NOT IN ('Y', 'N')) ) OR

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: END IF;
606:
607: IF ( (p_dirty NOT IN ('Y', 'N')) OR (p_deferred NOT IN ('Y', 'N')) ) OR
608: ( (p_dirty = 'N') AND (p_deferred = 'N') ) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: return;
611: END IF;
612:
613: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 613: x_return_status := FND_API.G_RET_STS_SUCCESS;

609: x_return_status := FND_API.G_RET_STS_ERROR;
610: return;
611: END IF;
612:
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614: counter :=1;
615: IF (p_dirty = 'Y') THEN
616: IF(p_deferred = 'Y') THEN
617: FOR cclnt_yy IN c_clients_yy LOOP

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

645: FROM asg_users_inqinfo a
646: WHERE a.device_user_name = p_user_name
647: ORDER BY tranid;
648: BEGIN
649: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: return;
652: END IF;
653:

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: WHERE a.device_user_name = p_user_name
647: ORDER BY tranid;
648: BEGIN
649: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: return;
652: END IF;
653:
654: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 654: x_return_status := FND_API.G_RET_STS_SUCCESS;

650: x_return_status := FND_API.G_RET_STS_ERROR;
651: return;
652: END IF;
653:
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655: counter :=1;
656: FOR cat IN c_all_tran(p_user_name) LOOP
657: x_tranids_tbl(counter) := cat.tranid;
658: counter := counter +1;

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

676: l_select_store_sqlstring VARCHAR2(512);
677: l_select_obj_sqlstring VARCHAR2(4000);
678: l_obj_name VARCHAR2(30);
679: BEGIN
680: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
681: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: return;
684: END IF;

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

677: l_select_obj_sqlstring VARCHAR2(4000);
678: l_obj_name VARCHAR2(30);
679: BEGIN
680: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
681: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: return;
684: END IF;
685:

Line 682: x_return_status := FND_API.G_RET_STS_ERROR;

678: l_obj_name VARCHAR2(30);
679: BEGIN
680: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
681: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: return;
684: END IF;
685:
686: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

682: x_return_status := FND_API.G_RET_STS_ERROR;
683: return;
684: END IF;
685:
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687: l_select_store_sqlstring :=
688: 'SELECT store ' ||
689: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
690: 'WHERE clid$$cs = :1 AND ' ||

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

760: l_select_store_sqlstring VARCHAR2(512);
761: l_select_obj_sqlstring VARCHAR2(4000);
762: l_obj_name VARCHAR2(30);
763: BEGIN
764: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
765: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
766: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: return;

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

761: l_select_obj_sqlstring VARCHAR2(4000);
762: l_obj_name VARCHAR2(30);
763: BEGIN
764: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
765: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
766: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: return;
769: END IF;

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

762: l_obj_name VARCHAR2(30);
763: BEGIN
764: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
765: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
766: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: return;
769: END IF;
770:

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: BEGIN
764: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
765: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
766: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: return;
769: END IF;
770:
771: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

767: x_return_status := FND_API.G_RET_STS_ERROR;
768: return;
769: END IF;
770:
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772: l_select_store_sqlstring :=
773: 'SELECT store ' ||
774: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
775: 'WHERE clid$$cs = :1 AND ' ||

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

853: l_cursor_ret1 NUMBER;
854: l_store VARCHAR2(30);
855: l_select_store_sqlstring VARCHAR2(512);
856: BEGIN
857: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
858: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
859: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: return;

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

854: l_store VARCHAR2(30);
855: l_select_store_sqlstring VARCHAR2(512);
856: BEGIN
857: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
858: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
859: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: return;
862: END IF;

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

855: l_select_store_sqlstring VARCHAR2(512);
856: BEGIN
857: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
858: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
859: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: return;
862: END IF;
863:

Line 860: x_return_status := FND_API.G_RET_STS_ERROR;

856: BEGIN
857: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
858: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
859: ((p_pubname = FND_API.G_MISS_CHAR) OR (p_pubname IS NULL)) THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: return;
862: END IF;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

860: x_return_status := FND_API.G_RET_STS_ERROR;
861: return;
862: END IF;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: l_select_store_sqlstring :=
866: 'SELECT store ' ||
867: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.c$inq '||
868: 'WHERE clid$$cs = :1 AND ' ||

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

900: sort_by_weight(p_pubname, x_pubitems_tbl);
901:
902: END get_all_dirty_pub_items;
903:
904: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
905: -- Returns both dirty and deferred tranids
906: PROCEDURE get_first_tranid(p_user_name IN VARCHAR2,
907: x_tranid OUT NOCOPY NUMBER,
908: x_return_status OUT NOCOPY VARCHAR2)

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

917: FROM asg_user
918: WHERE user_name=p_user_name);
919: l_compacted_tranid NUMBER;
920: BEGIN
921: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: return;
924: END IF;
925:

Line 922: x_return_status := FND_API.G_RET_STS_ERROR;

918: WHERE user_name=p_user_name);
919: l_compacted_tranid NUMBER;
920: BEGIN
921: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL))THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: return;
924: END IF;
925:
926: --12.1

Line 927: x_return_status := FND_API.G_RET_STS_SUCCESS;

923: return;
924: END IF;
925:
926: --12.1
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928: OPEN c_first_tran(p_user_name);
929: FETCH c_first_tran into x_tranid;
930: IF c_first_tran%NOTFOUND THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928: OPEN c_first_tran(p_user_name);
929: FETCH c_first_tran into x_tranid;
930: IF c_first_tran%NOTFOUND THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: CLOSE c_first_tran;
933: RETURN;
934: END IF;
935: CLOSE c_first_tran;

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

941: ' TranID: ' || x_tranid);
942:
943: END get_first_tranid;
944:
945: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
946: -- Returns both dirty and deferred tranids
947: PROCEDURE get_next_tranid(p_user_name IN VARCHAR2,
948: p_curr_tranid IN NUMBER,
949: x_tranid OUT NOCOPY NUMBER,

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

960: FROM asg_user
961: WHERE user_name=p_user_name);
962: l_compacted_tranid NUMBER;
963: BEGIN
964: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
965: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN
966: x_return_status := FND_API.G_RET_STS_ERROR;
967: return;
968: END IF;

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

961: WHERE user_name=p_user_name);
962: l_compacted_tranid NUMBER;
963: BEGIN
964: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
965: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN
966: x_return_status := FND_API.G_RET_STS_ERROR;
967: return;
968: END IF;
969:

Line 966: x_return_status := FND_API.G_RET_STS_ERROR;

962: l_compacted_tranid NUMBER;
963: BEGIN
964: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
965: ((p_curr_tranid = FND_API.G_MISS_NUM) OR (p_curr_tranid IS NULL)) THEN
966: x_return_status := FND_API.G_RET_STS_ERROR;
967: return;
968: END IF;
969:
970: --12.1

Line 971: x_return_status := FND_API.G_RET_STS_SUCCESS;

967: return;
968: END IF;
969:
970: --12.1
971: x_return_status := FND_API.G_RET_STS_SUCCESS;
972: OPEN c_next_tran(p_user_name, p_curr_tranid);
973: FETCH c_next_tran into x_tranid;
974: IF x_tranid IS NULL THEN
975: -- When the current tranid is the last one, set the next tranid

Line 978: x_return_status := FND_API.G_RET_STS_ERROR;

974: IF x_tranid IS NULL THEN
975: -- When the current tranid is the last one, set the next tranid
976: -- also to the last one.
977: x_tranid := p_curr_tranid;
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: CLOSE c_next_tran;
980: RETURN;
981: END IF;
982: CLOSE c_next_tran;

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

990:
991: END get_next_tranid;
992:
993: --12.1
994: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
995: -- Returns both dirty and deferred tranids
996: PROCEDURE get_compacted_tranid(p_user_name IN VARCHAR2,
997: p_tranid IN NUMBER,
998: x_compacted_tranid OUT NOCOPY NUMBER,

Line 1012: x_return_status := FND_API.G_RET_STS_SUCCESS;

1008: BEGIN
1009: log('get_compacted_tranid: UserName: ' || p_user_name ||
1010: ' Current TranID: ' || p_tranid);
1011:
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013:
1014: OPEN c_auto_sync_tranid(p_user_name, p_tranid);
1015: FETCH c_auto_sync_tranid into l_sync_id;
1016: IF c_auto_sync_tranid%NOTFOUND OR l_sync_id is null THEN

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

1037:
1038: END get_compacted_tranid;
1039:
1040: --12.1
1041: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if there is an error
1042: PROCEDURE process_auto_sync(p_user_name IN VARCHAR2,
1043: p_tranid IN NUMBER,
1044: x_compacted_tranid OUT NOCOPY NUMBER,
1045: x_return_status OUT NOCOPY VARCHAR2)

Line 1059: x_return_status := FND_API.G_RET_STS_SUCCESS;

1055: l_compact_tranid NUMBER;
1056: BEGIN
1057: log('process_auto_sync: UserName: ' || p_user_name ||
1058: ' Current TranID: ' || p_tranid);
1059: x_return_status := FND_API.G_RET_STS_SUCCESS;
1060:
1061: OPEN c_end_auto_sync(p_user_name, p_tranid);
1062: FETCH c_end_auto_sync into l_end_tranid;
1063: -- Shouldn't happen normally. Handle gracefully.

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

1062: FETCH c_end_auto_sync into l_end_tranid;
1063: -- Shouldn't happen normally. Handle gracefully.
1064: IF l_end_tranid IS NULL THEN
1065: x_compacted_tranid := p_tranid;
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: CLOSE c_end_auto_sync;
1068: RETURN;
1069: END IF;
1070: CLOSE c_end_auto_sync;

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

1116: inq_tbl_name VARCHAR2(30);
1117: sql_string VARCHAR2(512);
1118: BEGIN
1119:
1120: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1121: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1122: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1123: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;

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

1117: sql_string VARCHAR2(512);
1118: BEGIN
1119:
1120: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1121: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1122: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1123: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: return;

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

1118: BEGIN
1119:
1120: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1121: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1122: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1123: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: return;
1126: END IF;

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

1119:
1120: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1121: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1122: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1123: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: return;
1126: END IF;
1127:

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1121: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1122: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
1123: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: return;
1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: return;
1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129: inq_tbl_name := 'CFM$' || p_pubitem;
1130: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
1131: '.' || inq_tbl_name ||
1132: ' WHERE clid$$cs = :1 AND ' ||

Line 1143: x_return_status := FND_API.G_RET_STS_ERROR;

1139: USING p_user_name, p_tranid, p_sequence;
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: -- Ignore exceptions
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: log('delete_row: Exception: ', g_err_level);
1145: END;
1146:
1147: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,

Line 1150: IF l_deferred_row = FND_API.G_TRUE THEN

1146:
1147: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
1148: p_pubitem, p_sequence);
1149: -- Update status to processed or passed
1150: IF l_deferred_row = FND_API.G_TRUE THEN
1151: BEGIN
1152: UPDATE asg_deferred_traninfo
1153: SET status = 0
1154: WHERE device_user_name = p_user_name AND

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

1177: curr_pubitem VARCHAR2(30);
1178: inq_tbl_name VARCHAR2(30);
1179: sql_string VARCHAR2(512);
1180: BEGIN
1181: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1182: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1183: (p_pubitems_tbl IS NULL) THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: return;

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

1178: inq_tbl_name VARCHAR2(30);
1179: sql_string VARCHAR2(512);
1180: BEGIN
1181: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1182: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1183: (p_pubitems_tbl IS NULL) THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: return;
1186: END IF;

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

1180: BEGIN
1181: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1182: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1183: (p_pubitems_tbl IS NULL) THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: return;
1186: END IF;
1187:
1188: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1188: x_return_status := FND_API.G_RET_STS_SUCCESS;

1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: return;
1186: END IF;
1187:
1188: x_return_status := FND_API.G_RET_STS_SUCCESS;
1189: num_pubitems := p_pubitems_tbl.count;
1190: FOR curr_index in 1..num_pubitems LOOP
1191: curr_pubitem := p_pubitems_tbl(curr_index);
1192: inq_tbl_name := 'CFM$' || curr_pubitem;

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

1236: SELECT resource_id
1237: FROM asg_user
1238: WHERE user_name = p_user_name;
1239: BEGIN
1240: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1241: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1242: (p_pubitems_tbl IS NULL) THEN
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: return;

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

1237: FROM asg_user
1238: WHERE user_name = p_user_name;
1239: BEGIN
1240: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1241: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1242: (p_pubitems_tbl IS NULL) THEN
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: return;
1245: END IF;

Line 1243: x_return_status := FND_API.G_RET_STS_ERROR;

1239: BEGIN
1240: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1241: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
1242: (p_pubitems_tbl IS NULL) THEN
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: return;
1245: END IF;
1246:
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: return;
1245: END IF;
1246:
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;
1248: num_pubitems := p_pubitems_tbl.count;
1249: FOR curr_index in 1..num_pubitems LOOP
1250: curr_pubitem := p_pubitems_tbl(curr_index);
1251: -- Change to _inq once that synonym exists

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR;

1258: IF c_resource_id%NOTFOUND THEN
1259: CLOSE c_resource_id;
1260: log('purge_pubitems: User: ' || p_user_name ||
1261: ' not found in asg_user table',g_err_level);
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: return;
1264: END IF;
1265: CLOSE c_resource_id;
1266:

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

1352: l_select_store_sqlstring VARCHAR2(512);
1353: l_pubitems_tbl vc2_tbl_type;
1354: BEGIN
1355:
1356: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1357: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: return;
1360: END IF;

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

1353: l_pubitems_tbl vc2_tbl_type;
1354: BEGIN
1355:
1356: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1357: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: return;
1360: END IF;
1361:

Line 1358: x_return_status := FND_API.G_RET_STS_ERROR;

1354: BEGIN
1355:
1356: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1357: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: return;
1360: END IF;
1361:
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1362: x_return_status := FND_API.G_RET_STS_SUCCESS;

1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: return;
1360: END IF;
1361:
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363: l_select_store_sqlstring :=
1364: 'SELECT store ' ||
1365: 'FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq '||
1366: 'WHERE clid$$cs = :1 AND ' ||

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

1416: FROM asg_users_inqinfo
1417: WHERE device_user_name = p_user_name AND
1418: tranid <= p_max_tranid;
1419: BEGIN
1420: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: return;
1423: END IF;
1424:

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR;

1417: WHERE device_user_name = p_user_name AND
1418: tranid <= p_max_tranid;
1419: BEGIN
1420: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: return;
1423: END IF;
1424:
1425: counter :=1;

Line 1426: x_return_status := FND_API.G_RET_STS_SUCCESS;

1422: return;
1423: END IF;
1424:
1425: counter :=1;
1426: x_return_status := FND_API.G_RET_STS_SUCCESS;
1427: -- Get all the tranids for this user
1428: FOR cti in c_tranids(p_user_name, g_current_tranid) LOOP
1429: l_tranid_tbl(counter) := cti.tranid;
1430: counter := counter+1;

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

1441:
1442: END purge_pubitems;
1443:
1444: -- Signal the beginning of inq processing for an user
1445: -- returns FND_API.G_FALSE if no inq processing is necessary for this user
1446: PROCEDURE begin_client_apply(p_user_name IN VARCHAR2,
1447: x_begin_client_apply OUT NOCOPY VARCHAR2,
1448: x_return_status OUT NOCOPY VARCHAR2)
1449: IS

Line 1454: x_return_status := FND_API.G_RET_STS_SUCCESS;

1450: l_sync_tables PLS_INTEGER;
1451: l_tranids_tbl num_tbl_type;
1452: curr_tranid NUMBER;
1453: BEGIN
1454: x_return_status := FND_API.G_RET_STS_SUCCESS;
1455: x_begin_client_apply := FND_API.G_TRUE;
1456:
1457: -- Check if the c$inq and asg_users_inqinfo are in sync.
1458: get_sync_state(p_user_name, l_sync_tables);

Line 1455: x_begin_client_apply := FND_API.G_TRUE;

1451: l_tranids_tbl num_tbl_type;
1452: curr_tranid NUMBER;
1453: BEGIN
1454: x_return_status := FND_API.G_RET_STS_SUCCESS;
1455: x_begin_client_apply := FND_API.G_TRUE;
1456:
1457: -- Check if the c$inq and asg_users_inqinfo are in sync.
1458: get_sync_state(p_user_name, l_sync_tables);
1459: log('begin_client_apply: l_sync_tables: ' || l_sync_tables,g_stmt_level);

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

1486: FROM asg_users_inqinfo
1487: WHERE device_user_name = p_user_name;
1488: BEGIN
1489:
1490: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: return;
1493: END IF;
1494:

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR;

1487: WHERE device_user_name = p_user_name;
1488: BEGIN
1489:
1490: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: return;
1493: END IF;
1494:
1495: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1495: x_return_status := FND_API.G_RET_STS_SUCCESS;

1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: return;
1493: END IF;
1494:
1495: x_return_status := FND_API.G_RET_STS_SUCCESS;
1496: purge_pubitems(p_user_name, x_return_status);
1497: FOR caau in c_archive_asg_users(p_user_name) LOOP
1498: curr_tranid := caau.tranid;
1499: curr_tran_processed := caau.processed;

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

1514:
1515: END end_client_apply;
1516:
1517: -- Should be called before any user's transactions are processed
1518: -- returns FND_API.G_FALSE if no user has dirty/deferred data in inq.
1519: PROCEDURE begin_apply(x_begin_apply OUT NOCOPY VARCHAR2,
1520: x_return_status OUT NOCOPY VARCHAR2)
1521: IS
1522: counter PLS_INTEGER;

Line 1538: x_begin_apply := FND_API.G_TRUE;

1534: SELECT count(*) def_trans
1535: FROM asg_deferred_traninfo;
1536: BEGIN
1537:
1538: x_begin_apply := FND_API.G_TRUE;
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:
1541: -- Get the list of users with dirty data
1542: l_select_users_sqlstring :=

Line 1539: x_return_status := FND_API.G_RET_STS_SUCCESS;

1535: FROM asg_deferred_traninfo;
1536: BEGIN
1537:
1538: x_begin_apply := FND_API.G_TRUE;
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:
1541: -- Get the list of users with dirty data
1542: l_select_users_sqlstring :=
1543: 'SELECT distinct clid$$cs clientid ' ||

Line 1571: x_begin_apply := FND_API.G_FALSE;

1567: FETCH c_deferred into l_def_count;
1568: CLOSE c_deferred;
1569: IF l_def_count = 0 THEN
1570: -- No uploaded data, dirty or deferred
1571: x_begin_apply := FND_API.G_FALSE;
1572: g_only_deferred_trans := FND_API.G_FALSE;
1573: ELSE
1574: x_begin_apply := FND_API.G_TRUE;
1575: g_only_deferred_trans := FND_API.G_TRUE;

Line 1572: g_only_deferred_trans := FND_API.G_FALSE;

1568: CLOSE c_deferred;
1569: IF l_def_count = 0 THEN
1570: -- No uploaded data, dirty or deferred
1571: x_begin_apply := FND_API.G_FALSE;
1572: g_only_deferred_trans := FND_API.G_FALSE;
1573: ELSE
1574: x_begin_apply := FND_API.G_TRUE;
1575: g_only_deferred_trans := FND_API.G_TRUE;
1576: END IF;

Line 1574: x_begin_apply := FND_API.G_TRUE;

1570: -- No uploaded data, dirty or deferred
1571: x_begin_apply := FND_API.G_FALSE;
1572: g_only_deferred_trans := FND_API.G_FALSE;
1573: ELSE
1574: x_begin_apply := FND_API.G_TRUE;
1575: g_only_deferred_trans := FND_API.G_TRUE;
1576: END IF;
1577: ELSIF (counter >1) THEN
1578: g_only_deferred_trans := FND_API.G_FALSE;

Line 1575: g_only_deferred_trans := FND_API.G_TRUE;

1571: x_begin_apply := FND_API.G_FALSE;
1572: g_only_deferred_trans := FND_API.G_FALSE;
1573: ELSE
1574: x_begin_apply := FND_API.G_TRUE;
1575: g_only_deferred_trans := FND_API.G_TRUE;
1576: END IF;
1577: ELSIF (counter >1) THEN
1578: g_only_deferred_trans := FND_API.G_FALSE;
1579: FOR curr_index IN 1..l_users_tbl.count LOOP

Line 1578: g_only_deferred_trans := FND_API.G_FALSE;

1574: x_begin_apply := FND_API.G_TRUE;
1575: g_only_deferred_trans := FND_API.G_TRUE;
1576: END IF;
1577: ELSIF (counter >1) THEN
1578: g_only_deferred_trans := FND_API.G_FALSE;
1579: FOR curr_index IN 1..l_users_tbl.count LOOP
1580: curr_user := l_users_tbl(curr_index);
1581: begin_client_apply(curr_user, l_begin_client_apply, l_return_status);
1582: END LOOP;

Line 1592: x_return_status := FND_API.G_RET_STS_SUCCESS;

1588: -- session. Always returns TRUE.
1589: PROCEDURE end_apply(x_return_status OUT NOCOPY VARCHAR2)
1590: IS
1591: BEGIN
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593: END end_apply;
1594:
1595: -- Procedure to process sequence updates from client
1596: PROCEDURE process_sequences(p_user_name IN VARCHAR2,

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

1608: l_curr_val NUMBER(38);
1609: l_client_num NUMBER;
1610: BEGIN
1611:
1612: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1613: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: log('process_sequences: Invalid user or tranid passed: ' ||
1616: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);

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

1609: l_client_num NUMBER;
1610: BEGIN
1611:
1612: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1613: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: log('process_sequences: Invalid user or tranid passed: ' ||
1616: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1617: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1614: x_return_status := FND_API.G_RET_STS_ERROR;

1610: BEGIN
1611:
1612: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1613: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: log('process_sequences: Invalid user or tranid passed: ' ||
1616: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: return;

Line 1617: x_return_status := FND_API.G_RET_STS_ERROR;

1613: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: log('process_sequences: Invalid user or tranid passed: ' ||
1616: 'user: ' || p_user_name || ' tranid: ' || p_tranid,g_err_level);
1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: return;
1619: END IF;
1620:
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1621: x_return_status := FND_API.G_RET_STS_SUCCESS;

1617: x_return_status := FND_API.G_RET_STS_ERROR;
1618: return;
1619: END IF;
1620:
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;
1622: counter := 1;
1623:
1624: SELECT client_number INTO l_client_num
1625: FROM asg_user

Line 1727: x_return_status := FND_API.G_RET_STS_SUCCESS;

1723: SELECT resource_id
1724: FROM asg_user
1725: WHERE user_name = p_user_name;
1726: BEGIN
1727: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728: curr_tranid := p_tranid;
1729:
1730: -- Remove any custom pub items from c$inq
1731: -- Custom pub items are processed directly by custom implementor.

Line 1758: x_return_status := FND_API.G_RET_STS_ERROR;

1754: CLOSE c_resource_id;
1755: IF l_resource_id IS NULL THEN
1756: log('setup_inq_info: Did not find the user: '
1757: || p_user_name || ' in asg_user table',g_err_level);
1758: x_return_status := FND_API.G_RET_STS_ERROR;
1759: return;
1760: END IF;
1761:
1762: INSERT INTO asg_users_inqinfo (device_user_name,

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

1894: l_userid NUMBER;
1895:
1896: BEGIN
1897:
1898: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1899: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: return;
1902: END IF;

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

1895:
1896: BEGIN
1897:
1898: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1899: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: return;
1902: END IF;
1903:

Line 1900: x_return_status := FND_API.G_RET_STS_ERROR;

1896: BEGIN
1897:
1898: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
1899: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: return;
1902: END IF;
1903:
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1904: x_return_status := FND_API.G_RET_STS_SUCCESS;

1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: return;
1902: END IF;
1903:
1904: x_return_status := FND_API.G_RET_STS_SUCCESS;
1905:
1906:
1907: -- check if there are any entries in C$inq for this
1908: -- If there aren't any then this means there was some error and we

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

1965: l_pubitems_tbl := g_empty_vc2_tbl;
1966: get_all_pub_items(p_user_name, p_tranid, curr_pub,
1967: l_pubitems_tbl, l_return_status);
1968: -- Check if there is any data for this publication
1969: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1970: (l_pubitems_tbl.count >0) THEN
1971:
1972: -- For current user and current publication get the
1973: -- responsibility ID and application ID.

Line 2009: x_return_status := FND_API.G_RET_STS_SUCCESS;

2005: WHEN OTHERS THEN
2006: log('process_user: Exception in wrapper call. ' ||
2007: 'Check if valid wrapper exists ' ||
2008: SQLERRM,g_err_level);
2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010: --reset
2011: fnd_global.apps_initialize(g_conc_userid, g_conc_respid, g_conc_appid);
2012: return;
2013: END;

Line 2043: retcode := FND_API.G_RET_STS_SUCCESS;

2039: BEGIN
2040:
2041: g_user_name := null;
2042: g_is_conc_program := 'Y';
2043: retcode := FND_API.G_RET_STS_SUCCESS;
2044: /*remember the conc program start time*/
2045: g_conc_start_time:=null;
2046: select sysdate into g_conc_start_time from dual;
2047:

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

2059: g_conc_appid := 1;
2060: END IF;
2061:
2062: begin_apply(l_begin_apply, l_return_status);
2063: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2064: log('Error in begin_apply',g_err_level);
2065: retcode := l_return_status;
2066: return;
2067: END IF;

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

2064: log('Error in begin_apply',g_err_level);
2065: retcode := l_return_status;
2066: return;
2067: END IF;
2068: IF (l_begin_apply = FND_API.G_FALSE) THEN
2069: -- No users to process
2070: log('No users with uploaded data',g_stmt_level);
2071: return;
2072: END IF;

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

2069: -- No users to process
2070: log('No users with uploaded data',g_stmt_level);
2071: return;
2072: END IF;
2073: IF (g_only_deferred_trans = FND_API.G_TRUE) THEN
2074: log('Only deferred uploaded data is available for processing',
2075: g_stmt_level);
2076: ELSE
2077: log('Both dirty and deferred uploaded data is available for processing',

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

2085: x_return_status => l_return_status);
2086: log('process_upload: Num of users to process: ' || l_users_tbl.count,
2087: g_stmt_level);
2088:
2089: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2090: return;
2091: END IF;
2092:
2093: -- Fill in the client's subscriptions and handlers

Line 2103: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP

2099: get_first_tranid(p_user_name => curr_user,
2100: x_tranid => curr_tranid,
2101: x_return_status => l_return_status);
2102: g_current_tranid := curr_tranid;
2103: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP
2104: log('process_upload: Processing tranid: ' || curr_tranid,g_stmt_level);
2105: process_user(p_user_name => curr_user,
2106: p_tranid => curr_tranid,
2107: x_return_status => l_return_status);

Line 2108: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2104: log('process_upload: Processing tranid: ' || curr_tranid,g_stmt_level);
2105: process_user(p_user_name => curr_user,
2106: p_tranid => curr_tranid,
2107: x_return_status => l_return_status);
2108: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2109: -- Make the call to get the next tranid
2110: -- This means if upload processing for one transaction failed
2111: -- upload processing for the rest of the transactions is stopped.
2112: get_next_tranid(p_user_name => curr_user,