DBA Data[Home] [Help]

APPS.CSTPPWAS dependencies on CSTPPWAS

Line 1: PACKAGE BODY CSTPPWAS AS

1: PACKAGE BODY CSTPPWAS AS
2: /* $Header: CSTPWASB.pls 120.45.12020000.3 2012/12/19 12:04:06 penpan ship $ */
3:
4: G_MAX_RECORDS CONSTANT NUMBER := 1000;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAS';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAS';

1: PACKAGE BODY CSTPPWAS AS
2: /* $Header: CSTPWASB.pls 120.45.12020000.3 2012/12/19 12:04:06 penpan ship $ */
3:
4: G_MAX_RECORDS CONSTANT NUMBER := 1000;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAS';
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7:
8: /*---------------------------------------------------------------------------*
9: | PRIVATE PROCEDURE |

Line 1371: x_err_msg := SUBSTR('CSTPPWAS.insert_wip_costs('

1367: ROLLBACK;
1368: fnd_file.put_line(fnd_file.log,' Exception in Insert_wip_costs');
1369: x_err_num := SQLCODE;
1370: x_err_code := NULL;
1371: x_err_msg := SUBSTR('CSTPPWAS.insert_wip_costs('
1372: || to_char(l_stmt_num)
1373: || '): '
1374: ||SQLERRM,1,240);
1375: END insert_wip_costs;

Line 2633: x_err_msg := SUBSTR('CSTPPWAS.Relief_BOM_Quantity('

2629: END IF;
2630: ROLLBACK;
2631: x_err_num := SQLCODE;
2632: x_err_code := NULL;
2633: x_err_msg := SUBSTR('CSTPPWAS.Relief_BOM_Quantity('
2634: || to_char(l_stmt_num)
2635: || '): '
2636: ||SQLERRM,1,240);
2637: END Relief_BOM_Quantity;

Line 5354: x_err_msg := SUBSTR('CSTPPWAS.process_net_relief('

5350: END IF;
5351: ROLLBACK;
5352: x_err_num := SQLCODE;
5353: x_err_code := NULL;
5354: x_err_msg := SUBSTR('CSTPPWAS.process_net_relief('
5355: || to_char(l_stmt_num)
5356: || '): '
5357: ||SQLERRM,1,240);
5358:

Line 5639: l_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns('

5635: o_err_num => l_err_num,
5636: o_err_code => l_err_code,
5637: o_err_msg => l_err_msg);
5638: IF (l_err_num <> 0) THEN
5639: l_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns('
5640: ||TO_CHAR(l_stmt_num)
5641: ||'):'
5642: ||l_err_msg,1,240);
5643: RAISE CST_PROCESS_ERROR;

Line 5728: l_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns('

5724: o_err_num => l_err_num,
5725: o_err_code => l_err_code,
5726: o_err_msg => l_err_msg);
5727: IF (l_err_num <> 0) THEN
5728: l_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns('
5729: ||TO_CHAR(l_stmt_num)
5730: ||'):'
5731: ||l_err_msg,1,240);
5732: RAISE CST_PROCESS_ERROR;

Line 5797: l_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns('

5793: o_err_code => l_err_code,
5794: o_err_msg => l_err_msg);
5795:
5796: IF (l_err_num <> 0) THEN
5797: l_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns('
5798: ||TO_CHAR(l_stmt_num)
5799: ||'):'
5800: ||l_err_msg,1,240);
5801: RAISE CST_PROCESS_ERROR;

Line 5837: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

5833: o_err_msg => l_err_msg);*/
5834:
5835:
5836: IF (l_err_num <> 0) THEN
5837: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
5838: || TO_CHAR(l_stmt_num)
5839: ||'):'
5840: ||l_err_msg,1,240);
5841: RAISE CST_PROCESS_ERROR;

Line 5872: x_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns ('

5868: END IF;
5869: ROLLBACK;
5870: x_err_num := SQLCODE;
5871: x_err_code := NULL;
5872: x_err_msg := SUBSTR('CSTPPWAS.process_nonreworkassembly_txns ('
5873: || to_char(l_stmt_num)
5874: || '): '
5875: ||SQLERRM,1,240);
5876:

Line 6147: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6143: o_err_code => l_err_code,
6144: o_err_msg => l_err_msg);
6145:
6146: IF (l_err_num <> 0) THEN
6147: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6148: ||TO_CHAR(l_stmt_num)
6149: ||'):'
6150: ||l_err_msg,1,240);
6151: RAISE CST_PROCESS_ERROR;

Line 6205: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6201: o_err_code => l_err_code,
6202: o_err_msg => l_err_msg);
6203:
6204: IF (l_err_num <> 0) THEN
6205: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6206: ||TO_CHAR(l_stmt_num)
6207: ||'):'
6208: ||l_err_msg,1,240);
6209: RAISE CST_PROCESS_ERROR;

Line 6243: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6239: o_err_code => l_err_code,
6240: o_err_msg => l_err_msg);*/
6241:
6242: IF (l_err_num <> 0) THEN
6243: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6244: || TO_CHAR(l_stmt_num)
6245: ||'):'
6246: ||l_err_msg,1,240);
6247: RAISE CST_PROCESS_ERROR;

Line 6275: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6271: o_err_num => l_err_num,
6272: o_err_code => l_err_code,
6273: o_err_msg => l_err_msg);
6274: IF (l_err_num <> 0) THEN
6275: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6276: ||TO_CHAR(l_stmt_num)
6277: ||'):'
6278: ||l_err_msg,1,240);
6279: RAISE CST_PROCESS_ERROR;

Line 6365: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6361: o_err_code => l_err_code,
6362: o_err_msg => l_err_msg);
6363:
6364: IF (l_err_num <> 0) THEN
6365: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6366: ||TO_CHAR(l_stmt_num)
6367: ||'):'
6368: ||l_err_msg,1,240);
6369: RAISE CST_PROCESS_ERROR;

Line 6437: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6433: o_err_num => l_err_num,
6434: o_err_code => l_err_code,
6435: o_err_msg => l_err_msg);
6436: IF (l_err_num <> 0) THEN
6437: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6438: ||TO_CHAR(l_stmt_num)
6439: ||'):'
6440: ||l_err_msg,1,240);
6441: RAISE CST_PROCESS_ERROR;

Line 6466: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6462: o_err_code => l_err_code,
6463: o_err_msg => l_err_msg);
6464:
6465: IF (l_err_num <> 0) THEN
6466: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6467: ||TO_CHAR(l_stmt_num)
6468: ||'):'
6469: ||l_err_msg,1,240);
6470: RAISE CST_PROCESS_ERROR;

Line 6504: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6500: o_err_msg => l_err_msg);*/
6501:
6502:
6503: IF (l_err_num <> 0) THEN
6504: l_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6505: ||TO_CHAR(l_stmt_num)
6506: ||'):'
6507: ||l_err_msg,1,240);
6508: RAISE CST_PROCESS_ERROR;

Line 6539: x_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('

6535: END IF;
6536: ROLLBACK;
6537: x_err_num := SQLCODE;
6538: x_err_code := NULL;
6539: x_err_msg := SUBSTR('CSTPPWAS.process_reworkassembly_txns('
6540: || to_char(l_stmt_num)
6541: || '): '
6542: ||SQLERRM,1,240);
6543: END process_reworkassembly_txns;

Line 6650: x_err_msg := SUBSTR('CSTPPWAS.check_expense_flags('

6646: END IF;
6647: ROLLBACK;
6648: x_err_num := SQLCODE;
6649: x_err_code := NULL;
6650: x_err_msg := SUBSTR('CSTPPWAS.check_expense_flags('
6651: || to_char(l_stmt_num)
6652: || '): '
6653: ||SQLERRM,1,240);
6654:

Line 6657: END cstppwas;

6653: ||SQLERRM,1,240);
6654:
6655: END check_expense_flags;
6656:
6657: END cstppwas;