DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PO_NEGOTIATIONS_SV1

Line 9627: PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(

9623: and line_number = x_negotiation_line_num;
9624:
9625: -- remove negotiation references in po_requisition_lines
9626: -- and return the requisitions to the req pool
9627: PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(
9628: X_NEGOTIATION_ID => x_negotiation_id,
9629: X_NEGOTIATION_LINE_NUM => x_negotiation_line_num,
9630: X_ERROR_CODE => x_error_code);
9631:

Line 9648: PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(

9644: x_error_code out NOCOPY varchar2) is
9645:
9646: BEGIN
9647:
9648: PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(
9649: X_NEGOTIATION_ID => x_negotiation_id,
9650: X_NEGOTIATION_LINE_NUM => null,
9651: X_ERROR_CODE => x_error_code);
9652:

Line 9670: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(

9666:
9667: BEGIN
9668:
9669: -- return backing requisitions to the req pool
9670: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(
9671: X_NEGOTIATION_ID => x_negotiation_id,
9672: X_NEGOTIATION_LINE_NUM => null,
9673: X_FLAG_VALUE => 'Y',
9674: X_ERROR_CODE => x_error_code);

Line 9713: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_REF(

9709: where auction_header_id = x_new_negotiation_id);
9710:
9711: BEGIN
9712:
9713: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_REF(
9714: X_OLD_NEGOTIATION_ID => x_old_negotiation_id,
9715: X_NEW_NEGOTIATION_ID => x_new_negotiation_id,
9716: X_NEW_NEGOTIATION_NUM => x_new_negotiation_num,
9717: X_ERROR_CODE => x_error_code);

Line 9730: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_REF(

9726: l_amendment_flag:= NULL;
9727: END;
9728:
9729: IF(l_amendment_flag='Y') THEN
9730: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_REF(
9731: X_OLD_NEGOTIATION_ID => l_auction_header_id,
9732: X_NEW_NEGOTIATION_ID => x_new_negotiation_id,
9733: X_NEW_NEGOTIATION_NUM => x_new_negotiation_num,
9734: X_ERROR_CODE => x_error_code);

Line 9763: -- PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(x_new_negotiation_id, l_line_number, x_error_code);

9759: FETCH deletedItems INTO
9760: l_line_number;
9761: EXIT WHEN deletedItems%NOTFOUND OR (x_error_code <> FND_API.G_RET_STS_SUCCESS);
9762:
9763: -- PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(x_new_negotiation_id, l_line_number, x_error_code);
9764:
9765: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_LINE_REF(
9766: P_API_VERSION => 1.0,
9767: P_OLD_NEGOTIATION_ID => x_new_negotiation_id,

Line 9765: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_LINE_REF(

9761: EXIT WHEN deletedItems%NOTFOUND OR (x_error_code <> FND_API.G_RET_STS_SUCCESS);
9762:
9763: -- PO_NEGOTIATIONS_SV1.DELETE_NEGOTIATION_REF(x_new_negotiation_id, l_line_number, x_error_code);
9764:
9765: PO_NEGOTIATIONS_SV1.UPDATE_NEGOTIATION_LINE_REF(
9766: P_API_VERSION => 1.0,
9767: P_OLD_NEGOTIATION_ID => x_new_negotiation_id,
9768: P_OLD_NEGOTIATION_LINE_NUM => l_line_number,
9769: P_NEW_NEGOTIATION_ID => x_old_negotiation_id,

Line 9778: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(

9774: END LOOP;
9775: CLOSE deletedItems;
9776: -- FPI: bug 2811671 still need to return the req back to pool
9777: /* IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9778: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(
9779: X_NEGOTIATION_ID => x_old_negotiation_id,
9780: X_NEGOTIATION_LINE_NUM => null,
9781: X_FLAG_VALUE => 'Y',
9782: X_ERROR_CODE => x_error_code);

Line 9846: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(

9842: END LOOP;
9843:
9844: ELSE
9845: /* Non CLM things */
9846: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(
9847: X_NEGOTIATION_ID => x_old_negotiation_id,
9848: X_NEGOTIATION_LINE_NUM => null,
9849: X_FLAG_VALUE => 'Y',
9850: X_ERROR_CODE => x_error_code);

Line 9975: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(

9971:
9972: BEGIN
9973:
9974: -- return backing requisitions to the req pool
9975: PO_NEGOTIATIONS_SV1.UPDATE_REQ_POOL(
9976: X_NEGOTIATION_ID => x_negotiation_id,
9977: X_NEGOTIATION_LINE_NUM => x_negotiation_line_id,
9978: X_FLAG_VALUE => 'Y',
9979: X_ERROR_CODE => x_error_code);

Line 17836: po_negotiations_sv1.REMOVE_FROM_REQ_POOL('SOLICITATION', p_auction_header_id, p_requisition_line_id, l_return_status, l_error_msg);

17832: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' rows inserted in pon_backing_requisitions table: '|| l_no_of_rows_inserted);
17833: END IF;
17834:
17835: --to remove the selected requisitions from the requisition pool
17836: po_negotiations_sv1.REMOVE_FROM_REQ_POOL('SOLICITATION', p_auction_header_id, p_requisition_line_id, l_return_status, l_error_msg);
17837:
17838: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
17839: x_return_status := l_return_status;
17840: x_error_msg := l_error_msg;

Line 17843: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Exception occured in the procedure po_negotiations_sv1.REMOVE_FROM_REQ_POOL:' );

17839: x_return_status := l_return_status;
17840: x_error_msg := l_error_msg;
17841: l_progress := '0040';
17842: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
17843: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Exception occured in the procedure po_negotiations_sv1.REMOVE_FROM_REQ_POOL:' );
17844: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' return_status: '|| l_return_status || ' error_msg: '|| l_error_msg);
17845: END IF;
17846: END IF;
17847: