DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on FND_MESSAGE

Line 454: errBuf := substr(FND_MESSAGE.get, 1, 5000);

450:
451: -- May be a message on the stack or
452: -- a string passed in via the arg
453: if logText IS NULL then
454: errBuf := substr(FND_MESSAGE.get, 1, 5000);
455: else
456: errBuf := substr(logText, 1, 5000);
457: end if;
458:

Line 3312: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');

3308: 'min=' || to_char(1 - ruleData.toPercent));
3309: DBMS_SQL.bind_variable(dc1, 'own', ruleData.toPercent);
3310:
3311: else
3312: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3313: FND_MESSAGE.set_token('PROCEDURE',
3314: packageName || '.' || procedureName);
3315: FND_MESSAGE.set_token('VAR_NAME', varName);
3316: logString(exceptionLogLevel,

Line 3313: FND_MESSAGE.set_token('PROCEDURE',

3309: DBMS_SQL.bind_variable(dc1, 'own', ruleData.toPercent);
3310:
3311: else
3312: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3313: FND_MESSAGE.set_token('PROCEDURE',
3314: packageName || '.' || procedureName);
3315: FND_MESSAGE.set_token('VAR_NAME', varName);
3316: logString(exceptionLogLevel,
3317: procedureName,

Line 3315: FND_MESSAGE.set_token('VAR_NAME', varName);

3311: else
3312: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3313: FND_MESSAGE.set_token('PROCEDURE',
3314: packageName || '.' || procedureName);
3315: FND_MESSAGE.set_token('VAR_NAME', varName);
3316: logString(exceptionLogLevel,
3317: procedureName,
3318: 'exception',
3319: 'invalid_variable');

Line 3404: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');

3400: 'seq=' || to_char(stepSeq));
3401: DBMS_SQL.bind_variable(dc1, 'seq', stepSeq);
3402:
3403: else
3404: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3405: FND_MESSAGE.set_token('PROCEDURE',
3406: packageName || '.' || procedureName);
3407: FND_MESSAGE.set_token('VAR_NAME', varName);
3408: logString(exceptionLogLevel,

Line 3405: FND_MESSAGE.set_token('PROCEDURE',

3401: DBMS_SQL.bind_variable(dc1, 'seq', stepSeq);
3402:
3403: else
3404: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3405: FND_MESSAGE.set_token('PROCEDURE',
3406: packageName || '.' || procedureName);
3407: FND_MESSAGE.set_token('VAR_NAME', varName);
3408: logString(exceptionLogLevel,
3409: procedureName,

Line 3407: FND_MESSAGE.set_token('VAR_NAME', varName);

3403: else
3404: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_VARIABLE');
3405: FND_MESSAGE.set_token('PROCEDURE',
3406: packageName || '.' || procedureName);
3407: FND_MESSAGE.set_token('VAR_NAME', varName);
3408: logString(exceptionLogLevel,
3409: procedureName,
3410: 'exception',
3411: 'invalid_variable');

Line 4163: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_KEY');

4159: logString(exceptionLogLevel,
4160: procedureName,
4161: 'exception',
4162: 'missing_key');
4163: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_KEY');
4164: FND_MESSAGE.set_token('HASH_KEY', liaKey);
4165: RAISE missing_key;
4166: end;
4167:

Line 4164: FND_MESSAGE.set_token('HASH_KEY', liaKey);

4160: procedureName,
4161: 'exception',
4162: 'missing_key');
4163: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_KEY');
4164: FND_MESSAGE.set_token('HASH_KEY', liaKey);
4165: RAISE missing_key;
4166: end;
4167:
4168: --=======================================================

Line 4184: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_KEY');

4180: logString(exceptionLogLevel,
4181: procedureName,
4182: 'exception',
4183: 'missing_key');
4184: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_KEY');
4185: FND_MESSAGE.set_token('HASH_KEY', ataKey);
4186: RAISE missing_key;
4187: end;
4188:

Line 4185: FND_MESSAGE.set_token('HASH_KEY', ataKey);

4181: procedureName,
4182: 'exception',
4183: 'missing_key');
4184: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_KEY');
4185: FND_MESSAGE.set_token('HASH_KEY', ataKey);
4186: RAISE missing_key;
4187: end;
4188:
4189: --=======================================================

Line 4204: FND_MESSAGE.set_name( 'GCS', 'GCS_BAD_SIGN' );

4200: logString(exceptionLogLevel, procedureName, 'exception', 'bad_sign');
4201: /*4.29.04 UNCOMMENT THIS!!!!
4202: Close getSigns;
4203: logString( exceptionLogLevel, procedureName, 'exception', 'bad_sign');
4204: FND_MESSAGE.set_name( 'GCS', 'GCS_BAD_SIGN' );
4205: FND_MESSAGE.set_token( 'LINE_ITEM_ID' , to_char( linesData.line_item_id(i) ) );
4206: RAISE bad_sign;
4207: */
4208: End If;

Line 4205: FND_MESSAGE.set_token( 'LINE_ITEM_ID' , to_char( linesData.line_item_id(i) ) );

4201: /*4.29.04 UNCOMMENT THIS!!!!
4202: Close getSigns;
4203: logString( exceptionLogLevel, procedureName, 'exception', 'bad_sign');
4204: FND_MESSAGE.set_name( 'GCS', 'GCS_BAD_SIGN' );
4205: FND_MESSAGE.set_token( 'LINE_ITEM_ID' , to_char( linesData.line_item_id(i) ) );
4206: RAISE bad_sign;
4207: */
4208: End If;
4209: Close getSigns;

Line 4246: FND_MESSAGE.set_name( 'GCS', 'GCS_BAD_SIGN' );

4242: procedureName,
4243: 'exception',
4244: 'bad_sign');
4245: /*4.29.04 UNCOMMENT THIS!!!!
4246: FND_MESSAGE.set_name( 'GCS', 'GCS_BAD_SIGN' );
4247: FND_MESSAGE.set_token( 'LINE_ITEM_ID' , to_char( linesData.line_item_id(i) ) );
4248: RAISE bad_sign;
4249: */
4250: --4.29.04 REMOVE THE NEXT 2 LINES!!!!!

Line 4247: FND_MESSAGE.set_token( 'LINE_ITEM_ID' , to_char( linesData.line_item_id(i) ) );

4243: 'exception',
4244: 'bad_sign');
4245: /*4.29.04 UNCOMMENT THIS!!!!
4246: FND_MESSAGE.set_name( 'GCS', 'GCS_BAD_SIGN' );
4247: FND_MESSAGE.set_token( 'LINE_ITEM_ID' , to_char( linesData.line_item_id(i) ) );
4248: RAISE bad_sign;
4249: */
4250: --4.29.04 REMOVE THE NEXT 2 LINES!!!!!
4251: linesData.balance_factor(i) := 1;

Line 5233: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_RULE_STEPS');

5229: logString(exceptionLogLevel,
5230: procedureName,
5231: 'exception',
5232: 'rule has no steps');
5233: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_RULE_STEPS');
5234: logString(procedureLogLevel,
5235: procedureName,
5236: 'end',
5237: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5251: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_CURRENCY_DATA');

5247: logString(exceptionLogLevel,
5248: procedureName,
5249: 'exception',
5250: 'missing_currency_data');
5251: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_CURRENCY_DATA');
5252: logString(procedureLogLevel,
5253: procedureName,
5254: 'end',
5255: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5269: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_DIM_SET_ID');

5265: logString(exceptionLogLevel,
5266: procedureName,
5267: 'exception',
5268: 'invalid_dim_set_id');
5269: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_DIM_SET_ID');
5270: logString(procedureLogLevel,
5271: procedureName,
5272: 'end',
5273: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5324: FND_MESSAGE.set_name('GCS', 'GCS_OUT_OF_BALANCE');

5320: logString(exceptionLogLevel,
5321: procedureName,
5322: 'exception',
5323: 'out_of_balance');
5324: FND_MESSAGE.set_name('GCS', 'GCS_OUT_OF_BALANCE');
5325: logString(procedureLogLevel,
5326: procedureName,
5327: 'end',
5328: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5347: FND_MESSAGE.set_name( 'GCS', 'GCS_NO_ENTRY_LINES' );

5343: RETURN(2);
5344: /*
5345: WHEN no_entry_lines THEN
5346: logString( exceptionLogLevel, procedureName, 'exception', 'no_entry_lines' );
5347: FND_MESSAGE.set_name( 'GCS', 'GCS_NO_ENTRY_LINES' );
5348: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
5349: RETURN (1);
5350: */
5351: WHEN missing_key THEN

Line 5374: FND_MESSAGE.set_name('GCS', 'GCS_NO_DEFAULT_CCTR');

5370: logString(exceptionLogLevel,
5371: procedureName,
5372: 'exception',
5373: 'no_default_cctr_found');
5374: FND_MESSAGE.set_name('GCS', 'GCS_NO_DEFAULT_CCTR');
5375: logString(procedureLogLevel,
5376: procedureName,
5377: 'end',
5378: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5386: FND_MESSAGE.set_name('GCS', 'GCS_CONVERT_THRESHOLD_ERR');

5382: logString(exceptionLogLevel,
5383: procedureName,
5384: 'exception',
5385: 'convert_threshold_err');
5386: FND_MESSAGE.set_name('GCS', 'GCS_CONVERT_THRESHOLD_ERR');
5387: logString(procedureLogLevel,
5388: procedureName,
5389: 'end',
5390: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5404: FND_MESSAGE.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');

5400: logString(exceptionLogLevel,
5401: procedureName,
5402: 'exception',
5403: 'entry_header_error');
5404: FND_MESSAGE.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
5405: logString(procedureLogLevel,
5406: procedureName,
5407: 'end',
5408: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5422: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_CATEGORY_CODE');

5418: logString(exceptionLogLevel,
5419: procedureName,
5420: 'exception',
5421: 'invalid_category_code');
5422: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_CATEGORY_CODE');
5423: FND_MESSAGE.set_token('CATEGORY_CODE', contextData.eventCategory);
5424: logString(procedureLogLevel,
5425: procedureName,
5426: 'end',

Line 5423: FND_MESSAGE.set_token('CATEGORY_CODE', contextData.eventCategory);

5419: procedureName,
5420: 'exception',
5421: 'invalid_category_code');
5422: FND_MESSAGE.set_name('GCS', 'GCS_INVALID_CATEGORY_CODE');
5423: FND_MESSAGE.set_token('CATEGORY_CODE', contextData.eventCategory);
5424: logString(procedureLogLevel,
5425: procedureName,
5426: 'end',
5427: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 5433: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');

5429:
5430: WHEN OTHERS THEN
5431: errMsg := substr(SQLERRM, 1, 2000);
5432: logString(unexpectedLogLevel, procedureName, 'whenOthers', errMsg);
5433: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');
5434: FND_MESSAGE.set_token('PROCEDURE',
5435: packageName || '.' || procedureName);
5436: FND_MESSAGE.set_token('EVENT', 'OTHERS');
5437: if contextData.eventType = 'C' then

Line 5434: FND_MESSAGE.set_token('PROCEDURE',

5430: WHEN OTHERS THEN
5431: errMsg := substr(SQLERRM, 1, 2000);
5432: logString(unexpectedLogLevel, procedureName, 'whenOthers', errMsg);
5433: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');
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

Line 5436: FND_MESSAGE.set_token('EVENT', 'OTHERS');

5432: logString(unexpectedLogLevel, procedureName, 'whenOthers', errMsg);
5433: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');
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'

Line 5523: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_RULE_ID');

5519: logString(exceptionLogLevel,
5520: procedureName,
5521: 'exception',
5522: 'missing_rule_id');
5523: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_RULE_ID');
5524: FND_MESSAGE.set_token('PROCEDURE',
5525: packageName || '.' || procedureName);
5526: logString(procedureLogLevel,
5527: procedureName,

Line 5524: FND_MESSAGE.set_token('PROCEDURE',

5520: procedureName,
5521: 'exception',
5522: 'missing_rule_id');
5523: FND_MESSAGE.set_name('GCS', 'GCS_MISSING_RULE_ID');
5524: FND_MESSAGE.set_token('PROCEDURE',
5525: packageName || '.' || procedureName);
5526: logString(procedureLogLevel,
5527: procedureName,
5528: 'end',

Line 5535: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');

5531:
5532: WHEN OTHERS THEN
5533: errMsg := substr(SQLERRM, 1, 2000);
5534: logString(unexpectedLogLevel, procedureName, 'whenOthers', errMsg);
5535: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');
5536: FND_MESSAGE.set_token('PROCEDURE',
5537: packageName || '.' || procedureName);
5538: FND_MESSAGE.set_token('EVENT', 'OTHERS');
5539: logString(procedureLogLevel,

Line 5536: FND_MESSAGE.set_token('PROCEDURE',

5532: WHEN OTHERS THEN
5533: errMsg := substr(SQLERRM, 1, 2000);
5534: logString(unexpectedLogLevel, procedureName, 'whenOthers', errMsg);
5535: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');
5536: FND_MESSAGE.set_token('PROCEDURE',
5537: packageName || '.' || procedureName);
5538: FND_MESSAGE.set_token('EVENT', 'OTHERS');
5539: logString(procedureLogLevel,
5540: procedureName,

Line 5538: FND_MESSAGE.set_token('EVENT', 'OTHERS');

5534: logString(unexpectedLogLevel, procedureName, 'whenOthers', errMsg);
5535: FND_MESSAGE.set_name('GCS', 'GCS_UNHANDLED_EXCEPTION');
5536: FND_MESSAGE.set_token('PROCEDURE',
5537: packageName || '.' || procedureName);
5538: FND_MESSAGE.set_token('EVENT', 'OTHERS');
5539: logString(procedureLogLevel,
5540: procedureName,
5541: 'end',
5542: to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));