850:
851: l_step := 0;
852:
853: -- Drop all the error message stack.
854: FND_MSG_PUB.initialize;
855:
856: open l_party_id_cur;
857: fetch l_party_id_cur into l_party_id;
858: close l_party_id_cur;
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
1903: l_bank_id := p_bank_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;
1924: else
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:
1939: l_count := 0;
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
1953: p_EXT_BANK_ACCOUNT_ID is null and x_status = 'S' then