872: * error. so execute this api in a begin , end block and set the error status
873: */
874: BEGIN
875: -- Copy attachments for every draft budget copied
876: x_err_stage:= 'Calling fnd_attached_documents2_pkg.copy_attachments';
877: print_msg(x_err_stage);
878: fnd_attached_documents2_pkg.copy_attachments('PA_BUDGET_VERSIONS',
879: x_draft_version_id,
880: null,null,null,null,
874: BEGIN
875: -- Copy attachments for every draft budget copied
876: x_err_stage:= 'Calling fnd_attached_documents2_pkg.copy_attachments';
877: print_msg(x_err_stage);
878: fnd_attached_documents2_pkg.copy_attachments('PA_BUDGET_VERSIONS',
879: x_draft_version_id,
880: null,null,null,null,
881: 'PA_BUDGET_VERSIONS',
882: x_dest_version_id,
887: print_msg('End of copy_attachments');
888: -- End copying attachments
889: EXCEPTION
890: WHEN OTHERS THEN
891: print_msg('Errored in fnd_attached_documents2_pkg: ERRMSG:['||sqlcode||sqlerrm);
892: x_err_code := SQLCODE;
893: x_err_stack := substr(SQLERRM,630);
894: rollback to before_baseline;
895: RETURN;
1288: where v.budget_version_id = p_src_version_id
1289: )
1290: where budget_version_id = l_dest_version_id;
1291:
1292: fnd_attached_documents2_pkg.delete_attachments('PA_BUDGET_VERSIONS',
1293: l_dest_version_id,
1294: null, null, null, null,
1295: 'Y') ;
1296: end if;
1502: END;
1503: */
1504: -- Copy attachments for every draft budget copied
1505:
1506: fnd_attached_documents2_pkg.copy_attachments('PA_BUDGET_VERSIONS',
1507: p_src_version_id,
1508: null,null,null,null,
1509: 'PA_BUDGET_VERSIONS',
1510: l_dest_version_id,
1910: end if;
1911:
1912: -- Copy attachments for every draft budget copied
1913:
1914: fnd_attached_documents2_pkg.copy_attachments('PA_BUDGET_VERSIONS',
1915: x_src_version_id,
1916: null,null,null,null,
1917: 'PA_BUDGET_VERSIONS',
1918: x_dest_version_id,