[Home] [Help]
757:
758: -- Setting the Batch Status to 'Processing'
759: UPDATE csi_mass_edit_entries_b
760: SET status_code = 'PROCESSING',
761: request_id = FND_GLOBAL.CONC_REQUEST_ID
762: WHERE entry_id = p_entry_id;
763: COMMIT;
764:
765: -- Common Validations
1325: p_source_object_code => 'CP',
1326: p_notes => l_batch_desc,
1327: -- p_notes_detail => COMMENTS,
1328: p_note_status => 'I',
1329: p_entered_by => FND_GLOBAL.USER_ID,
1330: p_entered_date => SYSDATE,
1331: p_last_update_date => SYSDATE,
1332: p_last_updated_by => FND_GLOBAL.USER_ID,
1333: p_creation_date => SYSDATE,
1328: p_note_status => 'I',
1329: p_entered_by => FND_GLOBAL.USER_ID,
1330: p_entered_date => SYSDATE,
1331: p_last_update_date => SYSDATE,
1332: p_last_updated_by => FND_GLOBAL.USER_ID,
1333: p_creation_date => SYSDATE,
1334: p_created_by => FND_GLOBAL.USER_ID
1335: );
1336:
1330: p_entered_date => SYSDATE,
1331: p_last_update_date => SYSDATE,
1332: p_last_updated_by => FND_GLOBAL.USER_ID,
1333: p_creation_date => SYSDATE,
1334: p_created_by => FND_GLOBAL.USER_ID
1335: );
1336:
1337: debug('JTF API Return status :'||l_return_status);
1338: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS)
2559: l_txn_sys_rec.SYSTEM_ID := upd_system_tbl(system_rec_ind).SYSTEM_ID;
2560: -- Fix for the bug 7350165
2561: l_txn_sys_rec.CUSTOMER_ID := l_mu_new_party_rec.AccountId;
2562: --l_txn_sys_rec.CUSTOMER_ID := l_mu_customer_id_rec.CUSTOMER_ID;
2563: l_txn_sys_rec.REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
2564:
2565: -- Assign null values to the contact ids, site use ids
2566: -- TODO New enhancement has to be made at the mass update page
2567: -- to capture contact ids, site use id and that information
3034: WHERE BATCH_ID = p_entry_id;
3035:
3036: UPDATE csi_mass_edit_entries_b
3037: SET status_code = 'PROCESSING',
3038: request_id = FND_GLOBAL.CONC_REQUEST_ID
3039: WHERE entry_id = p_entry_id;
3040: COMMIT;
3041: EXCEPTION
3042: WHEN OTHERS THEN
4192: p_source_object_id => c_instance_tbl(inst_tab_row).INSTANCE_ID,
4193: p_source_object_code => 'CP',
4194: p_notes => l_batch_desc,
4195: p_note_status => 'I',
4196: p_entered_by => FND_GLOBAL.USER_ID,
4197: p_entered_date => SYSDATE,
4198: p_last_update_date => SYSDATE,
4199: p_last_updated_by => FND_GLOBAL.USER_ID,
4200: p_creation_date => SYSDATE,
4195: p_note_status => 'I',
4196: p_entered_by => FND_GLOBAL.USER_ID,
4197: p_entered_date => SYSDATE,
4198: p_last_update_date => SYSDATE,
4199: p_last_updated_by => FND_GLOBAL.USER_ID,
4200: p_creation_date => SYSDATE,
4201: p_created_by => FND_GLOBAL.USER_ID
4202: );
4203:
4197: p_entered_date => SYSDATE,
4198: p_last_update_date => SYSDATE,
4199: p_last_updated_by => FND_GLOBAL.USER_ID,
4200: p_creation_date => SYSDATE,
4201: p_created_by => FND_GLOBAL.USER_ID
4202: );
4203:
4204: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4205: debug_out('Error occured while creating a note for the created Instance: '
5759: p_source_object_id => u_instance_tbl(inst_tab_row).INSTANCE_ID,
5760: p_source_object_code => 'CP',
5761: p_notes => l_batch_desc,
5762: p_note_status => 'I',
5763: p_entered_by => FND_GLOBAL.USER_ID,
5764: p_entered_date => SYSDATE,
5765: p_last_update_date => SYSDATE,
5766: p_last_updated_by => FND_GLOBAL.USER_ID,
5767: p_creation_date => SYSDATE,
5762: p_note_status => 'I',
5763: p_entered_by => FND_GLOBAL.USER_ID,
5764: p_entered_date => SYSDATE,
5765: p_last_update_date => SYSDATE,
5766: p_last_updated_by => FND_GLOBAL.USER_ID,
5767: p_creation_date => SYSDATE,
5768: p_created_by => FND_GLOBAL.USER_ID
5769: );
5770:
5764: p_entered_date => SYSDATE,
5765: p_last_update_date => SYSDATE,
5766: p_last_updated_by => FND_GLOBAL.USER_ID,
5767: p_creation_date => SYSDATE,
5768: p_created_by => FND_GLOBAL.USER_ID
5769: );
5770:
5771: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5772: debug_out('Error occured while creating a note for the ' ||