DBA Data[Home] [Help]

APPS.PON_BIZ_EVENTS_PVT dependencies on FND_API

Line 42: -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_TRUE Optional

38: -- Locks : None
39: --
40: -- Parameters :
41: -- IN : p_api_version NUMBER Required
42: -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_TRUE Optional
43: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_TRUE Optional
44: -- IN : p_auction_header_id NUMBER Required, auction_header_id
45: -- of the negotiation published
46: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure

Line 43: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_TRUE Optional

39: --
40: -- Parameters :
41: -- IN : p_api_version NUMBER Required
42: -- IN p_init_msg_list VARCHAR2 DEFAULT FND_API.G_TRUE Optional
43: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_TRUE Optional
44: -- IN : p_auction_header_id NUMBER Required, auction_header_id
45: -- of the negotiation published
46: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
47: -- was successful or not; It can have

Line 49: -- FND_API.G_RET_STS_SUCCESS (Success)

45: -- of the negotiation published
46: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
47: -- was successful or not; It can have
48: -- following values -
49: -- FND_API.G_RET_STS_SUCCESS (Success)
50: -- FND_API.G_RET_STS_ERROR (Failed due to error)
51: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
52: -- to this procedure call. It will have following
53: -- values -

Line 50: -- FND_API.G_RET_STS_ERROR (Failed due to error)

46: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
47: -- was successful or not; It can have
48: -- following values -
49: -- FND_API.G_RET_STS_SUCCESS (Success)
50: -- FND_API.G_RET_STS_ERROR (Failed due to error)
51: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
52: -- to this procedure call. It will have following
53: -- values -
54: -- 0 (for Success without warning)

Line 167: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional

163: -- Locks : None
164: --
165: -- Parameters :
166: -- IN : p_api_version NUMBER Required
167: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
168: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
169: -- IN : p_bid_number NUMBER Required, bid_number
170: -- of the Response published
171: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure

Line 168: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional

164: --
165: -- Parameters :
166: -- IN : p_api_version NUMBER Required
167: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
168: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
169: -- IN : p_bid_number NUMBER Required, bid_number
170: -- of the Response published
171: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
172: -- was successful or not; It can have

Line 174: -- FND_API.G_RET_STS_SUCCESS (Success)

170: -- of the Response published
171: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
172: -- was successful or not; It can have
173: -- following values -
174: -- FND_API.G_RET_STS_SUCCESS (Success)
175: -- FND_API.G_RET_STS_ERROR (Failed due to error)
176: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
177: -- to this procedure call. It will have following
178: -- values -

Line 175: -- FND_API.G_RET_STS_ERROR (Failed due to error)

171: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
172: -- was successful or not; It can have
173: -- following values -
174: -- FND_API.G_RET_STS_SUCCESS (Success)
175: -- FND_API.G_RET_STS_ERROR (Failed due to error)
176: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
177: -- to this procedure call. It will have following
178: -- values -
179: -- 0 (for Success without warning)

Line 309: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional

305: -- Locks : None
306: --
307: -- Parameters :
308: -- IN : p_api_version NUMBER Required
309: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
310: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
311: -- IN : p_bid_number NUMBER Required, bid_number
312: -- of the Response published
313: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure

Line 310: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional

306: --
307: -- Parameters :
308: -- IN : p_api_version NUMBER Required
309: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
310: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
311: -- IN : p_bid_number NUMBER Required, bid_number
312: -- of the Response published
313: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
314: -- was successful or not; It can have

Line 316: -- FND_API.G_RET_STS_SUCCESS (Success)

312: -- of the Response published
313: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
314: -- was successful or not; It can have
315: -- following values -
316: -- FND_API.G_RET_STS_SUCCESS (Success)
317: -- FND_API.G_RET_STS_ERROR (Failed due to error)
318: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
319: -- to this procedure call. It will have following
320: -- values -

Line 317: -- FND_API.G_RET_STS_ERROR (Failed due to error)

313: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
314: -- was successful or not; It can have
315: -- following values -
316: -- FND_API.G_RET_STS_SUCCESS (Success)
317: -- FND_API.G_RET_STS_ERROR (Failed due to error)
318: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
319: -- to this procedure call. It will have following
320: -- values -
321: -- 0 (for Success without warning)

Line 454: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional

450: -- Locks : None
451: --
452: -- Parameters :
453: -- IN : p_api_version NUMBER Required
454: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
455: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
456: -- IN : p_auction_header_id NUMBER Required, auction_header_id
457: -- of the Negotiation submitted
458: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure

Line 455: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional

451: --
452: -- Parameters :
453: -- IN : p_api_version NUMBER Required
454: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
455: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
456: -- IN : p_auction_header_id NUMBER Required, auction_header_id
457: -- of the Negotiation submitted
458: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
459: -- was successful or not; It can have

Line 461: -- FND_API.G_RET_STS_SUCCESS (Success)

457: -- of the Negotiation submitted
458: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
459: -- was successful or not; It can have
460: -- following values -
461: -- FND_API.G_RET_STS_SUCCESS (Success)
462: -- FND_API.G_RET_STS_ERROR (Failed due to error)
463: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
464: -- to this procedure call. It will have following
465: -- values -

Line 462: -- FND_API.G_RET_STS_ERROR (Failed due to error)

458: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
459: -- was successful or not; It can have
460: -- following values -
461: -- FND_API.G_RET_STS_SUCCESS (Success)
462: -- FND_API.G_RET_STS_ERROR (Failed due to error)
463: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
464: -- to this procedure call. It will have following
465: -- values -
466: -- 0 (for Success without warning)

Line 582: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional

578: -- Locks : None
579: --
580: -- Parameters :
581: -- IN : p_api_version NUMBER Required
582: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
583: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
584: -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
585: -- of the Negotiation completed
586: -- IN : p_create_po_flag VARCHAR2 Required, Flag to indicate if the user

Line 583: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional

579: --
580: -- Parameters :
581: -- IN : p_api_version NUMBER Required
582: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
583: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
584: -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
585: -- of the Negotiation completed
586: -- IN : p_create_po_flag VARCHAR2 Required, Flag to indicate if the user
587: -- has decided to create PO after the completion of

Line 592: -- FND_API.G_RET_STS_SUCCESS (Success)

588: -- of the Award of the given Negotiation
589: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
590: -- was successful or not; It can have
591: -- following values -
592: -- FND_API.G_RET_STS_SUCCESS (Success)
593: -- FND_API.G_RET_STS_ERROR (Failed due to error)
594: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
595: -- to this procedure call. It will have following
596: -- values -

Line 593: -- FND_API.G_RET_STS_ERROR (Failed due to error)

589: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
590: -- was successful or not; It can have
591: -- following values -
592: -- FND_API.G_RET_STS_SUCCESS (Success)
593: -- FND_API.G_RET_STS_ERROR (Failed due to error)
594: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
595: -- to this procedure call. It will have following
596: -- values -
597: -- 0 (for Success without warning)

Line 726: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional

722: -- Locks : None
723: --
724: -- Parameters :
725: -- IN : p_api_version NUMBER Required
726: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
727: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
728: -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
729: -- of the Negotiation for which PO creation is started
730: -- IN : p_user_name VARCHAR2 Required, User Name

Line 727: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional

723: --
724: -- Parameters :
725: -- IN : p_api_version NUMBER Required
726: -- IN : p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE Optional
727: -- IN : p_commit VARCHAR2 DEFAULT FND_API.G_FALSE Optional
728: -- IN : p_auction_header_id NUMBER Required, p_auction_header_id
729: -- of the Negotiation for which PO creation is started
730: -- IN : p_user_name VARCHAR2 Required, User Name
731: -- of the Negotiation Creator who has initiated PO creation

Line 737: -- FND_API.G_RET_STS_SUCCESS (Success)

733: -- Negotiation has some backing Requisition(s)
734: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
735: -- was successful or not; It can have
736: -- following values -
737: -- FND_API.G_RET_STS_SUCCESS (Success)
738: -- FND_API.G_RET_STS_ERROR (Failed due to error)
739: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
740: -- to this procedure call. It will have following
741: -- values -

Line 738: -- FND_API.G_RET_STS_ERROR (Failed due to error)

734: -- OUT : x_return_status VARCHAR2, flag to indicate if the procedure
735: -- was successful or not; It can have
736: -- following values -
737: -- FND_API.G_RET_STS_SUCCESS (Success)
738: -- FND_API.G_RET_STS_ERROR (Failed due to error)
739: -- OUT : x_msg_count NUMBER, the number of warning of error messages due
740: -- to this procedure call. It will have following
741: -- values -
742: -- 0 (for Success without warning)

Line 916: x_return_status := FND_API.G_RET_STS_SUCCESS;

912: l_exist VARCHAR2(30);
913:
914: BEGIN
915: -- Initialize API return status to success
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917:
918: -- Standard Start of API savepoint
919: SAVEPOINT pon_biz_event_raise_event;
920:

Line 926: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,

922: LOG_MESSAGE('raise_event', g_err_loc);
923: --
924: -- Standard call to check for call compatibility
925: --
926: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
927: p_api_version,
928: l_api_name,
929: g_pkg_name )
930: THEN

Line 931: RAISE FND_API.G_EXC_ERROR;

927: p_api_version,
928: l_api_name,
929: g_pkg_name )
930: THEN
931: RAISE FND_API.G_EXC_ERROR;
932: END IF;
933:
934: g_err_loc := '10.1 Checked the FND_API.COMPATIBLE_API_CALL';
935: LOG_MESSAGE('raise_event', g_err_loc);

Line 934: g_err_loc := '10.1 Checked the FND_API.COMPATIBLE_API_CALL';

930: THEN
931: RAISE FND_API.G_EXC_ERROR;
932: END IF;
933:
934: g_err_loc := '10.1 Checked the FND_API.COMPATIBLE_API_CALL';
935: LOG_MESSAGE('raise_event', g_err_loc);
936:
937: --
938: -- Initialize message list if p_init_msg_list is set to TRUE

Line 943: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

939: -- We initialize the list by default. User should pass proper
940: -- value to p_init_msg_list in case this initialization is not
941: -- wanted
942: --
943: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
944: FND_MSG_PUB.INITIALIZE;
945: END IF;
946:
947: g_err_loc := '10.2 Checked and called FND_MSG_PUB.INITIALIZE';

Line 1018: x_return_status := FND_API.G_RET_STS_ERROR;

1014: l_parameter_list.DELETE;
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: ROLLBACK TO pon_biz_event_raise_event;
1020:
1021: FND_MESSAGE.SET_NAME('PON','PON_GENERIC_ERR');
1022: FND_MESSAGE.SET_TOKEN('TOKEN', g_err_loc|| ' :' || SQLCODE || ' :' || SQLERRM);