141: l_error_msg := p_error_msg;
142: END IF;
143: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
144: into l_prof_value from dual;
145: l_cp_run := asg_apply.is_conc_program_running;
146:
147: if(l_prof_value = 'Y')
148: then
149: if(l_cp_run = 'N' )
459: -- Check if this transaction is deferred
460: l_def_trans := is_deferred(p_user_name, p_tranid, p_pubitem, p_sequence);
461: IF l_def_trans = FND_API.G_FALSE THEN
462: -- Delete the row from inq
463: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,
464: x_return_status);
465: END IF;
466: IF(asg_helper.check_is_log_enabled(g_stmt_level))
467: THEN
625: counter PLS_INTEGER;
626: sql_string VARCHAR2(4000);
627: l_pub_handler asg_pub.wrapper_name%type;
628: l_pubname VARCHAR2(30);
629: l_pubitems_tbl asg_apply.vc2_tbl_type;
630: l_def_trans VARCHAR2(1);
631: l_return_status VARCHAR2(1);
632: l_pubs_tbl asg_apply.vc2_tbl_type;
633: l_pubhandlers_tbl asg_apply.vc2_tbl_type;
628: l_pubname VARCHAR2(30);
629: l_pubitems_tbl asg_apply.vc2_tbl_type;
630: l_def_trans VARCHAR2(1);
631: l_return_status VARCHAR2(1);
632: l_pubs_tbl asg_apply.vc2_tbl_type;
633: l_pubhandlers_tbl asg_apply.vc2_tbl_type;
634: l_def_count NUMBER;
635: l_user_id NUMBER;
636: l_resp_id NUMBER;
629: l_pubitems_tbl asg_apply.vc2_tbl_type;
630: l_def_trans VARCHAR2(1);
631: l_return_status VARCHAR2(1);
632: l_pubs_tbl asg_apply.vc2_tbl_type;
633: l_pubhandlers_tbl asg_apply.vc2_tbl_type;
634: l_def_count NUMBER;
635: l_user_id NUMBER;
636: l_resp_id NUMBER;
637: l_app_id NUMBER;
692: ' current pub : ' || l_pubname ||
693: ' current pub handler: ' || l_pub_handler,
694: 'asg_defer',g_stmt_level);
695: END IF;
696: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
697: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
698: l_pubitems_tbl, l_return_status);
699: -- Check if there is any data for this publication
700: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
693: ' current pub handler: ' || l_pub_handler,
694: 'asg_defer',g_stmt_level);
695: END IF;
696: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
697: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
698: l_pubitems_tbl, l_return_status);
699: -- Check if there is any data for this publication
700: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
701: (l_pubitems_tbl.count >0) THEN
777: x_return_status OUT NOCOPY VARCHAR2)
778: IS
779: l_def_trans VARCHAR2(1);
780: l_curr_pubitem VARCHAR2(30);
781: l_pubitems_tbl asg_apply.vc2_tbl_type;
782: l_return_status VARCHAR2(1);
783: BEGIN
784: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
785: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
799: ' transaction: ' || p_tranid,
800: 'asg_defer',g_stmt_level);
801: END IF;
802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803: asg_apply.get_all_pub_items(p_user_name, p_tranid,
804: l_pubitems_tbl, l_return_status);
805: -- Check if there is any data for this publication
806: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
807: (l_pubitems_tbl.count >0) THEN