APPS.CSTPACMS dependencies on CSTPACMS

Line 1: PACKAGE BODY CSTPACMS AS

1: PACKAGE BODY CSTPACMS AS
2: /* $Header: CSTACMSB.pls 115.9 2002/11/08 00:57:38 awwang ship $ */
3:
4: FUNCTION move_snapshot(
5: l_txn_temp_id IN NUMBER,

Line 154: err_msg := 'CSTPACMS:move_snapshot' || to_char(stmt_num) || substr(SQLERRM,1,150);

150: EXCEPTION
151:
152: WHEN OTHERS THEN
153: err_num := SQLCODE;
154: err_msg := 'CSTPACMS:move_snapshot' || to_char(stmt_num) || substr(SQLERRM,1,150);
155: return(-999);
156:
157: END move_snapshot;
158:

Line 175: IF (CSTPACMS.validate_snap_interface(l_txn_interface_id,

171:
172: BEGIN
173: stmt_num := 10;
174:
175: IF (CSTPACMS.validate_snap_interface(l_txn_interface_id,
176: l_interface_table,
177: l_primary_quantity,
178: err_num,
179: err_code,

Line 181: RETURN(CSTPACMS.move_snapshot_to_temp(l_txn_interface_id,

177: l_primary_quantity,
178: err_num,
179: err_code,
180: err_msg) = 1) THEN
181: RETURN(CSTPACMS.move_snapshot_to_temp(l_txn_interface_id,
182: l_txn_temp_id,
183: l_interface_table,
184: err_num,
185: err_code,

Line 194: err_msg := 'CSTPACMS:validate_move_snap_to_temp' || to_char(stmt_num) || substr(SQLERRM,1,150);

190:
191: EXCEPTION
192: WHEN OTHERS THEN
193: err_num := SQLCODE;
194: err_msg := 'CSTPACMS:validate_move_snap_to_temp' || to_char(stmt_num) || substr(SQLERRM,1,150);
195: return(-999);
196: END validate_move_snap_to_temp;
197:
198:

Line 386: err_msg := 'CSTPACMS:validate_snap_interface ' ||

382: fnd_message.set_token(
383: token => 'COLUMN',
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

Line 396: err_msg := 'CSTPACMS:validate_snap_interface ' ||

392: fnd_message.set_token(
393: token => 'COLUMN',
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

Line 406: err_msg := 'CSTPACMS:validate_snap_interface ' ||

402: fnd_message.set_token(
403: token => 'COLUMN',
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;

Line 420: err_msg := 'CSTPACMS:validate_snap_interface ' ||

416: fnd_message.set_token(
417: token => 'COLUMN',
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:

Line 427: err_msg := 'CSTPACMS:validate_snap_interface ' ||

423: RETURN(-999);
424:
425: WHEN OTHERS THEN
426: err_num := SQLCODE;
427: err_msg := 'CSTPACMS:validate_snap_interface ' ||
428: to_char(stmt_num) ||' '|| substr(SQLERRM,1,150);
429: RETURN(-999);
430:
431: END validate_snap_interface;

Line 548: err_msg := 'CSTPACMS:move_snapshot_to_temp' || to_char(stmt_num) || substr(SQLERRM,1,150);

544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: err_num := SQLCODE;
548: err_msg := 'CSTPACMS:move_snapshot_to_temp' || to_char(stmt_num) || substr(SQLERRM,1,150);
549: RETURN(-999);
550: END move_snapshot_to_temp;
551:
552: END CSTPACMS;

Line 552: END CSTPACMS;

548: err_msg := 'CSTPACMS:move_snapshot_to_temp' || to_char(stmt_num) || substr(SQLERRM,1,150);
549: RETURN(-999);
550: END move_snapshot_to_temp;
551:
552: END CSTPACMS;