227: p_line_number,
228: p_payment_id,
229: p_interface_line_id,
230: SYSDATE+7,
231: FND_GLOBAL.user_id,
232: SYSDATE,
233: FND_GLOBAL.user_id,
234: SYSDATE,
235: FND_GLOBAL.login_id
229: p_interface_line_id,
230: SYSDATE+7,
231: FND_GLOBAL.user_id,
232: SYSDATE,
233: FND_GLOBAL.user_id,
234: SYSDATE,
235: FND_GLOBAL.login_id
236: );
237: END IF;
231: FND_GLOBAL.user_id,
232: SYSDATE,
233: FND_GLOBAL.user_id,
234: SYSDATE,
235: FND_GLOBAL.login_id
236: );
237: END IF;
238: EXCEPTION
239: WHEN OTHERS THEN
7218: AND LINE_NUMBER = PAIP.LINE_NUMBER
7219: AND ROWNUM = 1),'N'),
7220: CLOSE_BIDDING_DATE = p_close_bidding_date,
7221: LAST_UPDATE_DATE = SYSDATE,
7222: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID(),
7223: LAST_UPDATED_BY = FND_GLOBAL.USER_ID()
7224: WHERE
7225: AUCTION_HEADER_ID = p_auction_header_id;
7226: END SET_ITEM_HAS_CHILDREN_FLAGS;
7219: AND ROWNUM = 1),'N'),
7220: CLOSE_BIDDING_DATE = p_close_bidding_date,
7221: LAST_UPDATE_DATE = SYSDATE,
7222: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID(),
7223: LAST_UPDATED_BY = FND_GLOBAL.USER_ID()
7224: WHERE
7225: AUCTION_HEADER_ID = p_auction_header_id;
7226: END SET_ITEM_HAS_CHILDREN_FLAGS;
7227:
7363: -- Errors will expire after seven days of creation
7364: l_expiration_date := SYSDATE + 7;
7365:
7366: l_user_id := p_user_id;
7367: l_login_id := FND_GLOBAL.LOGIN_ID;
7368:
7369: l_is_global_agreement := IS_GLOBAL_AGREEMENT (p_global_agreement_flag);
7370:
7371: SELECT PON_ITEM_PRICES_INTERFACE_S.NEXTVAL
7656: p_user_id, -- CREATED_BY
7657: sysdate, -- CREATION_DATE
7658: p_user_id, -- LAST_UPDATED_BY
7659: sysdate, -- LAST_UPDATE_DATE
7660: FND_GLOBAL.LOGIN_ID -- LAST_UPDATE_LOGIN
7661: );
7662: END LOG_INTERFACE_ERROR;
7663:
7664: FUNCTION CHECK_ACTION_ERRORS_PRESENT (
9322: p_user_party_id := ARGUMENT10;
9323: p_company_party_id := ARGUMENT11;
9324: p_curr_language := ARGUMENT12;
9325:
9326: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
9327: l_login_id := FND_GLOBAL.LOGIN_ID;
9328:
9329: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
9330: FND_LOG.string(log_level => FND_LOG.level_procedure,
9323: p_company_party_id := ARGUMENT11;
9324: p_curr_language := ARGUMENT12;
9325:
9326: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
9327: l_login_id := FND_GLOBAL.LOGIN_ID;
9328:
9329: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN --{
9330: FND_LOG.string(log_level => FND_LOG.level_procedure,
9331: module => g_module_prefix || l_module_name,