1894: x_end_date => l_end_date);
1895:
1896: if l_bank_id is not null then
1897: x_status := 'E';
1898: fnd_message.set_name('POS', 'POS_SBD_DUP_BANK');
1899: fnd_msg_pub.add;
1900: end if;
1901:
1902: else
1915: x_branch_id => l_branch_id,
1916: x_end_date => l_end_date);
1917: if l_branch_id is not null then
1918: x_status := 'E';
1919: fnd_message.set_name('POS', 'POS_SBD_DUP_BRANCH');
1920: fnd_msg_pub.add;
1921: end if;
1922:
1923: end if;
1930: if l_count is null then l_count := 0;
1931: end if;
1932: if l_count <> 0 then
1933: x_status := 'E';
1934: fnd_message.set_name('POS', 'POS_SBD_DUP_ACT2');
1935: fnd_msg_pub.add;
1936: end if;
1937: close dup_temp_act_cur;
1938:
1944: close dup_cur_act_cur;
1945:
1946: if l_count <> 0 then
1947: x_status := 'E';
1948: fnd_message.set_name('POS', 'POS_SBD_DUP_ACT1');
1949: fnd_msg_pub.add;
1950: end if;
1951:
1952: if l_bank_id is not null and l_branch_id is not null and