1144: ELSE
1145: p_account_id := l_account_id;
1146: END IF;
1147: ELSE
1148: --------dbms_output.put_line--('In UTILS Else: Given Individual Segments:p_account_segment1.Segment1');
1149: l_delimitor :=
1150: fnd_flex_ext.get_delimiter
1151: (application_short_name => l_appl_short_name
1152: , key_flex_code => l_key_flex_code
1966:
1967: BEGIN
1968: SELECT to_date(l_dd_part || '-' || l_mm_part || '-' || '2007', 'DD-MM-YYYY')
1969: INTO l_cal_start
1970: FROM DUAL;
1971: x_return_status := fnd_api.g_ret_sts_success;
1972: EXCEPTION
1973: WHEN OTHERS THEN
1974: /*fnd_message.set_name ('PN', 'PN_CAL_INVALID_DATE');