DBA Data[Home] [Help]

APPS.CSTPACMS dependencies on FND_MESSAGE

Line 381: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');

377: EXCEPTION
378: WHEN NO_DATA_FOUND THEN
379: err_num := SQLCODE;
380: IF (stmt_num = 10) THEN
381: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
382: fnd_message.set_token(
383: token => 'COLUMN',
384: value => 'TRANSACTION_INTERFACE_ID',
385: translate => FALSE);

Line 382: fnd_message.set_token(

378: WHEN NO_DATA_FOUND THEN
379: err_num := SQLCODE;
380: IF (stmt_num = 10) THEN
381: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
382: fnd_message.set_token(
383: token => 'COLUMN',
384: value => 'TRANSACTION_INTERFACE_ID',
385: translate => FALSE);
386: err_msg := 'CSTPACMS:validate_snap_interface ' ||

Line 388: fnd_message.get;

384: value => 'TRANSACTION_INTERFACE_ID',
385: translate => FALSE);
386: err_msg := 'CSTPACMS:validate_snap_interface ' ||
387: to_char(stmt_num) || ' : ' ||
388: fnd_message.get;
389:
390: ELSIF (stmt_num = 20) THEN
391: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
392: fnd_message.set_token(

Line 391: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');

387: to_char(stmt_num) || ' : ' ||
388: fnd_message.get;
389:
390: ELSIF (stmt_num = 20) THEN
391: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
392: fnd_message.set_token(
393: token => 'COLUMN',
394: value => 'WIP_ENTITY_ID',
395: translate => FALSE);

Line 392: fnd_message.set_token(

388: fnd_message.get;
389:
390: ELSIF (stmt_num = 20) THEN
391: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
392: fnd_message.set_token(
393: token => 'COLUMN',
394: value => 'WIP_ENTITY_ID',
395: translate => FALSE);
396: err_msg := 'CSTPACMS:validate_snap_interface ' ||

Line 398: fnd_message.get;

394: value => 'WIP_ENTITY_ID',
395: translate => FALSE);
396: err_msg := 'CSTPACMS:validate_snap_interface ' ||
397: to_char(stmt_num) || ' : ' ||
398: fnd_message.get;
399:
400: ELSIF (stmt_num = 30) THEN
401: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
402: fnd_message.set_token(

Line 401: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');

397: to_char(stmt_num) || ' : ' ||
398: fnd_message.get;
399:
400: ELSIF (stmt_num = 30) THEN
401: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
402: fnd_message.set_token(
403: token => 'COLUMN',
404: value => 'OPERATION_SEQ_NUM',
405: translate => FALSE);

Line 402: fnd_message.set_token(

398: fnd_message.get;
399:
400: ELSIF (stmt_num = 30) THEN
401: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
402: fnd_message.set_token(
403: token => 'COLUMN',
404: value => 'OPERATION_SEQ_NUM',
405: translate => FALSE);
406: err_msg := 'CSTPACMS:validate_snap_interface ' ||

Line 408: fnd_message.get;

404: value => 'OPERATION_SEQ_NUM',
405: translate => FALSE);
406: err_msg := 'CSTPACMS:validate_snap_interface ' ||
407: to_char(stmt_num) || ' : ' ||
408: fnd_message.get;
409:
410: END IF;
411: RETURN(-999);
412:

Line 415: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');

411: RETURN(-999);
412:
413: WHEN e_primary_quantity THEN
414: err_num := SQLCODE;
415: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
416: fnd_message.set_token(
417: token => 'COLUMN',
418: value => 'PRIMARY_QUANTITY',
419: translate => FALSE);

Line 416: fnd_message.set_token(

412:
413: WHEN e_primary_quantity THEN
414: err_num := SQLCODE;
415: fnd_message.set_name('BOM','CST_COMP_SNAP_INTERFACE_FAIL');
416: fnd_message.set_token(
417: token => 'COLUMN',
418: value => 'PRIMARY_QUANTITY',
419: translate => FALSE);
420: err_msg := 'CSTPACMS:validate_snap_interface ' ||

Line 422: fnd_message.get;

418: value => 'PRIMARY_QUANTITY',
419: translate => FALSE);
420: err_msg := 'CSTPACMS:validate_snap_interface ' ||
421: to_char(stmt_num) || ' : ' ||
422: fnd_message.get;
423: RETURN(-999);
424:
425: WHEN OTHERS THEN
426: err_num := SQLCODE;