2306: end if;
2307:
2308: EXCEPTION
2309: WHEN others THEN
2310: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2311: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2312: fnd_message.set_token('PROCEDURE', 'create_draft_neg_interface');
2313: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2314:
2307:
2308: EXCEPTION
2309: WHEN others THEN
2310: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2311: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2312: fnd_message.set_token('PROCEDURE', 'create_draft_neg_interface');
2313: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2314:
2315: ROLLBACK TO SAVEPOINT pon_before_insert;
2308: EXCEPTION
2309: WHEN others THEN
2310: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2311: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2312: fnd_message.set_token('PROCEDURE', 'create_draft_neg_interface');
2313: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2314:
2315: ROLLBACK TO SAVEPOINT pon_before_insert;
2316:
2309: WHEN others THEN
2310: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2311: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2312: fnd_message.set_token('PROCEDURE', 'create_draft_neg_interface');
2313: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2314:
2315: ROLLBACK TO SAVEPOINT pon_before_insert;
2316:
2317: app_exception.raise_exception;
2423:
2424:
2425: EXCEPTION
2426: WHEN others THEN
2427: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2428: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2429: fnd_message.set_token('PROCEDURE', 'val_auc_headers_interface');
2430: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2431: app_exception.raise_exception;
2424:
2425: EXCEPTION
2426: WHEN others THEN
2427: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2428: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2429: fnd_message.set_token('PROCEDURE', 'val_auc_headers_interface');
2430: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2431: app_exception.raise_exception;
2432:
2425: EXCEPTION
2426: WHEN others THEN
2427: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2428: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2429: fnd_message.set_token('PROCEDURE', 'val_auc_headers_interface');
2430: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2431: app_exception.raise_exception;
2432:
2433: END val_auc_headers_interface;
2426: WHEN others THEN
2427: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2428: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2429: fnd_message.set_token('PROCEDURE', 'val_auc_headers_interface');
2430: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2431: app_exception.raise_exception;
2432:
2433: END val_auc_headers_interface;
2434:
2548: end if;
2549:
2550: EXCEPTION
2551: WHEN others THEN
2552: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2553: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2554: fnd_message.set_token('PROCEDURE', 'val_auc_items_interface');
2555: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2556: app_exception.raise_exception;
2549:
2550: EXCEPTION
2551: WHEN others THEN
2552: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2553: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2554: fnd_message.set_token('PROCEDURE', 'val_auc_items_interface');
2555: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2556: app_exception.raise_exception;
2557:
2550: EXCEPTION
2551: WHEN others THEN
2552: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2553: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2554: fnd_message.set_token('PROCEDURE', 'val_auc_items_interface');
2555: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2556: app_exception.raise_exception;
2557:
2558: END val_auc_items_interface;
2551: WHEN others THEN
2552: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2553: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2554: fnd_message.set_token('PROCEDURE', 'val_auc_items_interface');
2555: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2556: app_exception.raise_exception;
2557:
2558: END val_auc_items_interface;
2559:
2631:
2632:
2633: EXCEPTION
2634: WHEN others THEN
2635: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2636: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2637: fnd_message.set_token('PROCEDURE', 'val_auc_shipments_interface');
2638: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2639: app_exception.raise_exception;
2632:
2633: EXCEPTION
2634: WHEN others THEN
2635: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2636: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2637: fnd_message.set_token('PROCEDURE', 'val_auc_shipments_interface');
2638: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2639: app_exception.raise_exception;
2640:
2633: EXCEPTION
2634: WHEN others THEN
2635: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2636: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2637: fnd_message.set_token('PROCEDURE', 'val_auc_shipments_interface');
2638: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2639: app_exception.raise_exception;
2640:
2641: END val_auc_shipments_interface;
2634: WHEN others THEN
2635: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2636: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2637: fnd_message.set_token('PROCEDURE', 'val_auc_shipments_interface');
2638: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2639: app_exception.raise_exception;
2640:
2641: END val_auc_shipments_interface;
2642:
2665: RETURN;
2666:
2667: EXCEPTION
2668: WHEN others THEN
2669: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2670: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2671: fnd_message.set_token('PROCEDURE', 'val_attachments_interface');
2672: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2673: app_exception.raise_exception;
2666:
2667: EXCEPTION
2668: WHEN others THEN
2669: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2670: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2671: fnd_message.set_token('PROCEDURE', 'val_attachments_interface');
2672: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2673: app_exception.raise_exception;
2674:
2667: EXCEPTION
2668: WHEN others THEN
2669: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2670: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2671: fnd_message.set_token('PROCEDURE', 'val_attachments_interface');
2672: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2673: app_exception.raise_exception;
2674:
2675: END val_attachments_interface;
2668: WHEN others THEN
2669: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2670: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2671: fnd_message.set_token('PROCEDURE', 'val_attachments_interface');
2672: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2673: app_exception.raise_exception;
2674:
2675: END val_attachments_interface;
2676:
2761: RETURN;
2762:
2763: EXCEPTION
2764: WHEN others THEN
2765: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2766: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2767: fnd_message.set_token('PROCEDURE', 'get_trading_partner_info');
2768: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2769: app_exception.raise_exception;
2762:
2763: EXCEPTION
2764: WHEN others THEN
2765: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2766: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2767: fnd_message.set_token('PROCEDURE', 'get_trading_partner_info');
2768: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2769: app_exception.raise_exception;
2770:
2763: EXCEPTION
2764: WHEN others THEN
2765: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2766: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2767: fnd_message.set_token('PROCEDURE', 'get_trading_partner_info');
2768: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2769: app_exception.raise_exception;
2770:
2771: END get_trading_partner_info;
2764: WHEN others THEN
2765: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2766: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2767: fnd_message.set_token('PROCEDURE', 'get_trading_partner_info');
2768: fnd_message.set_token('ERROR',v_debug_status || '[' || SQLERRM || ']');
2769: app_exception.raise_exception;
2770:
2771: END get_trading_partner_info;
2772:
2843: RETURN;
2844:
2845: EXCEPTION
2846: WHEN others THEN
2847: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2848: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2849: fnd_message.set_token('PROCEDURE', 'purge_interface_table');
2850: fnd_message.set_token('ERROR','[' || SQLERRM || ']');
2851: app_exception.raise_exception;
2844:
2845: EXCEPTION
2846: WHEN others THEN
2847: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2848: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2849: fnd_message.set_token('PROCEDURE', 'purge_interface_table');
2850: fnd_message.set_token('ERROR','[' || SQLERRM || ']');
2851: app_exception.raise_exception;
2852: END purge_interface_table;
2845: EXCEPTION
2846: WHEN others THEN
2847: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2848: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2849: fnd_message.set_token('PROCEDURE', 'purge_interface_table');
2850: fnd_message.set_token('ERROR','[' || SQLERRM || ']');
2851: app_exception.raise_exception;
2852: END purge_interface_table;
2853:
2846: WHEN others THEN
2847: fnd_message.set_name('PON','PON_AUC_PLSQL_ERR');
2848: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
2849: fnd_message.set_token('PROCEDURE', 'purge_interface_table');
2850: fnd_message.set_token('ERROR','[' || SQLERRM || ']');
2851: app_exception.raise_exception;
2852: END purge_interface_table;
2853:
2854: -------------------------------------------------------------------------------
3482:
3483: WHEN OTHERS THEN
3484: x_result := FND_API.G_RET_STS_ERROR ;
3485: x_error_code := 'UNKNOWN_ERROR';
3486: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
3488: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
3489: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
3490: --APP_EXCEPTION.RAISE_EXCEPTION;
3483: WHEN OTHERS THEN
3484: x_result := FND_API.G_RET_STS_ERROR ;
3485: x_error_code := 'UNKNOWN_ERROR';
3486: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
3488: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
3489: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
3490: --APP_EXCEPTION.RAISE_EXCEPTION;
3491: fnd_message.retrieve(x_error_message);
3484: x_result := FND_API.G_RET_STS_ERROR ;
3485: x_error_code := 'UNKNOWN_ERROR';
3486: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
3488: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
3489: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
3490: --APP_EXCEPTION.RAISE_EXCEPTION;
3491: fnd_message.retrieve(x_error_message);
3492: -- logme('in OTHERS' || x_error_message);
3485: x_error_code := 'UNKNOWN_ERROR';
3486: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
3488: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
3489: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
3490: --APP_EXCEPTION.RAISE_EXCEPTION;
3491: fnd_message.retrieve(x_error_message);
3492: -- logme('in OTHERS' || x_error_message);
3493:
3487: fnd_message.set_token('PACKAGE','PON_SOURCING_OPENAPI_GRP');
3488: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
3489: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
3490: --APP_EXCEPTION.RAISE_EXCEPTION;
3491: fnd_message.retrieve(x_error_message);
3492: -- logme('in OTHERS' || x_error_message);
3493:
3494: RETURN;
3495: