1091: bFailed := true;
1092: end;
1093:
1094: if not(bFailed) then
1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1094: if not(bFailed) then
1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1101: script := '';
1102:
1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1101: script := '';
1102:
1103: -- detach any aws if they are still attached
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1101: script := '';
1102:
1103: -- detach any aws if they are still attached
1104: msd_common_utilities.detach_all_aws;
1299:
1300: --insert into msd_temp values(script);
1301: msd_common_utilities.dbms_aw_interp_silent(script);
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1300: --insert into msd_temp values(script);
1301: msd_common_utilities.dbms_aw_interp_silent(script);
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1308:
1301: msd_common_utilities.dbms_aw_interp_silent(script);
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1308:
1309:
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1308:
1309:
1310: end execute_dml2;