81: l_ssn c_ssn%ROWTYPE;
82:
83: BEGIN
84:
85: fnd_msg_pub.initialize;
86: x_return_status := fnd_api.g_ret_sts_success;
87: SAVEPOINT SP_PROFILE;
88: x_msg_data := '';
89:
161: lv_message2 VARCHAR2(4000);
162:
163: BEGIN
164:
165: fnd_msg_pub.initialize;
166: x_return_status := fnd_api.g_ret_sts_success;
167: x_msg_data := '';
168:
169: SAVEPOINT SP_CREATE_PERSON;
373:
374:
375: BEGIN
376:
377: fnd_msg_pub.initialize;
378: x_return_status := fnd_api.g_ret_sts_success;
379: x_msg_data := '';
380:
381: igf_ap_profile_matching_pkg.ss_wrap_upload_Profile ( p_css_id => p_css_id,