APPS.GCS_RULES_PROCESSOR dependencies on GCS_CONS_ENG_RUN_DTLS

Line 3785: --Save the id so we can update the gcs_cons_eng_run_dtls table

3781: Into entryId;
3782: Close getADEntryId;
3783: end if;
3784:
3785: --Save the id so we can update the gcs_cons_eng_run_dtls table
3786: if ruleIteration = 1 then
3787: mainEntryId := entryId;
3788: elsif ruleIteration = 2 then
3789: statEntryId := entryId;

Line 4277: --Bug 3645309: Remove entry from gcs_cons_eng_run_dtls if no lines generated

4273:
4274: -- Make sure we end up with at least some non-zero lines!
4275: elsif linesData.cctr_org_id.COUNT = 0 then
4276: logString(statementLogLevel, procedureName, 'data', 'No entry lines');
4277: --Bug 3645309: Remove entry from gcs_cons_eng_run_dtls if no lines generated
4278: if contextData.eventType = 'C' then
4279: DELETE gcs_cons_eng_run_dtls
4280: WHERE run_detail_id = contextData.eventKey;
4281: END IF;

Line 4279: DELETE gcs_cons_eng_run_dtls

4275: elsif linesData.cctr_org_id.COUNT = 0 then
4276: logString(statementLogLevel, procedureName, 'data', 'No entry lines');
4277: --Bug 3645309: Remove entry from gcs_cons_eng_run_dtls if no lines generated
4278: if contextData.eventType = 'C' then
4279: DELETE gcs_cons_eng_run_dtls
4280: WHERE run_detail_id = contextData.eventKey;
4281: END IF;
4282: -- bug 4115816
4283: -- RAISE no_entry_lines;

Line 4563: --Save the id so we can update the gcs_cons_eng_run_dtls table

4559: Fetch getEntryId
4560: Into entryId;
4561: Close getEntryId;
4562:
4563: --Save the id so we can update the gcs_cons_eng_run_dtls table
4564: if ruleIteration = 1 then
4565: mainEntryId := entryId;
4566: elsif ruleIteration = 2 then
4567: statEntryId := entryId;

Line 4607: DELETE gcs_cons_eng_run_dtls

4603: 'Completed insert into gcs_entry_lines ' || l_row_count);
4604:
4605: --check if any lines where created
4606: if (l_row_count = 0) then
4607: DELETE gcs_cons_eng_run_dtls
4608: WHERE run_detail_id = contextData.eventKey;
4609: RAISE no_entry_lines;
4610: else
4611: --=======================================================

Line 5118: delete from gcs_cons_eng_run_dtls

5114:
5115: END LOOP;
5116:
5117: if (NOT l_valid_formula) then
5118: delete from gcs_cons_eng_run_dtls
5119: where run_detail_id = contextData.eventKey;
5120: end if;
5121:
5122: else

Line 5184: UPDATE gcs_cons_eng_run_dtls

5180: --================================================================
5181:
5182: --Update the eventKey for the entries
5183: if contextData.eventType = 'C' then
5184: UPDATE gcs_cons_eng_run_dtls
5185: SET entry_id = mainEntryId,
5186: stat_entry_id = statEntryId,
5187: -- SKAMDAR : Added updates for request_error_code, and bp_request_error_code
5188: request_error_code = DECODE(l_return_value,

Line 5239: UPDATE gcs_cons_eng_run_dtls

5235: procedureName,
5236: 'end',
5237: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5238: if contextData.eventType = 'C' then
5239: UPDATE gcs_cons_eng_run_dtls
5240: SET request_error_code = 'GCS_MISSING_RULE_STEPS',
5241: bp_request_error_code = 'GCS_MISSING_RULE_STEPS'
5242: WHERE run_detail_id = contextData.eventKey;
5243: end if;

Line 5257: UPDATE gcs_cons_eng_run_dtls

5253: procedureName,
5254: 'end',
5255: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5256: if contextData.eventType = 'C' then
5257: UPDATE gcs_cons_eng_run_dtls
5258: SET request_error_code = 'GCS_MISSING_CURRENCY_DATA',
5259: bp_request_error_code = 'GCS_MISSING_CURRENCY_DATA'
5260: WHERE run_detail_id = contextData.eventKey;
5261: end if;

Line 5275: UPDATE gcs_cons_eng_run_dtls

5271: procedureName,
5272: 'end',
5273: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5274: if contextData.eventType = 'C' then
5275: UPDATE gcs_cons_eng_run_dtls
5276: SET request_error_code = 'GCS_INVALID_DIM_SET_ID',
5277: bp_request_error_code = 'GCS_INVALID_DIM_SET_ID'
5278: WHERE run_detail_id = contextData.eventKey;
5279: end if;

Line 5290: UPDATE gcs_cons_eng_run_dtls

5286: procedureName,
5287: 'end',
5288: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5289: if contextData.eventType = 'C' then
5290: UPDATE gcs_cons_eng_run_dtls
5291: SET request_error_code = 'GCS_INVALID_VARIABLE',
5292: bp_request_error_code = 'GCS_INVALID_VARIABLE'
5293: WHERE run_detail_id = contextData.eventKey;
5294: end if;

Line 5338: UPDATE gcs_cons_eng_run_dtls

5334: procedureName,
5335: 'end',
5336: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5337: if contextData.eventType = 'C' then
5338: UPDATE gcs_cons_eng_run_dtls
5339: SET request_error_code = 'GCS_TEMPLATES_PKG_ERROR',
5340: bp_request_error_code = 'GCS_TEMPLATES_PKG_ERROR'
5341: WHERE run_detail_id = contextData.eventKey;
5342: end if;

Line 5392: UPDATE gcs_cons_eng_run_dtls

5388: procedureName,
5389: 'end',
5390: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5391: if contextData.eventType = 'C' then
5392: UPDATE gcs_cons_eng_run_dtls
5393: SET request_error_code = 'GCS_CONVERT_THRESHOLD_ERR',
5394: bp_request_error_code = 'GCS_CONVERT_THRESHOLD_ERR'
5395: WHERE run_detail_id = contextData.eventKey;
5396: end if;

Line 5410: UPDATE gcs_cons_eng_run_dtls

5406: procedureName,
5407: 'end',
5408: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5409: if contextData.eventType = 'C' then
5410: UPDATE gcs_cons_eng_run_dtls
5411: SET request_error_code = 'GCS_ENTRY_HEADER_ERROR',
5412: bp_request_error_code = 'GCS_ENTRY_HEADER_ERROR'
5413: WHERE run_detail_id = contextData.eventKey;
5414: end if;

Line 5438: UPDATE gcs_cons_eng_run_dtls

5434: FND_MESSAGE.set_token('PROCEDURE',
5435: packageName || '.' || procedureName);
5436: FND_MESSAGE.set_token('EVENT', 'OTHERS');
5437: if contextData.eventType = 'C' then
5438: UPDATE gcs_cons_eng_run_dtls
5439: SET request_error_code = 'GCS_UNHANDLED_EXCEPTION',
5440: bp_request_error_code = 'GCS_UNHANDLED_EXCEPTION'
5441: WHERE run_detail_id = contextData.eventKey;
5442: end if;