DBA Data[Home] [Help]

APPS.WMS_TXNREASONS_PUB dependencies on FND_API

Line 67: P_INIT_MSG_LST IN VARCHAR2 DEFAULT fnd_api.g_false,

63: P_CALLING_PROGRAM_NAME IN VARCHAR2 DEFAULT NULL,
64: P_EMAIL_ID IN VARCHAR2 DEFAULT NULL,
65: P_PROGRAM_NAME IN VARCHAR2 DEFAULT NULL,
66: P_RUN_MODE IN VARCHAR2 DEFAULT NULL,
67: P_INIT_MSG_LST IN VARCHAR2 DEFAULT fnd_api.g_false,
68: P_PROGRAM_CONTROL_ARG1 IN VARCHAR2 DEFAULT NULL,
69: P_PROGRAM_CONTROL_ARG2 IN VARCHAR2 DEFAULT NULL,
70: P_PROGRAM_CONTROL_ARG3 IN VARCHAR2 DEFAULT NULL,
71: P_PROGRAM_CONTROL_ARG4 IN VARCHAR2 DEFAULT NULL,

Line 117: RAISE fnd_api.g_exc_error;

113: -- make sure that reason name is not null
114: if (p_reason_id is null ) then
115: fnd_message.set_name('INV','INV_FIELD_INVALID');
116: fnd_msg_pub.ADD;
117: RAISE fnd_api.g_exc_error;
118: end if;
119:
120: IF (l_debug = 1) THEN
121: mdebug('Before Select WORKFLOW_NAME, WORKFLOW_PROCESS ');

Line 567: WHEN fnd_api.g_exc_error THEN

563: aname =>'XW_IS_CYCLE_COUNT_SUCCESSFUL');
564:
565: EXCEPTION
566:
567: WHEN fnd_api.g_exc_error THEN
568: x_return_status := fnd_api.g_ret_sts_error;
569: fnd_msg_pub.count_and_get
570: ( p_count => x_msg_count,
571: p_data => x_msg_data

Line 568: x_return_status := fnd_api.g_ret_sts_error;

564:
565: EXCEPTION
566:
567: WHEN fnd_api.g_exc_error THEN
568: x_return_status := fnd_api.g_ret_sts_error;
569: fnd_msg_pub.count_and_get
570: ( p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 574: WHEN fnd_api.g_exc_unexpected_error THEN

570: ( p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573:
574: WHEN fnd_api.g_exc_unexpected_error THEN
575: x_return_status := fnd_api.g_ret_sts_unexp_error ;
576: fnd_msg_pub.count_and_get
577: ( p_count => x_msg_count,
578: p_data => x_msg_data

Line 575: x_return_status := fnd_api.g_ret_sts_unexp_error ;

571: p_data => x_msg_data
572: );
573:
574: WHEN fnd_api.g_exc_unexpected_error THEN
575: x_return_status := fnd_api.g_ret_sts_unexp_error ;
576: fnd_msg_pub.count_and_get
577: ( p_count => x_msg_count,
578: p_data => x_msg_data
579: );

Line 582: x_return_status := fnd_api.g_ret_sts_error;

578: p_data => x_msg_data
579: );
580:
581: WHEN NO_DATA_FOUND THEN
582: x_return_status := fnd_api.g_ret_sts_error;
583: fnd_message.set_name('INV','INV_INT_REACODE');
584: fnd_msg_pub.ADD;
585:
586: WHEN OTHERS THEN

Line 587: x_return_status := fnd_api.g_ret_sts_unexp_error;

583: fnd_message.set_name('INV','INV_INT_REACODE');
584: fnd_msg_pub.ADD;
585:
586: WHEN OTHERS THEN
587: x_return_status := fnd_api.g_ret_sts_unexp_error;
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
589: THEN
590: fnd_msg_pub.add_exc_msg
591: ( g_pkg_name